Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Interviews
Top 15 SQL Server DBA Interview Questions
SQL Server DBA interviews: writing window functions, retention queries, explaining indexing internals and isolation levels.
Sara Nobrega -
SQL ROW_NUMBER() Function: Syntax and Applications
How to add SQL ROW_NUMBER() to your data handling and analysis tools? We’ll help you by explaining its workings, its syntax, and how to use it in examples.
Nathan Rosidi -
MS SQL vs MySQL: Similarities and Differences
Facing the choice of MS SQL vs MySQL? Here’s a guide through the similarities and differences of these two popular database systems.Nathan Rosidi -
Understanding SQL's INTERSECT Command
What is INTERSECT in SQL? How does it work? When to use it? How to write an INTERSECT query? You can find all these questions answered in this article.Nathan Rosidi -
An In-Depth Guide to SQL SELECT DISTINCT Statement
SQL SELECT DISTINCT is a powerful statement for removing duplicates from your data. Learn how to use it in different scenarios and what its alternatives are.Nathan Rosidi -
MS SQL Interview Questions That Will Challenge Your Skills
Solving actual MS SQL interview questions is the best way of preparing for a technical interview. Here’s a detailed guide on how to challenge your skills.Nathan Rosidi -
PySpark Interview Questions for Data Science Excellence
Navigating Through Essential PySpark Interview Questions from Basics to Advanced for Aspiring Data Scientists.Nathan Rosidi -
What Are the Most Common Python Basic Interview Questions?
This article covers key Python interview questions for beginners, focusing on basics and data handling in Python. Let's dive in!Nathan Rosidi -
Top Data Warehouse Interview Questions with Answers
Your ultimate guide to acing data warehouse interviews with in-depth answers to the interview questions and insider tips for every level.Nathan Rosidi -
A Guide to Tackling Challenging Deep Learning Interview Questions
Mastering Deep Learning and AI Interview Questions: What You Need to KnowNathan Rosidi -
SQL Interview Questions for the Data Analyst Position
Let's go over several examples which highlight some of the most important SQL concepts you’ll see in the SQL interview questions for Data Analyst position.Nathan Rosidi -
Postgres vs MySQL: Which is Better for Analytics?
Postgres vs MySQL: Looking into differences (and some similarities) between PostgreSQL and MySQL to help you decide which one suits your needs best.Nathan Rosidi -