Repository with exercises from SQL Fundamentals Track - DataCamp
- Relational Databases
- Querying
- Selecting Data
- Filtering Records
- Aggregate Functions
- Sorting and Grouping
- Introducing Inner Joins
- Outer Joins, Cross Joins and Self Joins
- Set Theory for SQL Joins
- Subqueries
- CASE
- Short and Simple Subqueries
- Correlated Queries, Nested Queries and Common Table Expressions
- Window Functions
- Introduction to Window Functions
- Fetching, Ranking and Paging
- Agggregate window functions and frames
- Beyond window functions
- Overview of Common Data Types
- Working with DATE/TIME Functions and Operators
- Parsing and Manipulating Text
- Full-Text and PostgreSQL Extensions