#100daysofsql نتائج البحث
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 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
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 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 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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 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: Bank Account Summary II Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Solved today in SQL: The Latest Login in 2020 Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
Day 1 of my #100DaysOfSQL challenge with @geeksforgeeks! What is a Database? SQL Career Path – Roles, Skills & Salaries Course link: tinyurl.com/2pt94xh7 #100DaysChallenge #SQL #LearningJourney #skillupwithgfg #nationskillup
Day 14 of #100DaysOfSQL ✅ Today I explored the CASE WHEN statement in SQL. I practiced classifying scores into: 📌 Distinction 📌 Good 📌 Fail Still rooting for more with CASE WHEN like using it with aggregate functions and in deeper queries. #SQL #DataAnalytics
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 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
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
Day 5 of #100DaysOfSQL Today I learned GROUP BY in SQL ✅ Using aggregate functions SUM(), COUNT(), and AVG() with Group by ✅ Filtered with WHERE ✅ Extracted YEAR() from dates ✅ Grouped by multiple columns
Day 12 of #100DaysOfSQL ✅ After learning the WHERE clause yesterday, I moved on to practicing the SELECT clause today, using it in subqueries. 💻 #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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 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 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 70 of #100DaysOfSQL Focus: Working with Date/Time Functions and Operators Practiced interval arithmetic to calculate differences between dates and times Learned how to retrieve the current date, time, and timestamp Used EXTRACT to pull specific parts #100DaysOfCode
Day 70 of #100DaysOfSQL Focus: Working with Date/Time Functions and Operators Practiced interval arithmetic to calculate differences between dates and times Learned how to retrieve the current date, time, and timestamp Used EXTRACT to pull specific parts #100DaysOfCode
Day 69 of #100DaysOfSQL Focus: Data Types Explored Text data types for storing strings Worked with Date and Time data types to handle temporal data efficiently Learned about INTERVAL data types for calculating durations Practiced using ARRAYs to store multiple values. #DA
Day 69 of #100DaysOfSQL Focus: Data Types Explored Text data types for storing strings Worked with Date and Time data types to handle temporal data efficiently Learned about INTERVAL data types for calculating durations Practiced using ARRAYs to store multiple values. #DA
Day 68 of #100DaysOfSQL Focus: Beyond Window Functions Explored pivoting tables to reshape data for better summaries Practiced pivoting with RANK() for advanced ordering Learned to use ROLLUP and CUBE to generate group-level subtotals and grand totals automatically #DataAnalytics
Day 15 of #100DaysOfSQL ✅ Today I explored how to use CASE WHEN with aggregate functions and practiced ORDER BY to sort query results. #SQL #DataAnalytics #LearningJourney #SelfLearning
Day 68 of #100DaysOfSQL Focus: Beyond Window Functions Explored pivoting tables to reshape data for better summaries Practiced pivoting with RANK() for advanced ordering Learned to use ROLLUP and CUBE to generate group-level subtotals and grand totals automatically #DataAnalytics
Day 67 of #100DaysOfSQL Focus: Aggregate Window Functions & Frames Calculated running totals using SUM() OVER() Applied frames to control which rows are included in calculations Computed moving totals & moving averages for trend analysis #DataAnalytics #100DaysOfCode
Day 67 of #100DaysOfSQL Focus: Aggregate Window Functions & Frames Calculated running totals using SUM() OVER() Applied frames to control which rows are included in calculations Computed moving totals & moving averages for trend analysis #DataAnalytics #100DaysOfCode
Day 66 of #100DaysOfSQL Focus: Fetching, Ranking & Paging LEAD(), LAG(), FIRST_VALUE(), LAST_VALUE() to fetch related rows Ranking rows with RANK(), DENSE_RANK(), ROW_NUMBER() NTILE() for paging — splitting data into equal-sized groups #100DaysOfCode #DataAnalytics
Day 14 of #100DaysOfSQL ✅ Today I explored the CASE WHEN statement in SQL. I practiced classifying scores into: 📌 Distinction 📌 Good 📌 Fail Still rooting for more with CASE WHEN like using it with aggregate functions and in deeper queries. #SQL #DataAnalytics
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 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
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
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 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 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 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 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
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: Bank Account Summary II Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
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
Just hit Day 10 of #100DaysOfSQL! 🚀 Still learning how to stay consistent and avoid overwhelm. Sharing what I’ve noticed so far — more to come! 👇 Follow my journey: linkedin.com/posts/esther-a… #SQL #DataAnalytics #KeepLearning
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
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 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
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. zendaya 5,246 posts
- 2. Apple TV 10.1K posts
- 3. trisha paytas 1,780 posts
- 4. No Kings 221K posts
- 5. #FanCashDropPromotion 1,424 posts
- 6. #เพียงเธอตอนจบ 1.88M posts
- 7. LINGORM ONLY YOU FINAL EP 1.86M posts
- 8. #FridayVibes 7,610 posts
- 9. #Yunho 28.3K posts
- 10. #SlideToMe 17.7K posts
- 11. GAME DAY 32.8K posts
- 12. Mamdani 287K posts
- 13. Cuomo 125K posts
- 14. Arc Raiders 4,934 posts
- 15. Good Friday 63.5K posts
- 16. eli roth N/A
- 17. Bolton 294K posts
- 18. Ramesh 4,509 posts
- 19. Happy Friyay 1,699 posts
- 20. F1 TV 3,512 posts