Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Types of Pandas Joins and How to use them in Python
Here are different types of pandas joins and how to use them in Python. Inner, Outer, Right, and Left joins are explained with examples from Amazon and Meta.
Nathan Rosidi -
Postgres Aggregate Functions You Must Know
In this article, we’ll explain the most popular Postgres aggregate functions, discuss their use cases, and answer five interview questions by top employers.
Irakli Tchigladze -
30 Product Analyst Interview Questions
Here are 30 Product Analyst Interview Questions and answers, including Python, SQL, A/B Testing, Probability and Statistics, and Product Questions.Nathan Rosidi -
The Essential 3 Data Science Projects to Land Your Dream Job
Here are 3 projects that will help land a data science job. These projects improve all five fundamental skills you’ll have to showcase in an interview.Nathan Rosidi -
Amazon SQL Interview Questions
In this article, we will discuss how to solve one of the interesting Amazon SQL interview questions using several different approaches!Nathan Rosidi -
Digging Deeper Into SQL Temp Tables
This article helps you unlock the power of SQL temporary or temp tables. Improve your query efficiency, data analysis, and data transformation with them.Nathan Rosidi -
Mastering the SQL Subqueries With Multiple Tables
Mastering the tools to use subqueries involving multiple tablesNathan Rosidi -
MySQL Interview Questions
Interview questions to learn MySQL from the basics and get ready for your next Data Science Interview involving the most popular open-source SQL database in the world.
Vivek Sankaran -
Why SQL is THE Language to Learn for Data Science
Outdated, non-cool, and basic – is that what you think of it? SQL is none of that! Here’s why you can’t avoid it in data science, and it’s here to stay.Nathan Rosidi -
Mastering SQL DENSE_RANK(): A Comprehensive Guide
How do you use SQL DENSE_RANK() to rank data in SQL? This guide will help you become a master in SQL ranking window functions.Nathan Rosidi -
Breakdown of the Data Analyst Salary and Job Market
Who are data analysts and how high is their salary? What skills do you need to become one? You'll find the answers to these questions in this article.Nathan Rosidi -
Python's Advanced Concepts: Copying, Regex, Decorators
Unlocking Python's Potential: Exploring Advanced Concepts - Shallow vs. Deep Copying, Regular Expressions, and DecoratorsNathan Rosidi -