SQL Tutorial for Beginners (and Technical Interview Questions Solved)

Welcome to this comprehensive SQL tutorial course. This course covers the basics of relational databases and SQL, including setting up MySQL, inserting data, and working with aggregation, grouping, and pagination in SQL queries. It also covers advanced topics such as combining tables using joins, executing SQL queries using Python and SQL Alchemy, and solving technical interview questions. By the end of this course, you'll have the knowledge and confidence to excel in SQL.

Important Links

A database is an organized collection of structured information, typically stored in the form of tables (rows & columns). Relational databases allow storing and retrieving different kinds of related information e.g. products, customers, and orders for an online shopping site. Structured Query Language or SQL (pronounced "sequel") is the most widely used language for interacting with relational databases, and is an essential skill for Data Science professionals.

⭐️ Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:01:28) Relational Databases & SQL
⌨️ (0:03:05) Setting up MySQL
⌨️ (0:29:23) Inserting Data into the Table
⌨️ (0:56:32) Practice Exercises
⌨️ (1:22:12) Aggregation, grouping & pagination in SQL queries
⌨️ (2:23:17) Mapping and Arithmetic Functions
⌨️ (2:54:53) Working with Dates
⌨️ (3:12:16) Combining Tables using Joins
⌨️ (3:30:14) Executing SQL queries using Python and SQL Alchemy
⌨️ (4:11:06) 3 step approach to Interview Questions
⌨️ (4:36:58) Interview Q - Apple
⌨️ (4:38:59) Interview Q - Linkedin
⌨️ (4:43:09) Interview Q - Meta
⌨️ (4:50:41) Interview Q - Uber
⌨️ (4:59:18) Interview Q - Amazon
⌨️ (5:07:27) Interview Q - Google

🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan

--

[jovianhq]

Thank you to the FCC team for sharing our tutorial! We hope the community finds it helpful, feel free to reach out to us or comment here for any additional questions

[sebl]

This channel should get some kind of Nobel prize for what they are doing!

[outis_]

I'm almost halfway through the course and if I'll be totally honest, the aspect of your teaching approach that I love the most is how you actually use other resources to get the solution to problems live in the course rather than pull them out of thin air. I think that will go a long way in letting your students know that it is ok to not know it all of the top of our heads. Thanks a lot for this great course.👏👏👏👏👏👏👏

[gauravmishra]

Great tutorial. Please make a long video only for interview questions and tricky questions.

[kanishkjaiswal]

this guy might have given someone/ will give someone a 6 figure job package
thanks for what ur doing!

[samuraipiang]

I love that because I finished from Jovian YT Channel❤

[peiliangyuan]

Thank you for your detailed training on SQL. This is the best version of SQL learning I have taken so far!

Question: When I create a table, what if I forget to set up the Foreign Key initially, how to set up a Foreign Key later, without changing the existing schema and structure of the table? Thanks.

[danniwah]

Thank you for this! Brushing up on new skills as I'm job hunting.

[poptartbuddy]

So i came from this from the other SQL course made 4 years ago, I'm excited to learn!

[khalidelgazzar]

Looks like a good course. It's on my list

[Strusprawa]

Thank you, 3 hours ago I had test recrutation

[name]

I was thinking which, sql video should I watch

I just selected this

now I am happy for the selection
1:09:37

[rvkohbj]

This is the best MySql dive, that I have ever to witness!

[samarbid]

FCC, if you cam have Database Maintainance tutorial: Backup, Restore would be greatlly apritated!

[CajAbrahamsson]

Informative, appropriate, clear...amazing course suitable for a beginner like me ✨️👍

[PedroTalaia]

This course is full of typos and uncomplete sentences.
The structure is good, but the content is a mess, mainly when the complexity begins to appear in the calculations.

[vaksman]

What is the difference between this one and one from 2018 previous course

[aN]

cte and window functions are crucial pls post a video on that topic also

[handle-handler]

SQL is just a class to manage 2D array.

[boejiden]

Does this also explain window functions and CTE’s?