You can find Alice's other videos on the Maven Analytics RUclips homepage such as these: - SQL guided project: ruclips.net/video/JaUKDbCXMX4/видео.htmlfeature=shared - SQL window functions: ruclips.net/video/rIcB4zMYMas/видео.htmlfeature=shared On the Maven Analytics platform, you can find Alice's courses on: - Data science in Python: mavenanalytics.io/online-data-analysis-courses?order=release_date%2Cdesc&instructors=Alice+Zhao - Advanced SQL (coming soon!): mavenanalytics.io/course/mysql-advanced-queries
We cover that in our MySQL Data Analysis course (mavenanalytics.io/course/mysql-data-analysis), but will also add it to our RUclips video requests list. Thanks for the suggestion!
Completely lost. I have MySQL downloaded from the link and have the files from the website. I can see the data in the MySQL workbench window but the lightning button is greyed out.
From the link, you'll have downloaded MySQL Workbench (dev.mysql.com/downloads/workbench/), which is a SQL editor. In addition, you'll need to download MySQL (dev.mysql.com/downloads/mysql/), which sits behind the SQL editor and actually executes the SQL code. During the installation process, you'll be asked to set a password. Note down the password. Next, you'll have to connect MySQL and MySQL Workbench. You can do this by opening MySQL Workbench, and if you double click on the box below MySQL Connections, you'll be prompted for a password, and you can enter in the password you set earlier. You'll now be able to open up a new query tab, and at this point, the lightening bolt should no longer be grayed out. You can now run the code from the project files and practice writing SQL queries on your own. As an alternative, if you don't want to go through all the installs, you can also practice writing SQL code in the browser with a website like sqliteonline.com/
Bro, I am gonna share this video to my friends who didn't study for the exam after 2 hours . Hats off to you
The best comprehensive introduction to SQL!
Glad you enjoyed it!
she is a great teacher, so clear in her explanations and examples
Thanks for this amazing instruction, lady :)
Wow, all the years of learning sql and I learnt more in these few minutes
This was such a good SQL intro! SQL beginner here.
Glad you enjoyed it. Welcome to the world of SQL!
This is so enjoyable. The JOIN in SQL seems so much better than what power query would do to join tables
Hi Alice,
What a great video! I love this bite-size video pack with a lot of nutrients.
I will definitely check the Restaurant Order project.
This is an amazing introduction to sql
You Rock
You made it look so easy
Thank you! With a bit of practice, it'll feel just as easy for you. 🙂
Bite-sized and digestible as usual. Thanks Alice!
Thank you for that clear explanation of the group by clause. :) New sub here!
Thank Alice 👍 You taught everything is easy to understand. Please publish more advanced courses about SQL in the future.
Glad to hear that! We have an Advanced SQL course (mavenanalytics.io/course/mysql-advanced-queries) coming out in the next few months. Stay tuned!
@@MavenAnalytics Yes, sure, I still wait to join
Thank you! Learnt so much in such a short amount of time!
Great work!
Thank you!
You're welcome!
Zhao, how do i get more of ur content? I really enjoy listening to you because i get to understand things quickly.
You can find Alice's other videos on the Maven Analytics RUclips homepage such as these:
- SQL guided project: ruclips.net/video/JaUKDbCXMX4/видео.htmlfeature=shared
- SQL window functions: ruclips.net/video/rIcB4zMYMas/видео.htmlfeature=shared
On the Maven Analytics platform, you can find Alice's courses on:
- Data science in Python: mavenanalytics.io/online-data-analysis-courses?order=release_date%2Cdesc&instructors=Alice+Zhao
- Advanced SQL (coming soon!): mavenanalytics.io/course/mysql-advanced-queries
@@MavenAnalytics Yes, thanks so much. I have seen the restaurant project and I am anticipating the advance sql video.
Have you in program to publish a video regarding the CASE WHEN?…
We cover that in our MySQL Data Analysis course (mavenanalytics.io/course/mysql-data-analysis), but will also add it to our RUclips video requests list. Thanks for the suggestion!
And also how do i get ur SQL pocket guide?
You can find the SQL Pocket Guide, 4th Edition on Amazon and other online book shops.
@@MavenAnalytics thank you so much
Completely lost. I have MySQL downloaded from the link and have the files from the website. I can see the data in the MySQL workbench window but the lightning button is greyed out.
From the link, you'll have downloaded MySQL Workbench (dev.mysql.com/downloads/workbench/), which is a SQL editor.
In addition, you'll need to download MySQL (dev.mysql.com/downloads/mysql/), which sits behind the SQL editor and actually executes the SQL code. During the installation process, you'll be asked to set a password. Note down the password.
Next, you'll have to connect MySQL and MySQL Workbench. You can do this by opening MySQL Workbench, and if you double click on the box below MySQL Connections, you'll be prompted for a password, and you can enter in the password you set earlier.
You'll now be able to open up a new query tab, and at this point, the lightening bolt should no longer be grayed out. You can now run the code from the project files and practice writing SQL queries on your own.
As an alternative, if you don't want to go through all the installs, you can also practice writing SQL code in the browser with a website like sqliteonline.com/
The best comprehensive introduction to SQL!