Level 1- Create a table & Insert Data

Why SQL?

DBMS

SQL

Create a table

Data Types

Constraints

Primary key, Foreign key & Unique key

Insert data

Import Data Set in MYSQL workbench

Level 2- Data Retrieval Single Table

DQL, DML, DDL, DCL and TCL

Select Query

Numeric Query & AND, ****OR

Clause ( WHERE, GROUP BY, HAVING, ORDER BY )

Clause ( DELETE, TRUNCATE, **DROP, UPDATE**, ALTER, DISTINCT )

Clause ( LIMIT, OFFSET, BETWEEN, IN, LIKE, NULL) & REGEXP

Functions (Scalar & Aggregate Functions)

More Functions & Statements ( CURDATE, YEAR, SUBSTR, NVL, CONCAT )