SQL For Data Analysis Full Portfolio Project with Practical [1Hour] | End-to-End SQL Project 2024

Подписаться 3,4 млн

Просмотров 143 тыс.

50% 1

SQL For #DataAnalysis Full Portfolio Project with Practical [1Hour] | End-to-End #SQL Project 2024
🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: www.wscubetech.com/landing-pa...
🔗DataSets Link: github.com/Ayushi0214/pizza-s...
WsCube Tech is a Vernacular Upskilling platform revolutionizing the way you learn and develop your career skills.🚀
WsCube Tech stands out as a leading EdTech platform, offering comprehensive education in Python, Machine Learning, and various Data Science skills. Our approach involves both online and classroom training, featuring hands-on projects delivered practically by seasoned industry experts.
With WsCube Tech, you'll gain hands-on skills that make you globally competitive. Our courses are designed to prepare over 100 million career aspirants for the 'Bharat' of the future. 😊
👉 Want to learn and acquire skills in English? Visit WsCube Tech English channel: bit.ly/2M3oYOs
📌 𝗩𝗼𝘁𝗲 𝗳𝗼𝗿 𝗼𝘂𝗿 𝗻𝗲𝘅𝘁 𝘃𝗶𝗱𝗲𝗼: bit.ly/share-topic-ideas
Watch Now our Trending App Development Playlist & Videos:
👉 Learn Python Programming in One Video - • PYTHON Full Course for...
👉 DSA Full Course - • DSA Full Course with P...
👉 20 Python Projects in One Video - • Top 20 Python Projects...
👉 Excel Full Course for Data Analysis - • Excel Full Course for ...
For any queries, call us on: +91-7878985501
✅ CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) -
👉 Instagram - / kushagrabhatiaofficial
👉 LinkedIn - / kushagra-bhatia
👉 Facebook - / kushagrawscubetech
Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more:
😄 Facebook: / wscubetech.india
🐦 Twitter: / wscubetechindia
📱 Instagram: / wscubetechindia
👨🏻‍💻 LinkedIn: / wscubetechindia
🔺 RU-vid: bit.ly/wscubechannel
🌐 Website: wscubetech.com
-------------------------------------| Thanks |--------------------------
#dataanalyst #dataanalysisproject #sqlprogramming

Опубликовано:

8 апр 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 181

@premro 2 месяца назад

Amazing. I have not found any video who has explained everything in such detail. Thank you very much.

@wscubetech 2 месяца назад

🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: www.wscubetech.com/landing-pages/online-data-analytics-course.html?RU-vid&April2024_08&RV

@SatyamSinghSikarwar-dy3vx Месяц назад

From Basics : Q.3-Identify the most common pizza size ordered. Querry- select pizzas.size , count(orders_details.quantity ) as order_count from orders_details join pizzas on orders_details.pizza_id = pizzas.pizza_id group by pizzas.size order by order_count desc ; Maam i am using this different querry for this problem , we both using different querries but our answers is same . for COUNT i am using quantity of order_details table instead of order_details_id of order_details table . so, maam could you please help me to understand the difference because our results is same

@prashantsharma466 Месяц назад

Great video I got better understanding of joins from your video

@tulsidasverenkar7566 Месяц назад

nicely explain very informative lot of thank you

@user-wb1ov4vh9x 2 месяца назад

great thank you for the sql project

@vishnuyadav9201 19 дней назад

In the question "Identify the most common pizza size ordered." you did " select size and count(order_details_id)" but actually it should by "select size and sum(quantity)"......... it should be sum(quantity) not count(order_details_id) in select statement because a lot of people ordered 2 pieces of same size and pizza flavor. and it should be counted in the size ordered. let me know if I'm doing wrong "check out 23:49 "

@utkarshs210i 2 месяца назад

Its really appreciated the efforts of team & mam... Everyone just make a video how to do project ...but you tells how to make slide, how to upload on LinkedIn and github which is totally awesome... Thanks a lot 🎉❤

@soumyasaxena77 2 месяца назад

this is so helpful! thank you :)

@preetshah3793 2 месяца назад

Thank you for this video 🙏

@imrulkayes7771 Месяц назад

Very helpful project. Hope you upload more projects like this in the future. Thanks again.

@kaminikowe535 2 месяца назад

Thank you Ayushi it will more helpful

@sundramprajapati8551 2 месяца назад

Thanks, and really helpful

@vidyatrimbake480 24 дня назад

Very very helpful mam, just mind blowing!!🔥🔥🔥

@akashhanchatet-2842 2 месяца назад

Wait, has anybody told you guys that you are simply AWESOME 🎉! Especially this session by Ayushi, Very impressive ✨ Appreciated.

@user-bf9uh6nl9z 2 месяца назад

Thank you for the video.

@rishabhjain133 Месяц назад

It's a great fun learning videos. I immensely enjoyed followed along, got few queries myself before watching ans. Kudos to you, please keep bringing more videos like this.

@souravchakraborty4397 2 месяца назад

Best of the best ....

@user-nk3cc6dd7l Месяц назад

Thanks for making video, keep making videos and educate us ... Super, great job , very informative 👍👍👍👍

@sonamchauhan2968 13 часов назад

thank you so much ma'am!

@RishiRajxtrim 2 месяца назад

thanks

@soniyachandran6491 Месяц назад

Thank you for this video

@faisalsheikh2079 Месяц назад

Hello WsCube Team I completed my BCA from Beginning to End with all efforts of your team members I really appreciated your works.Thanks a lot❤

@107vikrantdeshmukh4 Месяц назад

Thank you so much mam for this video 😊😊

@ujjawalanand5216 2 месяца назад

Thanku mam for this session

@md.shahriarkobir5191 Месяц назад

surely, you are the boss, impressive

@tejasgidde4837 29 дней назад

Nice 👍

@nsrajput4675 Месяц назад

Thanks for the video 😊

@MuhammadAli-ib4xn Месяц назад

thank you so much

@nehasri6307 Месяц назад

Thanks

@krishnaKumar-hj1pu 2 месяца назад

thank u soo much

@omkarkandekar8043 8 дней назад

you are doing great mam but if use the query for joining 3 tables differently that would be much easily uderstandable

@shaikusman536 22 дня назад

Awsome Content Ayushi mam......keep up the great work...Thanks....Respect from Bangalore.

@swatidas7069 Месяц назад

Very nice ma'am Please make Finance / Banking domain projects with portfolio

@lifeisosmyaar Месяц назад

Thanks , please provide question set for best practice.

@dreamhousepune2051 2 месяца назад

Dear Mam, Could you please create the video about etl testing end to end project.

@SagarPatel-rp5vw 2 месяца назад

Tk you

@Sjjsjam 2 месяца назад

Mam agar apki team ma sa koi comment dekh raha hai toh please my humble request to make videos on Java full stack web development 🙏🙏🙏🙏I know this channel is best channel in RU-vid ❤❤❤

@wscubetech 2 месяца назад

Coming Soon!

@misal_thakre 2 месяца назад

Ya this channel cover all technical topics/languages. And provide quality of content, currently i am learning android app development from this channel.

@PritamAnand20 Месяц назад

@@misal_thakrebro I am planning to buy paid course of flutter. Is it good for me or not. Please reply ❤❤❤❤❤❤

@misal_thakre Месяц назад

@@PritamAnand20 if you want to become a Android developer,you should first learn kotlin and xml. This is a core of android development and there are more jobs in that. Flutter has comparatively less jobs than kotlin with less community support. So i advice you to start with kotlin, after that you may learn kotlin multiplatform to build hybrid applications like flutter.

@mohdnasim2575 Месяц назад

Thank you so much, Please make a video and if available please provide how to remove duplicate data in MySQL.

@CivilGurujiShorts 2 месяца назад

Hi mam, kripya "Chief_Architect" design software civil Engineer pe full course video upload krwa dijiye please..... It's humble request 🙏🙏🙏🙏🙏

@user-ey7pq7ej6w Месяц назад

Very helpful

@Muhammadtajid Месяц назад

❤ mam please make a video on Tableau full course with practical 🙏

@roshanmohapatra8874 Месяц назад

I am a student of WS Cube. Ayushi ma'am teach Python well too.

@Dearstories414 2 месяца назад

❤❤❤❤❤

@PrathameshShinde-xg7df 13 дней назад

best video more on power bi

@hritik1213 2 месяца назад

40:41 In the third question from intermediate, we have to find out the category-wise distribution (category-wise orders), 41:08 but you wrote the query for how many pizzas are there in each category.

@anjalipethe1010 Месяц назад

Yes, I am also stuck on this. Thinking that I was wrong. But my answer was right. Thanks

@abhiroopchoudhury9010 Месяц назад

yes me too stuck on this

@SyedAmaan-yv7sz 25 дней назад

can you please share the right answer then Chicken 10815 Supreme 11777 Classic 14579 Veggie 11449 i got this output. is this correct

@sangee.th_4732 21 день назад

@@SyedAmaan-yv7sz I got the same output too

@AbdurRehman-sl2bz 18 дней назад

@@SyedAmaan-yv7sz Can you please share the query you wrote for this particular answer, I'll be thankful for the effort 😀.

@ManishJain-rl7lm 2 месяца назад

Can you please make a video on steps that should be used while analysing the data Because I am stuck as I don't know how to start analysing the data.

@user-mh3mw7fk9w 3 дня назад

Mam everything is great but if you had shown some use of CTE as well then it would be great, you just skipped it by just saying its name and used subqueries everywhere but great project mam really helpful

@reemachanotia4700 2 месяца назад

thank you soo much mam mam ek qution hai apse ki jb hmne orders name ka table create kiya to usme hmne datatypes b rkhi hai data column according too jb hmne data load kiya too jo data folder mein thaa uski b koi datatype hogi too jb hmne create kiya table too dataype automatically change hoo jeygi .. plz clear this doubt mam..i request you.. plzz ❤❤ and thankyou so much mam ...

@a.jtechnicalworld2834 Месяц назад

In the 4th question we can directly use Max to find heightest price

@informativefun6942 Месяц назад

Hi Mam, actually I m learning SQL now from ur vedios, I have one doubt, who will give us schema/ data in proper format like removing null values or numerice ,in between alphab. Values etc etc. in company....or as a data analyst we work on first on data like remove null values, setting PK, FK ...can u plz reply bcoz in this vedio we get CSV file in that all data r arrange format so i confused...

@VishalPatel-yd6gf Месяц назад

Thank you so much

@RishiRajxtrim 2 месяца назад

🙂🙏

@egbuchulamchinedu5136 9 дней назад

You tutorials are awesome and but i can seem to download the data set...could u help with alternative?

@user-ey7pq7ej6w Месяц назад

Madam please guide in details about git and git hub . And also repository

@rahmankhan7303 Месяц назад

Sorry to say mam but the first question (retrieve total number of orders placed) don't you think if v using select count(*) from orders; This will give us only unique orders not total no of orders cause on a single order id there may more than one orders (like in order_details table). So i think for perfect no. of total orders placed (not only unique orders) the querry should be select count(*) from order_details; 🤐🤐

@Shiva_7109 2 месяца назад

Mam I want project on cloud computing

@abhishekarya7915 2 месяца назад

ma'am aws devops pe ek project pe video bana do and ek erp pe bhi project video bana do

@tusharchavan8795 5 дней назад

Is it not possible to combine all four tables into one before uploading them to MySQL? It would simplify searches since we wouldn't need to search through multiple tables each time. What do you think?

@GauravKumar-on5wz 15 дней назад

Mam Q13 ASKING top 3 based on revenue for each category so I think also need to select category, name , revenue but you select only name and revenue

@mannumannu9200 2 месяца назад

Only upload pdf on github? Not the code & database file?

@Muhammadtajid Месяц назад

We want to Tableau full course for data analytics

@AK-Unstoppable Месяц назад

ma'am plz bta dijiye yeh jo SQL VERSION apne use kiya h yeh kon sa version h?

@gaffoor546 10 дней назад

I have understood the all Basic, Intermediate, Advanced level scenario. but how can we get the scenario from the raw data. Can you explain in details one hospital management example in the MS SQl Server.

@CodingSanchar 2 месяца назад

Thanks mam for 1252 subscribe

@rubysrivastava2288 2 месяца назад

How to prepare the questions to create a project? Please help...

@Ganeshay-996 2 месяца назад

Mam agar apki team ma sa koi comment dekh raha hai toh please my humble request to make videos on plsql development I know this channel is best channel in RU-vid

@mandeepsingh-se3mj 2 месяца назад

Cant this be done using pivot tables? Much easy and much faster way?

@mrawat0009 15 дней назад

Ma'am can you please make a project for me on data analysis in operations manufacturing sector

@sagaromer8385 2 месяца назад

apne starting me jo data add kiya hai tables me unke beech me referential integrity toh set hi nahi kari...

@shivanshbansal5841 Месяц назад

Can we make a power bi dash board using these data set? Can you help me?

@Manisha70856 7 дней назад

Her voice sounds like voice artist

@leooo30 21 день назад

Mam what description should be given to this project

@karstendsouza5280 24 дня назад

Ma'am, how do I save the sql file? When I save script to my laptop and then reopen the sql file then it says no database to connect to

@rakkeshkannadhanasekar8716 2 месяца назад

can u put videos in english it will be useful for more candidates

@abhishekpareek6858 5 дней назад

The data is not appearing in the orders section even after the data import process was completed successfully

@AK-Unstoppable Месяц назад

ma'am yeh SQL ka kon sa version use kiya h apne can you share the link ma'am?

@ankeshraj6724 11 дней назад

abhi takk 2 pizza order ho gya par video khtm nhi hua

@MoinAli-ou8qm 2 месяца назад

CHAT GPT prompt engineering ka course laaen

@sagaromer8385 Месяц назад

average pizzas order per day ka result ek single column nahi hoga i guess wo day wise average nikalna hoga agar single nikaloge toh average order per month hua na.

@avinashgohite9921 13 дней назад

I m not able to import pizza types file I have also tried to import the entries after creation of table but it showing error

@swatisinha2916 2 месяца назад

Mam apke channel par SQL k tutorial ni h

@nishachauhan9377 21 день назад

Hello mam...pizza types ki file import nhi ho rhi ...ms sql mai... Baki tino files ho gyi ..help plz

@ayushkawale2017 Месяц назад

can we put it on resume or is it too basic?

@vishalsir9233 2 месяца назад

Android phone kali Linux me network problem hai aap fixed kar do please 🙏🏻

@Xavier-ui5it 13 дней назад

Why am i getting error while uploading order dataset Row import falled with error: (Data truncated for column 'order date at row 1", 1265)

@ravishyadav8188 Месяц назад

fille name: Pizza_type not working . it showing (Unhandled exception: 'ascii' codec can't decode byte 0x91 in position 1710: ordinal not in range(128)). how to solve this plz help

@shivanityagi1097 22 дня назад

Hi actually I have downloaded the files from GitHub but they are not in Excel format or csv they appear in coding ...please help

@abhishekGogoi-hy4ko 6 дней назад

PG admin mein sikhaona.

@Data_Mom Месяц назад

Make use of CTE/ window functions, instead of subquery. Also alias the table names.

@user-pc7ud4vs2y 10 дней назад

if i have to describe this project in cv , how would you write this

@parmjeetbeniwal9363 2 месяца назад

Hello

@shrutnb2071 Месяц назад

order details table import nahi ho raha ...maine 3 4 bar try kiya thoda hota hain or band ho jata hain...plz give me solution

@truptidukhande1810 Месяц назад

Change the date format in excel

@adyaankhattak1809 2 месяца назад

how to install the MySQLworkbench please tell me

@jasveer7741 22 дня назад

Pls bta do ki ye data sql server per kese import karu kiyuki mene sql server sikha hai mysql nahi 😢

@shreeyanshisrivastava858 Месяц назад

Hi Mam, I am getting error Unhandled exception: 'ascii' codec can't decode byte 0x87 in position 10: ordinal not in range(128) while importing pizza_type file. I have removed the special characters and copied to the new csv file and then tried but the same error came up.

@kartiksoni1255 Месяц назад

did you solve it? because I am getting the same as well.

@vishalsir9233 2 месяца назад

Kex me use karte hai

@Ayaan_khan21 Месяц назад

couldn't understand-- Group the orders by date and calculate the average number of pizzas ordered per day easily, my bad

@user-vm7sz3cu1w 2 месяца назад

Hello Mam Question - Group the orders by date and calculate the average number of pizzas ordered per day. Query - SELECT order_date, COUNT(od.order_id) AS total_pizzas_ordered, ROUND(COUNT(od.order_id) / COUNT(DISTINCT order_date)) AS average_pizzas_per_day FROM orders o JOIN order_details od ON o.order_id = od.order_id GROUP BY order_date; Is it correct or not?

@sushugowda5743 2 месяца назад

-- Group the orders by date and calculate the average number of pizzas ordered per day. select day(order_date) as Date, round(avg(qty),0) as Avg_Count from (SELECT order_date, sum(quantity) as qty FROM orders o join order_details od on o.order_id = od.order_id group by order_date ) as a group by day(order_date);

@leooo30 21 день назад

Should we mention that it is a guided project 🙂