SQL Interview Prep for Data Analyst and Data Engineer (Junior Level)

Ace your SQL interviews with this focused course covering essential query writing, data manipulation, and optimization techniques for junior data analysts and engineers.

...

SQL Fundamentals: Querying and Filtering Data

Unit 1: Basic SQL Queries

Unit 2: Sorting and Limiting Results

Unit 3: SQL Data Types and Constraints

Joining Tables and Subqueries

Unit 1: Mastering INNER JOINs

Unit 2: Exploring OUTER JOINs

Unit 3: Subqueries: Queries within Queries

Unit 4: CTEs: Simplifying Complex Queries

Data Aggregation and Window Functions

Unit 1: Data Aggregation with GROUP BY

Unit 2: Filtering Aggregated Data with HAVING

Unit 3: Window Functions

Data Manipulation and Query Optimization

Unit 1: Data Manipulation with SQL

Unit 2: Query Optimization Techniques

Unit 3: Practical SQL Problem Solving