Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL
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 -
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 -
SQL Cheat Sheet – Technical Concepts for the Job Interview
This SQL cheat sheet gives you a concise and practical overview of the SQL concepts you’ll need for the job interview.Nathan Rosidi -
Top 30 SQL Query Interview Questions
Today we’re having a look at the top 30 SQL query interview questions and concepts that you must prepare for an SQL coding interview.Nathan Rosidi -
Data Science Coding Interview Questions with 5 Technical Concepts
Understanding 5 coding concepts of data science coding interview questions that companies will test you on and preparing for them effectively.Nathan Rosidi -
SQL Interview Questions You Must Prepare: The Ultimate Guide
This ultimate guide will take you through the top SQL interview questions for various data positions and tips to approach your next interview.Nathan Rosidi -
The Best Way to Learn SQL for Data Science
You don’t know how to learn SQL? No more excuses! This is a detailed guide to the best ways of learning this most in-demand skill.Nathan Rosidi -
Top Most Common SQL Coding Errors in Data Science
Let's look at some common SQL coding errors that data science beginners usually make. We will look at the concepts and hands-on practice using real examples.Nathan Rosidi -
Best Practices to Write SQL Queries: How To Structure Your Code
This article focuses on how to write SQL queries correctly and how it can still be improved, in particular when it comes to performance and readability.Nathan Rosidi -