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

[@chriss2295]

15 minutes well spent. I wanted to make sure that SQL was something I could get my mind around and this video confirmed that. Excellent! Thank you.

[@audreycreasy5008]

Hands down the best use of time and simplest explanation I've seen yet. So clean! Thanks!

[@mndhr79]

The best comprehensive introduction to SQL!

[@MavenAnalytics]

Glad you enjoyed it!

[@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

[@dc3295]

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

[@virtualvortex3146]

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

[@Alice-at-Maven]

Glad to hear that!

[@keagankemp6275]

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

[@thewordofgod2012]

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

[@MavenAnalytics]

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

[@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.

[@andrewdove342]

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

[@ChampCode]

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

[@SportMgmtNow]

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

[@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. 🙂

[@iurgnail]

excellent video, no time wasted

[@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 coming out in the next few months. Stay tuned!

[@karennguyen7083]

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

[@MavenAnalytics]

@@karennguyen7083 Our Advanced SQL Querying course is now live! mavenanalytics.io/course/sql-advanced-queries

[@mohamedaathif6475]

one of the best explanation video .

[@JustinLo878]

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

[@osvaldo81]

Thanks for this amazing instruction, lady :)

[@markyatx]

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

[@2finz]

Excellent lecture.

[@MuriLanval]

Great work!

[@jananipriya7561]

Easy understanding wow wow 😅

[@khalilmai4128]

Very useful

[@kevinshoemaker1466]

Thank you!

[@MavenAnalytics]

You're welcome!

[@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: mavenanalytics.io/course/sql-advanced-queries

[@momohtimothy6898]

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

[@mrxinnovations809]

100 times better than my college professors

[@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.

[@JohnYoga]

@@MavenAnalytics Unfortunately it appears you may haves steps in the above that were missed? 1. Connection Warning - Incompatable/nonstandard server version or connection protocol detected (9.1.0). Even though this is an error message, it gives me a choice to Continue Anyway. So I do this... Then, where do place each one of your queries? If you go to the top and stick in these lines, you get an error message in the Action Output below. LOL. Nevermind - seems nice, but useless to follow along. I think you mean to say, have it all figured out how to set this up and where to go, but in this video, I won't show this, yet here are examples of what SQL can do for beginners.

[@MavenAnalytics]

@@JohnYoga The connection warning is a known MySQL issue with their latest release. For those wanting to just quickly get started with SQL, this warning can be ignored. Once you download the project files, you can double click on the create_student_grades_db.sql file to open it up in MySQL Workbench, click the yellow lightening bolt to run the code, and you should be good to go to write all the queries in this video. If you don't want to deal with any installation issues, you can also use SQLite Online to write SQL queries within a web browser instead.

[@SkylerandNevaeh]

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

[@MavenAnalytics]

Once you download the project files (link in the description), you can open up the create_student_grades_db.sql script and run the CREATE and INSERT statements in your SQL editor, and that should generate 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.

[@mansip453]

Please remove the music from background. It is distracting

[@savvasafantitis4123]

How to link the SQLworkbench to a file/database?

[@MavenAnalytics]

Once you've downloaded and opened MySQL Workbench, you can take the following steps: 1. Click the + sign next to MySQL Connections to create a new connection. When prompted for a password, enter the password you set during the MySQL installation process. 2. Open up the create_student_grades_db.sql script within MySQL Workbench. Click the yellow lightening bolt button at the top of the screen to execute all the code in the script. 3. You should now be able to see the students data when you do a SELECT * FROM students;

[@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]

If the lightening button is greyed out, that means you need to download and connect MySQL to MySQL Workbench. Here are the detailed steps to do so: 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.

[@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!

[@inhobiswinecellar9571]

❤❤❤

[@mndhr79]

The best comprehensive introduction to SQL!