SQLSTRUCTURED QUERY LANGUAGE – LET’S COMMUNICATE WITH DATABASE!

Few What’s and Why’s…!

It is always better to start

things with questions rather

than explanation!!

I’ve guessed a few questions that starts running on your mind when you start learning SQL for the first time…• What is SQL?• What is this Database?• Why do we need Database?• Why do we need to Communicate with

Database?

• Let’s discuss each one by one…

1. What is SQL?

SQL stands for Structured Query

Language which is being used to

communicate with Database…

SQL is pronounced as "ess-que-el“.

Now you might be thinking, what is this database? Answer in Next

Slide!

2. What is Database?

Database is a structured set of Data stored on a computer, especially the one that can be

accessed by various ways!

Didn’t understand?? If not, Just understand the first part of the sentence and that is

enough for now!

3. Why do we need DataBase?

Very Simple!! If you have some data, then definitely you need something to store the data and there comes

our DATABASE!

Wanna see a video to understand What is Database and Why do we need it??

Here you go!( https://www.youtube.com/watch?v=djEZeF4KTaM )

4. Why do we need to communicate with Database?

There are mainly two reasons to communicate with Database…

• When you need the same data again.

• When you need to modify data stored in database.

No Worries, We’ve got SQL…

SO HOW CAN WE COMMUNICATE WITH

DATABASE???

We’ve Completed Intro to SQL – INTRO!

Let us now introduce ourselves to SQL!

SQL WELCOMES YOU TO WORLD OF DBMS(DBMS – DATA BASE MANAGEMENT SYSTEM)

So we got to know what is and why do we need SQL

Let’s see what all he can do and finish the introduction

1. He can execute queries against a database.2. He can retrieve data from a database.3. He can insert records into database.4. He can update records in database.5. He can delete records in database.6. He can create new tables in database.7. He can create new databases.8. He can create views in database.9. He can create stored procedures in a database.10. He can set permissions on tables, procedures and views.

SQL - Capabilities

Fine… SQL is a great person!But

how does he look like (Syntax)?How does he work?

How does he help us?

Refer Next Part…

THANK YOUSee You Again…