Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL
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 -
The Ultimate Guide to SQL Aggregate Functions
Aggregate Functions in SQL is the main tool for data aggregation and one of the most common topics when working with data.Nathan Rosidi -
Introduction to IFNULL() Function in SQL
Learn all about the SQL IFNULL() function in MySQL and PostgreSQL with the example of a hard-level Interview Question asked by Google.Nathan Rosidi -
SQL Cheat Sheet – Technical Concepts for the Job Interview
This SQL cheat sheet gives you a concise and practical overview of the SQL concepts you’ll need for the job interview.Nathan Rosidi -