Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Interviews
Python Pandas Interview Questions for Data Science
An overview of the basics of data manipulation and the types of Python Pandas interview questions asked in Data Science Interviews.
Vivek Sankaran -
Top Most Common SQL Coding Errors in Data Science
Let's look at some common SQL coding errors that data science beginners usually make. We will look at the concepts and hands-on practice using real examples.
Nathan Rosidi -
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
UNION vs UNION ALL is a crucial decision that analysts make daily. A wrong choice leads to erroneous business metrics. This article will help you avoid that.
Tihomir Babic -
Python Cheat Sheet – Technical Concepts for the Job Interview
A quick reference Python cheat sheet for learning the common tasks. Data structures, functions, data wrangling – the basics any data scientist should know.Vivek Sankaran -
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 -