SQL
• CREATE, INSERT, UPDATE, ALTER, DELETE, and complex SELECT queries
• Joins, subqueries, CTEs, window functions, aggregations
• Views, indexes, constraints, primary and foreign keys
• Functions, triggers, and stored procedures
• Data extraction and reporting queries
• Query optimization and execution plan tuning