DBMS SQL Syllabus

Topic	Subtopics / What to Cover
SQL Basics	What is SQL ⭐ SQL vs PL/SQL ⭐ Types of SQL ⭐
Data Types	Numeric ⭐ Character ⭐ Date ⭐ Boolean ⭐ NULL ⭐
CREATE Table	CREATE TABLE syntax ⭐ Column definition ⭐ Basic constraints ⭐
INSERT	INSERT INTO Multiple row insert INSERT with SELECT
SELECT Basics	SELECT * ⭐ Column selection ⭐ DISTINCT ⭐
WHERE Clause & Operators	WHERE clause usage ⭐ AND, OR, NOT ⭐ =, !=, >, < ⭐ BETWEEN ⭐ IN ⭐ LIKE ⭐
ORDER BY, GROUP BY, HAVING	ORDER BY ASC/DESC ⭐ Multiple column ordering GROUP BY with aggregates ⭐ HAVING vs WHERE ⭐
Aggregate Functions	COUNT⭐ SUM ⭐ AVG ⭐ MIN ⭐ MAX ⭐
LIMIT / TOP	LIMIT (MySQL) ⭐ TOP (SQL Server) ⭐
Constraints	PRIMARY KEY ⭐ FOREIGN KEY ⭐ UNIQUE NOT NULL CHECK
ALTER Table	ADD column/constraint MODIFY column DROP column/constraint
DROP vs TRUNCATE	DROP vs TRUNCATE difference Use cases
UPDATE & DELETE	UPDATE with WHERE UPDATE multiple columns DELETE with conditions
Joins	INNER JOIN ⭐ Equi Join ⭐ LEFT JOIN ⭐ RIGHT JOIN ⭐ FULL OUTER JOIN ⭐ SELF JOIN CROSS JOIN ⭐
Subqueries	Nested subquery ⭐ Single-row subquery ⭐ Multi-row subquery ⭐ IN, ANY, ALL ⭐ Correlated subquery
Views	CREATE VIEW UPDATE through view
Indexes	CREATE INDEX ⭐ Advantages ⭐ Disadvantages
Keys (Practical)	Candidate Key ⭐ Primary Key ⭐ Foreign Key ⭐
NULL Handling	IS NULL IS NOT NULL COALESCE
Set Operations	UNION UNION ALL INTERSECT EXCEPT