Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL
Similarities & Differences: Left Join vs. Left Outer Join
Today, we have a clash of titans: LEFT JOIN vs. LEFT OUTER JOIN! Are they different at all? Why answer ‘yes’ or ‘no’ when we can write an article on that?
Nathan Rosidi -
How To Use LeetCode For Data Science SQL Interviews
Is LeetCode built for data science interview preparation? Let’s find out!Nathan Rosidi -
Advanced SQL Concepts to Improve Your and Code’s Performance
In this article, we’ll discuss advanced SQL concepts and their use cases. Then we’ll use them to answer interview questions from reputable employers.
Irakli Tchigladze -
How to Simplify Complex SQL Queries (With Examples)
In this article, we’ll discuss various ways to simplify complex SQL queries and apply these tips to answer difficult SQL interview questions.Irakli Tchigladze -
SQL Scenario Based Interview Questions and Answers
SQL scenario based interview questions to learn how to wrangle date time fields for Facebook data science interviews.
Sara Nobrega -
Joining Multiple Tables in SQL - Examples and Walkthrough
We’ll show you how to use JOINs to join multiple tables in SQL and how choosing a specific type of JOIN can change the outcome of the query.Irakli Tchigladze -
SQL UNION vs UNION ALL: Differences You Need to Know
In this article, we’ll discuss differences and similarities between UNION vs UNION ALL, possible use cases, and compare the performance of two set operators.Irakli Tchigladze -
Data Engineer SQL Interview Questions From Top Employers
In this article, we will list important SQL concepts and walk you through 10 data engineer SQL interview questions asked by employers like Google and Amazon.Irakli Tchigladze -
A Comprehensive Guide to CASE WHEN statements in SQL
Let’s explore the basic and advanced syntax of CASE WHEN statements in SQL and show how to use CASE statements to answer difficult interview questions in SQL.Irakli Tchigladze -
Postgres Aggregate Functions You Must Know
In this article, we’ll explain the most popular Postgres aggregate functions, discuss their use cases, and answer five interview questions by top employers.Irakli Tchigladze -
30 Product Analyst Interview Questions
Here are 30 Product Analyst Interview Questions and answers, including Python, SQL, A/B Testing, Probability and Statistics, and Product Questions.Nathan Rosidi -
Amazon SQL Interview Questions
In this article, we will discuss how to solve one of the interesting Amazon SQL interview questions using several different approaches!Nathan Rosidi -