Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Interviews
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 -
Methods for Ranking in Pandas
Learn how to rank data in Python Pandas using different methods. We use the Airbnb, Google, and Yelp datasets for practical examples.Nathan Rosidi -
The Pandas Cheat Sheet To Be a Better Data Scientist
Here is Pandas cheat sheet explaining the functions any data scientist should know. Included are interview questions from Forbes, Meta, Google, and Amazon.Nathan Rosidi -
Probability Cheat Sheet: Rules, Laws, Concepts, and Examples
This probability cheat sheet equips you with knowledge about the concept you can’t live without in the statistics world. Yes, it’s probability!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 -
Python Pandas Interview Questions for Data Science
An overview of the basics of data manipulation and the types of Python Pandas interview questions asked in Data Science Interviews.
Vivek Sankaran -
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 -