Topics - SQL and Pandas

Fundamentals

• SELECT in SQL
• Primary Key and Foreign Key
• JOINS in SQL
• Aggregate functions and Group By
• WHERE and HAVING in SQL
• Working with Dates in SQL
• ORDER BY in SQL
• Sub-queries in SQL
• Operations with Sets in SQL
• LIKE operator in SQL
• ALL and ANY operators in SQL
• EXISTS operator in SQL

SQL Advanced Concepts

• Window Functions
• Common Table Expressions (CTE)
• Views and Materialized Views
• Stored Procedures
• Triggers and Events
• Database Indexing
• Transaction Management
• Database Optimization