Learn SQL In 60 Minutes
HTML-код
- Опубликовано: 21 май 2024
- In this video we will cover everything you need to know about SQL in only 60 minutes. We will cover what SQL is, why SQL is important, what SQL is used for, the syntax of SQL, and multiple examples of SQL. SQL is the standard language for interacting with and manipulating data in a relational database system, and is one of the most important concepts you can learn in programming. It allows you to create, read, update, and delete data which is something nearly every application will need to do.
IMPORTANT: Exercises Worksheet Repository:
github.com/WebDevSimplified/L...
How to Install MySQL:
• How To Install MySQL (...
Outline:
[00:00] - Intro
[05:10] - SQL Syntax
[07:30] - Create Database
[09:20] - Drop Database
[10:34] - Use Database
[11:22] - Create Table
[13:01] - Alter Table
[14:47] - Drop Table
[15:08] - Create Table (Part 2)
[15:35] - Band Table
[15:55] - Not Null
[16:10] - Primary Key/ID/Auto Increment
[18:40] - Album Table
[20:05] - Foreign Key/Table Relationships
[23:05] - Insert Into
[25:40] - Select
[26:27] - Limit
[26:52] - Specific Columns
[27:18] - As/Alias Columns
[28:20] - Order By
[29:24] - Insert Into (Part 2)
[32:04] - Distinct Select
[33:07] - Update
[33:40] - Where
[33:15] - Less Than
[33:55] - Like String Filter
[37:26] - Or
[38:04] - And
[38:40] - Between
[39:20] - Is Null
[39:46] - Delete
[41:00] - Join
[43:25] - Inner/Left/Right Comparison
[46:42] - Aggregate Functions
[48:05] - Group By
[50:40] - Combined With Join
[51:15] - Alias Tables
[53:57] - Having vs Where
Learn X in Y Minutes Playlist:
bit.ly/2RscdMZ
Twitter:
/ devsimplified
GitHub:
github.com/WebDevSimplified
CodePen:
codepen.io/WebDevSimplified
#SQL #LearnSQL #MySQL
![MySQL Tutorial for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
After finishing this long video on learning SQL make sure you complete the exercises I have created in this repository. These exercises are by far the best way to learn SQL so I definitely advise you to attempt them. All of the knowledge you will need to complete the exercises is taught in this video. github.com/WebDevSimplified/Learn-SQL
Outline:
[00:00] - Intro
[05:10] - SQL Syntax
[07:30] - Create Database
[09:20] - Drop Database
[10:34] - Use Database
[11:22] - Create Table
[13:01] - Alter Table
[14:47] - Drop Table
[15:08] - Create Table (Part 2)
[15:35] - Band Table
[15:55] - Not Null
[16:10] - Primary Key/ID/Auto Increment
[18:40] - Album Table
[20:05] - Foreign Key/Table Relationships
[23:05] - Insert Into
[25:40] - Select
[26:27] - Limit
[26:52] - Specific Columns
[27:18] - As/Alias Columns
[28:20] - Order By
[29:24] - Insert Into (Part 2)
[32:04] - Distinct Select
[33:07] - Update
[33:40] - Where
[33:15] - Less Than
[33:55] - Like String Filter
[37:26] - Or
[38:04] - And
[38:40] - Between
[39:20] - Is Null
[39:46] - Delete
[41:00] - Join
[43:25] - Inner/Left/Right Comparison
[46:42] - Aggregate Functions
[48:05] - Group By
[50:40] - Combined With Join
[51:15] - Alias Tables
[53:57] - Having vs Where
Thanks !!!
This material is very helpful, thank you🙏
Thank you so much ☺️
Will do
Well, I must do this
2 years ago, this video helped me pass my interview and secure my job offer, with no experience in SQL.
LOL what company do you work for? There is no way just this video is enough to pass anything. Good but ultra basic.
Haha just passed my interview as well thanks to this video. Fine yes I already know Python for DS but this was super helpful as I never really studied sql
@@Helloimtheshiieet basics are what's needed, rest is just practice until you're pro
@@Helloimtheshiieet it should be enough, if you're not aiming for DBA or senior level developer job
Got the job ty for the tutorial man
Made this for myself but may help some of you.
CREATE - Make something new;
DROP - Delete something (risky);
ALTER - Change something that has already been created;
ADD - Add something to something;
USE - Specify what Database you are using;
NOT - Something should not be a specific value / Only select things that don’t have this value;
AUTO_INCREMENT - Automatically increases a specific value making it different in each column;
PRIMARY KEY - Lets you uniquely identify each row in a table, used with AUTO INCREMENT;
FOREIGN KEY - Allows us to add a foreign key;
REFERENCES - Allows us to reference something;
INSERT INTO - Allows us to insert something into a table (Adding something new not modifying it);
VALUES - Thing to be inserted (INSERT INTO table_name (columns) VALUES (‘Your value’) );
SELECT - Lets you select something (* selects everything);
FROM - Lets you specify from where you want to select it (FROM table);
LIMIT - Lets us limit how much something should be (With select for example);
UPDATE - Lets us update something that has already been created;
SET - Lets us change something that has already been set;
AS - Lets us change column names (SELECT column_name FROM table_name AS ‘new name’);
ORDER BY - Lets you specify by what order things should be displayed by.
ASC - The default order of things (Ascending);
DESC - Used with order by. Makes them order by descending order;
DISTINCT - Only selects unique values (SELECT DISTINCT name FROM table);
WHERE - Add a condition to your statement (SELECT * FROM table WHERE column = 22);
LIKE - If contains something (SELECT * FROM table WHERE column_name LIKE ‘%dea%’)
% Means as many characters as possible before and or after it. LIKE ‘%dea%’ would be true for death;
AND - Basically just && (SELECT * FROM table WHERE column > 22 AND column2 < 33);
BETWEEN - (SELECT * FROM table WHERE column BETWEEN 666 AND 999);
IS NULL - You can’t say = NULL (SELECT * FROM table WHERE release_year IS NULL);
DELETE - Allows you to delete something (DELETE * FROM table WHERE id = 22) (deletes a row);
JOIN ON - (SELECT * FROM table1 JOIN table2 ON table1.column1 = table2.column2);
Select everything where (compare table 1 and table 2 with this condition: ….) THE () ARE RUN FIRST
thanks man i copied this and im using as a reference
Jesus. So much information versus the amount of time. This is something you'd expect from a professor at a university who has been doing his job for decades. You're really good at teaching and sharing ideas/information, and especially without dragging everything out into many hours. Thanks for this.
Exactly!
Well said!!
Equally impressive is that the tempo is still easy to follow along and understand without having to pause and restart all the time (mostly at least)
ironically the university professors who do this for decades still cant teach it.
i have found him much better than any university professor ive had.
sat there thinking.....whats a string?
2 years later, this video is still one of the best resource to get started with SQL.
My college professor tried to teach us this stuff over the course of a semester and I was still having trouble understanding certain concepts. You've been able to clear up any confusion and solidify my understanding in an hour, you're a great teacher!
Because u didn't pay attention there, neither did I. So we both ended up here.
@@Mehraj_IITKGP😂 that's wild
This guy taught me a 4-year course in 60 minutes. Love it!
Hilariously simple and intuitive channel. You really do hit on everything one needs to know-- and at the very least, enough to give someone an actually running start given some work on their end. Thanks for the work you put into this.
One of the best tech tutorials I have ever seen. Definitely going to check out some more videos from you! Very grateful for you sharing your knowledge with us.
Thank you bro. I recently got certified in IT, and have been learning as much as I can including getting AWS certified. I needed to get solid in SQL for work purposes and this was straight to the point, unlike the many other videos out there that blow hot air for 4 hours or more.
This gave a quick start to SQL even though I was having very limited knowledge on this. The way you have touched the basics while making each step clear is really superb. Thanks a lot for your efforts, really appreciate it.
I understand JOINS now! I've taken a class on SQL and watched plenty of videos, but nobody has explained joins as elegantly as you have : ) It's just that inner queries data where there is a match between both tables, and left joins also add data where the left table doesn't have an item in the right table, and right joins also add data where the right table doesn't have an item in the left table.
I doubted that I would get my head around this, but working with data, SQL is more and more a must have. You nailed this content, provided the needed structure and logic, explained rationale and highlighted it all with relatable examples. You've blown my mind and rocked my world. Thank you. Liked and subscribed to the channel, looking forward to downloading the examples and learning more
Now I know why she always texts me in capital letters. Its not actually her caps lock is broken, She is a SQL developer
INSERT
an*
@@blasphemxus LOL
Nice joke
lol
I love your content dude. Been watching a fair few videos of yours and they're all great! Straight to the point, no bullshit and definitely informative. Keep up the good work!
#eazzylearninglab fallow us
Thank you so much, Kyle!!! For procrastinators like me, it was very well organized and condensed content!
I literally finished it 20 minutes before my coding test and did quite well haha
You summed up my entire SQL experience working in a startup. Good job! Also, junior devs, we ought to also learn about operating Cloud-based DB servers, most if not all of your projects will make use of online DB servers, than local DBs in your intranet (big companies like banks, insurance companies use legacy tech for the physical safety of their data-stores) Keep learning!
Cramming for an exam and this helped a lot, thank you for explaining everything so clearly and concisely!
Awesome!!! The best video there is on RUclips about MySQL. Great introduction to how to insert values in tables (no where else to be found so well explained). Thanx, Brian
I'm 68 and have always used Microsoft Access to build databases. Recently I changed to using an Apple Macbook Pro that doesn't recognise Access so I've had to learn to program with SQL. You video is brilliant for explaining the process so I'd like to thank you.
I just saved myself $3k from a college course! Thanks so much Kyle!!
This is so helpful. I am taking SQL and was having a hard time, but this video really cleared up some questions I had. Great content.
I just needed a simple way to get started with SQL and you helped me with that. Wonderful video, insta-subscribe.
Thanks! I'm glad I could help!
Such a great material, very beginner friendly. I searched tons of videos before tumbling upon this one and it just cleared all the basics I required to know before learning the advanced stuff. Really appreciate your effort !! Thanks !!
As someone who has dived in SQL databases for many years I applaud the amazing effort in covering nearly all you need to learning SQL in under an hour. But I’m not gonna lie, I did cringed a little when you created a field called name due to it normally being a reserved word. Regardless, amazing lesson.
This is so cool to share these sql knowledge, appreciate it! Keep going and get more subs!
I am really glad I could help.
Such a great presentation - I appreciate the way that you step through the different queries without losing the focus. You did more to explain Joins in 5 minutes than a dedicated 30 minute join video could do.
So much of information neatly packaged in a 1 hour video. This was the first tutorial where I was hooked from start to finish and didn't realize that I had reached the end of the lesson. You are such a great teacher, time just flew by watching your video.
This can be actually really helpfull for some accountant jobs, or other where you only need to create some basic views over data. You probably should also include LATERAL (MySQL) or APPLY (MSSQL) and touch data types / implicit conversion / CONVERT/CAST functions, which can be really handy while creating reports :). Basic SQL is a must have in office jobs nowadays, so well done.
I love your tutorial. You've explain things very clearly and simple which makes your explanation very easy to understand without any confusions. Thank you!
Thanks for taking the time to make this video!
I'm trying to study RPA to get a job in that field, and my dad told me SQL is pretty much essential to understanding how that stuff works.
So here I am lol. Great video, going to try out those worksheets and hope I can get a job sometime in the coming months :P
having pursued a computer science degree for a couple years and coming SQL, this is wayyyy easier than a C++ or a Java. Thank you so much for making this!
Python >
i like how he saud way with 4 y's
Finally found the most informative SQL tutorial. My love for databases just refreshed after being gone from IT field for 8 years. I never enjoyed watching any such videos for an hour, just this one. 😌
One of the best SQL refreshers - well structured and concise information in 1 hour. Also the examples and exercises were very helpful to solidify knowledge.
You make everything so simple, I find myself going back to your videos all the time. Well done honestly.
Kyle, you are so eloquent and articulate; two qualities a must in a good teacher. Thank you.
It’s been 24 years since my sql course - back then it was pure theory - and I touch the stuff rarely in my professional career so I always get weeks/months to forget the exact syntax; this week I needed it twice after not touching it for ~7 months... this is a good primer and explains things clearly. Very good material!
Are you a self taught? I'm asking this because I'm currently learning this stuff for my future career and hoping companies accept self taught
@@ghzich017 I had a semester in university, but it was pure theory and we didn’t even touch a proper piece of sql in those days; still, in my career I was exposed to several sql servers and sometimes you just need to get in there to make things work. I don’t think any company will have issues with self taught, they might look for a certification if the core of the job is sql - ex. A d a function -but in general you will hardly ever touch the stuff….companies will more appreciate your initiative on willingness to learn new things. Golden tip regarding databases (applies to a lot of other things that are ‘difficult’ as well): if you touch it, you own it. So don’t poke around too much!
@@ghzich017 they accept.
@@ghzich017 Darn near everyone in tech is self taught. You'll have to be to pick up on things as they change. Degrees and certifications are used by Human Resources to screen candidates. Enterprise level companies who work with the government will place more emphasis on college degrees. Others may want certifications in terms of IT. Web Development is so vast, broad, and constantly changing to where they just want to know if you can code. They'll measure it by your sample portfolio web projects, and ideally want to see that you've worked on someone's website prior to applying to the job. Solution: Build a Real Estate Website, a Restaurant Website, and a Landing Page for your portfolio... And learn WordPress so you can deploy a website content management system for a friend or someone with a business for free so you can have a reference and real live website/client you've already listened to, and worked with.
hi Kyle, I just wanna say thankyou so much, for this, and for all of your vids, you've been a big part of where i am right now in my career, i cannot thank you enough.. please continue making these tutorials, you are helping a lot of aspiring developers including me.. thankyou!
I forgot almost all sql lesson that i've learned on my campus. And it took exactly one hour to remember it. Great video man i highly recommend this even for fresher.
Excellent presentation. I learned to program in dBase II years ago and have dabbled with SQL over the years and your video is great as a refresher. Thank you!
Can't thank you enough, Kyle! you made me take my confidence in my skills to a whole another level. Thanks alot!!!!
You're welcome! I'm really glad I can help.
Very helpful and simplified to the core. Keep up man!
First guide I found and decided to watch to learn more about SQL and something tells me I couldn't have picked a better video to start with. Thank you!
You made this super understandable for someone who knows absolutely nothing about coding. You are a great teacher and will begin to dive deeper into coding and hopefully be proficient in SQL.
So clear and simple to follow. Thank you!
The exercises are a great addition, really helped me consolidate what I learned. Thanks.
you have a calm tone/manner and good gestures to keep the content moving. Good job. +1 for Vanilla Ice hair.
I think you have the simplest, easiest to understand vidz tutorial in mySql. Thanks for the unselfish sharing, Sir!
I love your videos, its very detailed and walks you through every step and why we are doing what are doing. I also like how you walk us through the process from start to finish, from creating the data to putting it in order and tweeking it so it makes sense. Im very new to SQL and always need someone to hold my hand through the process so I can understand it, its just how i learn because i like to know every detail, how and why im doing something. I Believe that if i dont know why im doing something, then i dont really know what im doing. You can only know something when you are able to teach it to someone else and they understand it. I come from a Engineering background and that's what i believe. I love your video, Simple and straight to the point.
Thank you
Well done, I honestly thought I'd be bored outta my mind watching an hour long video about sql-ing but I wasn't. That was v detailed and v thorough. It kind of makes me feel a little more confident in getting a CERT at a computer vocational school so I can get a data analyst entry level job.
Good approach.
PPP aww re
You are awesome! This video is gold for me. I feel like I got so much from this video. The way you were able to build upon each previous example to further explain new concepts was genius and exactly what I needed to really feel like I digested how to use each new statement in a relevant way. So glad I stumbled on this video early on because I feel I could have easily gotten lost with some other videos I've browsed through. Thank you for this!
Thank you, this was my first step on what will probably be a long career path of using SQL. I will always remember the youthful phenom that showed me the way.
I've watched many tutorials but i find this one which is one of the best i learned so much in just 60 min's.
i have a data analyst interview and while there need to solve some SQL questions: would you suggest just watching this video and do his exercises or watch other videos as well (some take up to 4h)? i have 2days left and want to make the best out of it. Thanks in advance!
You are the best teacher I've ever had! Thank you so much!
The best concise video on the subject I have ever seen on the RUclips. You are an extraordinary teacher!
This video is a LIFE SAVER, 2 hours before my mid-term exam and helped me a TON! Thank you so much
Anyone else here before a job interview?
Good luck!
haha me too, i have one tomorrow!
@@amoghlakkanagavi10 How did it go ?
Bro..is it enough for a job interview in a company like tcs??be honest please!!!
@@damansharma6737 Umm. I would say that it wasn't enough for me for the interview as nothing beats working with SQL and putting in time. But however once I got the job, my manager appreciated that I knew these skills. :)
Great video using it in my database class.
This is awesome! Much more better than input everything one piece after one piece. Just Love You!!!
Dude that’s very nice of you to do these videos and exercises. Thank you man! I hope you’re having a good day
The comparison to CSS is extremely useful.
They are both extremely simple to do easy things but become exponentially more difficult when you need to do something more complex.
For anyone reading this - everything from 0:00 to 40:00 are the absolute basics.
Great video! Very clear and also good music taste ;-)
Thanks so much for this! Been scratching my head with joins and aggregates for weeks and felt so accomplished when I went through the worksheet exercises and got the last question down without using hints!
Genuine thanks, this helped me A LOT for an upcoming exam. I truly appreciate your work & effort.
Thanks for this informative video on SQL .Very easy to understand the full lecture. If dumb like me can get it then anyone can.
I am wondering how everybody's job interviews went and i am hoping one day i will also have an interview
one day soon you will.
4 years pass and this video is still so helpful.
That's just no need to go to any online courses like edX, DataCamp, Coursera, bootcamps or schools.
RUclips is the best university ever.
Thank you Kyle!
Definitely a great video to get a quick basic knowledge about SQL!
It was very helpful. Thank you!!
00:00 Learn SQL, the universal language for working with databases.
06:49 Creating a database and table in SQL
12:59 Learn how to create and alter tables in Sequel with different columns and data types
19:14 Creating tables and inserting data in a SQL database
25:31 Learn how to select and order data in a SQL table
31:49 Learn how to update and filter data in SQL databases
38:24 Sequel can be used to create, read, update and delete data as well as to join tables together on different properties to create relations between data.
44:53 Understanding join types and aggregate functions in SQL
51:05 Use 'HAVING' instead of 'WHERE' to filter by aggregate data
Would you add an advanced version of this? Like triggers, procedure etc
Thank you so much ! You are so great at explaining things. You make everything look so simple. I hope you keep posting this kind of videos. You clarify so many ideas on this video.
no words, i have no words how to thank you for such a simplified and super explanation..god blesses us by giving you to us.stay blessed and keep progressing.thanks a lot kyle :) you are a GEM
dude you are amazing! very easy to understand explanation.
Thank you!
You helped me more than my teacher. Thanks! ;)
DIANA-FLORINA ROMAN u look pretty.
Such a valuable resource for someone, like myself, who has never used SQL. You made learning SQL very easy! Thank you sir!
This was a superb instructional demonstrartion of SQL! Really accesible for anyone with no prior info about Sql
Simply Super!!! Awesome.. He covered almost all topics in sql.. And explanation was too good. Easily understandable from beginner to expert.... I thought of revising sql after working with this 60 mints of video I got full confidence that i remember every concept on handy😊☺
Thank you so much! I am really glad you enjoyed the video and that it was helpful for you.
and all great metal bands.
hey, your videos are very clear and to the point! and could you also make some videos for python as well? that will be so helpful!
Thought of covering SQL concepts for a very long time, but couldn't able to complete any course. But this is a good booster. Thank you so much for all the efforts you put into to make all these.
I have an interview tomorrow where they need someone who is familiar with sql. I am feeling much more confident after watching this video and having no prior experience, thanks Kyle!
@@LaraUAE it went really well thank you for asking, I felt pretty confident through out the entire process! The company is looking for a software dev who can work with node and express but they handle most of their logic on sql databases so that’s why there was such a strong emphasis on knowing SQL in the job description. Surprisingly they didn’t ask too many technical questions lol thank god! I should know next week if I got it or not 🙏
How did your interview go? Hoping it went well 🙌
@@LaraUAE nice lol it sounds like we both lucked out with the sql questions! Sounds like the interview went well and I wish you the best 🙌 hopefully we both make it back to this comment section with new jobs
why does this dude's hair look more perfect than my life
HAHAAHAH
"Learn SQL in 60 min"
Does it in 56:24. Boss mode 😁
he left 5 min for questions... obviously were none....
I'm taking a database class right now using MySQL, and I have a midterm tomorrow. I can't believe I went this semester so far manipulating databases for assignments (and doing good on them), yet still not understanding some of these basics!! You killed this video. Thanks.
Thank you for this video, I've been trying to learn SQL for some time now and this was straight to the point and also you did it with metal music examples, which was extra awesome!
your intense stare gave me the impression that you would hype your voice. to my surprise it is very chill.
Others on vacation: lemme enjoy outside view while traveling
Me : * lemme just Super Quickly Learn ( SQL) sql
Thank you so much for this video! I'm learning both English and SQL, this was crystal clear! :D
Watched this video three years ago and returning now as I have to reminisce. Great teaching and perfectly simple. I tried to re-visit the DSC book which in all fairness contains alot of great information but is extremely heavy and the material is made overly complex. So thanks alot for this. This is high quality.
Summary/Skip2points.
- 00:00 - 05min = Introduction
- 05:11 - 07min = Syntax of MySQL
- 07:30 - 23min = Creating databases and tables in MySQL workbench
- 23:03 - 40min = Basic query commands
- 40:56 - end = Unique and Powerful features to know for beginners.
Normal ppl: Ima go to the park and play! (or whatever normal ppl do)
Me: Ima watch a 1 hour SQL tutorial for fun!
Others on vacation: lemme enjoy outside view while traveling
Me : * lemme just Super Quickly Learn ( SQL) sql
Normal people, why the world is in a mess.
wow you're so special and quirky 😐
Wow this is one of the best explanations I have seen on youtube, period. Great job man!!!
Great introductory video on how to use SQL. i shall definitely be looking to the examples you have in the repository. thanks again.
Learn SQL in 60 minutes
Me: watches in 2x speed🥶🥵
🤣🤣
would you say this is a sequel to the sql vid
Dolphin coming in hot with the killer one liners. That must make the next video SQL cubed.
After so many years, this video on SQL is quite on point and helpful to someone like me who's just beginning to learn SQL. I'll checkout your other recent videos as well because your method of teaching is great.
I like that you used metal bands for this tutorial haha. Made this video more interesting for me. Huge thumbs up for you buddy
ahh you are so handsome and you are helping me for my exam, my savior prince charming
bak şuan düştü
I'm glad to have found this channel. Thank you so much.
Duuuuude !! This is hands down one the of best tutorials like ever ! very informative yet easy to follow
It was lucid and one of the best videos for beginners! Thank you.