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
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
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.
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.
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 !
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.
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.
@@HamzahAhmad-db5cy Thanks for this reassurance. @FRanger92 comment was discouraging, knowing that the essence of freeCodeCamp is free learning, so people can build themselves and then give back later.
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? 🤷♂🙂
0:40 I don't understand what's so hard to do a proper down migration for a whole company? You've already done all migrations, you know each step, now you just need a reverse record of it, it's not like you need an entire clone of the database. Cam't you have a whole changelog like Git does for repos but this time it's for a database and you can even roll back data?
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!
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
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.
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
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
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.
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.
Just finished this course. Thank you so much!
I've taken other courses Lane made before, and all of them were great.
Sql never gets old. We should atleast spend some time mastering it according to our needs
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 finally realized that I have to rethink about my normalization and join queries knowledge. Thank you uploading this video!
Very clear voice with good explanation.
Legends ! You guys read my mind I just need to learn SQL and you dropped this tutorial THANK YOU !
Thanks a lot for this. This has just helped me pass a backend interview. 😀
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 !
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.
easy .. just pick any sql playground .. there are dozens of them on the internet
@@HamzahAhmad-db5cy Thanks for this reassurance. @FRanger92 comment was discouraging, knowing that the essence of freeCodeCamp is free learning, so people can build themselves and then give back later.
Thank you! I really really need this as a full stack developer ❤️
Perfect teaching! I learned everything I wanted to know about SQL.
It is so refreshing and reassuring to hear the American English.
God bless bro, you are an excellent instructor.
I am just in love with this channel
great tutorial👏 thank you 🙏
It's SQUEAL, Structured Query Language. SEQUEL is CQL, Cassandra Query Language.
Damn.. Its like they knew i needed this 😂
Today I was about to search for sql tutorial and I got this😂🎉
I know right 😂
The timing is too suspicious
You are a perfect teacher.
2:27:52
What is the difference between top and limit in SQL.
Good timing i was looking for it
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? 🤷♂🙂
would be nicer if we can follow it along futher than chapter3
i request from the freecodecamp that please make a complete hardware engineering course
11:18, how the id's could be same for 2 rows??
0:40 I don't understand what's so hard to do a proper down migration for a whole company? You've already done all migrations, you know each step, now you just need a reverse record of it, it's not like you need an entire clone of the database.
Cam't you have a whole changelog like Git does for repos but this time it's for a database and you can even roll back data?
Very informative 👏
bro i needed this
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.
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.
Looks like a nice course. It's on my list
love to learn from man cause i really love coding
Thanks so very much for sql tutorial =D
please, teach about db transactions, it gonna be awesome stuff, btw thanks the course
enjoyed it thoroughly
good course especially if we follow along, could be great without asking for the "upgrade" or at least should have given the warning
Just what I needed, thx
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????
1:59:02 @bootdotdev you are being hunted!!
Ty, watched on 4x
what would one say is the most important concepts of these lesson sets? in order or just like top 5
can you give us best and detailed roadmap for backend including advance
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!
Thank you VERY much !
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!
is this is good course for sql? your view? and can you recommand better video for sql and postgresql?
He is the best.
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@@ZoroRonoroa-g7k
First learner 🙂
yas! you got this
1:41:35 paintfull memory unlocked 💀
Well stated💯
Thanks for the course! btw, the github URL doesn't work
Fixed!
@@bootdotdev Thank you 🙏🏽
4 hours ago a video posted with 4:44:42 (+ 2s error) long😂😂😂
Thanks a lot!
Github is not opening
Would love to see HTMX
You may need to see google first. 😂
1:30:28 / 4:44:42
just commenting so i don't lose my progress
light is faster than sound!
cool video)
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.
As per my very limited knowledge i think course was awesome but normalization was not taught well enough in this video
Can you please make a tutorial for zoom clone using react native
I call it cruud, or crood.
why all the sql courses are so basic? can you do something with advance functions, triggers and stored procedures? thanks any way!
Good
22:21
6:50
Nice! 🙃
It's sad that you have to pay to do the lessons :(
That website is asking for money after completing chapter 2 .
Taylor Charles Johnson Timothy Davis Melissa
Martinez Jeffrey Walker David Jones Brian
Funk Microsoft
What...? They don't own sql haha
Williams Jeffrey Jones Scott Lewis Kimberly
1
IIF is a bad name for a function type? literally means what it does...this guy is sus....lol
BOOT Div is not free
Walker Elizabeth Jones Helen Johnson Daniel