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
SQL Interview Questions for the Data Analyst Position
Let's go over several examples which highlight some of the most important SQL concepts you’ll see in the SQL interview questions for Data Analyst position.
Nathan Rosidi -
Postgres vs MySQL: Which is Better for Analytics?
Postgres vs MySQL: Looking into differences (and some similarities) between PostgreSQL and MySQL to help you decide which one suits your needs best.Nathan Rosidi -
Database Interview Questions
We’ll show you the most common SQL concepts you need to know to solve database interview questions.Nathan Rosidi -
The Ultimate Guide to Sorting in SQL
Mastering sorting in SQL is useful for both amateur and advanced programmers regardless of industry. Let's take a look at some real-life SQL sorting problems.Nathan Rosidi -
Microsoft SQL Interview Questions
We'll discuss one of the interesting Microsoft SQL interview questions to help prepare you for applying for a role as a Microsoft data scientist.Nathan Rosidi -
LinkedIn Data Scientist Interview Questions
In this article, we’ll work through one of the common LinkedIn Data Scientist Interview questions requiring a wide range of SQL skills.Nathan Rosidi -
40+ Data Science Interview Questions From Top Companies
Overwhelming you with the data science interview questions is the only way to make sure your data science interview doesn’t end underwhelmingly.Nathan Rosidi -
Data Analyst Interview Questions and Answers
In this article, we will discuss top data analyst interview questions and required skills from recent data analyst interviews at top companies.Nathan Rosidi -
The Ultimate Guide to SQL Window Functions
This is a complete overview of the SQL window functions. Learn everything you need to know about them to excel at your job interview and an actual job.
Tihomir Babic -
SQL CTEs: Usage, Advantages, and Drawbacks
All about SQL CTEs or Common Table Expressions, their types, and usage. We will also discuss the advantages and disadvantages of using them in your SQL queries.Nathan Rosidi -
How to Join 3 or More Tables in SQL
Here we’re going to talk about using a commonly required SQL concept - how to join 3 or more tables in SQL.Nathan Rosidi -
An Introduction to the SQL Rank Functions
This introduction covers two of the most common SQL Rank Functions, their differences, and how to use them.Nathan Rosidi -