Тёмный

SQL For Web Developers - Complete Database Course 

freeCodeCamp.org
Подписаться 10 млн
Просмотров 167 тыс.
50% 1

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.
💻 Follow along on Boot.dev: boot.dev/learn/learn-sql
💻 Raw code: github.com/bootdotdev/fcc-lea...
✏️ Course created by: ‪@bootdotdev‬
🔗 Learn back-end on Boot.dev: boot.dev
Follow Lane on Twitter: / wagslane
Boot.dev Discord: boot.dev/community
FCC Forum: forum.freecodecamp.org/
⭐️ 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
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Опубликовано:

 

31 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 108   
@bootdotdev
@bootdotdev 11 месяцев назад
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
@maria37883
@maria37883 11 месяцев назад
Tysm Lane
@TheCosmopolitanHefty
@TheCosmopolitanHefty 11 месяцев назад
Just completed my SQL assessment an hour ago and now I saw this course being uploaded 😂❤ I will watch this too. Thank you brother.
@SouravBasuRoy
@SouravBasuRoy 11 месяцев назад
can you also cover SQLAlchemy ? tutorials on this topic are almost nonexistent on RU-vid
@geraldlermont6656
@geraldlermont6656 11 месяцев назад
You don't know the value of things if you want everything to be free...
@kartikeytiwari5388
@kartikeytiwari5388 11 месяцев назад
Tysm Lane. Love from India
@easylearnplatform8967
@easylearnplatform8967 11 месяцев назад
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
@Pylogicx 10 месяцев назад
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.
@sunraiii
@sunraiii 9 месяцев назад
Just finished this course. Thank you so much! I've taken other courses Lane made before, and all of them were great.
@veebxl
@veebxl 5 месяцев назад
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 !
@Scottni2
@Scottni2 2 месяца назад
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!
@Hybridham86
@Hybridham86 11 месяцев назад
Legends ! You guys read my mind I just need to learn SQL and you dropped this tutorial THANK YOU !
@ricardocnn
@ricardocnn 10 месяцев назад
Perfect teaching! I learned everything I wanted to know about SQL.
@tanzimibthesam5861
@tanzimibthesam5861 11 месяцев назад
Sql never gets old. We should atleast spend some time mastering it according to our needs
@mgamer0164
@mgamer0164 11 месяцев назад
Thank you! I really really need this as a full stack developer ❤️
@thushanchathuranga6694
@thushanchathuranga6694 10 месяцев назад
I finally realized that I have to rethink about my normalization and join queries knowledge. Thank you uploading this video!
@wintersol9921
@wintersol9921 10 месяцев назад
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.
@Babu_bha1
@Babu_bha1 11 месяцев назад
Good timing i was looking for it
@joshuaajagbe5096
@joshuaajagbe5096 2 месяца назад
Thanks a lot for this. This has just helped me pass a backend interview. 😀
@middle-agedclimber
@middle-agedclimber 10 месяцев назад
You are a perfect teacher.
@funtushgaming2596
@funtushgaming2596 10 месяцев назад
I am just in love with this channel
@geralt-dy1qo
@geralt-dy1qo 11 месяцев назад
bro i needed this
@technologian1
@technologian1 10 месяцев назад
God bless bro, you are an excellent instructor.
@King_504
@King_504 11 месяцев назад
Just what I needed, thx
@mqjogos2024
@mqjogos2024 11 месяцев назад
Thanks so very much for sql tutorial =D
@FRanger92
@FRanger92 11 месяцев назад
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.
@sans.creates
@sans.creates 4 месяца назад
true that !
@HamzahAhmad-db5cy
@HamzahAhmad-db5cy 2 месяца назад
The course is still very informative, even if you can't follow along on the platform. Plus, you can easily spin up a database instance in, say pgAdmin, and follow along. And the author specifically mentioned data files you can use if you don't want to create an account.
@AbuAl7sn1
@AbuAl7sn1 Месяц назад
easy .. just pick any sql playground .. there are dozens of them on the internet
@atz527
@atz527 10 месяцев назад
Very informative 👏
@gytzero
@gytzero 9 месяцев назад
enjoyed it thoroughly
@khalidelgazzar
@khalidelgazzar 10 месяцев назад
Looks like a nice course. It's on my list
@3polygons
@3polygons 11 месяцев назад
Thank you VERY much !
@gintoki_sakata__
@gintoki_sakata__ 11 месяцев назад
Damn.. Its like they knew i needed this 😂
@roninspect4357
@roninspect4357 11 месяцев назад
Thanks a lot!
@kierkietv3496
@kierkietv3496 11 месяцев назад
love to learn from man cause i really love coding
@prashlovessamosa
@prashlovessamosa 11 месяцев назад
He is the best.
@rlxpudding2056
@rlxpudding2056 10 месяцев назад
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? 🤷‍♂🙂
@ersalomositorusdori308
@ersalomositorusdori308 11 месяцев назад
please, teach about db transactions, it gonna be awesome stuff, btw thanks the course
@userunknown-fc8wp
@userunknown-fc8wp 11 месяцев назад
what would one say is the most important concepts of these lesson sets? in order or just like top 5
@user-vi8ig1dw2u
@user-vi8ig1dw2u 11 месяцев назад
i request from the freecodecamp that please make a complete hardware engineering course
@AntiWest-sq3de
@AntiWest-sq3de 5 месяцев назад
Well stated💯
@4399lol
@4399lol 11 месяцев назад
would be nicer if we can follow it along futher than chapter3
@AnilKumar-tm6fq
@AnilKumar-tm6fq 11 месяцев назад
Good videos, please full SQL database management system
@skyisbluexd
@skyisbluexd 11 месяцев назад
wait this isnot full?
@_exxiff
@_exxiff 11 месяцев назад
Ty, watched on 4x
@Makeshitjusbecuz
@Makeshitjusbecuz 11 месяцев назад
Whats stopping me from using nested query instead of joins ?
@user-xl1xf4sv8p
@user-xl1xf4sv8p 6 месяцев назад
cool video)
@technogeeks4160
@technogeeks4160 11 месяцев назад
Today I was about to search for sql tutorial and I got this😂🎉
@gintoki_sakata__
@gintoki_sakata__ 11 месяцев назад
I know right 😂 The timing is too suspicious
@T-K-R-2024
@T-K-R-2024 11 месяцев назад
How apt is this with respect to learning swl for data analytics? I am looking for comprehensive courses for sql to start doing project
@anindiansquirrel
@anindiansquirrel 6 месяцев назад
same here. I want to know the answer for this question!
@AhmedAymanM
@AhmedAymanM 11 месяцев назад
3:30:00 unfortunately I guess depending on my knowledge the normalization part wasn't super clear / correct to me (since i'm just rememorizing with your great video), however good job so far!
@fulconandroadcone9488
@fulconandroadcone9488 8 месяцев назад
2.45.05 I have paused the video and am waiting for further instructions, it has been close to a year. What should I dooooooo????
@marwajomaa7594
@marwajomaa7594 4 месяца назад
can you give us best and detailed roadmap for backend including advance
@salmansarwar969
@salmansarwar969 5 месяцев назад
11:18, how the id's could be same for 2 rows??
@liftfresh4life
@liftfresh4life 11 месяцев назад
Will this be something good to watch for .NET development?
@bootdotdev
@bootdotdev 11 месяцев назад
Good for anyone who wants to understand SQL!
@Kevin-jc1fx
@Kevin-jc1fx 11 месяцев назад
If you will deal with data, then this is good for you.
@sandeeplakhiwal7043
@sandeeplakhiwal7043 11 месяцев назад
First learner 🙂
@bootdotdev
@bootdotdev 11 месяцев назад
yas! you got this
@Kokouvi_el_mejor
@Kokouvi_el_mejor 11 месяцев назад
Good
@doareu
@doareu 11 месяцев назад
Nice! 🙃
@umairjibran7
@umairjibran7 10 месяцев назад
1:59:02 @bootdotdev you are being hunted!!
@vassillyred-vibinkwiye759
@vassillyred-vibinkwiye759 11 месяцев назад
I would like a tutorial on how to store files (images, videos, PDF,...) in SQL like PostgreSQL. It's hard to find SQL ressources
@user-tf8ij9mb2m
@user-tf8ij9mb2m 11 месяцев назад
you don't , and you should never do it , store them in a folder called public in your web app and store the path of the file in the column , storing binary data in these database is really bad practice
@aryanjain5535
@aryanjain5535 11 месяцев назад
THIS! localstorage or s3 bucket is the key to go@@user-tf8ij9mb2m
@Ese_osa
@Ese_osa 11 месяцев назад
Just in time when I’m learning SQL. What’s the percentage of such coincidence 😂😂
@bootdotdev
@bootdotdev 11 месяцев назад
With the reach of FreeCodeCamp's channel, its pretty high that someone would be hahah
@alexjohnson6192
@alexjohnson6192 11 месяцев назад
Same I literally opened YT to search for an SQL video and this popped up on my recommendations lol
@amirmiri6951
@amirmiri6951 11 месяцев назад
Me too 😂
@anishbabbar8057
@anishbabbar8057 11 месяцев назад
Lmao us
@rongooden6545
@rongooden6545 11 месяцев назад
Extremely high since Google knows more about you than you know about yourself.
@sohaibabdullah9073
@sohaibabdullah9073 11 месяцев назад
Github is not opening
@hari_poojary
@hari_poojary 11 месяцев назад
Thanks for the course! btw, the github URL doesn't work
@bootdotdev
@bootdotdev 11 месяцев назад
Fixed!
@hari_poojary
@hari_poojary 11 месяцев назад
@@bootdotdev Thank you 🙏🏽
@kaushikbora2728
@kaushikbora2728 7 месяцев назад
light is faster than sound!
@sergiomendoza6833
@sergiomendoza6833 11 месяцев назад
Would love to see HTMX
@aammssaamm
@aammssaamm 11 месяцев назад
You may need to see google first. 😂
@codingreaction7332
@codingreaction7332 8 месяцев назад
1:41:35 paintfull memory unlocked 💀
@syedanwar1872
@syedanwar1872 10 месяцев назад
As per my very limited knowledge i think course was awesome but normalization was not taught well enough in this video
@sagarchourasiya529
@sagarchourasiya529 11 месяцев назад
4 hours ago a video posted with 4:44:42 (+ 2s error) long😂😂😂
@khizerrehman7227
@khizerrehman7227 11 месяцев назад
I just want to know that if i watch that and practice it well can i get a job??
@Kevin-jc1fx
@Kevin-jc1fx 11 месяцев назад
You can but you will need irrefutable proof that you actually practiced it well. For instance, a few projects that you applied this knowledge in from scratch. I mean at least one large project (something that would take you a solid month or 2 to complete on your own), 3 medium size projects and a few small ones.
@aammssaamm
@aammssaamm 11 месяцев назад
No.
@immortalroasterben7146
@immortalroasterben7146 6 месяцев назад
1:30:28 / 4:44:42 just commenting so i don't lose my progress
@Tech-fx5do
@Tech-fx5do 10 месяцев назад
why all the sql courses are so basic? can you do something with advance functions, triggers and stored procedures? thanks any way!
@SurajDas-zi7wb
@SurajDas-zi7wb 2 месяца назад
6:50
@Naoty_san
@Naoty_san 8 месяцев назад
22:21
@vaibhav_8
@vaibhav_8 11 месяцев назад
1
@rayenmerghmi5664
@rayenmerghmi5664 11 месяцев назад
Funk Microsoft
@bootdotdev
@bootdotdev 11 месяцев назад
What...? They don't own sql haha
@anabelberumen
@anabelberumen 10 месяцев назад
It's sad that you have to pay to do the lessons :(
@shriyashmangaonkar8542
@shriyashmangaonkar8542 6 месяцев назад
That website is asking for money after completing chapter 2 .
@lammydidon
@lammydidon 10 месяцев назад
IIF is a bad name for a function type? literally means what it does...this guy is sus....lol
@naveedali-kx3lg
@naveedali-kx3lg 9 месяцев назад
BOOT Div is not free
@jayeshnayak4516
@jayeshnayak4516 11 месяцев назад
Can you please make a tutorial for zoom clone using react native
Далее
God-Tier Developer Roadmap
16:42
Просмотров 7 млн
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58
Как пронести Конфеты В ТЮРЬМУ
19:16
I've been using Redis wrong this whole time...
20:53
Просмотров 345 тыс.
The Importance of Specialization in Coding
7:13
Просмотров 208 тыс.
I tried 8 different Postgres ORMs
9:46
Просмотров 397 тыс.
MySQL - The Basics // Learn SQL in 23 Easy Steps
17:17
Просмотров 822 тыс.
SQL vs NoSQL or MySQL vs MongoDB
21:30
Просмотров 1,8 млн
My Unconventional Coding Story | Self-Taught
27:14
Просмотров 587 тыс.
FULL SQL DATABASE COURSE | Learn SQL in 70 minutes
1:10:01
Викторина от МАМЫ 🆘 | WICSUR #shorts
00:58