#100daysofsql 搜索结果

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

Mr_nobody0210's tweet image. Any suggestions on how to take notes more efficiently 🤔
#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 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

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

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.

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

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

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

One of the most asked SQL interview questions: Second Highest Salary! #100DaysOfSQL #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 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

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

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

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

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

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

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

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

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

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

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

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

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

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


未找到 "#100daysofsql" 的结果

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

Mr_nobody0210's tweet image. Any suggestions on how to take notes more efficiently 🤔
#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 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

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

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.

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

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

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: Bank Account Summary II 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: Bank Account Summary II   

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

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 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%';



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.

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

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

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

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

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


Loading...

Something went wrong.


Something went wrong.


United States Trends