Analyzing 100,000+ Orders: My Olist E-Commerce SQL & OLAP Project
#sql
Reusable SQL in MySQL: Views, Stored Procedures, and User-Defined Functions
#sql
SQL Real-World Scenarios: Nth Highest Value, Removing Duplicates, and LAG/LEAD
#sql
SQL Basics Part 6: Subqueries and CTEs (Common Table Expressions)
#sql
SQL Basics Part 5: Window Functions, Running Totals, Ranking, LAG/LEAD, and PARTITION BY
#sql
SQL Basics Part 4: Numeric, Date, and String Transformations Plus CASE Conditionals
#sql
SQL Basics Part 3: INNER JOIN, LEFT JOIN, RIGHT JOIN, UPDATE, and DELETE
#sql
SQL Basics Part 2: SELECT, WHERE, Sorting, and GROUP BY
#sql
SQL Basics Part 1: DDL, DML, Constraints & Keys
#sql