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
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 -
Top 30 SQL Query Interview Questions
Today we’re having a look at the top 30 SQL query interview questions and concepts that you must prepare for an SQL coding interview.Nathan Rosidi -
Data Science Coding Interview Questions with 5 Technical Concepts
Understanding 5 coding concepts of data science coding interview questions that companies will test you on and preparing for them effectively.Nathan Rosidi -
SQL Interview Questions You Must Prepare: The Ultimate Guide
This ultimate guide will take you through the top SQL interview questions for various data positions and tips to approach your next interview.Nathan Rosidi -
The Best Way to Learn SQL for Data Science
You don’t know how to learn SQL? No more excuses! This is a detailed guide to the best ways of learning this most in-demand skill.Nathan Rosidi -
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 -
Best Practices to Write SQL Queries: How To Structure Your Code
This article focuses on how to write SQL queries correctly and how it can still be improved, in particular when it comes to performance and readability.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 -