Today's SQL learning update! 🚀
I've started learning Common Table Expressions (CTEs), and how they help structure complex queries into smaller, more readable parts.
So far, I've practised combining CTEs with:
JOINs
GROUP BY and HAVING
Subqueries
Window functions
Multiple CTEs
also relating these concepts to my Laboratory Inventory Database project.
One step at a time.
Another brick in the foundation.
It's Fridayyy!
A new day to remind yourself that you're capable of more than you think.
Keep believing in yourself, trust the process and keep showing up your efforts matter.
Have a beautiful Friday! ✨
Another day to try, learn, and get things done, one step at a time. 🤍
I hope today is kind to us all. 🥹
Today's progress...✨
I started learning ranking window functions in SQL today,
I learned how ROW_NUMBER() assigns a unique number to each row, while RANK() gives tied values the same rank and skips the next position.
I also explored ORDER BY, PARTITION BY, and the difference between integerbased and percentilebased ranking. Plus, I practised some questions
Next up: DENSE_RANK() and NTILE().🤍
Enjoying the experience at the Huawei ICT Roadshow, UNILORIN 🤍
Always nice to learn, connect, and experience new things! ✨
I C the future
@Huawei_Unilorin
@UnilorinNGR
#HuaweiICT
#huaweiiCTroadshow2026

















