Introduction to SQL:

• What are database and SQL and how they can be used together to drive analytics on big data?

How to store and modify the data in a database:

• DDL Commands: CREATE, ALTER, DROP, TRUNCATE, etc.
• Data Types: VARCHAR, INT, DECIMAL, DATE, BOOLEAN, etc.
• Constraints: PRIMARY KEY UNIQUE KEY and NOT NULL etc.
• DML Operations : INSERT, UPDATE, DELETE etc.

How to retrieve data: The SELECT Statement

• Basic select clause operations: Distinct, Limit, Order By
• The filter(WHERE) clause: Logical operators, Comparison operators, Advance filters
• Aggregation and Advance Aggregation: Group by, Partition By, Rows Between clause, Rolling Calculations, Filter with Having clause
• SQL JOINS: INNER, LEFT, RIGHT, FULL OUTER, SELF, CROSS
• SET Operations: UNION, UNION ALL, MINUS, INTERSECT
• Calculated Columns and SQL Functions: CASE WHEN, Date Functions, String Functions, Data type conversion functions, etc.

Queries within queries: Subqueries and CTE (With Clause)

Window Analytical Functions: RANK, ROW_NUMBER, DENSE_RANK, LEAD/LAG, NTILE

Performance Tuning: Clustered and non-clustered indexes, best practices for SQL optimization

SQL problems set for interview preparations.