Data Science Educational Resources StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL The Ultimate Guide to SQL Window Functions This ultimate guide is a complete overview of the types of SQL window functions, their syntax and real-life examples of how to use them in queries.
Nathan Rosidi - October 26, 2023
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 - October 25, 2023
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 - October 19, 2023
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 - October 12, 2023