#100daysofsql kết quả tìm kiếm

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

Etty_official's tweet image. 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

Etty_official's tweet image. 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

One of the most asked SQL interview questions: Second Highest Salary! #100DaysOfSQL #DataAnalytics


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

MensahRudolph's tweet image. Day 1: Back to the basis of SQL syntax: 
SELECT, FROM, WHERE.. #100DaysOfSQL
MensahRudolph's tweet image. Day 1: Back to the basis of SQL syntax: 
SELECT, FROM, WHERE.. #100DaysOfSQL

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

Etty_official's tweet image. 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

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.

datad1v3d's tweet image. 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.
datad1v3d's tweet image. 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.
datad1v3d's tweet image. 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.

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

Etty_official's tweet image. 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: Reformat Department Table Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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 😂

Etty_official's tweet image. 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: 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

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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 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

supratimdaswork's tweet image. 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
supratimdaswork's tweet image. 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 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

MensahRudolph's tweet image. 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%';



#Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.

Adanna_CI's tweet image. #Day29 of #100daysofSQL To use a subquery in an INSERT statement, it must be included in the values clause.

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.

MensahRudolph's tweet image. 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...

MensahRudolph's tweet image. 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...


#Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.

Adanna_CI's tweet image. #Day30 of #100daysofSQL A subquery is used in a DELETE statement with a logical operator to remove data from a table.

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

datad1v3d's tweet image. 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 57 of #100DaysOfSQL Working on the Analyzing Students’ Mental Health project. #SQL #DataCamp #100DaysOfCode

kafilat_yekeen's tweet image. Day 57 of #100DaysOfSQL

Working on the Analyzing Students’ Mental Health project.

#SQL #DataCamp #100DaysOfCode
kafilat_yekeen's tweet image. Day 57 of #100DaysOfSQL

Working on the Analyzing Students’ Mental Health project.

#SQL #DataCamp #100DaysOfCode

Day 56 of #100DaysOfSQL Focus: Sorting & Grouping ORDER BY with text & numeric fields Sorting by single & multiple fields GROUP BY for single & multiple fields Filtering grouped data with HAVING Difference between WHERE vs HAVING Combining HAVING & ORDER BY #100DaysOfCode

kafilat_yekeen's tweet image. Day 56 of #100DaysOfSQL

Focus: Sorting & Grouping

ORDER BY with text & numeric fields
Sorting by single & multiple fields
GROUP BY for single & multiple fields
Filtering grouped data with HAVING
Difference between WHERE vs HAVING
Combining HAVING & ORDER BY
 #100DaysOfCode


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

Adanna_CI's tweet image. #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.

#Day31 of #100daysofSQL The CONCAT () function adds two strings together. The list of string values that need to be merged together is entered into the CONCAT () function as parameters.

Adanna_CI's tweet image. #Day31 of #100daysofSQL The CONCAT () function adds two strings together. The list of string values that need to be merged together is entered into the CONCAT () function as parameters.

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

Etty_official's tweet image. 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

Etty_official's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

Etty_official's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

Etty_official's tweet image. 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

Etty_official's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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
kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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
kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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

Etty_official's tweet image. 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

Etty_official's tweet image. 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

kafilat_yekeen's tweet image. 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

kafilat_yekeen's tweet image. 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


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

Etty_official's tweet image. 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

Etty_official's tweet image. 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.

Etty_official's tweet image. 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

Etty_official's tweet image. 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

Không có kết quả nào cho "#100daysofsql"

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

MensahRudolph's tweet image. Day 1: Back to the basis of SQL syntax: 
SELECT, FROM, WHERE.. #100DaysOfSQL
MensahRudolph's tweet image. Day 1: Back to the basis of SQL syntax: 
SELECT, FROM, WHERE.. #100DaysOfSQL

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

Etty_official's tweet image. 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

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

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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 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.

datad1v3d's tweet image. 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.
datad1v3d's tweet image. 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.
datad1v3d's tweet image. 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 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

MensahRudolph's tweet image. 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: Project Employees I !!! Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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 88 of #100daysofsql SELECT * FROM memories WHERE date = '2024-12-28' AND event_type = 'cultural' 😅 😅 #sql

datad1v3d's tweet image. 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

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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

armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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 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.

datad1v3d's tweet image. 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.

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

DilipKumar2410's tweet image. 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
DilipKumar2410's tweet image. 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 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 😂

Etty_official's tweet image. 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: Article Views I Every query executed is a step closer to cleaner data and stronger logic. #SQL #Database #100DaysOfSQL #DataSkills #LeetCode

DilipKumar2410's tweet image. Solved today in SQL: Article Views I                  

Every query executed is a step closer to cleaner data and stronger logic.                           

#SQL #Database #100DaysOfSQL #DataSkills #LeetCode
DilipKumar2410's tweet image. Solved today in SQL: Article Views I                  

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

Etty_official's tweet image. 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

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

armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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

armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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.

MensahRudolph's tweet image. 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...

MensahRudolph's tweet image. 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...


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

armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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
armani0GK's tweet image. 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

Loading...

Something went wrong.


Something went wrong.


United States Trends