#100daysofsql kết quả tìm kiếm
Day 36 of SQL Learning Today I explored Views, basically saved SQL queries that act like virtual tables. ✅ Simplify complex queries ✅ Reuse code easily #SQL #100DaysOfSQL #DataJourney #LearnSQL
If you sign up for this SQL newsletter today, 22nd Dec will be the last day. You will close the year with better SQL skills and you won’t be starting from scratch come 2025! Onboarding is on Friday #100DaysOfSQL
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
Day 34 of SQL Learning Today was all about understanding the difference between Derived Tables and CTEs.They both help you build temporary tables in a query but CTEs? Cleaner, reusable, and easier to read. Derived tables? Quick and sometimes messy.#SQL #100DaysOfSQL
Day 92 of #100daysofsql NTILE & PERCENT RANK in SQL NTILE The NTILE function divides the rows into a result set into a specified number of groups and assigns each row a unique rank based on its group belongs.
It’s been 100 days of consistently posting SQL content. Hello everyone, I sincerely thank you all for joining me on this journey. Sharing this platform has been both exciting and full of learning. Day 100 of #100daysofsql
I know this is coming a bit late , I had a long and hectic day Today, I learned about the difference between EXISTSand IN in SQL. After understanding how each works and where they apply in solving queries, I jumped into MySQL Workbench to practice them.#100DaysOfSQL #SQL
Solved today in SQL: Reformat Department Table Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
🚀 How to find the second-highest salary in a table using SQL? 🚀 💡 Here's a quick solution using a table named "Emp" with employee details such as id, name, and salary. 👉 Check out for raw code snippets. Let's code together! 🚀🔍 #SQLQueries #100DaysOfSQL
Practicing SQL transformations with the AdventureWorks2022 database! I used CASE statements to: • Classify product prices • Categorize stock levels • Flag weekend orders • Recommend discount tiers Solid way to level up my SQL skills! #100DaysOfSQL #DataAnalytics #SQLServer
#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.
Day 24 I wrapped up a mini SQL project using: ✨ CTEs + Recursive CTEs ✨ ROW_NUMBER, RANK, DENSE_RANK ✨ NTILE(), PARTITION BY Analyzed employee hierarchy, ranked top performers & compared salaries by department. #100DaysOfSQL #SQL #DataAnalytics #LearningInPublic
Day 97 of #100daysofsql Using SQL with Python for Data Analysis You can use Python to write and execute SQL queries on a database using libraries such as SQLite3 (for SQLite databases), MySQL Connector (for MySQL), or psycopg2 (for PostgreSQL).
Day 19 of #100DaysOfSQL Today I explored Recursive CTEs. I understood the definition, but honestly, the query part didn’t click yet. So I’ll be reviewing it again tomorrow — learning is a process. No pressure, just progress. 💡📚 #SQL #LearningInPublic #DataJourney
#Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.
Day 9 of #100DaysOfSQL Today, I deepened my understanding of SQL JOINs. After practicing INNER JOIN, LEFT JOIN, and RIGHT JOIN, I explored CROSS JOIN and studied the concept of FULL OUTER JOIN— which isn’t supported natively in MySQL Workbench, but I now understand how it works.
#Day25 of #100daysofSQL Another window function LAG retrieves data from the previous row in the dataset while LEAD works the same way as LAG, but it gets the value from the next row instead of the previous row.
Day 10 #100DaysOfSQL used a self join to compare populations 2010 → 2015. Also explored joins with set theory — INNER = intersection, LEFT = all left + matches, RIGHT = all right + matches. SQL + math = clarity.
Day 36 of SQL Learning Today I explored Views, basically saved SQL queries that act like virtual tables. ✅ Simplify complex queries ✅ Reuse code easily #SQL #100DaysOfSQL #DataJourney #LearnSQL
Day 33 of SQL Learning Today, I learnt TEMPORARY TABLES. - Learnt they only exist during a session. - Practiced creating, inserting, and selecting from temp tables #SQL #DataLearning #100DaysOfSQL
Day 34 of SQL Learning Today was all about understanding the difference between Derived Tables and CTEs.They both help you build temporary tables in a query but CTEs? Cleaner, reusable, and easier to read. Derived tables? Quick and sometimes messy.#SQL #100DaysOfSQL
Day 9 of #100DaysOfSQL 💻 Finally wrapped my head around joins today — inner, left, right & full. Crazy how just changing where you join flips the whole result. It’s like seeing data relationships from 4 different angles. Starting to actually enjoy this 😄
Day 81 of #100DaysOfSQL Started the Introduction to Business Intelligence module: learned about data-driven decision making, filtering & ordering data, working with dates, and summarizing insights for reporting. Exciting shift toward BI thinking! #DataAnalytics #100DaysOfCode
Day 80 of #100DaysOfSQL Wrapped up with working on dates & timestamps, explored date/time types, formats, and components, aggregated by time, and calculated time between events. Time-based analysis brings real insights to life! #DataAnalytics #100DaysOfCode
Day 33 of SQL Learning Today I explored Self Joins— a concept where a table is joined to itself. It’s useful when comparing rows in the same table, like finding matching related records #SQL #DataAnalytics #100DaysOfSQL #LearningInPublic
The fix is simple but powerful 👇 ON c.code = e.code AND p.year = e.year Always join on all matching keys, not just one. Otherwise, your data lies to you — beautifully and silently. #SQLTips #DataEngineering #100DaysOfSQL
Day 80 of #100DaysOfSQL Wrapped up with working on dates & timestamps, explored date/time types, formats, and components, aggregated by time, and calculated time between events. Time-based analysis brings real insights to life! #DataAnalytics #100DaysOfCode
Day 79 of #100DaysOfSQL Explored categorical & unstructured text — identified character data issues, practiced splitting & concatenating text, grouping, and reordering values for cleaner analysis. Text data can be messy but insightful! #DataAnalytics #100DaysOfCode
Day 8/100 #100DaysOfSQL After 3 days of wrestling with INNER JOINs, I finally got it! 🔥 Joined countries → populations → economies ✅ Matching on code + year avoids messy rows. SQL = building data bridges! 🌉 #SQL #LearningByDoing
Day 31 of learning SQL 💻 Today I explored how to combine multiple window functions in a single query. From running totals, to ranks, to moving averages,all working together without grouping or collapsing rows #100DaysOfSQL #DataAnalytics #SQLLearning #LearningInPublic
And its DAY 6 #100DaysOFSQL I just completed Intermediate SQL by DataCamp datacamp.com/completed/stat… #DataCamp via @DataCamp
Day 30 of SQL Learning Today, I explored FIRST_VALUE() and LAST_VALUE() in SQL. Simple functions — but very useful for tracking how things start and end in a dataset. #SQL #DataAnalytics #100DaysOfSQL #LearningInPublic #TechJourney
Day 6 of learning SQL. Today I learnt the basics of Selecting and Filtering data. #Datacamp has amazing course following it was easy and handson practice made it more interesting. #100DaysOfSQL
Day 79 of #100DaysOfSQL Explored categorical & unstructured text — identified character data issues, practiced splitting & concatenating text, grouping, and reordering values for cleaner analysis. Text data can be messy but insightful! #DataAnalytics #100DaysOfCode
Day 78 of #100DaysOfSQL Focused on summarizing and aggregating numeric data: explored divisions & distributions, calculated mean and median, checked correlations and practiced creating/inserting into temporary tables. Solid data summarization day #100DaysOfCode #DataAnalytics
I’ve just completed the Understanding Data Engineering Course on DataCamp! 🚀 It was quick, interactive, and fun! Discover which of the 500+ data and AI courses can help you build a stronger career. #100DaysOfSQL datacamp.com/completed/stat… #DataCamp via @DataCamp
Day 25✅ I explored Moving Averages using the OVER() clause in SQL today. Another powerful window function added to the list! Every new concept is making data analysis feel more practical. #100DaysOfSQL #DataAnalytics #SQL #LearningInPublic #StudentInTech
Day 24 I wrapped up a mini SQL project using: ✨ CTEs + Recursive CTEs ✨ ROW_NUMBER, RANK, DENSE_RANK ✨ NTILE(), PARTITION BY Analyzed employee hierarchy, ranked top performers & compared salaries by department. #100DaysOfSQL #SQL #DataAnalytics #LearningInPublic
Today almost slipped off… Network issues almost won, but I refused to break my streak. Day 23 of #100DaysOfSQL ✅ I treated PARTITION BY window function today. Still learning. Still showing up. #SQL #LearningJourney #DataAnalytics #StudentInTech #100DaysOfCode
Day 22 of #100DaysOfSQL Today I explored the NTILE() function — a powerful ranking tool that splits data into equal parts. It’s perfect for: Dividing users into quartiles Grouping salaries into tiers #SQL #DataAnalytics #LearningInPublic #100DaysOfCode #TechJourney
Day 36 of SQL Learning Today I explored Views, basically saved SQL queries that act like virtual tables. ✅ Simplify complex queries ✅ Reuse code easily #SQL #100DaysOfSQL #DataJourney #LearnSQL
Day 92 of #100daysofsql NTILE & PERCENT RANK in SQL NTILE The NTILE function divides the rows into a result set into a specified number of groups and assigns each row a unique rank based on its group belongs.
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
DAY 3: Today's SQL lesson covered essential functions for data analysis: - AVG: Compute average values. - COUNT: Calculate the number of rows. - MAX: Find the maximum value. - MIN: Determine the minimum value. - SUM: Add up numerical values. #100DaysOfSQL
DAY 2: On the Basics: Today's SQL practice focused on querying a single table with various conditions. I learned to filter data based on specific criteria, like town names starting with 'A', using the LIKE operator. 📊 #100DaysOfSQL SELECT * FROM location WHERE town LIKE 'A%';
Day 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
Solved today in SQL: Reformat Department Table Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Solved today in SQL: Replace Employee ID With The Unique Identifier Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
If you sign up for this SQL newsletter today, 22nd Dec will be the last day. You will close the year with better SQL skills and you won’t be starting from scratch come 2025! Onboarding is on Friday #100DaysOfSQL
Practicing SQL transformations with the AdventureWorks2022 database! I used CASE statements to: • Classify product prices • Categorize stock levels • Flag weekend orders • Recommend discount tiers Solid way to level up my SQL skills! #100DaysOfSQL #DataAnalytics #SQLServer
Practicing SQL basics with the AdventureWorks2022 database today: SELECT WHERE ORDER BY TOP It’s amazing how much insight you can uncover with just the fundamentals. #SQL #100DaysOfSQL #datafam #DataAnalytics #LearnSQL #AdventureWorks
It’s been 100 days of consistently posting SQL content. Hello everyone, I sincerely thank you all for joining me on this journey. Sharing this platform has been both exciting and full of learning. Day 100 of #100daysofsql
Days 11-22 of #100DaysOfSQL Explored subqueries, table creation/modification, indexes, transactions, window functions, CTEs, data manipulation, views, advanced filtering, pivot/unpivot, and optimization techniques. Challenging and intriguing. Practicing.
Day 10 of #100DaysOfSQL: Thought of taking a break but I spent 45 mins to go over table joins; INNER, LEFT, RIGHT, and FULL joins, and their applications in combining data from multiple tables. To be continued...
Practiced SQL joins using the AdventureWorks2022 dataset: INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN Each query helped me understand how to combine and extract data from multiple related tables. Progress, one join at a time! #100DaysOfSQL #DataAnalytics #AdventureWorks #datafam
Day 9 of #100DaysOfSQL Today, I deepened my understanding of SQL JOINs. After practicing INNER JOIN, LEFT JOIN, and RIGHT JOIN, I explored CROSS JOIN and studied the concept of FULL OUTER JOIN— which isn’t supported natively in MySQL Workbench, but I now understand how it works.
Solved today in SQL: Project Employees I !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 75 of #100daysofsql Complex Joins - Joining Multiple Tables in SQL When working with relational databases, data is often spread across multiple tables that are interconnected by relationships.
Practicing aggregate functions and grouping in SQL using the AdventureWorks2022 database.Covered: COUNT, SUM, AVG, MIN, MAX GROUP BY HAVING Reviewing my queries and sharpening the basics.#SQL #DataAnalytics #100DaysOfSQL #SQLPractice #AdventureWorks #datafam
This week’s SQL grind ✅ Products > avg price ✅ Orders with ‘Bikes’ 🛞 ✅ Top-selling items (above avg) ✅ Employees w/ high latest pay Subqueries are key to unlocking deep insights. #SQL #DataAnalytics #100DaysOfSQL #LearningInPublic #AdventureWorks #Subqueries #datafam
Something went wrong.
Something went wrong.
United States Trends
- 1. Dodgers 424K posts
- 2. #WorldSeries 210K posts
- 3. Yamamoto 78.9K posts
- 4. Blue Jays 91.1K posts
- 5. Will Smith 34.1K posts
- 6. Rojas 48.1K posts
- 7. BACK TO BACK 775K posts
- 8. Kershaw 9,484 posts
- 9. Vlad 12.4K posts
- 10. Ohtani 67.7K posts
- 11. #Worlds2025 26.5K posts
- 12. Baseball 125K posts
- 13. Dave Roberts 7,792 posts
- 14. Jeff Hoffman 2,892 posts
- 15. Auburn 13.2K posts
- 16. Ernie Clement 11.4K posts
- 17. Nike 24.1K posts
- 18. MIGGY 7,602 posts
- 19. Andy Pages 3,504 posts
- 20. Dominguez 4,531 posts