1. Introduction of SQL

What is SQL?                                  

§ SQL is a designed for the retrieval and management of data in relational database.

§ SQL stands for Structured Query Language.

§ SQL is a 4th generation language. (We write what we say).

Why SQL?                            

§ Allows users to access data in relational database management systems.

§ Allows users to define the data in database and manipulate that data.

§ Allows to embed within other languages using SQL modules, libraries & pre-compilers.

§ Allows users to create and drop databases and tables.

§ Allows users to create view, stored procedure, functions in a database.

§ Allows users to set permissions on tables, procedures, and views.

                                                                                                                     <<Prev                                                  Next>>