SQL

 SQL stands for Structured Query Language.

        SQL is used for storing, retrieving and manipulating data in a database.

        It is used to perform CRUD(Create, Read, Update and Delete) operations on data stored in the form of tables in a database i.e. RDBMS(Relational Database Management System).

    Follow the contents of the course here...

• SQL Commands
• DDL - Data Definition Language
• DML - Data Manipulation Language
• DQL - Data Query Language: SELECT
• SELECT Clauses - WHERE, AND, OR, AS, WITH and HAVING
• HAVING Vs WHERE Clause
• SQL Select - DISTINCT, COUNT, SUM, NULL or NOT NULL, IN
• ORDER BY
• Keys in SQL - Primary, Composite, Foreign, Alternate
• SQL Join
• SQL LIKE operator and Wildcard Characters