SQL 
                     
What is 
SQSL Qis Lt?he standard language for 
dealing with  Relational Databases. SQL 
can be used to  insert, search, update, 
and delete database  records. SQL can 
do lots of other operations,  including 
optimizing and maintenance of  
databases.
A Brief History of 
1970 –  SDr.Q EdgLar F. “Ted” Codd described a relational model for 
databases.
1974 –  Structured Query Language 
appeared.  1978 –  IBM released a product 
called System/R.  1989 –  First ever version 
launched of SQL
SQL 2006 –  Support for XML Query 
Language
SQL 2011 -improved support for 
temporal databases
Types of SQL 
HeSre taare tfievem typeesn otf swidely used SQL 
queries.
Data Definition Language 
(DDL)  Data Manipulation 
Language (DML)
Data Control Language (DCL)  
Transaction Control Language 
(TCL)  Data Query Language 
(DQL)
SQL Query
SQL 
Language
SQL 
DBMS 
Process Parser Engine +Optimiizer
File  
Physical data manager+Transacti
base on  manager
What is a database in 
A dSataQbaLse is made up of a collection of tables that stores a detailed se?t  of structured data. It is a table that contains a 
collection of rows, referred  to as records or tuples, and 
columns that are also referred to as  attributes.
Each column in the table is designed to store a specific type 
of  information, for example, names, dates, dollar amounts, 
and numbers.
Thanks for 
watching
Learnbay provides data science courses in Chennai. 
The  course module includes SQL as well. Visit their 
website for  more information
https://www.learnbay.co/data-science-course/data-science-courses-in-
chennai/