HomeОбразованиеRelated VideosMore From: freeCodeCamp.org

SQL Tutorial - Full course for beginners

33261 ratings | 1874801 views
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. 🔗Company Database Code: https://www.giraffeacademy.com/databases/sql/creating-company-database/ ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw 🐦Follow Mike on Twitter: https://twitter.com/GiraffeAcademy 🔗The Giraffe Academy website: http://www.giraffeacademy.com/ -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Html code for embedding videos on your blog
Text Comments (1758)
Mike Dane (9 months ago)
Hey everyone! Thanks for watching my course Follow me on twitter at https://twitter.com/mike_dane
PomPoyoo ROYALE (5 days ago)
Subscribe to me xDDDDDDD
Paolo Yanes (10 days ago)
Another thank you SO MUCH. Thank you for all the courses!
picha (11 days ago)
@mingjie zhang Same problem here. Did you figured it out what's going wrong?
Ksee (13 days ago)
Jesusnchrist dude
Ly Nguyen Ha (18 days ago)
Thank you so much Mike! Easy to understand! Now I have something specific to show employers in the upcoming interviews!
BHANVI JETHI (8 minutes ago)
POPSQL provides paid services only. Can you help by telling any free platform?
Hop-A-Long (13 hours ago)
My man you need to post a venmo account, I'd donate purely out of respect. Non monetized and pure gold content.
Karthick sherly (14 hours ago)
Why are the subtitles not working? Is it only for me? or anyone else having the same issue?
Demas Meira (16 hours ago)
man you are a STAR. you know this programming concepts like the palm of your hand. wishing you good health for years to come so you can produce more interesting content on your page.
Paul Uhrig (18 hours ago)
can i get popsql for free ?
Mohammed Amine Telli (19 hours ago)
popsql is not for free and in our country we don't have international card ????
Harish karthik (20 hours ago)
Is this enough to make basic web apps?
Sxeymaxzma (21 hours ago)
Hi Mike, Thanks for the video. I find it very helpful. You mentioned to link a pdf of company database scheme in the information section. However, I am unable to find it. any chance you could help? thanks
Sachin kumar (21 hours ago)
Is popsql free??
a aa (1 day ago)
still cant get over crud lol
ColdShifted (1 day ago)
It looks like popsql is no longer free to download :(
nahor88 (12 hours ago)
It isn't.... *angry face* I intended to slowly go through the course so I can practice the lessons, and the fucking thing tells me I'm on a free trial...
Olivier Loua (12 hours ago)
ColdShifted use the MySQL workbench
Krithika Babu (1 day ago)
You are awesome buddy to sit for hours and teach us very clearly!very useful in learning many!thanks a lot.
thisismyname me (1 day ago)
I ran into problems on Triggers in the Command Line Client. If you get a '1359 table already exists' error message after fixing a typo in the trigger when you re-input the information into the command line client, one should delete the trigger in popsql before trying to re input the information into the clc again. Also, if mysql disappears in the clc and you get this -> instead of mysql> just type in \c, and this will erase what you wrote prior, and make mysql appear again. I'm a novice, so I would imagine that other novices may run into problems such as this as well and not know what's happening.
jindam madhav (1 day ago)
best lecture on dbms. This guy has whole computer database hidden in him.Lots of love❤❤
Babu Chingangbam (1 day ago)
why i cant install mysql server and my command line doesn't show up after installation......... msi 8.0.12
Hello
srikar reddy (2 days ago)
Dude seriously your tutorials are GOLD!Especially for people who are just lost thinking where to start or learn programming from!!THANK YOU!!
Brian Dacallos (3 days ago)
Is't the same if i write those codes in Cmd and i'm using xampp ?
The Gignerd (3 days ago)
Legend
kaskej (3 days ago)
thanks so much for your inexhaustible energy
nick dufresne (3 days ago)
at 1 hour 30 min, I get the error: ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn't match value count at row 1
BlackPanther X (3 days ago)
@nick dufresne well done
nick dufresne (3 days ago)
nevermind, I figured it out - I still had the GPA column in there
Hurry Media (3 days ago)
Hello Sir, Thank you for your video, what made you add free? Anyway it's really nice gift for me Sir. May Allah bless you Sir.
Rathish Rts (3 days ago)
you are the best...i learned a lot and lot..it helped me in the interview a lot..i hope u keep posting videos like this in different domains...thank u a lot..lot of loves from india
REBHU ROY (4 days ago)
hey man you are awesome to . it was too much help full no words to your teaching. but i would like to request freecodecamp to create industry related technology like oracle Retail management system that would help . thanks.
Mikhail Palagashvili (4 days ago)
well done
Giggity King (5 days ago)
17:57 you should have replaced the 'n' with an 'a'.
muriduru (5 days ago)
Thanks
Alexander Ilyin (5 days ago)
Hi man. I'm from Russia. I'm not good in English and for me it's difficult to understand english speech without subtitles. Something happened with subtitles on YouTube, so I watched your video without them. And I understand everything ) You english is so understandable. Thank you very much.
akshay chauhan (6 days ago)
when i write the wildcard for employee born in October i get this error - ER_WRONG_VALUE: Incorrect DATE value: '____-10%' Can someone help?
Jay Junior (6 days ago)
hey mike pls I have a question ... I just starting following up your tutorial but seems as if lately I couldn't connect to my database anymore both in popsql and in the mysql command line and the password is correct ... need help
naman mittal (6 days ago)
Revise it all at 1.75x
Kartik Agarwal (6 days ago)
Thanks a lot
Danyal Admani (6 days ago)
Beautiful
Vikram J (6 days ago)
thank you
Brian Sullivan (7 days ago)
Nice references to the OFFICE Scranton, michael scott Jan lol Great video
Sunny Me (7 days ago)
thank you so much..this video helped me brush up some basic concepts
Wireless008 (7 days ago)
Cool! Thank you so much!
hazel.for.life (7 days ago)
I got the best scores in exam just by watching this video.Thank you so muchh🤗😍
Unreal Everything (7 days ago)
1:44:07
Balla Baby (7 days ago)
Just got to the JOIN's portion of the video. I remember going over these in my database 1 class freshman year and I couldn't understand them at all no matter how hard I tried and how many venn diagram type things I looked at. Understood it instantly in this vid. Great teaching and I must say that learning how to program has definitely helped my logic skills.
Arina Grishina (7 days ago)
Could anybody, please, help me? When I enter query " SELECT * FROM employee WHERE birth_day LIKE '____-10%'; " it returns me an error saying " ER_WRONG_VALUE: Incorrect DATE value: '____-10%' ." What do I do wrong?
Alvin K. (7 days ago)
Hi Guys, Functions should be at 2:36:00 not 2:26:00 amazing video, I see alot of effort put into this thanks so much!
Krátòs ëz (8 days ago)
Want to save 52 precious minutes of your coding life! Just switch this video to 1.25x speed and yes it still sounds reasonable.
Good, comprehensive Topic about Databases, thanks for your Video !!
Liam Logan (8 days ago)
what a guy. This has helped me so much, thank you!
Mukul Jaiswal (8 days ago)
PopSQL isn't working on my laptop, is there any other option I can go on with?
Desireable725 (8 days ago)
I'm getting an incorrect date value when searching for people who were born in October this is what i had typed: SELECT * FROM employee WHERE birth_date LIKE '____-10%';
fortes calculatoare (7 days ago)
TRY THIS... Select * From employee Where month (birth_day) = '10' ;
ramanti shaw (9 days ago)
Can you tell me advance topic of sql?
Aszad Hossain (9 days ago)
such a nice and handy tutorial..i want to give 10 likes :)
Cerebral Reviews (9 days ago)
1:54:45
Rolonde Hainey (10 days ago)
When adding a value, It is saying that there is a wrong value. Help Im stuck
José RF Junior (10 days ago)
MUITO BOM !!
AbdulRehman Zahid (10 days ago)
EHAMAZING. Just finished the first hour and it is all very clear and easy to understand. Thankyou so much. Loved the the office reference since I am on season 7 right now.
AARON BARAIYA (11 days ago)
do you need a college degree to get a job as a database developer?(this is a real question:)
AARON BARAIYA (9 days ago)
@revues de minuit Thanks
revues de minuit (9 days ago)
AARON BARAIYA it depends on the employer. Some require a degree, while some require an equivalent amount of previous experience. If you get an interview, as long as you are proficient in the material, that’s all that matters.
Emmanuel Adigun (11 days ago)
Thank you for this tutorial on SQL. It's really helpful. God bless you.
gabriel malichi (12 days ago)
Best tutorial ever!!!
Rahul Kamble (13 days ago)
the popSQL says will expire in 14 days. is there any other option or editor for free? please help
Aneta Akelan (13 days ago)
Thank you. It was very helpful. :)
Bill Clinton (13 days ago)
That was a great watch, thanks a bunch. Setting aside that Dark Mode is Premium only, PopSQL is also pretty good to learn this stuff.
Latte Macchiato (13 days ago)
Seems as if everyone was "kinda interesting"
Sudhir Jain (14 days ago)
Thanks 💓
Clevon Teesdale (14 days ago)
Draft
Sahil Kumar (14 days ago)
No add timing here.... 😑😑😑
Rld82 (14 days ago)
Mike Dane is a hero.
Cyber Flow (15 days ago)
A year after it got uploaded, someone whose current username is Cyber Flow (me) entered the comment section database writing some text that might be considered as a string value or any kind of similar key, yey (I really hope I didn't mess up any kind of technical word for what I tried to mean).
MS COCO (13 days ago)
thats funny in a sql programming way
SUJITH H L (15 days ago)
very easy to understand...Thank you so much
Chogiwaaa all the way (15 days ago)
Was the list of your five best friends an intentional The Office reference?
DAATS_VoodooChild (16 days ago)
This tutorial is preping me for an interview at my first SWE job. Preesh
Kevin D (16 days ago)
how to write the query for the following question: Select employees whose phone numbers starting with 9980 or 9977. Can you please give the solution for this question
artisded (16 days ago)
⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas
Robi Parvez (16 days ago)
this video make me wanna actually donate
Robi Parvez (16 days ago)
priceless video ....best channel evr
Alessandro Mazzini (16 days ago)
What should I do next to this? Is this knowledge enough to start a junior position? Thank you a lot!
Alessandro Mazzini (14 days ago)
Reddy Pooja thank you! I will check them for sure!
Reddy Pooja (14 days ago)
You can get most realistic software certifications exams in Vullam website
Reddy Pooja (14 days ago)
Alessandro Mazzini Oracle DB is one of the best in the market Next is Microsoft You can find them in vullam website Better to write practice tests to gain confidence
Alessandro Mazzini (14 days ago)
Reddy Pooja there's one you suggest the most ? Tank you!
Reddy Pooja (14 days ago)
Getting Certification is the major thing everyone ignores But In this competitive software world certification is very important to sustain and stand out of competition 🥳 Many persons get good HR calls and also good salary packages once you get certification in technology This is out of my 15 years of experience and hope it helps 📔
Anirudh Bhaskaran (16 days ago)
He somewhat resembles "the good son" from Total Overdose.
Rohin (18 days ago)
I am not able to install MySQL because they're not accepting my current root password
Rohin (17 days ago)
@Jean Paul Zolabe let me try once more..
Jean Paul Zolabe (17 days ago)
Well make sure you unistall any previous version of MySQL and try again. You can go to your register to see if there is no any residue of MySQL left.
Twinkle (18 days ago)
Hi This tutorial is fantastic .For person like me who don't know about SQL ,but after watching this tutorial i know and now am making table and it helpful in learning SQL.Thanks
SANDIP SADHUKHAN (18 days ago)
good tutorial
mohammed suffiyan (19 days ago)
thanks mike dane :)
AAA (19 days ago)
Just completed this video, took about 6 hours for me, pausing, rewinding, taking notes, watching some parts over. Thank you for the video! I have a long way to go a lot of practicing to do but this was a great start for me.
ercan - (19 days ago)
i want to kill myself after this course but ok
Jon-David Woods (20 days ago)
Get real dude, Micheal Scott did not make 267,000 in sales. Utterly impossible.
mitul prajapati (20 days ago)
Thank you Buddy for the great video. Really appreciate your effort. Not enough words to say thanks.
Jon-David Woods (20 days ago)
extremely disappointed that you did not use dundermifflin in your paper companies. Shame on your family, shame on your cows, shame on your chickens.
Desh Sharma (20 days ago)
Who noticed birth_day Vs birth_date?
raghunath behera (20 days ago)
marvellous
Satinder Joshi (21 days ago)
Simple nd best
Floree (21 days ago)
Finally finished this tutorial. Few days later and 46 pages of notes, i am so proud and confident i can start working on my uni assignment. Thank you very much.
Twinkle Shah (22 days ago)
Is there any website where all the content of this video is written?
OCaptain MyCaptain (22 days ago)
I really want to learn SQL but I don’t understand what you said so add the english subtitles please.
John Frö (22 days ago)
BEST Tutorial ever!! Thanks for all the help and all the effort you put into this!!
messi vag (22 days ago)
Hello , I would like to add to my CV that I know the basics in the Database ..How can I pass it on my CV ? Are there levels of database knowledge? Thanks.
Fenella Lopez (22 days ago)
Understood SQL completely with this video.Thanks Mike Dane:)
Amor ry (23 days ago)
LOL ALL THESE FUCKIN OFFICE REFERENCES!!!
Aamna Bari (24 days ago)
Can we add multiple constraints together in a command, for example UNIQUE and AUTO INCREMENT for a column of ID? If yes, please share how.
arush raj (24 days ago)
plz add subtitle plzz
arush raj (24 days ago)
plzz add subtitle
Vignesh Nadar (24 days ago)
1:52:00
Alessandro Mazzini (25 days ago)
Thank you a lot man!
Thomas Philipo (25 days ago)
Thank you alot for your noble work , so can you help us to prepare tutorial for database including various calculation and sorting

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.