Practice Writing Complex SQL Queries using real dataset (PART 2) |Full Project Data Analysis Project
Вставка
- Опубліковано 2 жов 2024
- #DataAnalysis #SQLQueries #SAP #BikesSales #SQLTutorial #DataScience #BusinessIntelligence #FullProject #HandsOnLearning #sqlcte #windowfunctions
Here is a comprehensive tutorial on writing complex SQL queries! In this video, I'll walk you through a full data analysis project using a real-world dataset from SAP's Bikes Sales sample data. Perfect for anyone looking to enhance their SQL skills and gain hands-on experience with real business data.
🔗 Resources:
Download the dataset: github.com/Hor...
SQL query examples: github.com/Hor...
Data questions: github.com/Hor...
Hi, Omolara! Thanks so much for your videos; they are lovely to watch and learn from 🙌🙌🙌👌👌👌
Would you kindly do videos on the following for us:
- What you do as a Data Migration Specialist
- CTE Functions
- Window Functions
- Query Optimization
Thank you once again!
This is such a great suggestions which are well appreciated, thanks, I will work on these vidoes
Just watch your last video and subscribe.
Just know this if you post a video and you have one view know am the one, if you have thousand of view know am one of the thousands and if you have no view then am probably dead.
Keep it coming.
oh wow, thank you for your comment🙏
Please keep these coming
sure
Hi omolara, thanks for your great work. i am confused about sql and would be happy if anyone on this comment section could help me. i am currently learning about sql as part of the skill required for data scientist and when we did excel and tableau, i understood perfectly well from interpreting the data upto visualization. but you see this sql, how i can visualise all my exploratory analysis, how can i give report, in short is there any way for sql deployment to be sure you are actually doing the right thing. seriously confused dear
Hello, please take it one step at a time, data analysis as a field or Data Science as field isn’t just about Data visualisation, SQL itself can be use to answer some data questions, SQL can be used to clean large amount of data which in turn helps in better decision making, SQL can also be used in transforming data, while learning Tableau, am sure you must have heard about ETL, SQL can be used in our ETL processes too and so on,you can rarely see any data role that would not require knowledge of SQL, so I can assure it’s worth learning. I hope this helps🙏
So is the project finished or is there anything else needed to show this in the portfolio
@@cayspruceway yes please, you can check the data questions to solve more problems, it’s a pure SQL portfolio project
Great content
@@sushankkadayat5013 thank you 🥳
Hello Omolara , see this questions
-- Q24: List all addresses in a specific city, e.g., 'New York'.
trying to do this, no city bear new 'New York', like this
(select city
from addresses)
are you trying to say we should pull all out all cities. And more also you said addresses in a specific city. (Address, used to have, number of house, name of house or street, city, state, country). can you elaborate more on the questions. or may be is me that didn't understand it.
I think the idea is to play around the question, you question is just testing your where clause and wildcard understanding, you can try where of about two cities present in the data. Regarding address, you can also pay around every col you think should form your address and concat them respectively. I hope this helps
@@OmolaraFash ok. i will check through again,
kindly check the answer for this :
-- Q23: Count the number of addresses in each country.
select country, count(*) AS no_of_address
from addresses
group by COUNTRY
order by COUNTRY asc;
Is the code right?
@@olatunjioladayo7126 yes please
@@OmolaraFash thanks. I will be asking you much questions. Thanks for all you are doing
the code u gave for the question "top-selling product within each category along with its total sales amount." in last in github is not running....what should be the changes?
@@aashu90 hello please, it’s working really well, can I know the error you are getting? And by the way the full explanation is here ua-cam.com/video/KGIIvCQ0Bx8/v-deo.htmlsi=H56nPgtXRKO73cdh