Guide
joins-and-analytics.md
Database II work with joins, subqueries, CTEs, window functions, and optimization.
markdown
Advanced SQL: Joins and Analytics
This page covers the Database II repository sections focused on joins, CTEs, relational operators, and analytical queries.
Repository
- DataBase-Level2-SQL - Intermediate and advanced SQL coursework.
Main Sections
- SQL review
- Joins, subqueries, and CTE
- Relational operators
- Practice set
- Window functions
- Evaluation on joins and indexing
Representative Links
- Find the murderer
- Expired policy query
- Municipalities by state
- Window function over client codes
- Evaluation query 8
Technical Focus
- Multi-table querying
- Subqueries and CTEs
- Window functions
- Analytical and evaluation-style SQL exercises