What is SQL

SQL is a standard language for accessing and manipulating databases. 

 

What Can SQL do?

  • 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
  • SQL can insert records in a database
  • SQL can retrieve data from a database
  • SQL can execute queries against a database
  • SQL can update records in a database
  • SQL can delete records from a database

 

Basic Syntax of SQL:

SELECT * FROM table_name;

 

SQL KEYWORD - NOT CASE SENSITIVE

  • Select can be written in upper case or lower case.
  • SQL keyword is not case sensitive.

Ex: select or SELECT

 

SEMI-COLON: It is mandatory to have semicolon(;) at the end of each query.