SQL classes in Pune

1
What is SQL

• SQL is an abbreviation for structured query
  language, and pronounced either see-kwell or as
  separate letters.
• SQL is a standardized query language for
  requesting information from a database. The
  original version called SEQUEL (structured
  English query language) was designed by an IBM
  research center in 1974 and 1975. SQL was first
  introduced as a commercial database system in
  1979 by Oracle Corporation.

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
2
A Brief History of SQL

• 1970 Dr. Edgar F. "Ted" Codd of IBM is known as
  the father of relational
• databases. He described a relational model for
  databases.
• 1974 Structured Query Language appeared.
• 1978 IBM worked to develop Codd's ideas and
  released a product named
• System/R.
• 1986 IBM developed the first prototype of
  relational database and standardized
• by ANSI. The first relational database was
  released by Relational Software which
• later came to be known as Oracle.

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
3
Actions on SQL

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert,update,delete records in a
  database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures,
  and views

Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
4
SQL Process
Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
5
SQL Process

• When you are executing an SQL command for any
  RDBMS, the system determines the
• best way to carry out your request and SQL engine
  figures out how to interpret the task.
• There are various components included in this
  process.
• These components are
• Query Dispatcher
• Optimization Engines
• Classic Query Engine
• SQL Query Engine, etc.

Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
6
Why SQL is required

• SQL is required
• To create new databases, tables and views
• To insert records in a database
• To update records in a database
• To delete records from a database
• To retrieve data from a database

Classboat.com
Mobile No. 91-7767904499 E-mail -
support_at_classboat.com www.classboat.com
7
If you want to know more about SQL language then
visit https//www.classboat.com/tech/sql-classe
s-pune

• Mobile No. 91-7767904499 E-mail -
  support_at_classboat.com www.classboat.com