As a data analyst, SQL happens to be my favourite programming language or query language like I love to call it. It's quite easy to learn but gets complicated when you get deep into it.

I will be sharing with you a simple project I worked on this week. Nothing fancy. Just messing around with this dataset.

1) This is a productsData dataset and as you can see from the picture below:
a) i created a database
b) imported the dataset for Excel to mySQL
c) highlighting number 7 alone and running it will give the result below
d) this is the raw dataset

2) I decided to clean and analyse the data by:
a) adding row numbers to the data
b) using the CASE function to create a new product_ranking column
c) using the WHERE clause to remove product_name that has ? on it.
d) highlighting from 9 - 17 and running it, gives you the result below.
e) this is my new dataset

3) Writing a query to find the top 3 products and their prices.
a) highlighting 21 - 25 and running it gives you the result below.

4) Instead of executing the same query multiple times, I created a VIEW showing only values with pro from the professional_publication column.
a) writing the query from 28 - 39
b) highlighting 41 only and executing it, gives you the result below.

5) Just like the VIEW above, another VIEW was created to show 'private' values only from the professional_publication column
a) writing query from 44 - 55
b) highlighting 57 only and executing it, gives you the result below.

6) Instead of sending multiple sql statements, I created a procedure to store the products with price lesser than the total average price
a) writing query from 61 - 70
b) calling the stored procedure by highlighting 72 only and executing it, which then gives you the result below.

7) Finally Just like the STORED PROCEDURE above, I created another to store products with price greater than the total average price.
a) writing query from 75 - 84
b) calling the stored procedure by highlighting 86 only and executing it, which then gives you the result below.

jamerflepz:
2) I decided to clean and analyse the data by:
a) adding row numbers to the data
b) using the CASE function to create a new product_ranking column
c) using the WHERE clause to remove product_name that has ? on it.
d) highlighting from 9 - 17 and running it, gives you the result below.
e) this is my new dataset

This new dataset is exported to Excel or Power BI or tableau or python for data visualization. Creating a dashboard is important. Very important.

Well done

5.7 or v8?

gbengaoyeladun:
Well done

Thank you.

airsaylongcome:
5.7 or v8?

v8

jamerflepz:
v8

Let me go and dust up my SQL skills. Reading this was very nostalgic. With v8 I'm assuming you don't touch Maria. Postgres?

airsaylongcome:


Let me go and dust up my SQL skills. Reading this was very nostalgic. With v8 I'm assuming you don't touch Maria. Postgres?

Nah I don't. I do work on postgreSQL sometimes but not as much as MySQL.