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

@TheLofiDragon

4 жыл бұрын

Thanks !!!

@darboewuday4275

3 жыл бұрын

This material is very helpful, thank you🙏

@TyrellJoanna

2 жыл бұрын

Thank you so much ☺️

@ajalanbrown2200

2 жыл бұрын

Will do

@antoniofuller2331

2 жыл бұрын

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.

@Helloimtheshiieet

2 жыл бұрын

LOL what company do you work for? There is no way just this video is enough to pass anything. Good but ultra basic.

@kristiandemello

2 жыл бұрын

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

@user-jd8jx5fe6r

2 жыл бұрын

@@Helloimtheshiieet basics are what's needed, rest is just practice until you're pro

@kir9290

2 жыл бұрын

@@Helloimtheshiieet it should be enough, if you're not aiming for DBA or senior level developer job

@DevSecOpsAI

2 жыл бұрын

Got the job ty for the tutorial man

Made this for myself but may help some of you. CREATE - Make something new; DROP - Delete something (risky); ALTER - Change something that has already been created; ADD - Add something to something; USE - Specify what Database you are using; NOT - Something should not be a specific value / Only select things that don’t have this value; AUTO_INCREMENT - Automatically increases a specific value making it different in each column; PRIMARY KEY - Lets you uniquely identify each row in a table, used with AUTO INCREMENT; FOREIGN KEY - Allows us to add a foreign key; REFERENCES - Allows us to reference something; INSERT INTO - Allows us to insert something into a table (Adding something new not modifying it); VALUES - Thing to be inserted (INSERT INTO table_name (columns) VALUES (‘Your value’) ); SELECT - Lets you select something (* selects everything); FROM - Lets you specify from where you want to select it (FROM table); LIMIT - Lets us limit how much something should be (With select for example); UPDATE - Lets us update something that has already been created; SET - Lets us change something that has already been set; AS - Lets us change column names (SELECT column_name FROM table_name AS ‘new name’); ORDER BY - Lets you specify by what order things should be displayed by. ASC - The default order of things (Ascending); DESC - Used with order by. Makes them order by descending order; DISTINCT - Only selects unique values (SELECT DISTINCT name FROM table); WHERE - Add a condition to your statement (SELECT * FROM table WHERE column = 22); LIKE - If contains something (SELECT * FROM table WHERE column_name LIKE ‘%dea%’) % Means as many characters as possible before and or after it. LIKE ‘%dea%’ would be true for death; AND - Basically just && (SELECT * FROM table WHERE column > 22 AND column2 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

@sxythextr

Ай бұрын

thanks man i copied this and im using as a reference

Jesus. So much information versus the amount of time. This is something you'd expect from a professor at a university who has been doing his job for decades. You're really good at teaching and sharing ideas/information, and especially without dragging everything out into many hours. Thanks for this.

@vladekzbozinek

2 жыл бұрын

Exactly!

@ssekitolekojames5660

2 жыл бұрын

Well said!!

@lucasraihle1634

Жыл бұрын

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)

@xsuploader

Жыл бұрын

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.

@chrisg1234fly

Жыл бұрын

sat there thinking.....whats a string?

2 years later, this video is still one of the best resource to get started with SQL.

My college professor tried to teach us this stuff over the course of a semester and I was still having trouble understanding certain concepts. You've been able to clear up any confusion and solidify my understanding in an hour, you're a great teacher!

@Mehraj_IITKGP

7 ай бұрын

Because u didn't pay attention there, neither did I. So we both ended up here.

@gintoki_sakata__

5 ай бұрын

​@@Mehraj_IITKGP😂 that's wild

This guy taught me a 4-year course in 60 minutes. Love it!

Hilariously simple and intuitive channel. You really do hit on everything one needs to know-- and at the very least, enough to give someone an actually running start given some work on their end. Thanks for the work you put into this.

Now I know why she always texts me in capital letters. Its not actually her caps lock is broken, She is a SQL developer

@blasphemxus

3 жыл бұрын

INSERT

@pramodk4565

3 жыл бұрын

an*

@rohankademani6406

3 жыл бұрын

@@blasphemxus LOL

@rohankademani6406

3 жыл бұрын

Nice joke

@hibaamir3903

3 жыл бұрын

lol

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.

Thank you bro. I recently got certified in IT, and have been learning as much as I can including getting AWS certified. I needed to get solid in SQL for work purposes and this was straight to the point, unlike the many other videos out there that blow hot air for 4 hours or more.

This gave a quick start to SQL even though I was having very limited knowledge on this. The way you have touched the basics while making each step clear is really superb. Thanks a lot for your efforts, really appreciate it.

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.

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

2 жыл бұрын

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

@irbaboon1979

2 жыл бұрын

@@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!

@brunonegraozica5459

Жыл бұрын

@@ghzich017 they accept.

@busyrand

Жыл бұрын

@@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.

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!

@Helloimtheshiieet

2 жыл бұрын

Python >

@bigcat3177

Жыл бұрын

i like how he saud way with 4 y's

Cramming for an exam and this helped a lot, thank you for explaining everything so clearly and concisely!

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!

@aanaybhure7079

2 жыл бұрын

#eazzylearninglab fallow us

I just needed a simple way to get started with SQL and you helped me with that. Wonderful video, insta-subscribe.

@WebDevSimplified

4 жыл бұрын

Thanks! I'm glad I could help!

I'm 68 and have always used Microsoft Access to build databases. Recently I changed to using an Apple Macbook Pro that doesn't recognise Access so I've had to learn to program with SQL. You video is brilliant for explaining the process so I'd like to thank you.

I just saved myself $3k from a college course! Thanks so much Kyle!!

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

Anyone else here before a job interview?

@WebDevSimplified

5 жыл бұрын

Good luck!

@amoghlakkanagavi10

4 жыл бұрын

haha me too, i have one tomorrow!

@JoseMorales-gm4lr

4 жыл бұрын

@@amoghlakkanagavi10 How did it go ?

@damansharma6737

3 жыл бұрын

Bro..is it enough for a job interview in a company like tcs??be honest please!!!

@shrijitkoirala

3 жыл бұрын

@@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. :)

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 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

Awesome!!! The best video there is on KZread 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.

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.

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.

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 !!

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.

Kyle, you are so eloquent and articulate; two qualities a must in a good teacher. Thank you.

You make everything so simple, I find myself going back to your videos all the time. Well done honestly.

Great video using it in my database class.

So clear and simple to follow. Thank you!

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.

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.

This is so cool to share these sql knowledge, appreciate it! Keep going and get more subs!

@WebDevSimplified

5 жыл бұрын

I am really glad I could help.

Excellent presentation. I learned to program in dBase II years ago and have dabbled with SQL over the years and your video is great as a refresher. Thank you!

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.

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.

Very helpful and simplified to the core. Keep up man!

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!

@antoninoadornetto6958

2 жыл бұрын

@@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 🙌

@antoninoadornetto6958

2 жыл бұрын

@@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

Thanks for taking the time to make this video! I'm trying to study RPA to get a job in that field, and my dad told me SQL is pretty much essential to understanding how that stuff works. So here I am lol. Great video, going to try out those worksheets and hope I can get a job sometime in the coming months :P

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!

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. 😌

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. KZread is the best university ever. Thank you Kyle!

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!

I am wondering how everybody's job interviews went and i am hoping one day i will also have an interview

@joggyjames

2 жыл бұрын

one day soon you will.

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.

@Graenelolz

3 жыл бұрын

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!

This video is a LIFE SAVER, 2 hours before my mid-term exam and helped me a TON! Thank you so much

I think you have the simplest, easiest to understand vidz tutorial in mySql. Thanks for the unselfish sharing, Sir!

Can't thank you enough, Kyle! you made me take my confidence in my skills to a whole another level. Thanks alot!!!!

@WebDevSimplified

5 жыл бұрын

You're welcome! I'm really glad I can help.

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, 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.

Dude that’s very nice of you to do these videos and exercises. Thank you man! I hope you’re having a good day

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.

@raahi8581

2 жыл бұрын

Good approach.

@milisahu4795

Жыл бұрын

PPP aww re

The exercises are a great addition, really helped me consolidate what I learned. Thanks.

you have a calm tone/manner and good gestures to keep the content moving. Good job. +1 for Vanilla Ice hair.

The best concise video on the subject I have ever seen on the KZread. You are an extraordinary teacher!

You are the best teacher I've ever had! Thank you so much!

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.

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!

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.

Thanks for this informative video on SQL .Very easy to understand the full lecture. If dumb like me can get it then anyone can.

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

Such a valuable resource for someone, like myself, who has never used SQL. You made learning SQL very easy! Thank you sir!

This is awesome! Much more better than input everything one piece after one piece. Just Love You!!!

Great video! Very clear and also good music taste ;-)

"Learn SQL in 60 min" Does it in 56:24. Boss mode 😁

@MrDesgulsh

2 жыл бұрын

he left 5 min for questions... obviously were none....

I studied databases at uni, used it at a job, and yet this is the best source of learning SQL I have ever seen

I'm glad to have found this channel. Thank you so much.

You helped me more than my teacher. Thanks! ;)

@rajaa2852

4 жыл бұрын

DIANA-FLORINA ROMAN u look pretty.

dude you are amazing! very easy to understand explanation.

@WebDevSimplified

4 жыл бұрын

Thank you!

This was a superb instructional demonstrartion of SQL! Really accesible for anyone with no prior info about Sql

Genuine thanks, this helped me A LOT for an upcoming exam. I truly appreciate your work & 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

Would you add an advanced version of this? Like triggers, procedure etc

Others on vacation: lemme enjoy outside view while traveling Me : * lemme just Super Quickly Learn ( SQL) sql

you teach this in a way that makes SQL feel natural! Great job!

You are awesome! This video is gold for me. I feel like I got so much from this video. The way you were able to build upon each previous example to further explain new concepts was genius and exactly what I needed to really feel like I digested how to use each new statement in a relevant way. So glad I stumbled on this video early on because I feel I could have easily gotten lost with some other videos I've browsed through. Thank you for this!

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😊☺

@WebDevSimplified

4 жыл бұрын

Thank you so much! I am really glad you enjoyed the video and that it was helpful for you.

@hellelo.5840

4 жыл бұрын

and all great metal bands.

why does this dude's hair look more perfect than my life

@hazelnut8828

7 ай бұрын

HAHAAHAH

Definitely a great video to get a quick basic knowledge about SQL! It was very helpful. Thank you!!

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.

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!

your intense stare gave me the impression that you would hype your voice. to my surprise it is very chill.

Thank you so much ! You are so great at explaining things. You make everything look so simple. I hope you keep posting this kind of videos. You clarify so many ideas on this video.

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!

Normal ppl: Ima go to the park and play! (or whatever normal ppl do) Me: Ima watch a 1 hour SQL tutorial for fun!

@princess8064

3 жыл бұрын

Others on vacation: lemme enjoy outside view while traveling Me : * lemme just Super Quickly Learn ( SQL) sql

@DaleDix

3 жыл бұрын

Normal people, why the world is in a mess.

@mypenisisunbelievablysmall5650

3 жыл бұрын

wow you're so special and quirky 😐

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.

Every single time i think about something who is related to code, instantly your video with a great explanations appears.

Thank you for this video, I've been trying to learn SQL for some time now and this was straight to the point and also you did it with metal music examples, which was extra awesome!

Learn SQL in 60 minutes Me: watches in 2x speed🥶🥵

@vanavandi6012

2 жыл бұрын

🤣🤣

would you say this is a sequel to the sql vid

@WebDevSimplified

5 жыл бұрын

Dolphin coming in hot with the killer one liners. That must make the next video SQL cubed.

Thank you so much for this video! I'm learning both English and SQL, this was crystal clear! :D

I like that you used metal bands for this tutorial haha. Made this video more interesting for me. Huge thumbs up for you buddy

ahh you are so handsome and you are helping me for my exam, my savior prince charming

@kaan3045

3 жыл бұрын

bak şuan düştü

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.

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.

no words, i have no words how to thank you for such a simplified and super explanation..god blesses us by giving you to us.stay blessed and keep progressing.thanks a lot kyle :) you are a GEM