#100daysofsql результаты поиска
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 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 😂

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




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 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

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


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 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 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

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 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 1 of my #100DaysOfSQL journey 🚀 Today I: ✅ Installed SQL Server & SSMS ✅ Created my first database ✅ Explored the AdventureWorks sample database ✅ Learned SELECT, FROM, and WHERE clauses Can’t wait to dive deeper tomorrow. #LearnSQL #SQLServer #DataAnalytics
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 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 65 of #100DaysOfSQL Focus: Introduction to Window Functions in PostgreSQL Numbering rows with ROW_NUMBER() Using ORDER BY inside OVER() to define ranking order PARTITION BY to group calculations logically LAG() to compare current rows with previous ones #100DaysOfCode

Day 65 of #100DaysOfSQL Focus: Introduction to Window Functions in PostgreSQL Numbering rows with ROW_NUMBER() Using ORDER BY inside OVER() to define ranking order PARTITION BY to group calculations logically LAG() to compare current rows with previous ones #100DaysOfCode

Day 64 of #100DaysOfSQL Focus: Window Functions OVER() to calculate across rows without grouping PARTITION BY for grouping within the window Sliding windows for running totals, moving averages & rankings #100DaysOfCode #DataAnalytics


Day 64 of #100DaysOfSQL Focus: Window Functions OVER() to calculate across rows without grouping PARTITION BY for grouping within the window Sliding windows for running totals, moving averages & rankings #100DaysOfCode #DataAnalytics


Day 63 of #100DaysOfSQL Focus: Correlated Queries, Nested Queries & CTEs Correlated subqueries: depend on outer queries for each row Nested queries: multiple layers of subqueries for complex logic CTEs: use WITH to create reusable, readable query blocks #100DaysOfCode #DA

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 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 63 of #100DaysOfSQL Focus: Correlated Queries, Nested Queries & CTEs Correlated subqueries: depend on outer queries for each row Nested queries: multiple layers of subqueries for complex logic CTEs: use WITH to create reusable, readable query blocks #100DaysOfCode #DA

Day 62 of #100DaysOfSQL Focus: Subqueries Scalar subqueries → return a single value for filtering Subqueries in FROM → treat as virtual tables Subqueries in SELECT → add calculated columns Subqueries in WHERE → filter rows dynamically #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 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 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 😂

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

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


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 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%';
Day 84 of #100daysofsql Cascade on Delete in SQL In SQL, the ON DELETE CASCADE option is a powerful feature used in relational databases to maintain referential integrity between parent and child tables.

Day 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql

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


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




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...

Something went wrong.
Something went wrong.
United States Trends
- 1. phil 94.4K posts
- 2. phan 81.3K posts
- 3. Falcons 15.4K posts
- 4. Jorge Polanco 6,667 posts
- 5. Columbus 232K posts
- 6. #BillsMafia 5,717 posts
- 7. Mitch Garver N/A
- 8. Go Bills 7,881 posts
- 9. Bijan 3,575 posts
- 10. Doug Eddings 1,107 posts
- 11. Kincaid 1,777 posts
- 12. Joe Davis N/A
- 13. Middle East 329K posts
- 14. Jake Moody N/A
- 15. Monday Night Football 7,549 posts
- 16. Martin Sheen 1,934 posts
- 17. Springer 11.1K posts
- 18. Yesavage 3,502 posts
- 19. Pentagon 25.9K posts
- 20. Bears 36.2K posts