Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL Articles, Tutorials & Interview Questions
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 -
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
Lacking confidence for the product analyst interviews? 30 questions, 7 topic categories, numerous interview tips, and practice opportunities will fix that.Tihomir Babic -
Amazon SQL Interview Questions
Amazon SQL Interview Questions: The Real Patterns, Traps, and Query Skills Amazon Actually Tests.Sara Nobrega -
Digging Deeper Into SQL Temp Tables
This article helps you unlock the power of SQL temporary or temp tables. Improve your query efficiency, data analysis, and data transformation with them.
Nathan Rosidi -
Mastering the SQL Subqueries With Multiple Tables
Mastering the tools to use subqueries involving multiple tablesNathan Rosidi -
MySQL Interview Questions
Interview questions to learn MySQL from the basics and get ready for your next Data Science Interview involving the most popular open-source SQL database in the world.
Vivek Sankaran -