Top Tweets for #15DaysofSQL
Hey so for Day 12 of #15daysOfSQL I learned about writing subqueries. The lesson included:
Using subqueries to aggregate in multiple stages
Subqueries in conditional logic
Joining subqueries
Subqueries and UNIONs
#66daysOfData
Day 6 of #66DaysOfData challenge i continued #15daysOfSQL I learned about:
Cleaning strings
LEFT, RIGHT, and LENGTH
TRIM
POSITION and STRPOS
SUBSTR
CONCAT
Changing case with UPPER and LOWER
Turning strings into dates
Turning dates into more useful dates
COALESCE
Day 9 of the #15DaysOfSQL I learned about the
The SQL UNION operator
SQL Joins with Comparison Operators.
#66DaysOfData
Day 7 and 8 #15daysOfSQL i learned about
The SQL JOIN
Covering;
Intro to SQL joins: relational concepts
The anatomy of a join
Aliases in SQL
JOIN and ON
#66daysOfData
Day 5 & 6 on #15daysOfSQL I learned about:
The SQL CASE statement
Adding multiple conditions to a CASE statement
A quick review of CASE basics
Using CASE with aggregate functions
Using CASE inside of aggregate functions
#66daysOfData
Let's finish #15DaysofSQL in style🔥
Solve a case study with me in 10 minutes at https://t.co/lHYa0ZCBPJ
See you there!
Practice am SQL Case Study with me in 10 minutes at https://t.co/ZGB2M1iSej 🔥
2nd last session of #15DaysofSQL 🥺
Join me for the final tutorial session of #15DaysofSQL
We'll be discussing Window Functions-
✨ LAG
✨ LEAD
Link : https://t.co/211U2JzvOa
Let's solidify our Window Functions with the 12th episode of #15DaysofSQL
Today we have -
✨ RANK
✨ DENSE_RANK
Link to join : https://t.co/dReR6N5bF9
The 11th episode of #15DaysofSQL is here, where are you?
We'll get started with the Voldemort of SQL : The Window Functions. Today's pick -
✨ROW_NUMBER✨
Join now at https://t.co/myyIpGwW4S
Finish 2/3rd of #15DaysofSQL with me today!🔥
We'll learn about -
✨ Data Types in SQL
✨ Dealing with Dates
Live now at https://t.co/72A69KL1TO
https://t.co/aC3yinhzFv
#15DaysofSQL
Make your way past the half way mark in your #15DaysofSQL journey 🔥
Let's connect in 10 minutes, shall we?
We'll learn about ✨UNION✨
Link to join : https://t.co/dJTaM3EyAI
Let's demystify the MOST DREADED SQL topic😵💫
Ep 7 of #15DaysofSQL goes live in 10 minutes!🔥
We'll learn:
✨ JOIN
✨ INNER JOIN
✨ OUTER JOIN
✨ LEFT/RIGHT JOIN
Link to join : https://t.co/aSB97aeLyO
See you there!
Let's go SQL Fam🔥
Too tired today. But we depend on systems here not motivation.
Episode 6 of #15DaysofSQL goes LIVE in 5 minutes.
We conquer one of my favorite concepts today. The CASE statement✨
Link to join : https://t.co/SIBaHdK02f
Had such a great session today, thank you everyone for joining. Happy learning! ✨
#15DaysofSQL
CRUSH SQL with me in 10 minutes 🔥
Episode 5 of #15DaysofSQL goes live in 10 minutes!
We'll learn:
✨ Categorization in SQL
✨ Diving data to subcategories
✨ Extracting insights using Aggregate functions
Link to join : https://t.co/RE5lP4VASG
Ready to CRUSH Day 4 of #15DaysofSQL with me?
Going live in 5 minutes🔥
Let's learn how to:
✨ Order results in an ascending fashion
✨ Order results in an descending fashion
✨ Order results based on multiple columns
Join here : https://t.co/1vuiBP0R5c
Last Seen Hashtags on Sotwe
projecbyminek
Seen from United States
batwheels
Seen from United States
minichat filter:videos
Seen from Brazil
SIRVIENTA
Seen from Guatemala
layerPorn
Seen from United States
hooliganPride
Seen from United States
เหลือเฟือมกจ๊ก
Seen from United States
الشيخه_سمو
Seen from Jordan
hotclassrooms
Seen from United States
thisismyfood
Seen from United States
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
241.8M followers
Barack Obama
@barackobama
119M followers
Cristiano Ronaldo
@cristiano
114.6M followers
Donald J. Trump
@realdonaldtrump
111.9M followers
Narendra Modi
@narendramodi
107.2M followers
Rihanna
@rihanna
98.7M followers
NASA
@nasa
92.4M followers
Justin Bieber
@justinbieber
91.8M followers
KATY PERRY
@katyperry
90.1M followers
Taylor Swift
@taylorswift13
84M followers
Lady Gaga
@ladygaga
75.5M followers
Virat Kohli
@imvkohli
73.5M followers
Kim Kardashian
@kimkardashian
70.9M followers
YouTube
@youtube
68.8M followers
Neymar Jr
@neymarjr
66.5M followers
Bill Gates
@billgates
65.3M followers
Selena Gomez
@selenagomez
63.1M followers
The Ellen Show
@theellenshow
62.3M followers
CNN
@cnn
61.8M followers
X
@x
60.7M followers