SQL for Tech and Data Science Interviews

Name: SQL for Tech and Data Science Interviews
Rating: 4.1 (475 reviews)

Do you want to ace your SQL tech or data science interview? This Is the perfect resource for you!

Created by365 Careers, Tina Huang

Last updated 6/2021

English

What you'll learn

Build a winning strategy for the tech/data science interview
How to focus on mock interviews
A guided walkthrough to a set of interview questions
Work on your communication skills and interview style
Tina’s 5-step framework to acing your SQL interview
Know what SQL interviewers want to hear from you
Anticipate follow-up questions
Be able to demonstrate how you think and reason
Reduce interview stress by doing the 10 mock interviews provided in the course

Course content

5 sections • 23 lectures • 2h 27m total length

Why Take This Course and What Does It Cover5:03
Tina coaches you through ten mock interviews using a five-step framework, linking hands-on SQL practice with real interview style to strengthen communication and problem-solving for data science and tech interviews.

Section Intro0:24
Start with an overview of SQL and setting up your environment for beginners. Learn what SQL is, the structure of a SQL query, and SQL functions.
What is SQL?1:29
Discover how SQL serves as a declarative language for creating and manipulating data in databases, focusing on table operations and setup of SQL software and datasets.
SQL Setup2:39
Install PostgreSQL and pgAdmin, create the interviews database, load the interviews setup SQL file, run queries, verify tables, and prepare to dive into practice problems.

Section Intro0:35
Discover a five step framework for mock interviews and watch it in action, with covid times guidance on whiteboard vs computer practice and a bonus whiteboard version.
5 Step Framework for SQL Interviews1:02
What Comes Next0:48
Mock Interview 114:21
Learn to analyze a post feature with SQL by measuring enters, posts, and cancels; compute daily success rates and compare by day of week using grouping and case expressions.
Mock Interview 217:03
Mock Interview 35:39
Mock Interview 44:21
Use dense_rank over partition by department to identify the top three unique salaries per department in the Twitter employee table, ordered by department and salary.
Mock Interview 512:25
Calculate distance per dollar for each Uber ride by dividing distance traveled by cost. Then compute absolute difference from month's average, rounded to two decimals, and order by request date.
Mock Interview 611:10
Mock Interview 77:26
Compute month-over-month revenue change by truncating dates to months, summing monthly values, using lag from prior month, and rounding to two decimals, ascending by month.
Mock Interview 89:43
Mock Interview 922:26
Mock Interview 1021:55
Explain calculating a per-user average session time from weblog events (page load/exit) with edge cases and a self-join approach. Discuss ad revenue from scroll downs and user experience considerations.

How to Recover from Mistakes2:03
Learn to recover quickly from mistakes in tech interviews by clarifying assumptions, thinking through steps in English before writing the query, and articulating a plan to fix errors.
How to Anticipate Followups1:12
How to Remain Calm1:32
Practice interview questions to reduce anxiety and demonstrate your data science skills. Build confidence by recognizing you belong, staying calm, and letting your performance show your capabilities.

Requirements

Intro to SQL covered. This is not an Intro to SQL course.

Description

You want to make sure you are ready for your tech/data science interview?

Do you want to learn from an instructor who works for one of the FAANG companies?

Great! Perhaps it was chance that brought you here, but now that you have found this resource, you are a step closer to building a deliberate strategy. You will learn how to focus on doing mock interviews with real interview questions and in a real interview style.

Please bear in mind that this is not an Intro to SQL course that goes in depth about every single concept and function available for you to work with. Instead, this is a resource that will help you ace the job interview and get hired, provided that you have already learned the SQL basics.

If you are looking for a guided walkthrough and coaching through 10 mock interviews – this is the right course for you.

Tina’s 5-step framework will prepare you to tackle any SQL interview question. You will find out what interviewers want to hear from you. Learning how to interact with them is a fundamental skill you will need to master. Oftentimes, potential employers will challenge your assumptions and ask for your thoughts simply because they want to see how you deal with unexpected situations and challenges. You must find a way to keep the conversation going and know how to shrug off any mistakes you make throughout the interview!

The goal of this course is for you to have done the SQL interview at least 10 times – so, when the real interview comes, it just feels like another practice round.

About the author: Tina Huang is a data scientist at one of the FAANG companies. She is also a popular YouTuber with over 60k subscribers. Tina is proud she taught herself SQL from scratch in 11 days to pass her FAANG SQL interview.

This course is one of the best resources you can choose to prepare yourself for the SQL interview you need, to land a job in tech and data science!

Who this course is for:

Aspiring data scientists
Aspiring data analysts
Aspiring business intelligence analysts
Anyone who needs to get through a SQL interview to land their dream job

SQL for Tech and Data Science Interviews

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

SQL Overview and Environment Setup3 lectures • 5min

Fundamental SQL Components3 lectures • 4min

Full Mock Interviews13 lectures • 2hr 9min

Bonus3 lectures • 5min

Requirements

Description

Who this course is for: