Microsoft Word

🔹 BASIC SQL

1. Introduction to Database

• What is Data

• What is Database

• Database applications

• File System vs Database System

2. DBMS & RDBMS

• What is DBMS

• Limitations of DBMS

• What is RDBMS

• Difference between DBMS & RDBMS

3. Table & Keys Concept

• Table, Row, Column

• Primary Key

• Foreign Key

• Candidate Key

• Composite Key

4. Introduction to SQL

• What is SQL

• Why SQL is used

• Features of SQL

• SQL as a declarative language

5. Types of SQL Commands

• DDL

• DML

• DQL

• DCL

• TCL

🔹 CORE SQL (MOST IMPORTANT PART)

6. DDL Commands

• CREATE

• DROP

• TRUNCATE

• ALTER

  • ADD

  • MODIFY

  • DROP

7. Data Types

• Numeric data types

• Character data types

• Date & Time data types

8. DML Commands

• INSERT

• UPDATE

• DELETE

9. DQL Command (SELECT)

• SELECT statement

• SELECT with column names

• SELECT DISTINCT

• WHERE clause

10. Operators in SQL

• Arithmetic operators

• Comparison operators

• Logical operators

• BETWEEN

• IN

• LIKE

• IS NULL

11. Sorting & Filtering

• ORDER BY

• LIMIT / TOP (conceptual)

🔹 INTERMEDIATE SQL

12. Aggregate Functions

• COUNT

• SUM

• AVG

• MIN

• MAX

13. GROUP BY & HAVING

• GROUP BY clause

• HAVING clause

• Difference between WHERE & HAVING

14. Joins in SQL

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• SELF JOIN

15. Subqueries

• Subquery concept

• Single-row subquery

• Multiple-row subquery

• Subquery with IN, EXISTS

🔹 ADVANCED SQL

16. Constraints

• NOT NULL

• UNIQUE

• PRIMARY KEY

• FOREIGN KEY

• CHECK

• DEFAULT

17. Views

• What is a View

• CREATE VIEW

• DROP VIEW

• Advantages of Views

18. Indexes

• What is Index

• CREATE INDEX

• DROP INDEX

• Advantages & disadvantages

19. Transactions (TCL)

• COMMIT

• ROLLBACK

• SAVEPOINT

• Transaction concept

20. DCL Commands

• GRANT

• REVOKE

21. SQL Clauses Recap

• WHERE

• GROUP BY

• HAVING

• ORDER BY