#100daysofsql 搜尋結果
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 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #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 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 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
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 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
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 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #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
Day 77 of #100DaysOfSQL Focus: Dug into database exploration — checking table sizes, counting missing values, joining tables, identifying keys, and understanding column types & constraints. A solid step toward mastering data structures! #100DaysOfCode #DataAnalytics
Day 77 of #100DaysOfSQL Focus: Dug into database exploration — checking table sizes, counting missing values, joining tables, identifying keys, and understanding column types & constraints. A solid step toward mastering data structures! #100DaysOfCode #DataAnalytics
Day 76 of #100DaysOfSQL Focus: Explored correlation and hypothesis testing — understanding independent vs. dependent variables, experiments, interpreting test results, and the difference between Type I and Type II errors. #DataAnalysis #100DaysOfCode
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
Day 76 of #100DaysOfSQL Focus: Explored correlation and hypothesis testing — understanding independent vs. dependent variables, experiments, interpreting test results, and the difference between Type I and Type II errors. #DataAnalysis #100DaysOfCode
Day 75 of #100DaysOfSQL Focus: Dived deeper into distributions — learned about binomial, normal, and Poisson distributions, how to identify skewness, and grasped the Central Limit Theorem — a core concept in inferential statistics! #DataAnalytics #100DaysOfCode
Day 75 of #100DaysOfSQL Focus: Dived deeper into distributions — learned about binomial, normal, and Poisson distributions, how to identify skewness, and grasped the Central Limit Theorem — a core concept in inferential statistics! #DataAnalytics #100DaysOfCode
Day 74 of #100DaysOfSQL Focus: Learned Probability & Distributions — covered conditional probability, discrete vs continuous distributions, and explored the normal distribution that underpins most data patterns. #DataAnalytics #100DaysOfCode
Day 18 of #100DaysOfSQL ✅ Today, I explored CTEs (Common Table Expressions) by working on a practical challenge: 💡 Used concepts like: - WITH clause (CTE) - AVG()function #SQL #LearningJourney #DataAnalytics #100DaysOfCode
Day 74 of #100DaysOfSQL Focus: Learned Probability & Distributions — covered conditional probability, discrete vs continuous distributions, and explored the normal distribution that underpins most data patterns. #DataAnalytics #100DaysOfCode
Day 73 of #100DaysOfSQL Focus: Covered Summary Statistics — identifying data types, understanding descriptive vs inferential stats, and learning measures of center (mean, median, mode) and spread (range, variance, SD). #DataAnalytics #100DaysOfCode
Day 73 of #100DaysOfSQL Focus: Covered Summary Statistics — identifying data types, understanding descriptive vs inferential stats, and learning measures of center (mean, median, mode) and spread (range, variance, SD). #DataAnalytics #100DaysOfCode
Day 72 of #100DaysOfSQL Focus: Explored Full Text Search & PostgreSQL extensions — learned about tsvector for text search, creating user-defined data types, and enabling extensions for advanced database capabilities. #100DaysOfCode #DataAnalytics
Day 72 of #100DaysOfSQL Focus: Explored Full Text Search & PostgreSQL extensions — learned about tsvector for text search, creating user-defined data types, and enabling extensions for advanced database capabilities. #100DaysOfCode #DataAnalytics
Day 71 of #100DaysOfSQL Focus: Parsing and Manipulating Text Learned how to concatenate Practiced changing text case Used REPLACE to modify string Parsed text and character data Determined string length, truncated text, and extracted substrings Worked with trimming and padding
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 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
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
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
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
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 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: 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 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
Solved today in SQL: Article Views I Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Solved today in SQL: List the Products Ordered in a Period Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 3 of #100DaysOfSQL 📊 Today I explored: -ORDER BY for sorting results -Column/table aliases for cleaner queries -LIMIT (MySQL) & TOP (SQL Server) to control rows returned I think I'm enjoying this 😂
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: User Activity for the past 30 Days I Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
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: Sales Analysis III 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: Bank Account Summary II Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Something went wrong.
Something went wrong.
United States Trends
- 1. Skattebo 9,073 posts
- 2. Saquon 11.6K posts
- 3. Nick Mangold 22.2K posts
- 4. Vini 105K posts
- 5. #FlyEaglesFly 5,494 posts
- 6. James Cook 2,286 posts
- 7. Tush Push 8,560 posts
- 8. #NYGiants 2,542 posts
- 9. Lamine 248K posts
- 10. Ravens 31.9K posts
- 11. #ElClasico 92.5K posts
- 12. Go Birds 8,171 posts
- 13. Myles Garrett 1,356 posts
- 14. Madrid 528K posts
- 15. Mike Green 1,293 posts
- 16. Andy Dalton 2,749 posts
- 17. #BillsMafia 5,472 posts
- 18. #NYGvsPHI N/A
- 19. Tyler Nubin N/A
- 20. Barca 175K posts