Rasheedah Sanni (@D_dataSmith) profile picture

chemistry meets data 🧪📊 learning, building, and figuring things out.

Joined August 2026
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.
1
3
8
157
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! ✨
2
2
6
170
Another day to try, learn, and get things done, one step at a time. 🤍 I hope today is kind to us all. 🥹
2
4
9
71
It's Monday! New week, fresh energy, new possibilities. May this week be kind to us all. 🫶🏽
Happy Sunday! hope you’re having a peaceful one. and how’s preparation for the new week going? are we ready? 😂
3
4
5
146
Happy Sunday! hope you’re having a peaceful one. and how’s preparation for the new week going? are we ready? 😂
Good morning! ☀️ It’s weekend, but rest will have to wait a little because there’s still so much to get done 😅 One thing at a time, we move! Hope you all have a beautiful saturday. 🤍
4
5
1
12
337
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().🤍
Today’s sql practice taught me a lot. 😅 i spent almost 30 minutes on one confusing leetcode question, and I also learnt more about window functions. I also understand how they differ from group by and how they preserve data granularity. Next up: ranking window functions.
4
6
11
232
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
3
4
9
238
Good morning! ☀️ It’s weekend, but rest will have to wait a little because there’s still so much to get done 😅 One thing at a time, we move! Hope you all have a beautiful saturday. 🤍
4
5
1
9
376