Data Analyst Portfolio Project - Music Store Data Analysis Project using SQL

[@RishabhMishraOfficial]

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!🚀

[@experimenting_life]

Please pin this comment, I think it will be helpful. Great project, thank you. Best Wishes.

[@rizf800]

unhandeled exception charmap codec cant decode file 0*81 in position 4011 character maps to undefined . this error still showing in mysql

[@RishabhMishraOfficial]

​@@rizf800follow the above steps n link is updated now

[@yashshrivastava7541]

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]

​@@yashshrivastava7541 link is updated now - check pinned comment, follow the steps. just copy paste the query and it will be done

[@choudhrymujtaba]

The best thing about the video is that information is to the point and only as needed.

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@chakrabartisayantan4013]

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

[@amanisdreaming3914]

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

[@bhawnachawla6683]

Hey​@@chakrabartisayantan4013

[@bhawnachawla6683]

Hey

[@sarveshpawar4286]

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.

[@rithikahuja8203]

Tareef Karu kya uski jisne aapke Jess teacher bnaya ❤❤best explanation sir❤❤

[@kamalyadav3612]

dost mera toh restore hi nhi ho ra help kr de na

[@dhananjaymane627]

same here@@kamalyadav3612

[@gaurangdwivedi1234]

Wawa wa waa

[@sunnyblaze4912]

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!

[@aditibhardwaj9778]

thank you so much for the help

[@ColoursofIndianRailways]

Thank you brother👍

[@MayankGadiya-uq1el]

thank u so much brother

[@TravelTalesbyDisha]

Hey, Thank you so much for your help :)

[@yashpandey7271]

Thanks brother

[@Gpx1009]

Sir i am new to this field yet i had learn so much from your videos. You really know how to teach, which point to elaborate. Thank you so much sir.

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@anushrigupta5239]

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.

[@RishabhMishraOfficial]

Glad you liked ✅️ all the very best 👍

[@chakrabarti9634]

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

[@MD.ANISURRAHMAN-m9k]

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.

[@RishabhMishraOfficial]

Glad you liked ✅️ more project videos will come soon

[@MD.ANISURRAHMAN-m9k]

@@RishabhMishraOfficial thanks a million for the reply

[@shahrukhahmad4127]

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.

[@Shubham-le7yz]

exactly by writing query live it will be more helpful for us beginners to analyze the approach of the question.

[@muskanverma7152]

First portfolio project video that I am understanding. Thankyou

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@munitrajput]

Finally, I done my first data analytics project because of you Thank you sir 🙏

[@RishabhMishraOfficial]

Glad it was helpful! Awesome!

[@devg7929]

are you able to write 3rd set queries ???

[@munitrajput]

@@devg7929 sure

[@krishnagopal7890]

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

[@RishabhMishraOfficial]

Awesome 👌 Keep learning n keep growing 🚀

[@nee934]

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.

[@RishabhMishraOfficial]

Glad you liked ✅️ 👍

[@akshattiwari5495]

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.

[@RishabhMishraOfficial]

Glad it was helpful ✅️ Keep learning n keep growing 🚀

[@gurleensingh4138]

i need help not able to add data

[@anuragverma6061]

Best channel for learning sql and other concept of data analyst

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@hasanaziz8662]

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.

[@RishabhMishraOfficial]

Yes i uploaded it yesterday

[@hasanaziz8662]

​@@RishabhMishraOfficial wow what a coincidence 😅...Thanks😊

[@dipendrasinghshekhawat6415]

Hi, Have you done it? what is your progress

[@TaniyaLoomba]

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

[@RishabhMishraOfficial]

Awesome 👍 Keep learning n keep growing 🚀

[@payaltanty6440]

plz tell how you imported..

[@TaniyaLoomba]

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

[@nafigaming9947]

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.

[@saketsrivastava84]

Best teacher for end to end project

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@easemyjourney9599]

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.

[@Abhisheksharma0011]

Thank you

[@RishabhMishraOfficial]

Thank you for sharing ✅️, also you can check pinned comment 👍

[@prasanthdalai7854]

Thanks

[@LittleOnesCare]

@@RishabhMishraOfficial Can I load Zip file to SQL SSMS?

[@LittleOnesCare]

Can I load Zip file to SQL SSMS? Do i need to load CSV file one by one?

[@ayushpatil4001]

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 :-)

[@sarveshpawar4286]

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

[@RishabhMishraOfficial]

Glad you liked the content Sarvesh ✅️ Thank you soo much for your kind words 💯🚀

[@sarveshpawar4286]

@@RishabhMishraOfficial kind efforts required Kind words Data science roadmap please like this video only please with all resources please

[@nikhilreddy4582]

simply Superb. This cleared all my doubts on sql

[@RishabhMishraOfficial]

Glad it helped ✅️

[@rinzi111]

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!

[@RishabhMishraOfficial]

You can msg on LinkedIn or lnstagram link in video description

[@dhrubajyotichatterjee129]

Rishav bhai bahut achha laga upka content.

[@rishav144]

looks great project ...bring more such content in future

[@RishabhMishraOfficial]

Thank you, I will ✨️

[@Vinay_Kumar_Sahani]

I love you brother .... Bhai aap job chod teaching me aao ... Ek dum fabulous explanation and Quality Content point to point

[@desmond7182]

Thank you so much you are a gem of a person, amazing project analysis for freshers like us. Really glad for this project.

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@moonanaeem8445]

I have done this project easy or moderate level boht achay smajh ay Advance level ka first question Thora tricky thay or i recommend k recursive say zada cte acha smajh aya finally i have done😊

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@Shiivanie]

Can you tell me how do I share the project on LinkedIn??

[@lakshmi_edits4168]

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

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@rohityetre1867]

This channel deserves more subscribers ✨

[@kamalyadav3612]

bro mera toh restore hi nhi ho raha help me

[@dipakrawat9536]

Select * from invoice ❎ Select sab_kuch from invoice ✅

[@maitrygoel7442]

great content, seriously you are helping millions of students who are struggling with these topics... Thankyouuu sir.

[@prabhatmishra4393]

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 🙏

[@RishabhMishraOfficial]

Very soon 👍

[@Arjun-hc6pe]

@Prabhat Mishra how to upload this on github

[@prabhatmishra4393]

@@Arjun-hc6pe Risabh bhaiya kindly upload and tell how to upload

[@njanikrishna]

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.

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@anuragpatel9824]

Namaste...sir🙏 it is very helpful project...nd thank you so much sir for sharing with us

[@RishabhMishraOfficial]

Glad you liked it 💫

[@akashnayak9109]

Great way of making Zero to Hero.. keep going sir.. it's very helpful

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@neemkarolimaharajji-j6t]

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.

[@Yathin_mystyle]

Thank you sir! for teaching in as easy way as possible, its been helpful for many of us.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@technicalsohan2098]

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

[@jyothipuligilla7722]

save that in csv (comma delimited) format it must be in csv UTF-8 (comma delimited)

[@subhrajitswain4065]

@@jyothipuligilla7722 How to do that i'm unable to load album.csv in mysql

[@abhis3268]

Hi Rishabh Thank you for being a Data analyst mentor ❤

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@randomguy5183]

Thank you bhaiya for this project 🙏 Have subscribed your channel please make the video on SQL+python

[@RishabhMishraOfficial]

Thank you, I will 👍

[@Mranimater_0]

bhai you are the best teacher to teach sql

[@ahmadfarooqbutt3758]

help me dude. can't import csv files..

[@devanshpandey9358]

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

[@RishabhMishraOfficial]

Sure i will ✅️

[@NSCFutureSuccess1111]

@@RishabhMishraOfficial experienced person resume me is project ko mention kar sakta hai kya?

[@keshavagarwal5639]

Thanks a lot sir , your content is so unique and easy to understand. You don't know how much helpful it is for me.

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@Ak12345-g]

Good to see these vedio of joining tables multiple things.good to know on practical things rishabh mishra

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@yashmaniar7669]

Great content and much needed for beginners projects in sql, keep making such good videos.😀

[@RishabhMishraOfficial]

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

[@rohityetre1867]

Very Helpful And Clearly Explained Thank You Very Very Much Sir🙌❤

[@satviksatvik3033]

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

[@RishabhMishraOfficial]

Yes that's exactly what we did. Cte query is for finding the artist name i.e. queen

[@trishala731]

Exactly..

[@venkatashasidharreddychali7485]

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.

[@manishwalia5508]

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

[@Howto-cz7yf]

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

[@prashastjaipurkar2952]

Nice selection of database. Perfect for beginners to let go of their fear of multiple joins. Now only if someone could explain how is the group by clause not throwing error for when we don't include all other columns in it (except functions). I have used hive servers mainly and it does not allow having aggregate functions and other columns in select clause unless all other columns of select clause are also in group by clause.

[@neelabh87]

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 ?

[@aniketjaswal10]

I am also facing this issue. I am unable to import the dataset using MySQL workbench. Please help me if you find any solutions

[@sahilkadu9679]

I am also facing similar error in MySQL🙁

[@saranshmaheshwari6793]

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.

[@sahilkadu9679]

@@saranshmaheshwari6793 Thanks for the clarification! 🙌🙌

[@sarveshpawar4286]

you deserve lakhs of likes, i was searching for this video only , Thank you so much 🤩🤩🤩🤩🤩🤩🤩🤩

[@RishabhMishraOfficial]

Glad you liked ✅️

[@abhaytevatia6974]

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]

Same doubt, just because of this doubt I wasted 3 hours

[@deepakbehara198]

yes, question should be changed

[@ruhiscorner7318]

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

[@MahammedKareemulla]

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.

[@priyakalashi7420]

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

[@RishabhMishraOfficial]

Awesome 👌 I'm glad you completed the project.. keep learning n keep growing 🚀

[@sid_analytics]

Thank you Rishabh Bhai! It was really very informative. It's because of your teaching, am able to grasp the concepts much better!

[@RishabhMishraOfficial]

Glad you liked ✅️

[@payaldas8665]

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 🫡

[@RishabhMishraOfficial]

Awesome ✅️

[@shravanshukla5352]

Really I got such type of real project after 1 year I don't at 0 leval about sql

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@JavedAnsari-vba]

Thank you Rishabh Sir for making such a useful video , Thanks

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@aratipadwal7338]

Please provide guidance on SQL queries for importing tables when creating a database.

[@Amazing_things_videos]

U r my fav one sir❤️🤜🤛

[@UKJ28]

Great teaching skill...so precise...hats off to you

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@UKJ28]

@@RishabhMishraOfficial Sir, can you please let me know which application you use to create these youtube videos?

[@adarshpatil1016]

Thank you brother very informative.... N useful .

[@deosonalia]

Thank you so much for helping learn SQL..

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@ShreyaSonali-un3wz]

Hi Rishabh sir..., I’m really interested in learning more about topic like KZbin Analytics and SQL projects. Could you please make a video on topics like analyzing video performance, viewer demographics, and engagement metrics using SQL? It would be really helpful for my project! Thank you for your great content!..

[@milandorjee5140]

The best channel ever.

[@denzilgamingyt1786]

this wad good please give us all category beginners to advance projects

[@RishabhMishraOfficial]

Okay noted ✅️

[@Manoj-nn8gd]

we are request you to plz do this kind of video regularly

[@RishabhMishraOfficial]

Okayy noted ✅️

[@arsunny100]

Wonderful brother... Keep it up

[@sandeepkhawas3367]

Thanks a million Sir ......Must say you are helping to many Indians through your content! requesting please light on my below queries ! 1- I m working on MS SQL Server so just wanna to know is it good to extend my skills on it or should I move to MY SQL! 2- in real time how to refresh data from SQL data base to Power bi reports! 3- DO you have video on SQL data cleaning if yes then pls let me know the path!

[@abhilashjoseofficial]

Question 9 is actually confusing. It can be rephrased to like this : "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"

[@RishabhMishraOfficial]

Thanks for sharing

[@sahil5656]

Yes it is so confusing that i wasted 1 day in getting the question

[@jeffrinvite1107]

The contents are awesome and kindly teach in English completely.

[@njamrutharikka4105]

Big thanks to you sir for your guidance and support throughout this project! 🙌 Your insights made a huge difference. Grateful for the learning experience! 🙏

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@neerajkushwah9999]

Good afternoon sir... sir plz make a video on creating data warehouse using postGreys SQL.

[@manojkokane3365]

many thanks sir, god bless u

[@shaikusman536]

Awsome content brother.....keep up....respect from Bangalore.

[@chetanpujar9370]

12:30:33 select customer.customer_id, first_name,last_name,sum(invoice.total) as invoice_total from musical_database.customer join musical_database.invoice on customer.customer_id = invoice.customer_id group by customer.customer_id order by invoice_total desc limit 1.... Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column... plz look into this sir

[@shivanigangwar1192]

you are simple and awesome sir

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@prashantverma044]

you teach very fast feels like you are teaching yourself

[@tejas4054]

Isko sikhane nbi aata iske karan sql difficult lag rha hai

[@DATA_TALKS1430]

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

[@RishabhMishraOfficial]

Yes, there is already a video on this channel how to download n install postgre sql

[@RishabhSharma-q6s]

one of the best video and explanation for sql concept thankyou bro i learned a lot 🥰

[@RishabhMishraOfficial]

Happy to help ✅️

[@himanshurawat2398]

Thank You So Much for this easy Explanation ❤

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@Saurabh_desai]

thank you bhai multiple complication you can easy way to explin us ...best bro❤

[@shreyanshdangi4366]

this advance questions are not tough but just need the mindset that how to approach the question... Maine abhi tak basic sql padhi thi subquery tak but windows function se sir se padh and it helps me lot in understanding the ADVANCED Problems....now i think i will need more practice to broaden my skill Can anyone tell me the sources where i can practice advanced sql question?

[@ritwiksingh4937]

Bhai bawal content!! Me before watching the video : 🤡 Me after watching the video : 🗿 In SQL..

[@vishalsahu1104]

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

[@pradeepbkale]

Hi Rishabh ji I admire you for your simplicity. I practice mySQL and your videos as PostgresSQL which makes it relatively difficult to grasp. I wanted to know how to import excel big sheets into SQL, because that excel has all data in one sheet and not multiple tables. I'm thinking of taking that as project and go ahead.

[@RishabhMishraOfficial]

Glad you liked ✅️ n check pinned comment

[@niveditajha5717]

Tbh Rishabh bhaiya you are gem for our generation i enjoyed your video's it is help me a lot. Your video increase my confidence. Thankyou so much bhaiya for making such a amazing videos

[@RishabhMishraOfficial]

Glad it's helpful ✅️ keep learning n keep growing 🚀

[@yashgarg4937]

mishra jiii ek no concept 👍👍

[@fit-216rominaraju3]

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

[@KaRmA-ou7nb]

Thank you Sir ji for this amazing video😍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Manoj-nn8gd]

Thx it was help ful plz do repeat this kind videos

[@RishabhMishraOfficial]

Okay noted ✅️

[@shariqali3396]

Very helpful Sir..ese hi Data Analytics k project krw dijiye

[@pavanigoud98]

Thank you Rishabh. This video is very helpful 🥰

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@thewolf7405]

Bro is type pe projects aur lekr aao SQL ke liye. Same jaha SQL tool ki learning bhi ho and questions bhi solve kr rhe ho basic to advance level.

[@RishabhMishraOfficial]

Okyy noted ✅️

[@MUNANasher]

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

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@akedia759]

hello @Rishabh Mishra in moderate question 1 question is email staring with A then we will also have to use where email regexp '^A'

[@RishabhMishraOfficial]

Yes u can use that, it's similar to LIKE operator

[@akedia759]

@@RishabhMishraOfficial But in solution you have not given any where condition for checking email starting with A.If posible plz check moderate question 1 and its soln onces

[@suvadipnandi459]

Hi @RishabhMishraOfficial please tell us how to generate schema diagram in postgres?

[@keyurmhasawade5704]

Hey! can you make a video on Data modelling and also a video showing how you created that schema diagram ( logic and tools used ) ?

[@codewithashw]

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.