@@sravyath You can find my Data Science in Python courses at Maven Analytics or Udemy. I have an Advanced SQL course coming out next month on the same two platforms, so stay tuned!
Awesome tutorial, crystal clear a d concise. Well done. 1. CTE is elegant. I would go for CTE when the first query returns a table, and go for subquery when the result set of the first query goes into select or where clauses as sclares or list/tuple. 2. Can get access to the dataset used here. 3. I quickly took a glance. At your SQL trainning program and it seems you dive deep and cover quite a lot than most SQL trainning programs in the market. Please advise the rate. Thank u
Glad you enjoyed the video! 1. That's a great workflow 2. You can download the Restaurant Orders data set (and many more!) for free on our data playground: mavenanalytics.io/data-playground 3. Our SQL courses are available on the Maven Analytics platform for a monthly fee (mavenanalytics.io/signup/pricing) or on Udemy for a per course fee (www.udemy.com/user/maven-analytics/)
Thank you so much for explaining this, Alice! Would it be possible to get hold of the table you are using in this video? I guess having access to same would make it easy to follow along.
Of course! You can find the menu items table details on the Maven Analytics data playground: www.mavenanalytics.io/data-playground?order=date_added%2Cdesc&search=restaurant%20orders
Thank you Alice for your marvellous work!! I have a query, what is the database that you use in the point number 4, that has a table named stock_prices and the others one. if it would not be too much trouble, could you tell us where we can find it, thank you very much in advance
How do you manage to explain it so well. I watched another video too and the explanation was nonsensical, tho the author seemed to know what they are talking about. So.. how do you explain, is there a method to it? I am very interested to be able to explain so clearly to other people
My advice would be to break things down step by step and make things as practical as possible. Also, put yourself in the viewer's shoes - what would they know coming in, what questions would they have throughout, etc. - and do your best to address those things every step of the way. Good luck!
Yes, CTEs are an advanced topic! To understand them, we recommend first getting a solid grasp of the Big 6 and then getting some more exposure to subqueries. 1. Our Big 6 video: ua-cam.com/video/yg4ZhrjqYf8/v-deo.html 2. Our SQL guided project video (subquery example starts at 17:52): ua-cam.com/video/JaUKDbCXMX4/v-deo.html
Best SQL tutorial I have ever seen; Brilliant!
This is so clearly explained and concise. Thanx a bunch ma'am!
I was watching other videos before this one, and I just couldn't wrap my head around it, and this video was clear as crystal
This is maybe the best SQL guide on youtube, thank you, Alice!
You're welcome! 🙌
I quickly subscribed and liked, she killed the CTE lesson. Hats off!!
So much better explanation that my professor. Thank you!
Thank you for your well presented videos. I hope to see more videos from you regarding SQL server
This is an awesome video. the material she covers clearly in 30 minutes will take one hours to study on their own
Amazing explanation as always! The most complete and clear video about this topic. Thank you Alice!
You're welcome!
Hi, this video was really helpful, despite is not i'm My mother language, the logic that You provide is clearly than in spanish
Finally, I can now see and understand subqueries. Thank you.
Glad to hear that!
@@Alice-at-Maven mam how can I get a course from you?
@@sravyath You can find my Data Science in Python courses at Maven Analytics or Udemy. I have an Advanced SQL course coming out next month on the same two platforms, so stay tuned!
Awesome tutorial, crystal clear a d concise. Well done.
1. CTE is elegant. I would go for CTE when the first query returns a table, and go for subquery when the result set of the first query goes into select or where clauses as sclares or list/tuple.
2. Can get access to the dataset used here.
3. I quickly took a glance. At your SQL trainning program and it seems you dive deep and cover quite a lot than most SQL trainning programs in the market. Please advise the rate.
Thank u
Glad you enjoyed the video!
1. That's a great workflow
2. You can download the Restaurant Orders data set (and many more!) for free on our data playground: mavenanalytics.io/data-playground
3. Our SQL courses are available on the Maven Analytics platform for a monthly fee (mavenanalytics.io/signup/pricing) or on Udemy for a per course fee (www.udemy.com/user/maven-analytics/)
Wow! Thank you so much for the explanation, definitely helped me understand everything much better
At long last, I have met a good teacher 😂. Thank you so much ma'am 🎉
You're welcome 😃
as usual super fantastic.. what about a total series for beginners? u r definitely one of the best in explaining!
Here's our SQL for Beginners video: ua-cam.com/video/_vxobA36UN4/v-deo.html Enjoy!
It was so clear and easy to understand, thank you so much Alice! Hope to have your SQL course one day :)
Glad to hear that! My advanced SQL querying course comes out next month on the Maven Analytics platform. Stay tuned!
Thank you so much for explaining this, Alice! Would it be possible to get hold of the table you are using in this video? I guess having access to same would make it easy to follow along.
Of course! You can find the menu items table details on the Maven Analytics data playground: www.mavenanalytics.io/data-playground?order=date_added%2Cdesc&search=restaurant%20orders
Super Informative. Thank you
WOW!!!! that was amazing, I learned a lot. Thank so much. Got a new sub here.
Thank you! Glad you found it helpful 🙌
Thank you Alice for your marvellous work!!
I have a query, what is the database that you use in the point number 4, that has a table named stock_prices and the others one.
if it would not be too much trouble, could you tell us where we can find it, thank you very much in advance
Here you go!
CREATE TABLE stock_prices (
date DATE PRIMARY KEY,
price DECIMAL(10, 2)
);
INSERT INTO stock_prices (date, price) VALUES
('2024-06-01', 668.27),
('2024-06-03', 678.83),
('2024-06-04', 635.40),
('2024-06-06', 591.01);
@@MavenAnalyticscould you give the script of the table my_dates. Please :3
How do you manage to explain it so well. I watched another video too and the explanation was nonsensical, tho the author seemed to know what they are talking about. So.. how do you explain, is there a method to it? I am very interested to be able to explain so clearly to other people
My advice would be to break things down step by step and make things as practical as possible. Also, put yourself in the viewer's shoes - what would they know coming in, what questions would they have throughout, etc. - and do your best to address those things every step of the way. Good luck!
@@Alice-at-Maven Thanks a lot, Alice!
Hello, very clear explantion !! what software do you use ?
For the demo, I'm using MySQL Workbench. Glad you enjoyed the video!
If someone hates to see 10 hour courses vedios and getting tied ignore watch this kind of vedios
Amazing
Where can I find your SQL courses? Where you're teaching as a instructor.
You can find all our courses at: mavenanalytics.io/online-data-analysis-courses 🙌
❤
a CTE must be advanced because I'm confused.... I'll have to re-watch a bunch of times until I understand
Yes, CTEs are an advanced topic! To understand them, we recommend first getting a solid grasp of the Big 6 and then getting some more exposure to subqueries.
1. Our Big 6 video: ua-cam.com/video/yg4ZhrjqYf8/v-deo.html
2. Our SQL guided project video (subquery example starts at 17:52): ua-cam.com/video/JaUKDbCXMX4/v-deo.html
@@MavenAnalytics thanks for the links!