SQL - SPLessons

Chapter 1

SQL Tutorials

SQL Tutorials

SQL stands for Structured Query Language. The dialect initially created by IBM at mid 1970 and is utilized for dealing with the database. It is a non-procedural dialect. Client can compose SQL script to execute and SQL compiler consequently produces a method to get to database and convey the fancied output. SQL is a database coding, planned for the recuperation and organisation of data in social database.

Taking after outline clarifies how SQL getting to database to recover wanted information.

SQL Languages

SQL is used for controlling all the functions provided by the DBMS like

  • Data Definition: SQL permits a client to characterize the structure of information to store and relate between them.
  • Data Retrieval: SQL helps a client or an operation to recover information from database.
  • Data Manipulation: SQL permit client or an operation to overhaul the current information, include some new information and erase existing information.
  • Access Control: SQL can likewise be utilized to confine a client or an application to get to some delicate information by setting up authorization level.

Summary

  • SQL – Stands for Structured Query Language.
  • Purpose of SQL Tutorials – Used for managing the database.
  • DDL – Stands for data definition language, and which is used to define data in database server.
  • DML – Stands for data manipulation language, and which is used to manipulate the data in database server.
  • Access control – Restrict the user to access confidential data.