Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL
MS SQL vs MySQL: Similarities and Differences
Facing the choice of MS SQL vs MySQL? Here’s a guide through the similarities and differences of these two popular database systems.
Nathan Rosidi -
Understanding SQL's INTERSECT Command
What is INTERSECT in SQL? How does it work? When to use it? How to write an INTERSECT query? You can find all these questions answered in this article.Nathan Rosidi -
An In-Depth Guide to SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT is a powerful statement for removing duplicates from your data. Learn how to use it in different scenarios and what its alternatives are.Nathan Rosidi -
A Comprehensive Review of Online Platforms for SQL Practice
This article will give you directions on how to practice SQL online. We talk about the best SQL platforms and practices you should apply when learning online.Nathan Rosidi -
Clustered vs. Non-Clustered Indexes in SQL
Today’s showdown is clustered vs. non-clustered indexes. Learn more about their features, strengths, and weaknesses, and join us to see who wins this fight.Nathan Rosidi -
MS SQL Interview Questions That Will Challenge Your Skills
Solving actual MS SQL interview questions is the best way of preparing for a technical interview. Here’s a detailed guide on how to challenge your skills.Nathan Rosidi -
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 -