SQL Crash Course for Beginners

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

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

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

[@OrleansMakuza]

Very eloquent, was a pleasure to watch your video.

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

[@dwaynecadguy1897]

you make it easy to understand. 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!! 💪

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

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

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

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

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

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