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.
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. TH-cam is the best university ever. Thank you Kyle!
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'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.
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.
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.
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.
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.
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.
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!
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.
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!
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 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 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!
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.
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!
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.
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
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!
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!
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!!!!
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
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!
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.
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.
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.
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. 😌
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 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.
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 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 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!
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!
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.
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!
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.
Awesome!!! The best video there is on TH-cam about MySQL. Great introduction to how to insert values in tables (no where else to be found so well explained). Thanx, Brian
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😊☺
OK another shout out thank you for explaining the JOIN, not one instructor I've had explained it as well, not even JOIN and INNER JOIN are doing the same thing. 🙌
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 have a degree in IS but have interviews this week and need to brush up on SQL. This video has me feeling like a confident BADDIE now going into these interviews. Thank you!!!
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
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!
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 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!
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!
@@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. :)
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 so much for this video. I have no experience with SQL, I have just watched this weekend and I am feeling confident to do basic SQL queries. This has been a great use of my time to watch thank you for keeping explanations simple so I could pause the video (numerous times) to follow exactly what you were doing. 👍
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?
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.
TH-cam is the best university ever.
Thank you Kyle!
2 years later, this video is still one of the best resource to get started with SQL.
5 years*
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'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.
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.
You make everything so simple, I find myself going back to your videos all the time. Well done honestly.
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.
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.
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.
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.
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
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 just saved myself $3k from a college course! Thanks so much Kyle!!
In that current year , this video help me to cracked interview and passed it with some experience, now I am SQL, PL/SQL Developer
Cramming for an exam and this helped a lot, thank you for explaining everything so clearly and concisely!
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!
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
I studied databases at uni, used it at a job, and yet this is the best source of learning SQL I have ever seen
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 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!
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.
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!
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.
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
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 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!
Kyle, you are so eloquent and articulate; two qualities a must in a good teacher. Thank you.
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.
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!
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!!!!
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
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!
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
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.
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.
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.
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. 😌
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 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.
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 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.
This class took me from zero knowledge to something pretty decent. Now I can confidently write my SQL fearlessly.
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
Attending a course to get a certificate for MS SQL but I wanted to be prepared beforehand and this video was great! 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.
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!
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
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.
Great video using it in my database class.
There is no video on TH-cam that would explain SQL in 60 minutes better than this one and it's not even close.
This is so cool to share these sql knowledge, appreciate it! Keep going and get more subs!
I am really glad I could help.
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!
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.
This was a superb instructional demonstrartion of SQL! Really accesible for anyone with no prior info about Sql
Awesome!!! The best video there is on TH-cam about MySQL. Great introduction to how to insert values in tables (no where else to be found so well explained). Thanx, Brian
Great tutorial. Thank you.
By the way, the album names are "The Number of the Beast" (singular) and "Powerslave" (one word). Rock on!
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.
Such a valuable resource for someone, like myself, who has never used SQL. You made learning SQL very easy! Thank you sir!
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.
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...
So clear and simple to follow. Thank you!
OK another shout out thank you for explaining the JOIN, not one instructor I've had explained it as well, not even JOIN and INNER JOIN are doing the same thing. 🙌
Would you add an advanced version of this? Like triggers, procedure etc
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 !
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 have a degree in IS but have interviews this week and need to brush up on SQL. This video has me feeling like a confident BADDIE now going into these interviews. Thank you!!!
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
You are the best teacher I've ever had! Thank you so much!
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.
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!
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 !!
you have a calm tone/manner and good gestures to keep the content moving. Good job. +1 for Vanilla Ice hair.
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!
Just started learning SQL, this video is so beginner friendly. THANK YOU SO MUCH!!! 🙂
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.
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!
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 this video. I didn't even know what SQL was before watching this. Now I feel confident using it in my job.
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. :)
This video is a LIFE SAVER, 2 hours before my mid-term exam and helped me a TON! Thank you so much
The exercises are a great addition, really helped me consolidate what I learned. Thanks.
I come back here from time to time just to remind myself how helpful this video is
Thanks for this informative video on SQL .Very easy to understand the full lecture. If dumb like me can get it then anyone can.
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 liked that you start it from scratch. other are also good, but they skip important steps for beginners like me : )
thank you !
dude you are amazing! very easy to understand explanation.
Thank you!
The best concise video on the subject I have ever seen on the TH-cam. You are an extraordinary teacher!
why does this dude's hair look more perfect than my life
HAHAAHAH
one of the best SQL tutorial on TH-cam. Thanks a lot
Great video! Very clear and also good music taste ;-)
Thank you so much for this video. I have no experience with SQL, I have just watched this weekend and I am feeling confident to do basic SQL queries. This has been a great use of my time to watch thank you for keeping explanations simple so I could pause the video (numerous times) to follow exactly what you were doing. 👍