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?
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.
"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!"
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).
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.
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
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 😊
❤❤❤❤❤❤❤❤❤
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.
A very good presentation. Big Thanks !
Super useful tutorial…
Thank you for providing such detailed explanation
Shuppments data is not available in the dataset
This was perfect! And explained very well, thank you so much
Great work, It's really help us in our preparation in the data field
Great video, thank you 🎉
I hope you do different datasets for the upcoming tutorials.
Thank you sir, this video really helped me understand SQL joins!
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 ?
Thank you Chandoo!
Nice teaching 🎉
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?
Please share the files related to the video so that we could practice more.
Is there any new course for Advanced Excel sir?
was good but you rushed the last part after the variable "with". you should slow that part down and explain it more clearly
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.
Hi Chandu, the table names seems to be changed, please check once..
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 .
"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!"
With statements is not working for me in MySQL? Do you know why?
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).
Sir please make a video on SQL sub query, correlation subquery and window function
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.
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
Sir,I cant import the database ,show me 1 error
I want to download the files in csv form. Please upload the data link ro download csv files.
what is solution of 5th HW problem?
Anna Telugu lo Full course undha
Make more videos on sql
Finished watching
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 😊
Need SQL full course please sir
@chandoo I tried to restore the db , it is corrupted, I tried from SQL Server
Sir please post same videos in Telugu language also because we addict ur videos please Sir😢
make vdos for analytics solver in excel plz plz plz
Chandu anna super ga chepparu mee abhimani from West Godavari 😊
Awesome
thanks
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
12:32
Don't stop