SQL For Web Developers - Complete Database Course
HTML-код
- Опубликовано: 14 май 2024
- 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
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
Tysm Lane
Just completed my SQL assessment an hour ago and now I saw this course being uploaded 😂❤ I will watch this too. Thank you brother.
can you also cover SQLAlchemy ? tutorials on this topic are almost nonexistent on RUclips
You don't know the value of things if you want everything to be free...
Tysm Lane. Love from India
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.
true that !
Just finished this course. Thank you so much!
I've taken other courses Lane made before, and all of them were great.
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
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 !
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!
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.
Perfect teaching! I learned everything I wanted to know about SQL.
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.
Sql never gets old. We should atleast spend some time mastering it according to our needs
Thank you! I really really need this as a full stack developer ❤️
Legends ! You guys read my mind I just need to learn SQL and you dropped this tutorial THANK YOU !
Good timing i was looking for it
I finally realized that I have to rethink about my normalization and join queries knowledge. Thank you uploading this video!
what would one say is the most important concepts of these lesson sets? in order or just like top 5
You are a perfect teacher.
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? 🤷♂🙂
Thanks so very much for sql tutorial =D
Just what I needed, thx
Thanks a lot!
God bless bro, you are an excellent instructor.
Thank you VERY much !
enjoyed it thoroughly
I am just in love with this channel
bro i needed this
Looks like a nice course. It's on my list
Very informative 👏
He is the best.
would be nicer if we can follow it along futher than chapter3
love to learn from man cause i really love coding
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!
Whats stopping me from using nested query instead of joins ?
please, teach about db transactions, it gonna be awesome stuff, btw thanks the course
How apt is this with respect to learning swl for data analytics?
I am looking for comprehensive courses for sql to start doing project
same here. I want to know the answer for this question!
Today I was about to search for sql tutorial and I got this😂🎉
I know right 😂
The timing is too suspicious
Good videos, please full SQL database management system
wait this isnot full?
Just in time when I’m learning SQL. What’s the percentage of such coincidence 😂😂
With the reach of FreeCodeCamp's channel, its pretty high that someone would be hahah
Same I literally opened YT to search for an SQL video and this popped up on my recommendations lol
Me too 😂
Lmao us
Extremely high since Google knows more about you than you know about yourself.
i request from the freecodecamp that please make a complete hardware engineering course
Damn.. Its like they knew i needed this 😂
Well stated💯
Will this be something good to watch for .NET development?
Good for anyone who wants to understand SQL!
If you will deal with data, then this is good for you.
I would like a tutorial on how to store files (images, videos, PDF,...) in SQL like PostgreSQL. It's hard to find SQL ressources
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
THIS! localstorage or s3 bucket is the key to go@@user-tf8ij9mb2m
Thanks for the course! btw, the github URL doesn't work
Fixed!
@@bootdotdev Thank you 🙏🏽
Nice! 🙃
Good
can you give us best and detailed roadmap for backend including advance
Github is not opening
Would love to see HTMX
You may need to see google first. 😂
Ty, watched on 4x
1:59:02 @bootdotdev you are being hunted!!
11:18, how the id's could be same for 2 rows??
First learner 🙂
yas! you got this
cool video)
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????
As per my very limited knowledge i think course was awesome but normalization was not taught well enough in this video
1:41:35 paintfull memory unlocked 💀
4 hours ago a video posted with 4:44:42 (+ 2s error) long😂😂😂
I just want to know that if i watch that and practice it well can i get a job??
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.
No.
light is faster than sound!
6:50
why all the sql courses are so basic? can you do something with advance functions, triggers and stored procedures? thanks any way!
22:21
1:30:28 / 4:44:42
just commenting so i don't lose my progress
1
It's sad that you have to pay to do the lessons :(
Funk Microsoft
What...? They don't own sql haha
That website is asking for money after completing chapter 2 .
IIF is a bad name for a function type? literally means what it does...this guy is sus....lol
BOOT Div is not free
Can you please make a tutorial for zoom clone using react native