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... 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...

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 🎯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 ...

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 🧵 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…

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

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😁 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 😊

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