Breaking into data engineer in Tech - Acing SQL interview

"Master SQL Skills and Land Your Dream Data Engineering Job in Tech"

Created byEmily Lau

Last updated 9/2024

English

What you'll learn

This course applies to all level learner who wants to break into tech and consulting area as a data engineer, business intelligence engineer or data analyst..
You will learn Basic, Medium and Advanced SQL topics that asked in SQL interviews.
Mock Session with 40 real interview questions asked by Meta, Google, Amazon and TikTok as example .
Ready to get you next million tech job, this is the course for you.

Course content

5 sections • 62 lectures • 5h 5m total length

Introduction of course1:07
Uncover Myths of SQL interview1:22

Group By1:59
Having1:01
Count0:40
Min and Max0:36
Sum0:57
Like1:11
Order of Execution0:38
Mocking Session: Example 1 (easy)4:10
Mocking Session: Example 2 (easy)5:55
Mocking Session: Example 3 (easy)5:06
Mocking Session: Example 4 (easy)4:31
Mocking Session: Example 5 (easy)7:32
Mocking Session: Example 6 (easy)4:25
Mocking Session: Example 7 (medium)5:17
Mocking Session : Example 8 (medium)13:01
Mocking Session: Example 9 (medium)4:59
Mocking Session: Example 10 (medium)3:28
Mocking Session: Example 11 (medium)4:11
Mocking Session: Example 12 (medium)9:50

Different Joins: Inner Join, Outer Joins, Cross Join2:16
Case When1:23
Union Vs Union All3:24
CTE Vs Subquery1:00
Mocking Session: Example 13 (easy)3:13
Mocking Session: Example 14 (easy)6:27
Mocking Session: Example 15 (easy)9:19
Mocking Session: Example 16 (easy)6:24
Mocking Session: Example 17 (medium)5:49
Mocking Session: Example 18 (medium)6:51
Mocking Session: Example 19 (medium)5:18
Mocking Session: Example 20 (medium)5:56
Mocking Session: Example 21 (medium)5:11
Mocking Session: Example 22 (medium)14:28
Mocking Session: Example 23 (medium)4:24
Mocking Session: Example 24 (medium)5:58
Mocking Session: Example 25 (medium)10:23
Mocking Session: Example 26 (medium)6:36
Mocking Session: Example 27 (medium)6:17
Mocking Session: Example 28 (medium)4:41
Mocking Session: Example 29 (medium)5:49
Mocking Session: Example 30 (medium)7:17
Mocking Session: Example 31 (medium)6:22
Medium SQL interview questions: Joins
Medium and hard SQL interview questions: CTE, Subquery
Medium SQL interview questions: Union, Union All
Medium and hard SQL interview questions: Case When

Ranking Functions: row_number(), rank(), dense_rank()2:25
Window Function: lead(), lag()2:32
Window Function: max(), min(), sum(), avg()1:16
Window Function: first_value(), last_value()0:34
Window Function: Rolling Average0:53
Mocking Session: Example 32 (easy)7:58
Mocking Session: Example 33 (medium)8:48
Mocking Session: Example 34 (medium)5:30
Mocking Session: Example 35 (medium)6:10
Mocking Session: Example 36 (medium)5:33
Mocking Session: Example 37 (medium)10:42
Mocking Session: Example 38 (hard)11:23
Mocking Session: Example 39 (hard)8:38
Mocking Session: Example 40 (hard)10:25
Medium and hard SQL practice questions: row_number(), rank(), dense_rank()
Medium and Hard SQL Practice Questions: lag(), lead()
Medium SQL Practice Questions: max(), min(), sum(), avg()
Medium and Hard SQL Practice Questions: first_value(), last_value()
Medium and Hard SQL Interview Questions: rolling average

Requirements

Basic knowledge on SQL, such as can write a few lines of SQL and knowing select, group by and order by.

Description

In today’s tech-driven world, data engineers are in high demand, and SQL is at the heart of almost every data engineering role. "Breaking into Data Engineering in Tech: Acing the SQL Interview" is designed to equip aspiring data engineers with the critical SQL skills needed to pass technical interviews and land a job in the tech industry.

This course offers a deep dive into SQL, covering everything from the basics to advanced query techniques commonly tested in data engineering interviews. You’ll learn to write optimized, efficient SQL queries for real-world scenarios, tackle complex problems involving large datasets, and understand key data warehouse principles.

Who This Course is For:

Aspiring data engineers, business intelligence engineer or business intelligence analyst preparing for SQL interviews in the tech industry
Software engineers or analysts looking to transition into data engineering roles
Professionals who want to strengthen their SQL skills and enhance their data manipulation expertis

What You Will Learn:

Master SQL query writing, including complex joins, subqueries, and data aggregation, window functions
Optimize queries for performance and handle large-scale datasets
Tackle common SQL interview questions with confidence
Understand database design, indexing, and normalization principles

Prepare yourself to break into one of the fastest-growing fields in tech by mastering SQL, a critical tool for every data engineer.

Who this course is for:

This course is for people who want pivot into data engineer, business intelligence engineer or data analyst role in tech or experienced data engineer having an upcoming SQL interview

Breaking into data engineer in Tech - Acing SQL interview

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

Chapter 1: Review Basic SQL knowledge19 lectures • 1hr 19min

Chapter 2: Review Medium SQL Knowledge23 lectures • 2hr 15min

Chapter 3: Advanced SQL Knowledge - Window Functions14 lectures • 1hr 23min

Chapter 4: Data Warehouse and Other SQL Interview Questions4 lectures • 6min

Requirements

Description

Who this course is for: