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
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
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.
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!
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
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.
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!
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'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.
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!
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!
@@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 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.
This video is a great quick guide to learning SQL in just 60 minutes! The explanations are simple and easy to follow, making it perfect for beginners. I recently joined my son for a project at Moonpreneur, and this really helped me get a clearer understanding. Highly recommend it for anyone looking to get started with databases.
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!
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.
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.
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.
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
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.
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!
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
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
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.
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.
Typing in data is sometimes tedious, so I will leave this here: ('The Number of the Beasts', 1985, 1), ('Power Slave', 1984, 1), ('Nightmare', 2018, 2), ('Nightmare', 2010, 3), ('Test Album', NULL, 3); Great tutorial, very practical!
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.
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.
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. 😌
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.
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!
5 years later this video just save me from wasting my time! You are great teacher and explainer ! I hope you still make more video and get million views!
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.
Goodness me! I can't believe I just stumbled upon such an important video. I just need to practice 10 times and 80% of my requires skills covered! Thank you so much. I'll preserve this video, it my greatest pathway to data analytics! I can't believe it was made 5 years ago already? Where on earth have I been🙊🙊🙊
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.
Finished my bachelor's at the start of this pandemic. No internship or entry levels for months! I ended up taking a low wage job for the last year, and recently starting applying again. Sadly, I lost a lot of my knowledge, but your video helped a lot! Not overly explainy on each syntaxes. Thanks :)
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.
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.
@@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. :)
Currently a Computer Science Major and this has helped me alot. Looking to snag a associate level job in in IT/Database Management. Thanks and wish me luck!!!!
I have a job interview in 2 day in accounting and it specialist and this video really helped me regain the knowledge that i once had in sql. Thank you, this is one of my dream jobs!
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.
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😊☺
This is a comprehensive video for ppl who are are starting with SQL/MySQL. Pretty much have everything. Good job! Can you please post a hands-on video on advanced database concepts like normalization, partitioning, sharding etc. It would be very useful!
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 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
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 !!
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 a great amount! As I am coding for for over a decade, but never touched any DB stuff. This was exactly what was needed! Short easy to follow. The extra exercises made all the difference! Thanks again!
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!
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!
Thank you for the usual brilliance :) - For Newbies such as myself: One may use short-cut keys: Ctrl+Shift+Enter to execute All & Ctrl+Enter to Execute selected line.
It is great course indeed but as a remainder I would like to mention that if you give something 'Primary Key' status it will be considered as 'Not Null' and 'Unique' at the same time.So actually you would not need to use 'Not Null' keyword while creating 'id''s.Because afterwards you make it as 'Primary Key' anyway.Thank you so much for your effort!
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.
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.
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.
I started a career in SQL almost 3 years ago with a 8-10 hrs SQL youtube video tutorial thinking SQL wasn't that complicated, believe me is not that easy, I'm now struggling with database programming, stored procedures and huge raw data files. You need to practice syntax A LOT then come with smart ways to transform and load data which somethimes hurts my brain lol. I got an entry job where they used Oracle, I failed miserably and quit, now I am working with sql server which is way more forgiving. By the way I don't have a degree in computers or programming.
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
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
This guy taught me a 4-year course in 60 minutes. Love it!
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.
5 years*
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
@@Mehraj_IITKGP VERY TRUE 😀😀😀😀. AT TIMES, WE ARE QUICK TO BLAME OUR PAST TEACHERS WHEN INFACT IT'S OUR FAULT.
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
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.
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!
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'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.
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
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.
Cramming for an exam and this helped a lot, thank you for explaining everything so clearly and concisely!
This video is a great quick guide to learning SQL in just 60 minutes! The explanations are simple and easy to follow, making it perfect for beginners. I recently joined my son for a project at Moonpreneur, and this really helped me get a clearer understanding. Highly recommend it for anyone looking to get started with databases.
I just saved myself $3k from a college course! Thanks so much Kyle!!
You make everything so simple, I find myself going back to your videos all the time. Well done honestly.
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!
In that current year , this video help me to cracked interview and passed it with some experience, now I am SQL, PL/SQL Developer
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.
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.
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!
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.
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
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.
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!
I studied databases at uni, used it at a job, and yet this is the best source of learning SQL I have ever seen
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
Thank you so much!
thanks buddy
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
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.
This class took me from zero knowledge to something pretty decent. Now I can confidently write my SQL fearlessly.
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.
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.
Typing in data is sometimes tedious, so I will leave this here:
('The Number of the Beasts', 1985, 1),
('Power Slave', 1984, 1),
('Nightmare', 2018, 2),
('Nightmare', 2010, 3),
('Test Album', NULL, 3);
Great tutorial, very practical!
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.
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
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. 😌
There is no video on RUclips that would explain SQL in 60 minutes better than this one and it's not even close.
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.
I have studied SQL like 10 times in detail. I forget everytime. Never used but it is still asked in interviews.
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
5 years later this video just save me from wasting my time! You are great teacher and explainer ! I hope you still make more video and get million views!
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
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.
Great video using it in my database class.
Sir , this is worth 2 months of studying in my university u just made it in 60 minutes you are definitely the best 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.
Goodness me! I can't believe I just stumbled upon such an important video. I just need to practice 10 times and 80% of my requires skills covered! Thank you so much. I'll preserve this video, it my greatest pathway to data analytics! I can't believe it was made 5 years ago already? Where on earth have I been🙊🙊🙊
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.
Finished my bachelor's at the start of this pandemic. No internship or entry levels for months! I ended up taking a low wage job for the last year, and recently starting applying again.
Sadly, I lost a lot of my knowledge, but your video helped a lot! Not overly explainy on each syntaxes.
Thanks :)
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.
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.
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. :)
Currently a Computer Science Major and this has helped me alot. Looking to snag a associate level job in in IT/Database Management. Thanks and wish me luck!!!!
This is so cool to share these sql knowledge, appreciate it! Keep going and get more subs!
I am really glad I could help.
I have a job interview in 2 day in accounting and it specialist and this video really helped me regain the knowledge that i once had in sql. Thank you, this is one of my dream jobs!
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.
Kyle, you are so eloquent and articulate; two qualities a must in a good teacher. Thank you.
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.
This is a comprehensive video for ppl who are are starting with SQL/MySQL. Pretty much have everything. Good job! Can you please post a hands-on video on advanced database concepts like normalization, partitioning, sharding etc. It would be very useful!
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
Tomorrow I have an interview and they will make a test on SQL and Transact SQL, I am here to refresh my memory, thanks for this big effort !
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
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 !!
Attending a course to get a certificate for MS SQL but I wanted to be prepared beforehand and this video was great! Thank you!
Would you add an advanced version of this? Like triggers, procedure etc
I come back here from time to time just to remind myself how helpful this video is
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 a great amount! As I am coding for for over a decade, but never touched any DB stuff. This was exactly what was needed! Short easy to follow. The extra exercises made all the difference! Thanks again!
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.
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!
So clear and simple to follow. Thank you!
Great tutorial. Thank you.
By the way, the album names are "The Number of the Beast" (singular) and "Powerslave" (one word). Rock on!
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 have watched many videos but, i didn't understand but this time learn the new thinks like a Create database, select, from, left join etc...
Thanks for this informative video on SQL .Very easy to understand the full lecture. If dumb like me can get it then anyone can.
My professor makes us watch about 2 hour long videos per assignment. And after the videos I still am confused. But watching you just helps so much.
You are the best teacher I've ever had! Thank you so much!
Thank you for the usual brilliance :) - For Newbies such as myself: One may use short-cut keys: Ctrl+Shift+Enter to execute All & Ctrl+Enter to Execute selected line.
The exercises are a great addition, really helped me consolidate what I learned. Thanks.
I am going to learn this on first day of my SQL class so I will have a head start. Thank you
Very helpful and simplified to the core. Keep up man!
It is great course indeed but as a remainder I would like to mention that if you give something 'Primary Key' status it will be considered as 'Not Null' and 'Unique' at the same time.So actually you would not need to use 'Not Null' keyword while creating 'id''s.Because afterwards you make it as 'Primary Key' anyway.Thank you so much for your effort!
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.
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!
This was a superb instructional demonstrartion of SQL! Really accesible for anyone with no prior info about Sql
dude you are amazing! very easy to understand explanation.
Thank you!
Can you imagine that in Hungary we learn this easy thing for 4 years? -_- You are just so much better than all my 5 programming teachers
why does this dude's hair look more perfect than my life
HAHAAHAH
Thank you, learned SQL through this video only and cleared my interview.
"Learn SQL in 60 min"
Does it in 56:24. Boss mode 😁
he left 5 min for questions... obviously were none....
you have a calm tone/manner and good gestures to keep the content moving. Good job. +1 for Vanilla Ice hair.
Great video! Very clear and also good music taste ;-)
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.
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.
Thank you for this video. I didn't even know what SQL was before watching this. Now I feel confident using it in my job.
your intense stare gave me the impression that you would hype your voice. to my surprise it is very chill.
I started a career in SQL almost 3 years ago with a 8-10 hrs SQL youtube video tutorial thinking SQL wasn't that complicated, believe me is not that easy, I'm now struggling with database programming, stored procedures and huge raw data files. You need to practice syntax A LOT then come with smart ways to transform and load data which somethimes hurts my brain lol.
I got an entry job where they used Oracle, I failed miserably and quit, now I am working with sql server which is way more forgiving.
By the way I don't have a degree in computers or programming.
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
i liked that you start it from scratch. other are also good, but they skip important steps for beginners like me : )
thank you !