Let's learn SQL with MySQL

• Structure query langauge : used to interact with Database.
• SQL is the standard language for dealing with Relational Databases.
• SQL is used to insert, search, update, and delete database records.
• SQL keywords are NOT case sensitive: select is the same as SELECT

• 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 table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index