This repository contains solutions to exercises from "SQL Beginner to Advanced For Data Professionals" course by CodeBasics.
The tasks simulate real-life organizational business problems, and the course provided me with a valuable learning experience.
Course Curriculum:
- SQL Basics (SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY, etc.)
- Joins (LEFT, RIGHT, INNER, FULL, CROSS)
- Subqueries, CTEs, Views, Temporary Tables
- Fundamentals of ETL, Data Warehouse, OLAP, OLTP
- User Defined Functions, Stored Procedures
- Window Functions (Over, ROW_NUMBER, RANK, DENSE_RANK, etc.)
- Data Engineer-Specific Topis: Indexes, Triggers, Events, User Accounts & Privileges
- Kanban Project Management