SQL For Web Developers - Complete Database Course

Learn all the basics of Structured Query Language in this comprehensive SQL course. You will build out real database tables and practice querying them in flexible ways as a backend web developer would in a production setting.

✏️ Course created by: @bootdotdev

⭐️ Contents ⭐️
⌨️ (0:00:00) Course Overview (Intro video)
⌨️ (0:03:00) Ch 1. Introduction
⌨️ (0:22:19) Ch 2. Tables
⌨️ (0:50:43) Ch 3. Constraints
⌨️ (1:15:59) Ch 4. CRUD
⌨️ (2:00:13) Ch 5. Basic Queries
⌨️ (2:24:38) Ch 6. Structuring
⌨️ (2:33:52) Ch 7. Aggregations
⌨️ (2:54:14) Ch 8. Subqueries
⌨️ (3:03:40) Ch 9 . Normalization
⌨️ (3:55:44) Ch 10. Joins
⌨️ (4:22:09) Ch 11. Performance

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

--

[bootdotdev]

Thanks so much @FreeCodeCamp for letting us share this SQL course! I really hope y'all enjoy it, SQL is such a foundational skill for any web developer

[easylearnplatform]

I spent four years without understanding SQL but within an hour it's making sense. Big ups. Kindly do another on how to link a users table to transactions table

[Pylogicx]

I watched almost 30 minutes of the course, and I didn't feel any boring and sleepy as I feel watching tutorial on YT. Greate Teacher. I will complete it.

[FRanger]

By about 50mins in you are forced to buy the course to be able to 'follow along' in the browser. Just a warning for those that don't want to pay $29 a month or ($99) and waste 50mins for this one course.

[tanzimibthesam]

Sql never gets old. We should atleast spend some time mastering it according to our needs

[sunraiii]

Just finished this course. Thank you so much!
I've taken other courses Lane made before, and all of them were great.

[Scottni]

This course is incredibly well organized and easy to follow. Lane is definitely one of the best instructors I've peronally come across on YT. Kudos!

[joshuaajagbe]

Thanks a lot for this. This has just helped me pass a backend interview. 😀

[wintersol]

2:44:48 here you have an example query ``` select song_name, avg(song_length) from songs; ``` but this will cause an error because you should group them by song_name (or maybe song_artist to make more sense) to resolve the issue. Great course. Thank you.

[veebxl]

Thank you so much for creating this tutorial - it helps grasp SQL so fast - I did use it and had lessons, but now I needed a refresher, and it just clicked - "omg it's not that hard at all"! You are a great teacher! Thanks !

[Hybridham]

Legends ! You guys read my mind I just need to learn SQL and you dropped this tutorial THANK YOU !

[mgamer]

Thank you! I really really need this as a full stack developer ❤️

[thomasliangus]

It is so refreshing and reassuring to hear the American English.

[thushanchathuranga]

I finally realized that I have to rethink about my normalization and join queries knowledge. Thank you uploading this video!

[ricardocnn]

Perfect teaching! I learned everything I wanted to know about SQL.

[lol]

would be nicer if we can follow it along futher than chapter3

[technologian]

God bless bro, you are an excellent instructor.

[clashcosmos]

good course especially if we follow along, could be great without asking for the "upgrade" or at least should have given the warning

[technogeeks]

Today I was about to search for sql tutorial and I got this😂🎉

[rlxpudding]

Hi, thanks for your time that you had invest in your courses. I just started because I need to learn to CRUD data on an MS SQL Server. So I decided to set up an MS SQL Server on my Home Server and it works. Am my Question is, is it possible to take that course with the MS SQL as database? 🤷‍♂🙂