#100daysofsql resultados de búsqueda
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
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
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 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
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 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 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 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
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 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 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 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
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...
#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.
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.
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 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql
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: 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
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
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
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.
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
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
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
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 75 of #100daysofsql Complex Joins - Joining Multiple Tables in SQL When working with relational databases, data is often spread across multiple tables that are interconnected by relationships.
Something went wrong.
Something went wrong.
United States Trends
- 1. Dick Cheney 17.2K posts
- 2. Election Day 79.8K posts
- 3. Good Tuesday 25K posts
- 4. #tuesdayvibe 1,366 posts
- 5. GO VOTE 68.5K posts
- 6. Rolex 15.4K posts
- 7. #Election2025 2,110 posts
- 8. George W. Bush 7,430 posts
- 9. #WeTVAlwaysMore2026 1.42M posts
- 10. Halliburton 1,159 posts
- 11. Jonathan Bailey 45K posts
- 12. Hogg 6,975 posts
- 13. iPads N/A
- 14. Comey 93.9K posts
- 15. Tommy Robinson 21.4K posts
- 16. Logan Wilson 1,438 posts
- 17. #AllsFair N/A
- 18. Nino 49.2K posts
- 19. Nick Smith 19.6K posts
- 20. Jake Paul 5,779 posts