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.
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 😊
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
A very good presentation. Big Thanks !
Great work, It's really help us in our preparation in the data field
Thank you sir, this video really helped me understand SQL joins!
I hope you do different datasets for the upcoming tutorials.
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!"
Thank you Chandoo!
This was perfect! And explained very well, thank you so much
Shuppments data is not available in the dataset
Great video, thank you 🎉
Hi Chandu, the table names seems to be changed, please check once..
Nice teaching 🎉
Sir please make a video on SQL sub query, correlation subquery and window function
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 ?
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 please post same videos in Telugu language also because we addict ur videos please Sir😢
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.
was good but you rushed the last part after the variable "with". you should slow that part down and explain it more clearly
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
Please share the files related to the video so that we could practice more.
Make more videos on sql
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 😊
Is there any new course for Advanced Excel sir?
make vdos for analytics solver in excel plz plz plz
With statements is not working for me in MySQL? Do you know why?
what is solution of 5th HW problem?
Chandu anna super ga chepparu mee abhimani from West Godavari 😊
Awesome
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 .
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.
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).
thanks
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