Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Guides
The Ultimate Guide to SQL Window Functions
This ultimate guide is a complete overview of the types of SQL window functions, their syntax and real-life examples of how to use them in queries.
Nathan Rosidi -
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 -
A Beginner’s Guide to Collinearity: What it is and How it affects our regression model
What is Collinearity? How does it affect our model? How can we handle it?Nathan Rosidi -
Basic Types of Statistical Tests in Data Science
Navigating the World of Statistical Tests: A Beginner’s Comprehensive Guide to the Most Popular Types of Statistical Tests in Data ScienceNathan 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 -
LeetCode Python Solutions for Data Science
How does a data scientist use LeetCode to practice their python skills for their data science interviews?Nathan Rosidi -
19 Data Science Project Ideas for Beginners
This article will offer 19 data science project ideas for beginners. Pick one or all of them - whatever looks like the most fun to you.
Zulie Rane -
4 Python Data Visualization Libraries You Can’t Do Without
Matplotlib, seaborn, Plotly, and pandas - the 4 Python data visualization libraries you can’t do without. Learn how to use them with our code examples.Nathan Rosidi -
Data Mining Projects: With Source Codes
Unlock the Full Potential of Data with Expert-Guided Data Mining Projects and Source Code.Nathan Rosidi -