“Data Geek | Data Analyst | Finance Fan | Simplifying money moves"
Joined July 2025
- Tweets 1,355
- Following 220
- Followers 275
- Likes 1,968
125 Photos and videos
Pinned Tweet
May 24
Day 90/120 ✅
Finally Done with @TechSphereAcad Capstone Project
This Project really tested my understanding and also some critical traits of being an analyst.
Thank u so much @ezekiel_aleke for being a wonderful tutor.
Github documentation: github.com/simplysmarty/Tran…
13
6
69
1,735
Day 109/120✅
SQL Sprint Day 16.
Yesterday we understood why JOINs exist.
Today: we write our first one.
INNER JOIN — the most common JOIN in SQL.
Here's everything you need to understand and use it🧵
#120DayChallenge #SQLSprint
3
1
9
105
One rule: when the same column name exists in both tables, you must specify which table.
customers.customer_id → the ID from the customers table orders.customer_id → the ID from the orders table
Use table.column_name notation whenever there's any ambiguity.
1
8
Sprint Day 16 challenge:
Write an INNER JOIN between any two tables you can imagine — customers orders, employees departments, products sales.
Define both tables and the shared key.
Write the query and drop it in the replies.
#SQLSprint #SQL #LearningInPublic
8
Jun 12
Day 108/120✅
SQL Sprint Day 15.
Week 3 starts now.
Weeks 1 and 2 worked on one table at a time.
Week 3 connects tables together.
This is JOINs. The most talked-about skill in SQL interviews.
Here's where it begins. 🧵
#120DayChallenge #SQLSprint
1
1
5
86
Jun 12
There are four types of JOIN. We'll cover them all this week:
INNER JOIN → only matching rows from both tables
LEFT JOIN → all rows from the left table matches from right
RIGHT JOIN → all rows from the right table matches from left
FULL JOIN
1
11
Jun 12
No challenge today — just a question.
In your job or business, how many separate data sources do you work with that you've always wished you could combine?
Replies welcome.
Tomorrow we start writing real JOIN queries.
12 sprint days left.
#SQLSprint #SQL #LearningInPublic
13
Jun 11
Day 107/120✅
SQL Sprint Day 14.
Week 2 of the SQL Sprint is done.
7 concepts, 7 days with a completely different level of SQL.
Here's the full recap plus the query that ties every single lesson together.
Thread worth saving. 🧵
#120DayChallenge #SQLSprint
1
4
20
193
Jun 11
Week 2 final challenge:
Write a query using:
→ At least 2 aggregate functions
→ GROUP BY
→ HAVING to filter groups
→ ORDER BY to rank results
Drop it in the replies.
1
13
Jun 11
13 days left in this challenge.
If you've been following the #SQLSprint — drop a 🔥 below.
I want to see who's still running with me.
RT tweet 1 if this thread was useful.
Someone in your network needs to see it.
#120DayChallenge #SQL #LearningInPublic #SQLSprint
1
1
13