Learn SQL

What is SQL?

SQL is a standard language for accessing and manipulating databases.

  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL executes queries against a database
  • SQL retrieves data from a database
  • SQL inserts records in a database
  • SQL updates records in a database
  • SQL deletes records from a database
  • SQL creates new databases
  • SQL creates new tables in a database
  • SQL creates stored procedures in a database
  • SQL create views in a database
  • SQL set permissions on tables, procedures, and views

Some of The Most Important SQL Commands are

  • SELECT – extracts data from a database
  • UPDATE – updates data in a database
  • DELETE – deletes data from a database
  • INSERT INTO – inserts new data into a database
  • CREATE DATABASE – creates a new database
  • ALTER DATABASE – modifies a database
  • CREATE TABLE – creates a new tabl
  • ALTER TABLE – modifies a table
  • DROP TABLE – deletes a table
  • CREATE INDEX – creates an index (search key)
  • DROP INDEX – deletes an index

Lets deep dive into SQL !!!