SQL Crash Course for Beginners

You’ll find SQL in almost every company, so demand for data professionals with SQL skills is through the roof, and that’s not changing any time soon.
A lot of folks are intimidated by SQL, but it’s actually one of the easiest languages to learn. You just need to know where to start.
In this live session, Maven instructor and Data Scientist Alice Zhao will walk you through the basics and point you in the right direction so you can take your SQL game to the next level.
What You'll Learn:
1) Foundational SQL concepts like relational databases, and the Big 6 of SQL querying
2) Syntax basics so you can start querying with real data immediately
3) Where you should focus your learning to maximize results
This session was part of our OPEN CAMPUS week in October, which included 6 days of live expert sessions.
🗣️ Follow us on LinkedIn for daily data analysis tips and career guidance: / maven-analytics
💡 Interested in data courses? Join over 1,000,000 students who have taken our Maven Analytics courses in Excel, SQL, PowerBI, Tableau, Python and more: bit.ly/3UjF6hc

[@DDataAnalyst]

Oh 😮!!! Crazy!! I heard this book is amazing and I have it in my Amazon cart 🛒 and now here you are 😊 so cool!

[@papajon619]

Great stuff right here. If you’re looking to start your SQL journey, look no further. Watch this

[@jbpauler]

This comment makes me happy. Thanks for taking the time!

[@Sugah724]

OMG! THIS WAS AMAZING Alice. I just completed a free SQL beginners bootcamp on youtube. While I was able to actually do the work and follow, I absolutely LOVE this 30 minute tutorial and it would have helped me tremendously had I watched this video first.

[@Alice-at-Maven]

Glad you enjoyed the video!

[@ibrahim82649]

This introduction to SQL is Amazing. Would definitely consider learning more.

[@jbpauler]

Great to hear you enjoyed it Ibrahim. SQL is such a foundational skill in data. Highly recommend you do pick it up. It's been a game changer for my career.

[@OrleansMakuza]

Very eloquent, was a pleasure to watch your video.

[@chirumeadmiretarisirayi6196]

This is beautiful. You made this look so simple, easy.

[@efrainperez257]

Wow that’s a great way to start SQL I’m looking forward to learn it I want to start my new career related to data analytics

[@jbpauler]

Right on! If you want to be in data, SQL is a core skill. It's everywhere and there still somehow aren't enough people that are truly good at it. So companies need people all the time.

[@maferca1977]

You are awesome! Thanks for the intro!

[@DiamondSpeedbuilds]

loved this video! I had this on and my cat couldn't stop staring at the screen he loved ur guys presentation

[@Alice-at-Maven]

Haha, your comment made my day. Glad you and your cat enjoyed the video!

[@ifeomajames8702]

Thanks for this

[@nafeesatrabiu-adebayo3301]

This really helpful and easy. Thank you.

[@stewartmoore5158]

This was a brilliant introduction to SQL!

[@Alice-at-Maven]

Glad you enjoyed it!

[@DatawithHimanshu]

Amazing SQL introduction

[@jbpauler]

Yea it really was!! 💪

[@dwaynecadguy1897]

you make it easy to understand. Thank you

[@Stellathediamond]

Thank you Alice ♥️👏🏾👏🏾👏🏾♥️

[@Alice-at-Maven]

You're welcome!

[@rjofins1845]

Great explanation, I think that the examples with a real abstraction, they are really good. Regards from Spain.

[@Alice-at-Maven]

Glad you found it helpful!

[@maitranslator1324]

Thank you ALice. that was great intro...since this is for biginners, I was wondering where do you save tables in? or is it amtter of uploading the files somehwere? thank you

[@MavenAnalytics]

Let's say I'm using MySQL to write SQL queries. In that case, all the tables I'm working with would be saved in MySQL. If you have a .csv file, you could load that data file into MySQL and it would then be saved as a table in MySQL for you to query.

[@ChinnaChennaiah-wo3ob]

good explanation

[@jbpauler]

Alice is 🔥 and SQL is such a core skill. Hope we'll reach a lot of folks with this one :)

[@sothingmarkrk5165]

Where can I find the book

[@sujaykoushik]

Great introduction to SQL. Please forgive my ignorance here, but I wonder why do many programming books have wierd pictures of animals on their cover page. Does anyone know?

[@Alice-at-Maven]

The book publisher O'Reilly has animals on the cover of all their programming books.

[@maureenokoro8818]

Do you have a KZbin channel.or how do I connect with you to learn

[@Alice-at-Maven]

You can find my SQL videos within the SQL Tips playlist on this Maven Analytics KZbin channel. I'll also be coming out with an Advanced SQL Querying course next month, available on the Maven Analytics platform and Udemy.

[@simonhamilton2037]

Also... I'"m looking at SQL as an alternative to MS Access for a variety of reasons. Can SQL be used to generate a fully-fledged front-end online 'app' To what extent would you say they are equals, or is one better than the other?

[@Alice-at-Maven]

They're different. If you're looking for a front-end app that's ready to use out-of-the-box, then MS Access is the way to go. If your goal is to create a front-end online app, then you would have to combine SQL on the back end with web development technologies on the front end (HTML / CSS / etc.). If your goal is just to interact with a database using a user-friendly interface, you can use a SQL editor like MySQL Workbench (for MySQL), pgAdmin (for PostgreSQL), etc.

[@simonhamilton2037]

@@Alice-at-Maven Thanks, it's what I suspected. To work!

[@bryanlomerio6398]

24:00

[@moemoe-jb2fw]

In the grade table why do you have grade_id ?

[@Alice-at-Maven]

The grade_id gives each row a unique ID. While it isn't necessary, you'll sometimes see unique IDs like this in a transactions table where each entry or row is given a unique ID in case you need to reference a particular entry. For this demo, I included it to simplify things and give each table a simple primary key in the left most column, versus of creating a more complex composite key (primary key based on multiple columns).

[@moemoe-jb2fw]

@@Alice-at-Maven thank you, you’re really good at explaining. I will start my sql journey soon. Should I learn excel? my goal is to learn how to test a database and write complex queries. Any advice ?

[@Alice-at-Maven]

@@moemoe-jb2fw If your goal is to write complex queries and work with a database, SQL should be good enough for now. If you'd like to do data analysis tasks, then I would recommend learning Excel.

[@Number-s9h]

Can you people get over the bleading obvious and just get on with it! And it is sql not sequel! 8 minutes and still debating what things are called! No wonder they are too long.

[@simonhamilton2037]

Another great course, thank you! Question: at around @28:00 you code , eg. 'Students s' and 'g.final_grade', which seem to be related to the join. Do you go iinto this ('s' & 'g') elsewhere?

[@Alice-at-Maven]

I don't go over the s and g in detail in the video, but I can explain it here! Those are aliases, which are essentially nicknames for the tables. Once you define the nicknames in the FROM clause (Students s, Grades g), you can use those nicknames throughout the rest of the query whenever you're referencing a column from a table (ON s.student_id = g.student_id, s.student_name, etc.).

[@simonhamilton2037]

@@Alice-at-Maven Thank you!

[@osvaldo81]

@@Alice-at-Maven thanks for explaining this I paused the video and stay hold observing and I understood like you confirmed here, you are aawesome woman keep the good work :)