You can find Alice's other videos on the Maven Analytics TH-cam homepage such as these: - SQL guided project: th-cam.com/video/JaUKDbCXMX4/w-d-xo.htmlfeature=shared - SQL window functions: th-cam.com/video/rIcB4zMYMas/w-d-xo.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
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/
We cover that in our MySQL Data Analysis course (mavenanalytics.io/course/mysql-data-analysis), but will also add it to our TH-cam video requests list. Thanks for the suggestion!
she is a great teacher, so clear in her explanations and examples
The best comprehensive introduction to SQL!
Glad you enjoyed it!
This is so enjoyable. The JOIN in SQL seems so much better than what power query would do to join tables
Thank you for that clear explanation of the group by clause. :) New sub here!
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.
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!
Bite-sized and digestible as usual. Thanks Alice!
This was such a good SQL intro! SQL beginner here.
Glad you enjoyed it. Welcome to the world of SQL!
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. 🙂
Wow, all the years of learning sql and I learnt more in these few minutes
Great work!
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 TH-cam homepage such as these:
- SQL guided project: th-cam.com/video/JaUKDbCXMX4/w-d-xo.htmlfeature=shared
- SQL window functions: th-cam.com/video/rIcB4zMYMas/w-d-xo.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.
Thank you!
You're welcome!
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/
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 TH-cam 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
The best comprehensive introduction to SQL!