#100daysofsql ผลการค้นหา
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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.
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
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: Project Employees I !!! 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
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 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.
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
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
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 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 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
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...
Day 11 of #100DaysOfSQL ✅ Today, I focused on subqueries in the WHERE clause. I took time to really understand what a subquery is and how it works before practicing it in MySQL Workbench. #SQL #DataAnalytics #LearningJourney #100DaysOfCode
Day 16 of #100DaysOfSQL💻 Today I focused on dealing with NULLs in SQL ✨ I used: • IS NULL to find missing salary • COALESCE to fill in NULL bonuses • NULLIF to avoid dividing by zero #SQL #DataAnalytics #LearningInPublic #SelfTaught #DataJourey
Day 17 of #100DaysOfSQL Today, I put my SQL skills to the test by building a Hospital Data Analytics Project mini project no tutorials, just thinking like a real analyst. ✅ SELECT, WHERE, JOINS ✅ CASE WHEN, NULL handling ✅ Real questions, real insights #SQL #DataAnalytics
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 86 of #100daysofsql Entity Relational Diagram (ERD) An ERD (Entity-Relationship Diagram) in SQL visually represents a database's data structure. It illustrates the relationships between different entities (tables) in the database and how they interact. 🖼️: SQL Murder Myst
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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 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%';
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
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
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
Day 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
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
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
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
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
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
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.
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...
Practicing SQL after some helpful classes with @iam_daniiell ! - Created fact & dimension tables - Set a foreign key with GenderID - Inserted into an IDENTITY column with IDENTITY_INSERT ON/OFF Loving the process! #SQL #100DaysOfSQL #DataAnalytics #LearningByDoing #datafam
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. Jets 102K posts
- 2. Sauce 76K posts
- 3. Sauce 76K posts
- 4. Garrett Wilson 4,187 posts
- 5. Breece 11.9K posts
- 6. Cheney 212K posts
- 7. AD Mitchell 5,928 posts
- 8. Shaheed 15.3K posts
- 9. Mazi Smith 4,256 posts
- 10. Jerry 53.8K posts
- 11. Jermaine Johnson 2,787 posts
- 12. Merino 28.9K posts
- 13. #JetUp 1,483 posts
- 14. Aaron Glenn N/A
- 15. Indy 16.6K posts
- 16. #NFLtradedeadline N/A
- 17. Minkah 5,042 posts
- 18. Micah 9,737 posts
- 19. Veach 3,945 posts
- 20. Mougey 1,551 posts