#100daysofsql search results

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

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

Day 10 of #100DaysOfSQL ✅ Today, I explored the difference between UNION and UNION ALL. UNION combines results without duplicate UNION ALL includes all records, even duplicates I practiced this using two customer tables and see the output. #SQL #DataAnalytics

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 8 of #100DaysOfSQL After understanding the concepts of INNER JOIN, LEFT JOIN, and RIGHT JOIN, I jumped into MySQL Workbench to practice them hands-on. Seeing the results come to life really helped solidify the logic #SQL #TechJourney

Any suggestions on how to take notes more efficiently 🤔 #100DaysofSQL

Day 1: Back to the basis of SQL syntax: SELECT, FROM, WHERE.. #100DaysOfSQL

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 😂

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

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 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 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 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: Bank Account Summary II Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode

#SQLQueries #SQLDeveloper #100DaysOfSQL #100DaysDB #60DaysOfCodeChallenge

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

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.

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