Malcom Okonkwo #DataFestAfrica2024 Profile picture
Data Analyst (Microsoft Certified) 👨‍💻📊📉 Winner of DataFestAfrica 2022 (Team Nova) First Class chemical engineering graduate (B.eng)
Nov 27, 2023 10 tweets 2 min read
Hey #datafam

I got a Job as a Data Analyst... but then I lost it 🥲

I take full responsibility for it.

Why am I sharing this story? I want to inspire someone and I also want someone to learn from my mistake

So here goes... Image I was pretty vocal about my search for a new job so I told people I know

So there was this job posting a friend of mine @NancyAmandi came across and sent to me and I applied.

I wasnt exactly confident because the Job description asked for a mid level Analyst with Strong SQL...
Oct 6, 2023 11 tweets 3 min read
SQL Optimization Tips 🔵

Have you tried running SQL queries but it takes a while before you get a result?

Have you thought about Optimizing your queries but you dont know how?

Here are a few tips I would recommend to improve your query performance

#Thread #sql Image 🎯Tip 1 Instead of * use column names in a select statement and limit your records

When working with very large amount of data, it isnt a good practice to use "SELECT * FROM table_name" because you are retrieving all records and fields in the database which requires a lot of ...
Sep 18, 2023 8 tweets 3 min read
Hello Data Analysts/SQL Lovers

Have you tried solving questions or solving problems with SQL? Are you currently learning SQL and are looking for where to practice?

Here are a few of my go-to websites that I used to learn and practice SQL

#Thread 🧵 Image Before I go into practice websites, why not start by taking a SQL test to see what you know and dont know

Test your proficiency with this 25 SQL Questions by W3Schools

Feel free to share your score at the end of the test @Olaoluwa__Mercy

Test Link: w3schools.com/sql/sql_quiz.a…
Image
May 22, 2023 9 tweets 5 min read
Hello Datafam,

So someone asked me where they can get to practice SQL so I would dropping links to platforms where you can practice SQL

Thread 🧵 1) Hackerrank @hackerrank

I have used this platform and I really loved using it. I also love that they reward with badges and stars as you make progress

check it out here: hackerrank.com/domains/sql
May 21, 2023 5 tweets 5 min read
Happy Sunday Everyone,

I think I am feeling well enough to make this tweet

So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors

Top of the table😁 ImageImage The Level 2 challenge was a murder mystery challenge to find who the killer is and we were to solve the challenge using SQL

If you dug deeper you'd find out that there was someone who hired it.

Nothing complex but it was fun, felt like a detective 😊 ImageImage
Feb 20, 2023 9 tweets 5 min read
Have you been trying to improve your SQL skills but you don’t know the right resources to use

Have you been confused on which SQL resource to use to become very proficient

I’d love to share what I’ve used to learn SQL since I started my data journey last year Okay first course I’d recommend which is the first course I took is the introduction to SQL course by IBM on @edXOnline . The course uses IBM db2. With this course, I got my first experience in solving problems with SQL. They have series of questions that I enjoyed solving