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

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: [phone]
✅ 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
🔺 KZbin: bit.ly/wscubechannel
🌐 Website: wscubetech.com
-------------------------------------| Thanks |--------------------------
#dataanalyst #dataanalysisproject #sqlprogramming

[@wscubetech]

🔴 To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: www.wscubetech.com/landing-pages/online-data-analytics-course.html?KZbin&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

[@premro]

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

[@user-wb1ov4vh9x]

great thank you for the sql project

[@preetshah3793]

Thank you for this video 🙏

[@soumyasaxena77]

this is so helpful! thank you :)

[@tulsidasverenkar7566]

nicely explain very informative lot of thank you

[@utkarshs210i]

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 🎉❤

[@prashantsharma466]

Great video I got better understanding of joins from your video

[@sundramprajapati8551]

Thanks, and really helpful

[@kaminikowe535]

Thank you Ayushi it will more helpful

[@imrulkayes7771]

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

[@user-bf9uh6nl9z]

Thank you for the video.

[@omkarkandekar8043]

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

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

[@vishnuyadav9201]

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 "

[@user-nk3cc6dd7l]

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

[@vidyatrimbake480]

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

[@souravchakraborty4397]

Best of the best ....

[@soniyachandran6491]

Thank you for this video

[@RishiRajxtrim]

thanks

[@ujjawalanand5216]

Thanku mam for this session

[@akashhanchatet-2842]

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

[@107vikrantdeshmukh4]

Thank you so much mam for this video 😊😊

[@MuhammadAli-ib4xn]

thank you so much

[@krishnaKumar-hj1pu]

thank u soo much

[@nsrajput4675]

Thanks for the video 😊

[@md.shahriarkobir5191]

surely, you are the boss, impressive

[@tejasgidde4837]

Nice 👍

[@nehasri6307]

Thanks

[@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❤

[@SagarPatel-rp5vw]

Tk you

[@shaikusman536]

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

[@lifeisosmyaar]

Thanks , please provide question set for best practice.

[@swatidas7069]

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

[@dreamhousepune2051]

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

[@mohdnasim2575]

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

[@user-ey7pq7ej6w]

Very helpful

[@Muhammadtajid]

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

[@Sjjsjam]

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 KZbin ❤❤❤

[@wscubetech]

Coming Soon!

[@misal_thakre]

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.

[@CivilGurujiShorts]

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

[@PrathameshShinde-xg7df]

best video more on power bi

[@roshanmohapatra8874]

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

[@ManishJain-rl7lm]

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-ey7pq7ej6w]

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

[@Dearstories414]

❤❤❤❤❤

[@a.jtechnicalworld2834]

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

[@reemachanotia4700]

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

[@egbuchulamchinedu5136]

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

[@hritik1213]

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]

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]

@@SyedAmaan-yv7sz I got the same output too

[@AbdurRehman-sl2bz]

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

[@gaffoor546]

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.

[@abhishekarya7915]

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

[@rubysrivastava2288]

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

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

[@RishiRajxtrim]

🙂🙏

[@kanikasuneja8526]

Hi I got an error while creating orders table The definition for column 'primary_key' must include a data type. Could you pls explain this? thanks!

[@VishalPatel-yd6gf]

Thank you so much

[@Shiva_7109]

Mam I want project on cloud computing

[@leooo30]

Mam what description should be given to this project

[@shivanshbansal5841]

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

[@AK-Unstoppable]

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

[@GauravKumar-on5wz]

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

[@Muhammadtajid]

We want to Tableau full course for data analytics

[@mannumannu9200]

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

[@mandeepsingh-se3mj]

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

[@CodingSanchar]

Thanks mam for 1252 subscribe

[@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; 🤐🤐

[@sagaromer8385]

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

[@mrawat0009]

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

[@karstendsouza5280]

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

[@avinashgohite9921]

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

[@Manisha70856]

Her voice sounds like voice artist

[@Xavier-ui5it]

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

[@adyaankhattak1809]

how to install the MySQLworkbench please tell me

[@ashutoshmishra4781]

but when my output is different instead of using same querey & same software , why ?

[@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

[@ankeshraj6724]

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

[@swatisinha2916]

Mam apke channel par SQL k tutorial ni h

[@Ganeshay-996]

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 KZbin

[@nishachauhan9377]

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

[@user-pc7ud4vs2y]

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

[@vishalsir9233]

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

[@shivanityagi1097]

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

[@jasveer7741]

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

[@AK-Unstoppable]

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

[@vishalsir9233]

Kex me use karte hai

[@MoinAli-ou8qm]

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.

[@rakkeshkannadhanasekar8716]

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

[@Ayaan_khan21]

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

[@abhishekmishra9985]

Can we do this In postgre sql

[@Data_Mom]

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

[@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

[@parmjeetbeniwal9363]

Hello

[@yogenderrawat4687]

The Orders file doesn't work

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

[@ayushkawale2017]

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

[@leooo30]

Should we mention that it is a guided project 🙂

[@RajnikantHalge]

Mam muje hacking me interest hai 10 th ke baad kya karu

[@praveshsingh8255]

Mam I want SQL classes , how can i join pls help me

[@MariyamKhalid-sz2sc]

beautify by Ctrl + B Or Ctrl + D what is right...

[@jeeyakasar2802]

Ctrl + B

[@prajyot8002]

Your data’s table name is too confusing to understand columns