Scribd
Upload
4 views3 pages

Complete SQL Topics

The document outlines a comprehensive SQL curriculum covering topics from basics to advanced concepts. It includes essential SQL commands, data manipulation techniques, filtering, sorting, aggregation, joins, subqueries, constraints, indexes, views, stored procedures, triggers, window functions, transactions, and advanced topics like normalization and query optimization. This structured approach is designed for learners to progressively build their SQL skills.

Uploaded by

aravindkumarcs216
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

Complete SQL Topics

The document outlines a comprehensive SQL curriculum covering topics from basics to advanced concepts. It includes essential SQL commands, data manipulation techniques, filtering, sorting, aggregation, joins, subqueries, constraints, indexes, views, stored procedures, triggers, window functions, transactions, and advanced topics like normalization and query optimization. This structured approach is designed for learners to progressively build their SQL skills.

Uploaded by

aravindkumarcs216
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

■ Complete SQL Topics (Beginner → Advanced)

1. Basics
• What is SQL, DBMS, RDBMS
• Database, Table, Row, Column
• DDL (CREATE, ALTER, DROP, TRUNCATE)
• DML (INSERT, UPDATE, DELETE)
• DQL (SELECT)

2. Filtering Data
• WHERE clause
• Logical operators: AND, OR, NOT
• Comparison operators: =, >, <, >=, <=, <>
• BETWEEN, IN, LIKE, IS NULL

3. Sorting & Limiting


• ORDER BY (ASC/DESC)
• LIMIT / TOP

4. Aggregate Functions
• COUNT, SUM, AVG, MIN, MAX

5. Grouping Data
• GROUP BY
• HAVING

6. Joins
• INNER JOIN
• LEFT JOIN / RIGHT JOIN
• FULL OUTER JOIN
• SELF JOIN
• CROSS JOIN

7. Subqueries
• Subquery in WHERE
• Subquery in SELECT
• Subquery in FROM
• Correlated subqueries

8. Set Operations
• UNION, UNION ALL
• INTERSECT
• EXCEPT / MINUS

9. Constraints
• PRIMARY KEY
• FOREIGN KEY
• UNIQUE, NOT NULL, DEFAULT, CHECK

10. Indexes & Keys


• Clustered vs Non-clustered index
• Composite keys
• Surrogate keys

11. Views
• Creating views
• Updating through views
• Dropping views

12. Stored Procedures & Functions


• Creating procedures
• Parameters (IN, OUT)
• User-defined functions (UDFs)

13. Triggers
• BEFORE / AFTER triggers
• Row-level vs Statement-level triggers

14. Window Functions (Advanced)


• ROW_NUMBER()
• RANK()
• DENSE_RANK()
• NTILE()
• OVER (PARTITION BY … ORDER BY …)

15. Transactions
• BEGIN, COMMIT, ROLLBACK
• ACID properties

16. Advanced Topics


• Normalization (1NF, 2NF, 3NF, BCNF)
• Denormalization
• CTEs (WITH clause)
• Materialized Views
• Query Optimization (EXPLAIN, indexes usage)

You might also like