#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 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 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
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 😂
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
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 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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: 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
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 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 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 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 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 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 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 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
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 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 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
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
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: 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
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
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
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 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 😂
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 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.
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
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
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
Something went wrong.
Something went wrong.
United States Trends
- 1. #WorldSeries 198K posts
- 2. Dodgers 242K posts
- 3. Freddie 90.3K posts
- 4. Klein 197K posts
- 5. Ohtani 131K posts
- 6. Kershaw 19.2K posts
- 7. Mookie 15.1K posts
- 8. Yamamoto 27.2K posts
- 9. #Worlds2025 8,120 posts
- 10. Lauer 5,145 posts
- 11. Joe Davis 2,247 posts
- 12. Will Smith 13.9K posts
- 13. WHAT A GAME 41.9K posts
- 14. Marlins 1,873 posts
- 15. 18 INNINGS 13.2K posts
- 16. Dave Roberts 6,097 posts
- 17. Bottom of the 18th 2,364 posts
- 18. Schneider 12.7K posts
- 19. Tommy Edman 4,948 posts
- 20. Mary Hart N/A