Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
How to Use SELECT INTO in SQL for Analytics
SELECT INTO is an often-overlooked tool for analytics. Here we explain its syntax, use cases, how to use it in staging, and how it is tested in interviews.
Tihomir Babic -
Retention in SQL: How to Calculate User and Cohort Retention?
One-stop shop for product data scientists and job candidates: what is retention and its different types, how to calculate them, with the SQL application.
Shivani Arun -
What Is the Role of SQL Substring in Queries?
We explore the use of the SQL SUBSTRING() function to demonstrate its power in analyzing string formats, both for interview preparation and handling data.Shivani Arun -
Simplifying Python’s IF and AND Statements
Python IF and AND statements help you write clear, correct conditional logic by safely combining checks, handling edge cases, and keeping your code readable, efficient, and maintainable.
Sara Nobrega -
Understanding FLOOR and CEILING Functions in SQL
We explore fundamental concepts of FLOOR and CEILING functions in SQL and demonstrate their value for interview preparation and handling data at scale.Shivani Arun -
How to Use Python Multiprocessing for Better Performance
A quick guide to Python multiprocessing: Speeding up heavy Python tasks by running code in parallel, and knowing when to use threads or async instead.
Nathan Rosidi -
Python Inner Classes: A Guide to Using Class in a Class
Inner classes, an advanced form of Python classes, are explained with simple use cases, common mistakes, and best practices.Nathan Rosidi -
How to Iterate Over a Dictionary in Python?
We explore fundamental concepts in Python ‘Iterate’ over a ‘Dictionary’ (dict) and learn iteration methods to search, update, modify, and transform data.Shivani Arun -
Career Path for Artificial Intelligence Engineers
Artificial intelligence engineers are a very hot commodity in today's data jobs market. Learn everything you need to know about an AI engineering career.Nathan Rosidi -
How to Conduct a T-Test in R for Data Analysis
Learn to run t-tests in R: check assumptions, interpret statistical results, and apply insights effectively to real-world data analysis projects.Nathan Rosidi -
How to Create Pivots in SQL (with examples)
Reshaping data using Pivots is table-stakes in data science. Learn about its importance, techniques, and implementation.Shivani Arun -
Creating a Python Linked List Step by Step
Build a stack using a Python linked list, understand the logic, memory flow, and interview-ready reasoning behind it.Nathan Rosidi -