SQL # 1 - Introduction to SQL

Introduction to SQL-

What is SQL?

• SQL stands for Structured Query Language.
• It is designed for managing data in a relational database management system (RDBMS).
• SQL is a database language, it is used for database creation, deletion, fetching rows and modifying rows etc.
• SQL has reduced the need for lengthy programming to access data.
• The SQL user does not need to know how data is stored. The query language (SQL) takes care of retrieving, replacing, adding, and deleting data.
• A procedural programming language needs every specification about data. SQL is simpler in operation than procedural languages like C/C++ for database management.
• DBMS like MySQL, Oracle, MS Access, Sybase, Informix, Postgres and SQL Server use SQL as standard database language.

Why SQL is required?

SQL is required:

• To create and drop databases and tables.
• To create and drop databases and tables.
• To update records in a database.
• To delete records from a database.
• To retrieve data from a database.
• To set permissions on tables, procedures and views.
• To define the data in a database and manipulate that data.
• To access data in the relational database management systems.
• To create view, stored procedure,functions in a database.