3 SQL Games that will take your SQL skills to the next level

🧵👇 1. SQL Murder Mystery

A murder has happened in SQL city!

Can you use your SQL knowledge to find the killer?

mystery.knightlab.com

“couldn't find an internship so I built an AI Robot Hand”

Creating portfolio projects is an amazing way to stand out on the job hunt but I've never seen someone do a project as well as Alan Lu & his robot hand!

Want your portfolio project to stand out too?

Here's 3 tips 🧵 ✅ Align the project to your dream job

Want to work in robotics?

Do what Alan did!

Want to work in healthcare analytics?

Go on Kaggle, analyze a free CDC dataset, then visualize your results publicly on Tableau!

Want to be a PM?

Mock up & spec a new feature for Twitter!

Can you solve this real Microsoft SQL interview question:

“Which Azure customer buys at least 1 Azure product from each product category?”

You're given a customer_contracts table & a table of Azure products. Hints:

• Join the two tables with either a LEFT or INNER JOIN

• Count all of the distinct product categories that a customer has purchased a product from using COUNT(DISTINCT products.product_category) AS unique_count

Data Science Interviews cover a HUGE range of topics:

🔹 Data Structures & Algorithms
🔹 Product/Business Sense
🔹 Machine Learning
🔹 Statistics
🔹 Python
🔹 SQL

Seems like a lot?

IT F**KING IS !!

Here's why Data Science interviews seem to cover everything under the sun 🧵👇 In an ideal world, Data Science candidates are only evaluated on the skills needed for the job they will be doing.

But the reality is that many Hiring Managers don't know exactly what Data Science projects their team will work on next quarter, let alone next year.

8 must-read books to land a Product Data Science or Product Analytics job:

(along with a guided 12 week study plan)

🧵👇 First, refresh your statistics fundamentals by spending 2 weeks on OpenIntro Stats.

Don't skip this step, or you'll get wrecked by the A/B testing & ML concepts built on stats foundations

You can find a free version of the OpenIntro textbook here:
openintro.org/book/os/

Advanced SQL Interviews LOVE to test you on Window Functions.

Here's 4 real SQL interview questions from Uber, Google, Spotify & Wayfair to practice SQL window functions like:
• LEAD()
• LAG()
• RANK()
• DENSE_RANK()
• ROW_NUMBER()
• NTH_VALUE()

🧵👇 𝐔𝐛𝐞𝐫 𝐒𝐐𝐋 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧

Uses Row_Number() to find the 3rd ride booked:
datalemur.com/questions/sql-…

Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.

Here's 15 Data Analytics Questions Google expects you to know:

(how many can you answer??) 1. Not all data or inputs for analysis arrive in perfect condition.

Explain some of the errors or problems you might look for as part of the data cleaning process.

My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year 🎉

($120k base, $40k stock, $15k annual bonus)

Here's the 17 interview questions they were asked:

(how many of these could you answer?) 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 🤖

1. What is PCA, why is it helpful, and how does it work?

2. What is heteroskedasticity, and how can you check for it?

3. After loading the Boston house prices dataset (it comes with scikit-learn), can you find any outliers in the data?

My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year 🎉

($120k base, $40k stock, $15k annual bonus)

Here's the 17 interview questions they were asked:

(how many of these could you answer?) 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 🤖

1. What is PCA, why is it helpful, and how does it work?

2. What is heteroskedasticity, and how can you check for it?

3. After loading the Boston house prices dataset (it comes with scikit-learn), can you find any outliers in the data?

Linear Algebra is FOUNDATIONAL to Data Science & Machine Learning.

Here’s 3 FREE Linear Algebra resources I highly recommend to build a strong foundation 🧵👇 𝐄𝐬𝐬𝐞𝐧𝐜𝐞 𝐨𝐟 𝐋𝐢𝐧𝐞𝐚𝐫 𝐀𝐥𝐠𝐞𝐛𝐫𝐚 𝐏𝐥𝐚𝐲𝐥𝐢𝐬𝐭:

At only ~2.5 hours long, in the time it takes you to watch a movie you could instead develop some helpful intuitions about linear algebra!

youtube.com/playlist?list=…

Do you know SQL?

PROVE IT – try to solve this real Microsoft SQL Interview question with me 👇 Write a SQL query to identify the top 2 Power Users who sent the highest number of messages on Microsoft Teams in August 2022.

Display the IDs of these 2 users along with total num of messages they sent.

Output the results in descending order based on number of messages.

Learn Data Science For FREE:

SQL→
Python →
Statistics →
Machine Learning → sqlbolt.com
LearnPython.org
bit.ly/StatEssentials
bit.ly/CourseraMLCour… Practice Data Science For FREE:

SQL →
Python →
Statistics →
Machine Learning → DataLemur.com
CodingBat.com/python
bit.ly/StatsInterview…
Kaggle.com

REAL Spotify SQL Interview Question – can you solve it??

(SQL problem in next Tweet 👇) Given three Spotify tables (artists, songs, and global_song_rank)

Write a query to find the top 5 artists whose songs appear most frequently in the Top 10 of the global_song_rank table.

Display the top 5 artist names in ascending order, along with their rank.

Learn SQL in 30 days for FREE with these 5 amazing resources:

(be sure to bookmark this 30-Day SQL Roadmap)

A thread🧵👇 Week 1 🗓️

Work through the first 12 free interactive lessons on SQL Bolt.

This will teach you
○ SELECT
○ WHERE
○ JOINS
○ Aggregate Functions

Don't worry about the Update/Create/Alter table lessons - skip these!

sqlbolt.com

3 SQL Games that will take your SQL skills to the next level

🧵👇 1. SQL Murder Mystery

A murder has happened in SQL city!

Can you use your SQL knowledge to find the killer?

mystery.knightlab.com

Google recently released an "Interview Warmup" tool, to help candidates who are applying to Data Analytics jobs at Google better prep for their technical interview.

Here's 15 Data Analytics Questions Google expects you to know:

(how many can you answer??) 1. Not all data or inputs for analysis arrive in perfect condition.

Explain some of the errors or problems you might look for as part of the data cleaning process.

A past coaching client of mine interviewed for an entry-level Data Science job in Los Angeles that paid $110k per year.

Here's the 19 interview questions they were asked:

(how many of these could you answer?) 𝐒𝐭𝐚𝐭𝐢𝐬𝐭𝐢𝐜𝐬 🔢

1. Explain the difference between population variance vs sample variance

2. Describe a p-value to a 13-year-old (8th grader)

3. What Does an R-Squared Value of 0.9 Mean?

Can you solve this TikTok SQL Interview Question?

Write a query to find users who didn't confirm their sign-up on the 1st day, but confirmed on the 2nd day. 𝐅𝐮𝐥𝐥 𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭:

You're given tables about user sign-ups & confirmations through email and text.

Write a query to find users who didn't confirm their sign-up on the 1st day, but confirmed on the 2nd day.

3 SQL Games that will take your SQL skills to the next level

🧵👇 1. SQL Murder Mystery

A murder has happened in SQL city!

Can you use your SQL knowledge to find the killer?

https://t.co/UHBZEOfdYgmystery.knightlab.com

Linear Algebra is FOUNDATIONAL to Data Science & Machine Learning.

Here’s 3 FREE Linear Algebra resources I highly recommend to build a strong foundation 🧵👇 𝐄𝐬𝐬𝐞𝐧𝐜𝐞 𝐨𝐟 𝐋𝐢𝐧𝐞𝐚𝐫 𝐀𝐥𝐠𝐞𝐛𝐫𝐚 𝐏𝐥𝐚𝐲𝐥𝐢𝐬𝐭:

At only ~2.5 hours long, in the time it takes you to watch a movie you could instead develop some helpful intuitions about linear algebra!

youtube.com/playlist?list=…

My 22-year old coaching client landed a new-grad Machine Learning job at a NYC startup that pays $175k per year 🎉

($120k base, $40k stock, $15k annual bonus)

Here's the 17 interview questions they were asked:

(how many of these could you answer?) 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 🤖

1. What is PCA, why is it helpful, and how does it work?

2. What is heteroskedasticity, and how can you check for it?

3. After loading the Boston house prices dataset (it comes with scikit-learn), can you find any outliers in the data?