Lovely video as usual CHANDOO. I would love to see more and more of SQL. The 'awesome chocolates' need to be updated to be the same as the video, I needed to add data to understand the left joint as there is not in the data.
Hi Chandoo. Can i reuse the pivot charts and dashboard even when data source changes? And, is there a way to automatically update or change the data source of multiple pivot tables?
"Hello! 😊 I noticed that the dataset on the website currently has no relationships defined between tables, which makes it challenging to interpret connections within the data. Could we consider updating it by introducing some well-defined relationships (like primary keys, foreign keys, or link tables) where relevant? This would improve data integrity, make it easier to work with, and enhance the usability of the dataset. Thank you!"
Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.
Sir i want to add month in excel when ever number repeat for example if in serial number 1 month will march whenever number 1 repeat next month automatically display like april and so on. kindly guide regarding the same
You don't need relationships. Technically, SQL tables don't really have relationships. They have referential integrity constraints. But these don't apply for SELECT clause.
Bro How to create a template in power bi, I have one M query, i would like to make this as example to someone, so if possible do a video that how to create a template please 😊
I think in the website it is the OLD version of the dataset which was used for the previous long SQL tutorial. For this tutorial he is using a slightly modified version of the dataset (which has two new product categories).
❤❤❤❤❤❤❤❤❤
Loved it sir, your demonstrate is so easy simple to understand.
You are my favourite teacher!! In every field ,Excel ,SQL ,financial concepts, power bi, your videos are the best. your way of teaching is the best!!!
Left-join and anti-joins are very informative. Thank you !!
I have my data analytics job interview approaching and I am preparing from your videos, thanks man I appreciate your work.
You can do it!
@@chandoo_ thank you so much
What are you doing now. Did you pass?
Lovely video as usual CHANDOO. I would love to see more and more of SQL.
The 'awesome chocolates' need to be updated to be the same as the video, I needed to add data to understand the left joint as there is not in the data.
Another brilliant video Chandoo. You explain everything so perfectly. Thank you :)
Extremely useful stuff, especially the Pro part which was really well explained (the shipped vs not shipped example) 👌
Could you please make video on stored procedures and triggers as I love the way you teach and explain the stuff.
Super useful tutorial…
Thank you for providing such detailed explanation
Thank you sir, this video really helped me understand SQL joins!
Great work, It's really help us in our preparation in the data field
A very good presentation. Big Thanks !
I hope you do different datasets for the upcoming tutorials.
This was perfect! And explained very well, thank you so much
Hi Chandoo. Can i reuse the pivot charts and dashboard even when data source changes?
And, is there a way to automatically update or change the data source of multiple pivot tables?
Shuppments data is not available in the dataset
"Hello! 😊 I noticed that the dataset on the website currently has no relationships defined between tables, which makes it challenging to interpret connections within the data. Could we consider updating it by introducing some well-defined relationships (like primary keys, foreign keys, or link tables) where relevant? This would improve data integrity, make it easier to work with, and enhance the usability of the dataset. Thank you!"
Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.
Sir, this database is not running in pgadmin software. Can you provide us the, create table statement for all the tables used in this video ?
Sir please make a video on SQL sub query, correlation subquery and window function
Thank you Chandoo!
Great video, thank you 🎉
Sir please post same videos in Telugu language also because we addict ur videos please Sir😢
Nice teaching 🎉
Finished watching
Sir i want to add month in excel when ever number repeat for example if in serial number 1 month will march whenever number 1 repeat next month automatically display like april and so on. kindly guide regarding the same
Hi sir. Is relationship between two table required to apply joins or it can work with out relationship between table. Please answer🙏🙏
You don't need relationships. Technically, SQL tables don't really have relationships. They have referential integrity constraints. But these don't apply for SELECT clause.
Hi Chandu, the table names seems to be changed, please check once..
With statements is not working for me in MySQL? Do you know why?
Please share the files related to the video so that we could practice more.
Bro How to create a template in power bi, I have one M query, i would like to make this as example to someone, so if possible do a video that how to create a template please 😊
Chandu anna super ga chepparu mee abhimani from West Godavari 😊
Is there any new course for Advanced Excel sir?
I tried importing to SQL workbench. However, I cannot see the complete dataset as shown in the video. Is anything missing from my side?
What tables are you missing?
@@chandoo_ shipment table
@@chandoo_ shipment table is missing
Shipment table is missing
In the schema it is called "sales". Either update the table name or use Sales .
was good but you rushed the last part after the variable "with". you should slow that part down and explain it more clearly
Make more videos on sql
Awesome
Sir,I cant import the database ,show me 1 error
thanks
I want to download the files in csv form. Please upload the data link ro download csv files.
where is shipement dataset , i found only choclate dataset
I think in the website it is the OLD version of the dataset which was used for the previous long SQL tutorial. For this tutorial he is using a slightly modified version of the dataset (which has two new product categories).
make vdos for analytics solver in excel plz plz plz
what is solution of 5th HW problem?
Need SQL full course please sir
Anna Telugu lo Full course undha
Chandoo plz start Telugu channel
I have. See this please - www.youtube.com/@data_with_chandoo
@@chandoo_Anna continuous post videos in Telugu channel like English channel
1st viewer
@chandoo I tried to restore the db , it is corrupted, I tried from SQL Server
12:32