Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)

[@virtualvortex3146]

wow, what a teacher! what I couldn't understand for years I understood in a few minutes here! amazing!

[@mndhr79]

The best comprehensive introduction to SQL!

[@MavenAnalytics]

Glad you enjoyed it!

[@dc3295]

she is a great teacher, so clear in her explanations and examples

[@keagankemp6275]

Wow, all the years of learning sql and I learnt more in these few minutes

[@markyatx]

This is awesome!!! Thank you so much!!

[@hasnat6976]

Bro, I am gonna share this video to my friends who didn't study for the exam after 2 hours . Hats off to you

[@SportMgmtNow]

You are an absolutely excellent in your explanation & breakdown on SQL basics- thank you!

[@andrewdove342]

This is so enjoyable. The JOIN in SQL seems so much better than what power query would do to join tables

[@carlosserra1588]

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.

[@thewordofgod2012]

This was such a good SQL intro! SQL beginner here.

[@MavenAnalytics]

Glad you enjoyed it. Welcome to the world of SQL!

[@ChampCode]

Thank you for that clear explanation of the group by clause. :) New sub here!

[@jadehandy]

Bite-sized and digestible as usual. Thanks Alice!

[@karennguyen7083]

Thank Alice 👍 You taught everything is easy to understand. Please publish more advanced courses about SQL in the future.

[@MavenAnalytics]

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!

[@karennguyen7083]

@@MavenAnalytics Yes, sure, I still wait to join

[@carlosluischavarriarivera9271]

This is an amazing introduction to sql You Rock You made it look so easy

[@MavenAnalytics]

Thank you! With a bit of practice, it'll feel just as easy for you. 🙂

[@JustinLo878]

Thank you! Learnt so much in such a short amount of time!

[@osvaldo81]

Thanks for this amazing instruction, lady :)

[@khalilmai4128]

Very useful

[@MuriLanval]

Great work!

[@kevinshoemaker1466]

Thank you!

[@MavenAnalytics]

You're welcome!

[@davesmith7658]

Would be nice to see how to setup MySQL as its not straight forward when trying to follow along.

[@MavenAnalytics]

You're right, setting up MySQL is not an easy task. The focus of this video was on basic SQL syntax, but to setup MySQL, these are the steps you should take: 1. Download MySQL: dev.mysql.com/downloads/mysql/ Download the installer for your operating system, go through the setup steps and accept the default options. When asked to pick a root password, choose a password that you'll remember because you'll need it for a later step in the installation process. 2. Download MySQL Workbench: dev.mysql.com/downloads/workbench/ Download the installer for your operating system, go through the setup steps and accept the default options. 3. Connect MySQL Workbench and MySQL Open up MySQL Workbench and double click on the icon below the text "MySQL Connections". Enter in the root password you chose in step 1. You are now ready to use MySQL Workbench. 4. Download project files: maven-datasets.s3.amazonaws.com/KZbin+Downloads/maven-student-grades-db.zip Unzip the project files and open up the create_student_grades_db.sql script in MySQL Workbench. Go to Query >> Execute All to create the students table. You should now be able to follow along with the demo.

[@momohtimothy6898]

Zhao, how do i get more of ur content? I really enjoy listening to you because i get to understand things quickly.

[@MavenAnalytics]

You can find Alice's other videos on the Maven Analytics KZbin homepage such as these: - SQL guided project: kzbin.info/www/bejne/gJK4fHeYeL2AjpYfeature=shared - SQL window functions: kzbin.info/www/bejne/qHrGc2ewgr6Al9Ufeature=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

[@momohtimothy6898]

@@MavenAnalytics Yes, thanks so much. I have seen the restaurant project and I am anticipating the advance sql video.

[@SkylerandNevaeh]

Like the way she teach but how did she connect her students to SQL data base?

[@MavenAnalytics]

If you download the project files (maven-datasets.s3.amazonaws.com/KZbin+Downloads/maven-student-grades-db.zip), and open up the create_student_grades_db.sql script, you'll find CREATE and INSERT statements that you can run to create the students table.

[@davesmith7658]

To any one with server connection issues you need to download the full MySQL server not just the Work Bench. ✌

[@MavenAnalytics]

Thanks for the tip! You can find links to both MySQL Server and MySQL Workbench in the description, as well as detailed installation steps in the comment above.

[@Simone_Lu_]

Have you in program to publish a video regarding the CASE WHEN?…

[@MavenAnalytics]

We cover that in our MySQL Data Analysis course (mavenanalytics.io/course/mysql-data-analysis), but will also add it to our KZbin video requests list. Thanks for the suggestion!

[@momohtimothy6898]

And also how do i get ur SQL pocket guide?

[@MavenAnalytics]

You can find the SQL Pocket Guide, 4th Edition on Amazon and other online book shops.

[@momohtimothy6898]

@@MavenAnalytics thank you so much

[@andrewjohnson4352]

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.

[@MavenAnalytics]

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/

[@mansip453]

Please remove the music from background. It is distracting

[@mndhr79]

The best comprehensive introduction to SQL!