five SQL command types (DDL, DML, DCL, TCL, and SQL queries) is included and ensure every
important topic is mentioned under each.
SQL Command Types Covered:
1. DDL (Data Definition Language)
o CREATE, ALTER, DROP, TRUNCATE, RENAME
o Table creation, schema design, and table modification.
2. DML (Data Manipulation Language)
o SELECT, INSERT, UPDATE, DELETE
o Querying, inserting, updating, and deleting data from tables.
3. DCL (Data Control Language)
o GRANT, REVOKE
o Granting or revoking permissions on database objects.
4. TCL (Transaction Control Language)
o BEGIN, COMMIT, ROLLBACK
o Managing transactions to ensure ACID properties.
5. SQL Queries
o Includes all the essential queries like SELECT, filtering, sorting, aggregation, and
joining data.
o Subqueries, set operations, and window functions.
Detailed Day-by-Day Plan with Full Command Coverage:
📅 Day 1: SQL Basics (DDL, DML)
Morning:
1. Introduction to SQL and Database
o Introduction to SQL and types of SQL commands: DDL, DML, DCL, TCL
o DDL Concepts:
CREATE: Creating tables
ALTER: Modifying table structure
DROP: Deleting tables
TRUNCATE: Removing all rows from a table
o DML Concepts:
SELECT: Basic querying
INSERT INTO: Adding data to a table
UPDATE: Modifying data
DELETE: Removing data
Afternoon:
2. Filtering and Aggregation
o WHERE for filtering rows.
o Aggregate functions like COUNT(), SUM(), AVG(), etc.
o GROUP BY and HAVING for grouping data.
3. Basic Data Modification
o INSERT INTO (Insert data into a table)
o UPDATE (Modify data)
o DELETE (Remove data)
📅 Day 2: Intermediate SQL (DML, DDL, Subqueries)
Morning:
1. Joins (DML)
o INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
o Combining data from multiple tables using joins.
2. Aliasing Tables (DML)
o Table and column aliases to make queries cleaner.
Afternoon:
3. Subqueries (DML)
o Single-row subqueries
o Multi-row subqueries
o Correlated subqueries (subqueries that reference outer query)
4. Set Operations (DML)
o UNION, INTERSECT, EXCEPT (Combining result sets)
Evening:
5. Working with Views (DDL)
o Creating and querying views: virtual tables.
o Modifying views.
📅 Day 3: Advanced SQL (TCL, DCL, Window Functions, Performance)
Morning:
1. Transactions (TCL)
o BEGIN, COMMIT, ROLLBACK
o Ensuring ACID properties for database transactions.
2. Window Functions (DML)
o ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG()
o PARTITION BY and ORDER BY for analyzing data.
Afternoon:
3. Stored Procedures and Triggers (DDL)
o Creating and executing stored procedures.
o Using triggers to automate actions like AFTER INSERT, BEFORE UPDATE.
4. Security & Permissions (DCL)
o GRANT and REVOKE commands to manage database access.
Evening:
5. Performance Optimization
o Indexes: Creating indexes for faster querying
o Query Optimization using EXPLAIN PLAN
o Writing optimized SQL queries.
Summary of Covered Topics (SQL Commands)
DDL (Data Definition Language):
o CREATE, ALTER, DROP, TRUNCATE, RENAME, Views, Stored Procedures, Triggers
DML (Data Manipulation Language):
o SELECT, INSERT INTO, UPDATE, DELETE, Joins, Subqueries, Set Operations,
Aggregation, Window Functions
DCL (Data Control Language):
o GRANT, REVOKE
TCL (Transaction Control Language):
o BEGIN, COMMIT, ROLLBACK
SQL Queries:
o All basic query techniques, filters, groupings, joins, subqueries, set operations, etc.