Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Interviews
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 -
Data Architect Interview Questions You Should Be Prepared to Answer
A deep dive into conquering data architect interview questions: an in-depth exploration and strategic preparation guide for aspiring data architects.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 -
A Comprehensive Statistics Cheat Sheet for Data Science Interviews
The statistics cheat sheet overviews the most important terms and equations in statistics and probability. You’ll need all of them in your data science career.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 -
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 -