- Grouping Data with GROUP BY
- Aggregate functions with GROUP BY
- HAVING vs WHERE
- Subqueries and Nested Queries
- Single-row and multi-row subqueries
- Correlated subqueries
- Modifying Table Structure
- ALTER TABLE: Adding, modifying, and deleting columns
- DROP TABLE: Removing tables from the database
- Creating and Managing Indexes
- What is an index?
- Creating and dropping indexes
- SQL Constraints
- Primary Key, Foreign Key, Unique, Not Null, and Default constraints
- Introduction to Views
- Creating and managing views
- Benefits of using views
- Transactions in SQL
- What are transactions?
- COMMIT, ROLLBACK, and SAVEPOINT
- User Access Control
- GRANT and REVOKE permissions
- Role-based access control in SQL
- Best Practices and Optimization
- Writing efficient queries
- Avoiding common SQL pitfalls