Top Tweets for #7DaysOfSQL
Day 7 done β
A week of errors, frustration and missing commas but I made it to the endπ
Finished with Stored Procedures, Triggers & Events. Not the easiest way to close out a week but I showed up every day and thatβs enough for me π
On to the next. #SQL #7DaysOfSQL
@PrimeW1sdom Solid! CTEs are a game changer for readability π₯ Pro tip for Day 7:
try chaining multiple CTEs together WITH cte1 AS (...), cte2 AS (...) it's where they really shine for complex analysis.
Keep going! #SQL #7DaysOfSQL
Day 6 done β
Covered CTEs & Temp Tables today.
A CTE lets you define a temporary result set at the top of your query.
Instead of one long messy query, you break it into named steps that makes things look a lot simpler.
Day 7 on Mondayπ.
#SQL #7DaysOfSQL
Day 5 done β
Not going to pretend this one was easy, behind these screenshots are hours of errors and frustration π.
But I covered Window Functions β AVG OVER, Rolling Totals, ROW_NUMBER, RANK & DENSE_RANK.
Day 6 tomorrow. #SQL #7DaysOfSQL
Day 4 done β
SQL is really frustrating. This minute itβs flowing, the next youβre scrolling looking for where the error is from, only to find out its a missing comma π
Covered UNIONS, CONCAT & CASE WHEN today.
Day 5 tomorrow.
#SQL #7DaysOfSQL
Day 3 done β
#7DaysOfSQL
JOINs.
This one was a lot more technical than I expected.
INNER, LEFT, RIGHT & Self JOIN β combining tables sounds simple until you're actually doing it π
Day 4 tomorrow. #SQL #BuildInPublic
Day 2 done β
Still making errors, but I guess mistakes are part of the journey.
Had to keep looking at my notes all through for guidance π
Covered HAVING, LIMIT & String Functions β UPPER, LOWER, LENGTH, TRIM, LEFT, RIGHT & SUBSTRING.
Day 3 tomorrow π
#SQL #7DaysOfSQL
Day 1 done, after so many errorsπβ
SELECT, WHERE, AND/OR/NOT, LIKE, GROUP BY & ORDER BY
More than I planned to cover, but we're not complaining.
Day 2 loading...
#7DaysOfSQL #SQL
Let's see how far we can go in a weekπ
Let me know when you are starting brother π«
#SQL #7DaysOfSQL
Capstone done, guess it's time to focus on other thingsπ₯²
7 days of SQL.
Topics: SELECT, Strings, GROUP BY, JOINs, CTEs, Window Functions, Stored procedures & Temp Tables.
Let's see how far I can go in a weekπ
Day 1 coming up π #SQL #7DaysOfSQL
Capstone done, guess it's time to focus on other thingsπ₯²
7 days of SQL.
Topics: SELECT, Strings, GROUP BY, JOINs, CTEs, Window Functions, Stored procedures & Temp Tables.
Let's see how far I can go in a weekπ
Day 1 coming up π #SQL #7DaysOfSQL
π Christmas break = skill upgrade.
For the next 7 days,
Iβm learning SQL as a MERN dev
from @Hiteshdotcom sir @udemy web dev course
Goal:
β’ SQL basics (dev POV)
β’ How backend apps use relational DBs
Sharing daily.
Building in public.
#7DaysOfSQL #Backend #WebDev
Data Analysis Project
HOSPITAL ADMISSION
Day 1 of 7 Days of #SQLwithFunmi ο― @olufunmilola olapeju olaewe @innotech IT Consultancy.
tantobatechworld #SQLwithFunmi #7DaysOfSQL #LearningInPublic #DataAnalytics #SQLSkills #DataJourney
Day 7:
Over the past three days, I went down the rabbit-hole of SQL tutorials, YouTube videos, online courses and data analysis articles. I realised that Data Analytics is a never-ending learning journey and you need a mentor within the field to guide you.
#7daysofSQL
Day 6:
Today I spent more time on databases and watched a couple of YouTube videos on creating a database. By the end of the second video, I had created three databases.
#SQL #7daysofsql
Day 5:
Today I created my first database in SQL. It was such a fun experience and quite rewarding I must add. #7daysofSQL #sql #DataScience
Day 4:
Still on my SQL journey, I learned how to create, alter and update tables, edit databases and create new ones. I also completed the SQL tutorials on W3Schools.
#7daysofSQL #sql
Day 2:
Today I learned about aggregate functions (MIN, MAX, COUNT, AVG, SUM) in SQL and practiced with the Chinook Database.
#7daysofSQL
Today I learned how to create databases and tables, insert, update, delete, alter and drop, and to add in check constraints for columns. (Who needs a .tar file, right?) #7daysofSQL
Last Seen Hashtags on Sotwe
pregnantfemale
Seen from Netherlands
barrybrenner
movie
Seen from Saudi Arabia
ε°εθη·
Seen from Japan
CORNO
Seen from United Arab Emirates
cnckink
Seen from United States
azureadhealthmonitoring
Seen from United States
stepsister #sleeping
Seen from United States
Ψ³ΨΉΩΨ―ΩΨ©
FD
Seen from Korea
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.1M followers
Barack Obama
@barackobama
119.3M followers
Donald J. Trump
@realdonaldtrump
111.6M followers
Cristiano Ronaldo
@cristiano
108.8M followers
Narendra Modi
@narendramodi
106.9M followers
Rihanna
@rihanna
97.2M followers
NASA
@nasa
92.1M followers
Justin Bieber
@justinbieber
90.5M followers
KATY PERRY
@katyperry
86.7M followers
Taylor Swift
@taylorswift13
80.5M followers
Lady Gaga
@ladygaga
72.1M followers
Kim Kardashian
@kimkardashian
69.3M followers
YouTube
@youtube
68.6M followers
Virat Kohli
@imvkohli
68.4M followers
Bill Gates
@billgates
63.4M followers
The Ellen Show
@theellenshow
62.5M followers
CNN
@cnn
61.9M followers
Neymar Jr
@neymarjr
61M followers
X
@x
60.9M followers
CNN Breaking News
@cnnbrk
59.9M followers