Hi folks, csv files link (zip folder): 🔖Music Store zip csv files: shorturl.at/sEIUV If you are using Postgresql, Then directly import the database file .sql file. But if you're getting any error in album file then use the below query: CREATE TABLE public.album2 ( album_id int8 PRIMARY KEY, title character varying, artist_id int8 ); - refresh database (now u can see album table there) - Right click on the ablum table and select the Import/Export option Then select the album2.csv file (from your computer) The file will be imported successfully 👍🏻 Similarly, you can do it for other files. NOT USING POSTGRE SQL: 2. If using any other sql then, Use csv files n create your own music database. And for album file, first copy n paste in a new csv file in your computer n then import it to sql. It will work ✌️ Also, if you want help, pls watch my video on - How to import csv files in sql Keep learning and keep growing!🚀
after following the steps mentioned,and while creating the playlist_tracks, it says the error "can't create the table playlist_track, as multiple foreign keys are found" PLEASE HELP ME IN IT
@@RishabhMishraOfficial SIr please please write add to resume points in my reply ...your writing is so much professional please i wanna add this in resume
@@chakrabartisayantan4013 use chatgpt, prompt what u have done in your resume and ask gpt to write it like as u would write in resume/ short and crisp and highlighting everystep
you saved lakh of rupess , srlsy student dont understand that there is lots of free education on internet, they just have to gain and make some awesome projects but they prefer to spend lakhs of rupees , Thank You Sir For Your Efforts.
Congratulations, sir, on reaching 100K subscribers! This is a significant milestone and a testament to your hard work, dedication, and the valuable content you have been providing to us.
For those having issues importing the Database file.sql file, In PostgreSql, File -> preferences scroll down a bit paths -> binary paths For both server paths make sure your binary path is set: For instance EDB Advanced Server 16 I have set it to C:\Program Files\PostgreSQL\16\bin and then saved it Hope that helps!
Since I got interested in getting a Data Analyst job, I am binge-watching your videos and practicing. Your videos are very easygoing and rich in content. Requesting you to make an EDA project using python in the future. Thanks in advance.
Hiii, I am interested in switching my current field to a Data Analyst job, I find your videos to be engaging, effortlessly comprehensible, and packed with valuable insights. I am watching your videos and practicing. thank you.
Sir how to add this in resume means what points I have to write please write jn details please it will hardly take your precious 5 minutes. I'm begging to you😢@@RishabhMishraOfficial
Guys please share his channel and all videos he deserves million subscribers , your are awesome i mean i saw your video about data analyst roadmap , after i saw that video i thought there is no use to go to institute you have planned the roadmap very perfectly and it look like easy and amazing, and the videos step by step , middile class people can't affort institutes fees but you provide it all free from scratch thats amazing and its free of cost hats off to you bro lots of love and good wishes and one request please make video about data science also like roadmap and all the things you provide in data analysis provide in data science course also it will help me and all students guys share this video please he deserves millions subscribers 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
Hi Rishabh, I am writing this comment at the end of the video, this was my first Data Analytics Project and all I want to say is you're doing God's work out here. In the beginning I struggled a bit but as the video went by things became easier and I got the hang of it. Through the course of the video I got to learn new concepts of SQL as well as brush up my past knowledge of SQL. The video is very well structured and each question is explained very well, crisp and precise. Again, thanks a lot, I really appreciate your efforts, keep it up.
Hi brother.. Mera name krishna gopal hai Mai bhut dino se ek sahi mentor dhoond rha tha.. Finally i got you. Or maine thode din phle hi aapki.. Data analytics road map vali video dekhi. Or uska pdf download krke.. Excel se apna learning process start bhi kr diya hai.. Please hmesha hmaare sath bne rhna.. .. Thanks May god bless you bde bhai..
Learned a lot from your channel, I have completed this project with 3 days effort because I am a beginner. Please teach us more SQL-related real projects through your channel. Really Appreciate you, BOSS.
Nice video sir but if possible then please try to explain each query by writing live so that we can see the approach of you while dealing with complex and nested query. It will be very helpful for us.
for those who are getting error in restoring the sql file. kindly do the following necessary changes in pgadmin 4 look for File>Preferences>Binary Paths> update the dir location to the C:\Program Files\postgreSQL\16\bin then save it then restore the SQL file.
@@payaltanty6440 hi..are you using MySQL..cause I used that so ..if u are then all you need to do is check for some sort of errors that are in the file..like contents were missing..once done with that ..u are good to go ..let me know again if you still faced the issue ..I will gladly help and once more thing as far i remember in first file only few rows were missing..so check that thoroughly
Thank you, Rishabh Mishra bhai, for being an amazing instructor! I appreciate your guidance and support throughout the video. You're the true GOAT of data analyst!!! Bhai can you add English subtitle? Because some of your international viewers facing some difficulties like me. Best Wishes for your family & you. FROM BANGLADESH.
Really good work Rishabh! I really appreciate the way you make things simple .It's really helpful for making projects and also understanding them instead of just copying.Thankyou so much!! Let your channel be reached to more people..!
Thank you so much for this awesome series.... Kindly make one series on python also......You are awesome work for people like us who wants to start from zero, a big thanks to you 🙏
Thank you so much for the portfolio project. Your projects give me confidence that I can enter into data field without worrying about my non-cs background. I have a question here. How do we quantify or measure the insights that we derive out of this project. Any guidance will be very helpful. Thank you again!
Thanks a lot for yours videos, these are really helpful to me or new aspirant to learn the data analytics. I had referred more than 5 friends till now, and I am watching your every single video.
Thank you for making these!! I'm following all of your videos :) I'm doing this project now and the advanced level is so hard.... but I'll keep practicing 🫡
You are great and you have shared your experience it's very helpful for us and make some more such kind of video for SQL ,Python , as well as if possible plz make video on power BI
Hi Sir, Thanks for this wonderful video. Can you share the summary of this project? what should i write on my resume regarding this project to get more interview calls? please help me out in this. I will a great help for me sir.
Rishabh its very nice project, i learned so many thing from u, in future will learn too. Kindly make one vedio about Views,Indexes with project examples.
Glad you liked it 👍 Also, tomorrow morning i m uploading a very important video for data science jobs that is forecasting. You can watch that as well and can include the skill in your resume
Im mysql workbench I am able import all the table excep album.csv table It's showing unhandled exception: 'charmap' codec can't decode byte 0*81 in position 6012: character maps to check the log for details
Hi Rishabh. Firstly, thank you very much for this amazing project. A good way to start enhancing the SQL skills. Just one thing - I was practicing this project following your video, in the advanced level, question 1, do you think there is something missing/correction needed? like how much each customer spent on the top artist instead of how much each customer spent on the artists? Let me know if I am wrong.. Thanks again for this portfolio project. :)
The question is amount spent by each customer on artists, but the explanation seems to be the amount spent on top selling artist. Correct me If I am wrong. Thank u.
@@venkatashasidharreddychali7485 yes you are right i am trying the same both things are different . explaination is actually for the customers spent total amount on top selling artist where as question is for artists which means all artists . even i got confused
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: 'PGDMP'. ERROR AA RAHA HAI MYSQL MAIN
Thanks Rishabh for such an amazing content. Your explainations are amazing. I have a problem in importing this database to mysql workbench. I am getting encoding error. I tried another way by first creating the database then created tables. But, when I started importing csv data files in mysql workbench using import wizard, it shows 0 rows imported. I tried using copy command that you mentioned in sql tutorial video, still no luck. How to import datacsv files into mysql workbench ?
You can't import postgresql dump files directly in mysql workbench. Either you have to re write the files because both have different syntaxes or you can import these files in postgresql. No other way! I had the same problem.
I have a doubt in (ADVANCE ques -1) the question says " amount spent by each customer on ARTISTS " but in the video in CTE you take LIMIT 1 which gives you the top artist only. why????
@@sarwarayaanali272 So did you get any solution to this?Should the question be different. I believe this must be the desired query for this question: select c.customer_id,c.first_name,c.last_name,at.name, sum(il.unit_price*il.quantity) as total_amt_spent from customer c join invoice i on c.customer_id=i.customer_id join invoice_line il on il.invoice_id=i.invoice_id join track t on t.track_id=il.track_id join album a on a.album_id=t.album_id join artist at on at.artist_id=a.artist_id group by 1,2,3,4 order by total_amt_spent Do let me know your thoughts on this. Thankyou so much. Awaiting response as I'm also scratching my head for last one hour.
Question Set 1 - Easy Notes: Q1: Who is the senior most employee based on the job title? Select * FROM Employee ORDER by levels desc limit 1 Q2: Which countrries have most number of invoices? select count(*) as c, billing_country from invoice group by billing_country order by c desc Q3: What are top three values of total invoice? SELECT total FROM invoice order by total desc limit 3 Q4: Which city has the best customers? We would like to throw a promotional Music Festival in the city we made the most money. Write a query that returns one city that has the highest sum of invoice totals. Return both the city name and sum of all invoice totals. select SUM(total) as invoice_total, billing_city from invoice group by billing_city order by invoice_total desc Q5: Who's the best customer? --The customer who has spent the most money will be declared as best customer. --Write a query that returns the person who has spend the most money. select customer.customer_id, customer.first_name, customer.last_name, SUM(invoice.total) as total from customer JOIN invoice ON customer.customer_id = invoice.customer_id group by customer.customer_id order by total desc limit 1
First file ko download karo from link, next file ko unzip karo and uske baad ek ek karke file ko database mei upload/import karo. bus itna hi hai. You can also take the help of any mysql video on youtube
Thank you for the project and SQL . The database link is not working but I copied the data from csv to Postgresql and it works .It is matter of 8 tables to be copied so I think it is doable. Thanks for the insight
Hi sir, In advance level question , I think you need to rephrase question 1 as it creates confusion . i think the question should be rephrased to " Find the total amount spent by each customer on purchases related to the artist who has generated the highest revenue. Write a query to return the customer name, artist name, and total amount spent"
For anyone facing issue while importing the album.csv file, open the file in excel, and for each column run the =CLEAN() command, and then import the csv file.
Thank you so mush for the content you provide us, I have watched some of your videos on SQL and excel despite I didn’t speak or understand Hindi I use the caption. I wish if you make the video in English so that a lot of people can benefit from your content. I appreciate your effort thank you
You explained in good way ,i found in Advanced query section last 2 question u solved by using Recursion (2nd method) but actually its not recursion function u simply used 2 temp table .u not even using correct recursion syntax.see i might be wrong ,just observed and i thought i should inform here
hello rishab your way of teaching is very easy to understand and your usp mean Hindi language is really a good choice to distinct from crowd but i need one help just that i have mysql not Pg either please also provide database in mysql or teach us to install Pg
if others are having problem with restoring sql file in postgre then go to local disk C. THEN GO TO program files click on postgre files you will see bin folder. open it . and select all file and copy it then paste it into pgadmin 4 runtime file
please tell me how to import database in mysql workbench i watch ur all sql related videos .... great job from ur side .... please carry on ur this journey.....
sir plz make a video which sql want to use because there is different sql software types which identify one is difficult and to start. because i have started postgresql,ssms,my sql but port no issue is these plz make video its helpful for others also
question number 1 -> the senior employee is margaret park(employee id 4) born in 1947 not mohan madan who is born in1961 we cannot find based on their levels sir
Hi Rishabh, I really appreciate your content and the significant help you provide for learners like us. I have a question about advanced set question number 1. I believe the question asks for a list of all customers, artists, and the total amount spent by each customer on each artist. The query you provided only focuses on the best-selling artist, which is not what the question is asking for.
Bhaiya aap jab bhi questions kraye usse pehle ye bta dijiye chahiye kiya kiya explanation mein aur kaha se milega beginers ke liye kaafi dikkat hai mere advance ke question smjh nhi arhe hai aap help kr dijiye koi resources ho intermediate ko clear cut krlu taaki
Thanks, Manish sir, actually, I didn't have any idea about CTE but now I have it. especially thanks and can you please make more videos of sql projects only not for powerbi projects.
Thanks, Rishabh, for your valuable videos. Just one suggestion please, could you pls make your picture bit smaller in the corner. Sometimes, the query gets hidden behind it. Thanks!
Hi folks, csv files link (zip folder):
🔖Music Store zip csv files: shorturl.at/sEIUV
If you are using Postgresql,
Then directly import the database file .sql file. But if you're getting any error in album file then use the below query:
CREATE TABLE public.album2
(
album_id int8 PRIMARY KEY,
title character varying,
artist_id int8
);
- refresh database (now u can see album table there)
- Right click on the ablum table and select the Import/Export option
Then
select the album2.csv file (from your computer)
The file will be imported successfully 👍🏻
Similarly, you can do it for other files.
NOT USING POSTGRE SQL:
2. If using any other sql then,
Use csv files n create your own music database. And for album file, first copy n paste in a new csv file in your computer n then import it to sql. It will work ✌️
Also, if you want help, pls watch my video on - How to import csv files in sql
Keep learning and keep growing!🚀
Please pin this comment, I think it will be helpful. Great project, thank you. Best Wishes.
unhandeled exception charmap codec cant decode file 0*81 in position 4011 character maps to undefined . this error still showing in mysql
@@rizf800follow the above steps n link is updated now
after following the steps mentioned,and while creating the playlist_tracks, it says the error "can't create the table playlist_track, as multiple foreign keys are found"
PLEASE HELP ME IN IT
@@yashshrivastava7541 link is updated now - check pinned comment, follow the steps. just copy paste the query and it will be done
The best thing about the video is that information is to the point and only as needed.
Glad you liked it ✨️
@@RishabhMishraOfficial SIr please please write add to resume points in my reply ...your writing is so much professional please i wanna add this in resume
@@chakrabartisayantan4013 use chatgpt, prompt what u have done in your resume and ask gpt to write it like as u would write in resume/ short and crisp and highlighting everystep
Tareef Karu kya uski jisne aapke Jess teacher bnaya ❤❤best explanation sir❤❤
dost mera toh restore hi nhi ho ra help kr de na
same here@@kamalyadav3612
you saved lakh of rupess , srlsy student dont understand that there is lots of free education on internet, they just have to gain and make some awesome projects but they prefer to spend lakhs of rupees , Thank You Sir For Your Efforts.
Congratulations, sir, on reaching 100K subscribers! This is a significant milestone and a testament to your hard work, dedication, and the valuable content you have been providing to us.
Glad you liked ✅️ 👍
For those having issues importing the Database file.sql file,
In PostgreSql,
File -> preferences
scroll down a bit
paths -> binary paths
For both server paths make sure your binary path is set:
For instance
EDB Advanced Server 16
I have set it to C:\Program Files\PostgreSQL\16\bin
and then saved it
Hope that helps!
thank you so much for the help
Thank you brother👍
thank u so much brother
Hey, Thank you so much for your help :)
Thanks brother
Since I got interested in getting a Data Analyst job, I am binge-watching your videos and practicing. Your videos are very easygoing and rich in content. Requesting you to make an EDA project using python in the future. Thanks in advance.
Yes i uploaded it yesterday
@@RishabhMishraOfficial wow what a coincidence 😅...Thanks😊
Hi, Have you done it? what is your progress
Hiii, I am interested in switching my current field to a Data Analyst job, I find your videos to be engaging, effortlessly comprehensible, and packed with valuable insights. I am watching your videos and practicing. thank you.
Glad you liked ✅️ all the very best 👍
Sir how to add this in resume means what points I have to write please write jn details please it will hardly take your precious 5 minutes. I'm begging to you😢@@RishabhMishraOfficial
Guys please share his channel and all videos he deserves million subscribers , your are awesome i mean i saw your video about data analyst roadmap , after i saw that video i thought there is no use to go to institute you have planned the roadmap very perfectly and it look like easy and amazing, and the videos step by step , middile class people can't affort institutes fees but you provide it all free from scratch thats amazing and its free of cost hats off to you bro lots of love and good wishes and one request please make video about data science also like roadmap and all the things you provide in data analysis provide in data science course also it will help me and all students guys share this video please he deserves millions subscribers 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
Glad you liked the content Sarvesh ✅️
Thank you soo much for your kind words 💯🚀
@@RishabhMishraOfficial kind efforts required Kind words Data science roadmap please like this video only please with all resources please
Hi Rishabh, I am writing this comment at the end of the video, this was my first Data Analytics Project and all I want to say is you're doing God's work out here. In the beginning I struggled a bit but as the video went by things became easier and I got the hang of it. Through the course of the video I got to learn new concepts of SQL as well as brush up my past knowledge of SQL. The video is very well structured and each question is explained very well, crisp and precise. Again, thanks a lot, I really appreciate your efforts, keep it up.
Glad it was helpful ✅️
Keep learning n keep growing 🚀
i need help not able to add data
Hi brother.. Mera name krishna gopal hai
Mai bhut dino se ek sahi mentor dhoond rha tha.. Finally i got you.
Or maine thode din phle hi aapki.. Data analytics road map vali video dekhi. Or uska pdf download krke.. Excel se apna learning process start bhi kr diya hai.. Please hmesha hmaare sath bne rhna.. .. Thanks
May god bless you bde bhai..
Awesome 👌 Keep learning n keep growing 🚀
Finally, I done my first data analytics project because of you
Thank you sir 🙏
Glad it was helpful! Awesome!
are you able to write 3rd set queries ???
@@devg7929 sure
Learned a lot from your channel, I have completed this project with 3 days effort because I am a beginner. Please teach us more SQL-related real projects through your channel. Really Appreciate you, BOSS.
Glad you liked ✅️ more project videos will come soon
@@RishabhMishraOfficial thanks a million for the reply
Nice video sir but if possible then please try to explain each query by writing live so that we can see the approach of you while dealing with complex and nested query. It will be very helpful for us.
exactly by writing query live it will be more helpful for us beginners to analyze the approach of the question.
for those who are getting error in restoring the sql file. kindly do the following necessary changes in pgadmin 4 look for File>Preferences>Binary Paths> update the dir location to the C:\Program Files\postgreSQL\16\bin then save it then restore the SQL file.
Thank you
Thank you for sharing ✅️, also you can check pinned comment 👍
Thanks
@@RishabhMishraOfficial Can I load Zip file to SQL SSMS?
Can I load Zip file to SQL SSMS? Do i need to load CSV file one by one?
Sir i was able to import the data all thanks to your help, now I can do the project... Once again thanks to the best teacher out there
Awesome 👍 Keep learning n keep growing 🚀
plz tell how you imported..
@@payaltanty6440 hi..are you using MySQL..cause I used that so ..if u are then all you need to do is check for some sort of errors that are in the file..like contents were missing..once done with that ..u are good to go ..let me know again if you still faced the issue ..I will gladly help and once more thing as far i remember in first file only few rows were missing..so check that thoroughly
Best channel for learning sql and other concept of data analyst
Glad you liked it ✅️
Thank you, Rishabh Mishra bhai, for being an amazing instructor! I appreciate your guidance and support throughout the video. You're the true GOAT of data analyst!!!
Bhai can you add English subtitle?
Because some of your international viewers facing some difficulties like me.
Best Wishes for your family & you.
FROM
BANGLADESH.
Rishab bhai thanks a lot. i have completed my first project in data analysis using sql. you have great teaching skills. lots of love. many thanks :-)
First portfolio project video that I am understanding. Thankyou
Glad it was helpful! ✅️
Really good work Rishabh! I really appreciate the way you make things simple .It's really helpful for making projects and also understanding them instead of just copying.Thankyou so much!! Let your channel be reached to more people..!
Glad it was helpful ✅️
Thank you sir! for teaching in as easy way as possible, its been helpful for many of us.
Glad you liked ✅️
Best teacher for end to end project
Glad you liked it ✅️
Thank you so much for this awesome series.... Kindly make one series on python also......You are awesome work for people like us who wants to start from zero, a big thanks to you 🙏
Very soon 👍
@Prabhat Mishra how to upload this on github
@@Arjun-hc6pe Risabh bhaiya kindly upload and tell how to upload
Thank you so much you are a gem of a person, amazing project analysis for freshers like us. Really glad for this project.
Glad you liked it ✅️
I love you brother .... Bhai aap job chod teaching me aao ... Ek dum fabulous explanation and Quality Content point to point
Thanks a lot sir , your content is so unique and easy to understand. You don't know how much helpful it is for me.
Glad it was helpful ✅️
Namaste...sir🙏
it is very helpful project...nd thank you so much sir for sharing with us
Glad you liked it 💫
Thank you so much for the portfolio project. Your projects give me confidence that I can enter into data field without worrying about my non-cs background. I have a question here. How do we quantify or measure the insights that we derive out of this project. Any guidance will be very helpful. Thank you again!
You can msg on LinkedIn or lnstagram link in video description
Thanks a lot for yours videos, these are really helpful to me or new aspirant to learn the data analytics. I had referred more than 5 friends till now, and I am watching your every single video.
Glad it was helpful ✅️
simply Superb. This cleared all my doubts on sql
Glad it helped ✅️
looks great project ...bring more such content in future
Thank you, I will ✨️
Thank you bhaiya for this project 🙏
Have subscribed your channel please make the video on SQL+python
Thank you, I will 👍
Thank you for making these!! I'm following all of your videos :)
I'm doing this project now and the advanced level is so hard.... but I'll keep practicing 🫡
Awesome ✅️
great content, seriously you are helping millions of students who are struggling with these topics... Thankyouuu sir.
You are great and you have shared your experience it's very helpful for us and make some more such kind of video for SQL ,Python , as well as if possible plz make video on power BI
Sure i will ✅️
@@RishabhMishraOfficial experienced person resume me is project ko mention kar sakta hai kya?
Hi Sir, Thanks for this wonderful video. Can you share the summary of this project? what should i write on my resume regarding this project to get more interview calls? please help me out in this. I will a great help for me sir.
Thank you Rishabh Bhai! It was really very informative. It's because of your teaching, am able to grasp the concepts much better!
Glad you liked ✅️
Rishabh its very nice project, i learned so many thing from u, in future will learn too. Kindly make one vedio about Views,Indexes with project examples.
Great content and much needed for beginners projects in sql, keep making such good videos.😀
Glad you liked it 👍
Also, tomorrow morning i m uploading a very important video for data science jobs that is forecasting. You can watch that as well and can include the skill in your resume
Im mysql workbench I am able import all the table excep album.csv table
It's showing unhandled exception: 'charmap' codec can't decode byte 0*81 in position 6012: character maps to check the log for details
save that in csv (comma delimited) format it must be in csv UTF-8 (comma delimited)
@@jyothipuligilla7722 How to do that i'm unable to load album.csv in mysql
This channel deserves more subscribers ✨
bro mera toh restore hi nhi ho raha help me
Great way of making Zero to Hero.. keep going sir.. it's very helpful
Glad you liked it ✅️
Hi Rishabh. Firstly, thank you very much for this amazing project. A good way to start enhancing the SQL skills. Just one thing - I was practicing this project following your video, in the advanced level, question 1, do you think there is something missing/correction needed? like how much each customer spent on the top artist instead of how much each customer spent on the artists? Let me know if I am wrong.. Thanks again for this portfolio project. :)
Yes that's exactly what we did. Cte query is for finding the artist name i.e. queen
Exactly..
The question is amount spent by each customer on artists, but the explanation seems to be the amount spent on top selling artist. Correct me If I am wrong. Thank u.
@@venkatashasidharreddychali7485 yes you are right i am trying the same both things are different . explaination is actually for the customers spent total amount on top selling artist where as question is for artists which means all artists . even i got confused
would you please help me how to import database in mysql or mssql .i want to practice this but not able to upload it.Thanks in advance
ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: 'PGDMP'.
ERROR AA RAHA HAI MYSQL MAIN
Hi bro, pls check the pinned comment of this video have shared details on how to do it
@@RishabhMishraOfficial there is no pinned comment! Kindly resolve this issue
@@amansanduja3474 bro
just scroll up the comments with some open eyes -_-
Getting error like pg_restore: error: input file does not appear to be a valid archive Please help
you deserve lakhs of likes, i was searching for this video only , Thank you so much
🤩🤩🤩🤩🤩🤩🤩🤩
Glad you liked ✅️
Select * from invoice ❎ Select sab_kuch from invoice ✅
Thanks Rishabh for such an amazing content. Your explainations are amazing. I have a problem in importing this database to mysql workbench. I am getting encoding error. I tried another way by first creating the database then created tables. But, when I started importing csv data files in mysql workbench using import wizard, it shows 0 rows imported. I tried using copy command that you mentioned in sql tutorial video, still no luck. How to import datacsv files into mysql workbench ?
I am also facing this issue. I am unable to import the dataset using MySQL workbench. Please help me if you find any solutions
I am also facing similar error in MySQL🙁
You can't import postgresql dump files directly in mysql workbench. Either you have to re write the files because both have different syntaxes or you can import these files in postgresql. No other way! I had the same problem.
@@saranshmaheshwari6793 Thanks for the clarification! 🙌🙌
I have a doubt in (ADVANCE ques -1) the question says " amount spent by each customer on ARTISTS " but in the video in CTE you take LIMIT 1 which gives you the top artist only. why????
Same doubt, just because of this doubt I wasted 3 hours
yes, question should be changed
@@sarwarayaanali272 So did you get any solution to this?Should the question be different. I believe this must be the desired query for this question:
select c.customer_id,c.first_name,c.last_name,at.name,
sum(il.unit_price*il.quantity) as total_amt_spent
from customer c join invoice i on c.customer_id=i.customer_id
join invoice_line il on il.invoice_id=i.invoice_id
join track t on t.track_id=il.track_id
join album a on a.album_id=t.album_id
join artist at on at.artist_id=a.artist_id
group by 1,2,3,4
order by total_amt_spent
Do let me know your thoughts on this. Thankyou so much. Awaiting response as I'm also scratching my head for last one hour.
Question Set 1 - Easy Notes:
Q1: Who is the senior most employee based on the job title?
Select * FROM Employee
ORDER by levels desc
limit 1
Q2: Which countrries have most number of invoices?
select count(*) as c, billing_country
from invoice
group by billing_country
order by c desc
Q3: What are top three values of total invoice?
SELECT total FROM invoice
order by total desc
limit 3
Q4: Which city has the best customers?
We would like to throw a promotional Music Festival in the city we made the most money.
Write a query that returns one city that has the highest sum of invoice totals.
Return both the city name and sum of all invoice totals.
select SUM(total) as invoice_total, billing_city
from invoice
group by billing_city
order by invoice_total desc
Q5: Who's the best customer?
--The customer who has spent the most money will be declared as best customer.
--Write a query that returns the person who has spend the most money.
select customer.customer_id, customer.first_name, customer.last_name, SUM(invoice.total) as total
from customer
JOIN invoice ON customer.customer_id = invoice.customer_id
group by customer.customer_id
order by total desc
limit 1
could you please also share for question set 2? I am getting error for 1st question in set 2. Thanks
will do. give me sometime sis.@@riyamody6544
Please make more such full projects with increasing difficulty level.
It'll be really helpful.
Thanks.
Okayy noted ✅️
Bhaiya I'm Requesting You to Please Make a Another Video on How To import Csv File on Mysql
First file ko download karo from link, next file ko unzip karo and uske baad ek ek karke file ko database mei upload/import karo. bus itna hi hai. You can also take the help of any mysql video on youtube
BHAI ANKIT KUMAR PROBLEM SOLVE HUE TUMHARI
UTF-8 error aaraha hai
All the files in the data set can be uploaded except album file.
Plz help me with this
@@Truesignature2610file ko excel format me change kro fir wps us excel file ko csv file me save kro aur us file ko open kro :)
you teach very fast feels like you are teaching yourself
Isko sikhane nbi aata iske karan sql difficult lag rha hai
Thank you for the project and SQL . The database link is not working but I copied the data from csv to Postgresql and it works .It is matter of 8 tables to be copied so I think it is doable. Thanks for the insight
Awesome 👌 I'm glad you completed the project.. keep learning n keep growing 🚀
Hi Rishabh Thank you for being a Data analyst mentor ❤
Glad you liked the content ✅️
A serious and focused teacher and easy explainer
U r my fav one sir❤️🤜🤛
Please provide guidance on SQL queries for importing tables when creating a database.
Good to see these vedio of joining tables multiple things.good to know on practical things rishabh mishra
Glad it was helpful ✅️
bhai you are the best teacher to teach sql
help me dude. can't import csv files..
Very Helpful And Clearly Explained
Thank You Very Very Much Sir🙌❤
Hi sir, In advance level question , I think you need to rephrase question 1 as it creates confusion . i think the question should be rephrased to " Find the total amount spent by each customer on purchases related to the artist who has generated the highest revenue. Write a query to return the customer name, artist name, and total amount spent"
one of the best video and explanation for sql concept
thankyou bro i learned a lot 🥰
Happy to help ✅️
Thank you Rishabh Sir for making such a useful video , Thanks
Glad you liked it ✅️
Really I got such type of real project after 1 year I don't at 0 leval about sql
Glad you liked it ✨️
For anyone facing issue while importing the album.csv file,
open the file in excel, and for each column run the =CLEAN() command, and then import the csv file.
Thank you so mush for the content you provide us, I have watched some of your videos on SQL and excel despite I didn’t speak or understand Hindi I use the caption. I wish if you make the video in English so that a lot of people can benefit from your content. I appreciate your effort thank you
Glad it was helpful ✅️
Bhai bawal content!!
Me before watching the video : 🤡
Me after watching the video : 🗿
In SQL..
You explained in good way ,i found in Advanced query section last 2 question u solved by using Recursion (2nd method) but actually its not recursion function u simply used 2 temp table .u not even using correct recursion syntax.see i might be wrong ,just observed and i thought i should inform here
Thank you brother very informative.... N useful .
this wad good please give us all category beginners to advance projects
Okay noted ✅️
hello rishab your way of teaching is very easy to understand and your usp mean Hindi language is really a good choice to distinct from crowd but i need one help just that i have mysql not Pg either please also provide database in mysql or teach us to install Pg
Yes, there is already a video on this channel how to download n install postgre sql
aise hi videos practice set k sath daalte rahe..
okiaa :)
The best channel ever.
Nice and best explain with your hard working on video please make video on power bi
Glad you liked ✅️ Power bi videos are already uploaded on this channel
Thankyou so much for your efforts bhai.
if others are having problem with restoring sql file in postgre then
go to local disk C.
THEN GO TO program files
click on postgre files
you will see bin folder. open it . and select all file and copy it
then paste it into pgadmin 4 runtime file
Awesome 👌
thank you bhai multiple complication you can easy way to explin us ...best bro❤
Wonderful brother... Keep it up
we are request you to plz do this kind of video regularly
Okayy noted ✅️
Great teaching skill...so precise...hats off to you
Glad it was helpful ✅️
@@RishabhMishraOfficial Sir, can you please let me know which application you use to create these youtube videos?
please tell me how to import database in mysql workbench
i watch ur all sql related videos .... great job from ur side .... please carry on ur this journey.....
Glad you liked it ✅️ to import data pls check pinned comment
Thank you so much for helping learn SQL..
Glad it was helpful! ✅️
Thank you very much 🥇🤲🤲🤲👍😊💐
sir plz make a video which sql want to use because there is different sql software types which identify one is difficult and to start.
because i have started postgresql,ssms,my sql but port no issue is these plz make video its helpful for others also
Rishav bhai bahut achha laga upka content.
Artist name in excel file showing annoying, it's showing like LuÀ - s this one
Thank you Sir ji for this amazing video😍
Glad you liked ✅️
Not able to restore sql file in database, it is showing process failed every time
question number 1 -> the senior employee is margaret park(employee id 4) born in 1947 not mohan madan who is born in1961 we cannot find based on their levels sir
Hi Rishabh,
I really appreciate your content and the significant help you provide for learners like us.
I have a question about advanced set question number 1. I believe the question asks for a list of all customers, artists, and the total amount spent by each customer on each artist. The query you provided only focuses on the best-selling artist, which is not what the question is asking for.
you are simple and awesome sir
Glad you liked it ✅️
Hi rishabh please do one more project for beginners or intermediate if possible... Thanks😊
Noted ✅️
Bhaiya aap jab bhi questions kraye usse pehle ye bta dijiye chahiye kiya kiya explanation mein aur kaha se milega beginers ke liye kaafi dikkat hai mere advance ke question smjh nhi arhe hai aap help kr dijiye koi resources ho intermediate ko clear cut krlu taaki
The contents are awesome and kindly teach in English completely.
Thanks, Manish sir, actually, I didn't have any idea about CTE but now I have it.
especially thanks and can you please make more videos of sql projects only not for powerbi projects.
thank you soo much Sir💚
Glad you liked ✅️
Thx it was help ful plz do repeat this kind videos
Okay noted ✅️
Good afternoon sir... sir plz make a video on creating data warehouse using postGreys SQL.
Thanks, Rishabh, for your valuable videos. Just one suggestion please, could you pls make your picture bit smaller in the corner. Sometimes, the query gets hidden behind it. Thanks!