Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Interviews
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 -
What Are the Steps to Cast INT in SQL for Type Conversion?
Cast INT in SQL is a must-know for anyone even remotely interested in data handling and analysis. This article will cover all the important cast INT topics.Nathan Rosidi -
How to Perform Python String Concatenation?
Learn essential Python string concatenation techniques, including the + operator, join() method, f-strings, and format() method.Nathan Rosidi -
How to Drop Duplicates in PySpark?
Learn how to ensure accurate analysis by identifying and removing duplicates in PySpark, using practical examples and best practices for handling large datasets.Nathan Rosidi -
How to Use SQL Wildcards for Flexible Data Queries
This article is all about uncertainty and using it to add flexibility to SQL queries. How do you do that? Start using one of the five SQL wildcards regularly.Nathan Rosidi -
How Does SQL Date Formatting Work?
In this article, we explore the SQL date format. We’ll deal with how standard and custom date formatting work in four of the most popular SQL flavors.Nathan Rosidi -
Simplifying SQL Queries with Aliases: A How-To Guide
SQL aliases are a simple yet efficient way of simplifying your SQL queries. In this guide, we’ll show you all the benefits and provide examples of their use.Nathan Rosidi -
Data Type Conversion in SQL: A Closer Look at CAST Function
Master data type conversion: why do it, how to do it, and how not to do it. The article covers all that with some real-world examples from the platform.
Tihomir Babic -
SELECT UNIQUE in SQL: Mastering Data Retrieval with DISTINCT
What is SELECT UNIQUE in SQL? What about SELECT DISTINCT? How do you retrieve unique data? We will answer these three and more questions in this article.Nathan Rosidi -
Python String Methods: Here is How to Master Them
Explore practical examples, learn how to effectively clean and format strings, and harness the power of Python’s memory model to master string operations.Nathan Rosidi -
A Detailed Comparison Between Inner Join vs. Outer Joins
In this article, we compare inner join vs. outer join. We will talk about their similarities and differences and show you how to use them in practice.Nathan Rosidi -