Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.

How Do You Perform SQL LIKE Queries for Pattern Matching?
The LIKE SQL query allows you to perform a pattern-matching search of your text data. Learn how to use it and add wildcards for increased flexibility.
Nathan Rosidi -

What is Big O Notation? (+ Cheat Sheet)
Big O Notation helps developers predict how an algorithm's performance scales with input size, guiding them to choose the most efficient solution.
Nathan Rosidi -

Must-Have Tools for Every Stage of Data Analysis
What tools do data analysts need? We’ll cover each data analysis stage and give you top tools to work with.
Nathan Rosidi -

What is NLP in Machine Learning?
Explore the wonders of NLP, from sassy chatbots to AI doctors, and discover how this technology is revolutionizing human-computer interactions.
Nathan Rosidi -

Utilizing DENSE_RANK for Data Deduplication in SQL
Data deduplication in SQL can be done in several ways. Using DENSE_RANK() is one. Today, we’ll talk about using this function to improve your data’s quality.
Nathan Rosidi -

How to Determine Python String Length?
Discover the simple yet powerful tools Python offers to measure string length effortlessly, enhancing your coding efficiency and data manipulation skills.
Nathan Rosidi -

From Arrays to Lists: Converting Numpy Arrays with Python
Learn the essential methods for converting NumPy arrays to Python lists, enhancing your data handling skills in Python with practical examples and applications.
Nathan Rosidi -

Tips for Crafting an Impressive Data Analyst Portfolio
Having a project portfolio is an industry standard for data analysts. Making it impressive is not easy, but we’ll provide plenty of tips to make it easier.
Nathan Rosidi -

PySpark GroupBy Guide: Super Simple Way to Group Data
Master efficient data grouping techniques with PySpark GroupBy for optimized data analysis.
Nathan Rosidi -

Tools for the Full-Stack Data Scientist
What tools does a full-stack data scientist need? In the article, we answer this question by discussing six types of tools you should have in your toolkit.
Nathan Rosidi -

Adding and Removing List Elements with Python
Explore the versatile techniques of adding and removing elements in Python lists to enhance data manipulation and streamline your coding workflow.
Nathan Rosidi -

SQL PARTITION BY: Advanced Analytical Insights
SQL PARTITION BY makes SQL window functions – already a powerful analytical tool – even more suitable for advanced analytical insights from your data.
Nathan Rosidi -