Search results for #30DaysOfSQL
Day 5 of my #30DaysOfSQL Challenge Today’s focus: DQL (Data Query Language) the art of asking questions with SELECT 🧵
I practiced writing some queries with our datasets before calling it a day🤭. #SQLChallenge #DataAnalytics #SQL #30DaysOfSQL
DML is like being an editor of your data — you can add, revise, or remove lines from the story. Tomorrow we explore how to query data 🚀 #SQL #DataAnalytics #30DaysOfSQL
DML is like being an editor of your data you can add, revise, or remove lines from the story. #SQL #DataAnalytics #30DaysOfSQL
🚀 Day 4 of my #30DaysOfSQL Challenge Today’s focus: DML (Data Manipulation Language) — where we actually work with the data 🧵
DDL gives you the power to build, adjust, or destroy structures. It’s the true foundation of SQL. Tomorrow, we move to the next building block 🚀 #SQL #DataAnalytics #30DaysOfSQL
🚀 Day 3 of my #30DaysOfSQL Challenge Today’s focus: DDL (Data Definition Language) the architect of databases 🧵
Day 2 of my #30DaysOfSQL Challenge Today’s lesson: SQL Categories 🧵
Reflection: SQL makes data powerful by connecting the dots. I’ll be sharing 1 concept daily for the next 30 days 🚀 Follow along with #30DaysOfSQL 💻
Day 1 of my #30DaysOfSQL Challenge Special thanks to Jennifer Joseph for inspiring me to learn & share in public 🙌 Today’s lesson: Why SQL? 🧵
Day 30 of #30DaysOfSQL I wrapped up this challenge with a Top Customers table from the Sakila DB: 1.Shows Total spend & rentals per customer 2.Breaks rentals down by category 3.Includes JSON arrays of all rented films 4. Used window functions and CTEs #datafam #techtwitter
Day 30 of #30DaysOfSQL I wrapped up this challenge with a Top Customers table from the Sakila DB: 1. Shows Total spend & rentals per customer 2.Breaks rentals down by category 3.Includes JSON arrays of all rented films 4. Used window functions and CTEs #datafam #techtwitter
Day X of #30DaysOfSQL 🚀 Today I explored ROLLUP in MySQL. It’s like running multiple GROUP BY queries at once. It is perfect for subtotals & grand totals. Task : Use Rollup to see payments by staff id and customer id #datafam #techtwitter
Day 28 of #30DaysOfSQL Today I worked with JSON functions in SQL. This is perfect for APIs & modern applications. Task: Generate a JSON array of all films rented by each customer #SQL #30DaysOfSQL #DataEngineering #datafam #buildinpublic #TechTwitter
Day 28 of #30DaysOfSQL Today I worked with JSON functions in SQL. This is perfect for APIs & modern applications. Task: Generate a JSON array of all films rented by each customer #SQL #30DaysOfSQL #DataEngineering #datafam #buildinpublic #TechTwitter
Day 27 of #30DaysOfSQL Today I used conditional aggregation to create a pivot table in SQL. I turned customer payments into monthly columns (Jan, Feb, Mar 2006). Pivoting makes it easier to compare values side by side #datafam #SQLServer #mysql #DataCleaning #buildinpublic #build
Day 27 of #30DaysOfSQL Today I used conditional aggregation to create a pivot table in SQL. I turned customer payments into monthly columns (Jan, Feb, Mar 2006). Pivoting makes it easier to compare values side by side #datafam #SQLServer #mysql #DataCleaning #buildinpublic
Day 26 of #30DaysOfSQL Today I combined CTEs + Window Functions. Using ROW_NUMBER() & LAG(), I tracked the current rentals of customers with their previous rental. Task : Find the current and previous rentals for the first 20 customers. #datafam #techtwitter #buildininpublic
Day 25 of #30DaysOfSQL Today I used the FIRST_VALUE() window function. A powerful way to track "firsts" (like first purchase, first login, etc.) in data. Task: Find the first film rented per customer. #datafam #techtwitter #TechTips #TechTrends #Database
