SQL - Series - Quick Start

Introduction:

SQL - Structured Query Language which is used to query and retrieve the data from Relational Database Management System (RDBMS)

SQL - SQL Keywords are NOT CASE SENSITIVE. Example: Select is the same as SELECT

Semicolon after SQL Statement ?

Some database systems require a semicolon at the end of each SQL statement.

Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

Some of The Most Important SQL Commands

• SELECT - Extracts data from database
• UPDATE - Updates data in a database
• DELETE - Deletes data from a database
• INSERT INTO - Inserts a new data into a database
• CREATE DATABASE - Creates a new database
• ALTER DATABASE - Modifies a database
• CREATE TABLE - Creates a new table
• ALTER TABLE - Modifies a table
• DROP TABLE - Deletes a table
• CREATE INDEX - Creates an Index (Search Key) 
• DROP INDEX -  Deletes an Index

Credit: https://www.w3schools.com/