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.
0 on: "SQL # 1 - Introduction to SQL"