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!

[@DavidCountryman-zz4er]

Hi , I'm relatively new to data analytics and wanted to tell you that your tutorial was one of the most informative and easy to understand videos i have seen yet................................ THANK YOU FOR YOUR CONTRABUTION...

[@AntonioGeorgeGambino]

This is one of the most useful 15 minutes I've spent learning

[@mndhr79]

The best comprehensive introduction to SQL!

[@MavenAnalytics]

Glad you enjoyed it!

[@ginasantiago1136]

This is the best SQL tutorial I've found yet that allows the listener to understand the why behind the commands and the concept and benefits of SQL. Thank you so much!

[@BlackRussian0795]

I don't typically comment on YT videos, but i have commented and subscribed to your channel. My boss wants all the team members to learn SQL in a few months, I have been stressing since then but after watching this video. I can confidently say " I am ready for SQL" Thank you so much!!!

[@Alice-at-Maven]

So glad to hear that -- you got this!

[@andrewdove342]

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

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

[@dc3295]

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

[@nrashedfate]

This SQL tutorial by Maven Analytics is simply outstanding! It explains complex concepts in such a clear and practical way-highly recommended!

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

[@21brill]

you are so easy to listen to and learn from, thanks, looking to learn more from you

[@Alice-at-Maven]

Thank you for the kind words!

[@EinKesselBuntes]

"vocal fry" or "creaky voice" - very irritating. I stopped watching the video after two minutes. It might have been a great content but I just couldn't handle it.

[@thewordofgod2012]

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

[@MavenAnalytics]

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

[@keagankemp6275]

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

[@andreschavez3342]

i just discovered your channel, and i love it. I am pretty new to data analytics, and even newer to SQL. i work as a labourer in construction, and i do really want to change my carreer into data anayltics and cyber security, and i am finding myself very happy and motivated, not only with the resources that i have found, but also with the content from your channel. I really have to choose mostly "free" content because i have been unemployed for like 2 months, as the labourer industry in cosntructino is extremely unstable and honestly really hard.

[@hanshaofei2248]

I am in a similar boat. Im on codecademy and completed 20% so far, which consisted of SQL. Then they went to python which I hate. SQL was fun and I enjoyed working with data. Hopefully this channel helps the motivation

[@Alice-at-Maven]

Glad your enjoying our channel and best of luck on your data analytics journey!

[@Alice-at-Maven]

@@hanshaofei2248 We have a lot more SQL content lined up for this year, so stay tuned!

[@PriscillaNorton]

So much clearer than my instructor has shown. You have a great talent for simplifying the concepts.

[@kalonjitshisekedi6037]

Your teaching skills are like superpowers!!!! this is truly a gift not given to many. Thank you for making this available hope to learn more from you

[@Alice-at-Maven]

Thank you for the kind words!

[@LawrenceManyozo]

You are amazing. Listened and learned

[@Alice-at-Maven]

Glad you enjoyed the video!

[@iurgnail]

excellent video, no time wasted

[@gremilymemily3399]

You are an excellent teacher. You make these concepts so easy to learn and you talk at the perfect speed. Thank you

[@Alice-at-Maven]

Thank you! Glad you enjoyed the video.

[@Tressbytesssisterlocks]

Being a beginner in an online bootcamp, your very detail friendly introduction made me feel like a novice. THANK YOU...I feel bad for cheating on my teacher (well it's a year old FREE bootcamp) you help catapult a few things that will keep me from getting bored.

[@Alice-at-Maven]

You're welcome! It's often nice to get multiple perspectives when learning to keep things interesting.

[@wgalloPT]

I like the way you teach. And this is an excellent beginner tutorial, big thanks !

[@Alice-at-Maven]

Glad you enjoyed the video!

[@xThe3xecution]

Thank you soo much for creating this Videos. They are so straight forward and still constructed in a way, so that the topics can be easily understand and that in way less time than any else tutorials I could find. For getting to know the exact same functions I worked through 1 1/2 hrs (or even slighty more) on a different course I was watching. You are a life and time saver!

[@Alice-at-Maven]

That's our goal -- clear and succinct! Glad you enjoyed the video.

[@EmmanuelAkujobi]

Best simplified video I have ever watched.... Thank you.

[@Alice-at-Maven]

Thank you for the kind words!

[@RepentBritain]

Best video to reinforce my SQL knowledge. Thanks a lot.

[@Alice-at-Maven]

You're welcome!

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

[@kevinvalenzuela1723]

This video took me 1hr. I don't know why it says 16:47. Can't wait to implement this. Thank you!

[@denisejo10462]

Your video was extremely helpful. 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. 🙂

[@khomotsomokoka1830]

Good refresher. Thank you for the vid.

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

[@ChampCode]

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

[@scottsilvey2390]

Thank you so much for this great intro video!

[@SportMgmtNow]

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

[@missngubane2150]

You are an amazing teacher!!!

[@Elmomonster21]

Thank you for this amazing video young padawan! The force strong is inside you! More videos record you must!

[@Alice-at-Maven]

😆Will do!

[@jadehandy]

Bite-sized and digestible as usual. Thanks Alice!

[@JustinLo878]

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

[@nitinmore7686]

Hi, you covered a lot information in short time, how best teaching skill you thought and expressed! Great!!!❤

[@onyinyechietunwoke4496]

Best 15mins!

[@markyatx]

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

[@pascaljoly5752]

thanks for the video; i started learning power query last year, which is a fantastic tool and i started learning power bi last month. please can you explain what SQL does that i can't do with either of these tools? or do you use them in combination? for instance, the filtering can be done using power bi as an example.

[@Alice-at-Maven]

While Power Query, Power BI and SQL all allow for filtering, they have different focuses. SQL is mainly used to manage large databases and prepare data for analysis, while Power Query / Power BI are used for smaller data sets and simpler data prep. Power BI also focuses on visualizing data with dashboards. As you work on more complex projects, you can absolutely use a combination of the tools, starting with SQL for data prep and moving on to the others for more fine tuned data analysis and visualization.

[@2finz]

Excellent lecture.

[@blessedt5]

Thank you for breaking that down

[@Alice-at-Maven]

You're welcome!

[@mohamedaathif6475]

one of the best explanation video .

[@MuriLanval]

Great work!

[@arcanefinix7674]

THIS IS WHAT I NEED THANKYOUUU SMM!!! 💖

[@osvaldo81]

Thanks for this amazing instruction, lady :)

[@ugonunes1544]

Amazing!!

[@mark_themotivationgibbs9267]

This was really good

[@chiomaikenwe7806]

Very clear

[@kevinshoemaker1466]

Thank you!

[@MavenAnalytics]

You're welcome!

[@shaikhabeebulla9710]

Superb ma'am

[@obsecuredme]

Really, a big help from your side . I got really a lucky sister as I wanna say this ❤❤❤❤love you mam 😢❤

[@khalilmai4128]

Very useful

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

[@Unseen_.22]

the best video

[@SAKE42able]

I have questions about using where grouo by Why do I use them?? Or when Do I need to add them to my code??

[@Alice-at-Maven]

You use a WHERE when you want to filter your data, so for example, show me all customers that are older than 30 would be SELECT * FROM customers WHERE age > 30; You use a GROUP BY when you want to make a calculation for different groups of your data, so for example, for each customer, show me the total amount they spent would be SELECT customer, SUM(spend) FROM customers GROUP BY customer;

[@R-Type-II]

Complete newbe here just installed workbench and sql server. How do you load the .csv files into workbench once opened with create_student_grades_db.sql ?

[@MavenAnalytics]

You have to first connect MySQL Workbench and MySQL Community Server, and then execute the .sql file. Here are the detailed setup steps -- you'll have to do steps 3 and 4. 1. Download 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 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 Unzip the project files and open up the create_student_grades_db.sql script in MySQL Workbench. Go to the Query drop down, and click Execute All to create the students table. You should now be able to follow along with the demo.

[@jananipriya7561]

Easy understanding wow wow 😅

[@alexa.percic]

I'm saved!

[@MsCJones2011]

Hi. I wanted to follow along. But, for some reason, it doesn't let me create the student table in MySQL. It's all greyed out. Do you know why that might be?

[@MavenAnalytics]

You likely have to connect MySQL Workbench and MySQL. Here are the detailed setup steps -- step 3 should fix the greying out problem. 1. Download 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 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 Unzip the project files and open up the create_student_grades_db.sql script in MySQL Workbench. Go to the Query drop down, and click Execute All to create the students table. You should now be able to follow along with the demo.

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

[@crystalcarpenter8310]

Can you help hunt for tables when your not sure what you're working with

[@Alice-at-Maven]

Yep! I like to look at data models to see how the various tables connect to one another, and then view the top 100 rows of each table to get a feel for the data they contain.

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

[@obstfrukty1063]

Hi Alice, I'm reading the German translation of your book on SQL (in German "SQL kurz & gut", O'REILLY, maybe in English "SQL, Pocket Guide"), and have found the first step of the four steps in "A simple data analysis workflow" (Chap. 2 under "other programming languages") incomprehensible. I'm afraid that there is a translation error in it. Could you please put the English original text in the reply? Many thanks in advance!

[@Alice-at-Maven]

Here you go! Step 1: Write a SQL query within a database tool.

[@obstfrukty1063]

@@Alice-at-Maven Hi Alice, thank you very much! The German text reads (translated into English) "write B enumeration 1 a SQL query within a database tool". Obviously the formatting instruction is printed as clear text, since this text is one point of the enumeration. I'll inform the publisher of the error. Thank you again!

[@Alice-at-Maven]

@ Thank you for logging the issue!

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

[@chrisyoun1812]

Please help is My first time and am confused The dates you work with how did you get them

[@MavenAnalytics]

You have to install MySQL and MySQL Workbench, and then run a SQL script to create the tables. You can find the details towards the end of the description in the "Detailed Setup Steps" section.

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

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

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

[@inhobiswinecellar9571]

❤❤❤

[@elijahtomaquin3160]

I'm having a hard time opening the file in MySQL Workbench

[@MavenAnalytics]

You may need to install MySQL as well. You can find step-by-step instructions for how to install the software and open the file at the bottom of the description under the section DETAILED SETUP STEPS.

[@nchetibui9255]

15 mins well spent

[@Alice-at-Maven]

Glad to hear that!

[@mansip453]

Please remove the music from background. It is distracting

[@mndhr79]

The best comprehensive introduction to SQL!