#100daysofsql risultati di ricerca
Day 40 I learnt about User Defined Functions (UDFs) in SQL how to create custom functions that return values based on input. #SQL #LearningInPublic #100DaysOfSQL #DataJourney
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 42 of 100 days SQL learning Today, I did a mini SQL project and applied everything I’ve learned so far from Self Joins to Triggers, Views, CTEs, UDFs, and more. I also explored Pivoting & Unpivoting to transform and analyze my dataset better #DataAnalytics #100DaysOfSQL
Day 50/100 of my SQL learning journey Today I learnt about ENUM and SET data types in SQL useful for restricting column values to predefined options. On to the next! #100DaysOfSQL #SQL #LearningData
Day 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
Day 49/100 of my SQL learning journey... Today, I focused on learning IF and IFNULL in SQL. As I was practicing, I couldn’t help but notice the similarity between IFNULL and COALESCE, which I had learnt earlier same as IF and CASE WHEN...... #100DaysOfSQL #LearningInPublic
Day 41 of SQL Learning Today I learned triggers! At first, the syntax had me spinning 😅 But after breaking it down with a simple example, it finally clicked. #100DaysOfSQL #SQLLearning #DataJourney
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 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 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 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 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.
#Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.
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
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 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
#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.
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 50/100 of my SQL learning journey Today I learnt about ENUM and SET data types in SQL useful for restricting column values to predefined options. On to the next! #100DaysOfSQL #SQL #LearningData
Day 84 of #100DaysOfSQL Data-Driven Decision Making with OLAP SQL Queries. Explored powerful multidimensional analysis tools like CUBE, ROLLUP, and GROUPING SETS to summarize data across multiple hierarchies. #DataAnalytics #100DaysOfCode
Day 83 of #100DaysOfSQL Data Driven Decision Making with advanced SQL. Practiced nested & correlated subqueries, EXISTS, UNION & INTERSECT to answer complex business questions with precision.Leveling up decision logic with powerful query patterns #DataAnalytics #100DaysOfCode
Day 49/100 of my SQL learning journey... Today, I focused on learning IF and IFNULL in SQL. As I was practicing, I couldn’t help but notice the similarity between IFNULL and COALESCE, which I had learnt earlier same as IF and CASE WHEN...... #100DaysOfSQL #LearningInPublic
Day 44 of learning SQL 💻 Today, I learnt Transactions and the ACID properties that keep data safe and reliable — especially in real-world systems like banking & e-commerce. #100DaysOfSQL #Day44 #SQLLearning #TechJourney
Day 42 of 100 days SQL learning Today, I did a mini SQL project and applied everything I’ve learned so far from Self Joins to Triggers, Views, CTEs, UDFs, and more. I also explored Pivoting & Unpivoting to transform and analyze my dataset better #DataAnalytics #100DaysOfSQL
Day 83 of #100DaysOfSQL Data Driven Decision Making with advanced SQL. Practiced nested & correlated subqueries, EXISTS, UNION & INTERSECT to answer complex business questions with precision.Leveling up decision logic with powerful query patterns #DataAnalytics #100DaysOfCode
Day 82 of #100DaysOfSQL Focused on decision-making with simple SQL queries: writing queries that support business choices, using filters, comparisons & logic to answer real-world questions from data. Step-by-step building sharper data intuition! #DataAnalysis #100DaysOfCode
Day 41 of SQL Learning Today I learned triggers! At first, the syntax had me spinning 😅 But after breaking it down with a simple example, it finally clicked. #100DaysOfSQL #SQLLearning #DataJourney
Day 40 I learnt about User Defined Functions (UDFs) in SQL how to create custom functions that return values based on input. #SQL #LearningInPublic #100DaysOfSQL #DataJourney
Day 82 of #100DaysOfSQL Focused on decision-making with simple SQL queries: writing queries that support business choices, using filters, comparisons & logic to answer real-world questions from data. Step-by-step building sharper data intuition! #DataAnalysis #100DaysOfCode
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 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
Day 41 of SQL Learning Today I learned triggers! At first, the syntax had me spinning 😅 But after breaking it down with a simple example, it finally clicked. #100DaysOfSQL #SQLLearning #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.
Day 40 I learnt about User Defined Functions (UDFs) in SQL how to create custom functions that return values based on input. #SQL #LearningInPublic #100DaysOfSQL #DataJourney
Day 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
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 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 21 of #100DaysOfSQL Today I explored Ranking Functions in SQL: ROW_NUMBER() RANK() DENSE_RANK() #SQL #DataAnalytics #LearningInPublic #100DaysOfCode
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 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 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%';
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: Invalid Tweets Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode
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
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
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
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
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
🚀 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
Something went wrong.
Something went wrong.
United States Trends
- 1. $NVDA 80.2K posts
- 2. Jensen 26.2K posts
- 3. Peggy 38.4K posts
- 4. GeForce Season 6,200 posts
- 5. NASA 55.8K posts
- 6. Sam Harris N/A
- 7. #YIAYalpha N/A
- 8. Arabic Numerals 5,698 posts
- 9. Sumrall 2,580 posts
- 10. Stargate 7,620 posts
- 11. Judge Smith 4,192 posts
- 12. Martha 20.6K posts
- 13. Comey 59K posts
- 14. Potomac N/A
- 15. #WWESuperCardNewSeason 1,265 posts
- 16. #2Kgiveaway 1,242 posts
- 17. WNBA 9,584 posts
- 18. Kwame 6,599 posts
- 19. #WickedWaysToMakeABuck N/A
- 20. Tarris Reed N/A