Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL
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 -
Advanced SQL Interview Questions You Must Know How to Answer
Advanced SQL interview questions that every data scientist should know. It is quite important to understand what is being tested and how you can prepare for it.Nathan Rosidi -
Different Types of SQL JOINs that You Must Know
In this article, we will discuss different types of SQL JOINs and show practical examples to help you wrap your head around a variety of JOINs in SQL.
Irakli Tchigladze -
Facebook Data Engineer Interview Questions
Interview questions for all the data engineers that wish to work at Meta/Facebook. We carefully selected the interview questions to reflect the data engineer job description as closest as possible.Nathan Rosidi -
Computing Cumulative Sum in SQL Made Easy
Showing you what the cumulative sum is and how to calculate it in SQL. We’ll go through three distinct methods, so you can use whichever method you like best.Nathan Rosidi -
SQL COALESCE() Function: A Guide for PostgreSQL Users
Learn how to handle null values with ease and efficiency using the versatile COALESCE() function in PostgreSQL, with practical examples and insights.Nathan Rosidi -
SQL BETWEEN Operator: Selecting the Range of Values
Learn how to select the data interval using the SQL BETWEEN. We will show you its syntax and different scenarios of using it in filtering and labeling data.Nathan Rosidi -
Technical Skills Needed as a Data Analyst with 1-2 Years of Experience
An overview of the top must-have technical skills a data analyst needs to stay competitive in the job market.Vivek Sankaran -