Basic SQL

• Basic structure of SQL Queries
• SELECT, WHERE, FROM GROUP BY, HAVING, ORDER BY, LIMIT
• Comparison Operators
• Logical Operators
• LIKE, IN, BETWEEN, IS NULL, AND, OR, NOT
• Data Manipulation
  • INSERT
  • UPDATE
  • DELETE
  • TRUNCATE
• Data Definition
  • CREATE
  • ALTER
  • DROP

Intermediate SQL

• SQL Aggregate Functions
• COUNT, SUM, MIN/AVG, GROUP BY, HAVING, CASE
• JOINS
  • INNER JOIN
  • OUTER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • SELF JOIN
  • JOINS using WHERE or ON
  • JOINS with Comparison Operators
  • JOINS on Multiple Keys
• Set Operations
  • UNION
  • INTERSECT
  • EXCEPT

Advanced SQL

• Data Types
• Date Format
• Subqueries in SQL
• Data Wrangling with SQL
• Using SQL String Functions to Clean Data
• Indexes to optimize query performance
• Views to simplify complex queries and enhance security
• Transactions
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
• Triggers to automate certain actions based on database events
• Normalization to design efficient database schemas
• Analytic Functions
• Performance Tuning SQL queries
• Pivoting Data in SQL