Keep your database of accounts and passwords secure by using DashLane! Sign up now at www.dashlane.com/networkchuck50 and use the code networkchuck50 to get 50% off dashlane at checkout! Walkthrough/Commands ⏩ntck.co/SQL 🔥🔥Join the NetworkChuck Academy!: ntck.co/NCAcademy **Sponsored by Dashlane 0:00 ⏩ Intro 3:06 ⏩ What is SQL? 7:02 ⏩ Let’s make our own database! 10:36 ⏩ and let’s add some tables 16:47 ⏩ Challenge: create some tables by yourself 19:33 ⏩ Let’s remove the imposter in our data! 20:20 ⏩ How do I update my tables? 21:05 ⏩ What if I want to change the order? 21:42 ⏩ How to alter your table 23:39 ⏩ This puts the relation in relational databases 24:19 ⏩ Outro
I have been dealing with IT for about 3 decades and have been doing this professionally since 1998. I have never seen such entertaining, educational and perfectly presented content as on this channel. It's really a lot of fun to watch and also to refresh already known topics as well as to get new topics explained. Please keep up the good work! Thank you from Munich Germany.
We have a really sharp guy on our team here at Cymer, named Torsten and also from Germany. Not sure if that is a common German name or not. Cool either way. Good luck with your long career.
I want to learn SQL too and this video is absoluty hilarious for someone who never heard about SQL. Side Fact: The Colleague who will teach me at my company also is Thorsten but with an H. Thank you from Niedersachsen Germany.
This feels less like a tutorial and more like your buddy decided to sit you down and show you what they've been working on, explaining it all along the way. And I love you for it. Thanks for the fantastic refresher.
I'm a back-end developer, with 85% of my time spent on MS-SQL DBs, your video is extremely useful for a beginner to understand the basics of DBs and SQL, I think I'll use your approach during training sessions with new hires. Thank you for the video!
@@negros111 Yes many Database Administrators use mainly SQL in their day to day and they make relatively good money for the difficulty level of the job.
I've been in the industry for over 20 years and I think this is the best 101 class I've ever seen when it comes to SQL. Well done and would love to see this as a series and expanded.
Agree, a great "overview". I was doing a Udacity class on Data Science (I was dealing with several 20M line databases at the time, and obviously Excel can't do that, and neither could MS-Access). The databases were in Oracle, and while I could use the program "Altryx" my company wanted me to take data science classes. They had a bunch (400 or 500) available Udacity class slots available and set me up. The first class started in Excel (using functions virtually nobody uses because there are so many better ways of doing it), and then moved to SQL. I darn near had a meltdown on the SQL. The class was riddled with errors, between the videos, the text, and more. It was VERY poorly presented, and the "said" it would take 40 hour to go through that section. The VIDEO portion alone was 60 hours, and the classwork was easily another 40. Thankfully I was offered a retirement package and took it...I never finished that Udacity class, and let them know I would NEVER use them again after seeing how bad they were. Reading comments from others...I'm not in the minority...LOL. Chuck did a bang up job for an overview. Would love to see him do more on this.
@@brendalg4 Fortunately for you SQL is a long-standing ISO standard and you would already be aware of any implementation-specific details. If it ain't broken, don't fix it
I wish I had a teacher like you when I was in university. I believe we can all agree that the way you teach feels like you are teaching me (us) on a 1:1 basis. Thank you for these great videos and I wish you all the success.
Hey chuck i got introduced to your channel by learning linux 2 years ago when i didn't know anything about it i was only curious and a technology lover and now I've come along road IT is my world and i can't appreciate how good you explain everything it's just top nutch fun ! Please make more SQL tutorials it's really helpful. Wish you the best my friend!
i’ve done some SQL database management in a GUI before but learning to do it through a terminal has been awesome. I would love to see a part two going over primary and foreign keys and database relationships. The way you format your videos is great for learning and i love it, thank you so much for the content you put out. here’s hoping for a part 2
Each row in a database table has (ideally) to have a unique identifier - a unique field. This is the primary key. Its usually a sequential number. If this links to another table, that field that references this field is called a foreign key. So table 'customers' lists your customers. Primary key of 'customer_id'. Another table called 'orders'. Each order belongs to a customer. So in the order table, you'd have a field called 'customer_id'. This would be a foreign key as it points to a primary key (the field in the customer table).
Hey Man. I am actually learning SQL right now and this video just gave me a boost that I am going in the right direction. We definitely need a part 2. God bless you!
Today 10/21/24: I learned SqL and created DBS and now table and did some data manipulations. I can’t believe it. I ran my code on Linux (Ubuntu default distro ). Used sudo to install MySQL server. Thank you so much Chuck. Saving me college money with the fact that I love tech so much. You made my transition the easiest with all your skill packed videos. Love from 🇳🇬 . Thank you 👏
Best move I've made in my career. I hated operation management so I took a few SQL classes online. In a few months, I got hired as an operations system analyst. I learned MySQL and Postgre. Now I use Oracle.
When I was in college SQL was the only class I ever got a grade other than an A in (it was a B). I hated it so much. 11 years into my professional career and SQL is my favorite language between any other language I've had to learn. Absolutely love it. It made so little sense to me back in the day, but now I look at other languages and now I think they're structured in less than desirable ways while SQL has figured out the secret sauce of language! Great video!
Yes please Chuck, make more videos about SQL. You read my mind: I just started to make a website with flask for python and a sqlite3 or mySQL database. Thanks for the new video!
Your tutorials means great to my thirsty passionate course....I don't have money to go in class but won't miss data bundles to watch ur excellent and simple tutorials...really thankful
Just started my SQL journey. Please make more videos to cover the rest! Please!! You have such a great way of making everything so relatable and fun! Would love to see a playlist on your channel
I have been writing simple to medium sql for over 20 years now, and I still watched the hole video because of the great presentation. I did not learn anything new this time, but it´s okay, it was fun anyway.
I am in IT and 19 years old. I have a ton of material I am learning for classes and certifications, and no one comes remotely close to explaining topics well without losing the audience's attention is amazing. Well done, appreciate all the work you do.
ALWAYS backup your table BEFORE inserting/deleting/updating rows! and run select statement in first instance. I work on tables that have millions of records and that is best practice.
In addition to this video, I watched your networking videos. You make it easy to follow & get straight to the point. You don’t make it too wordy like some “educational” material out there or other video makers - thank you for that! Sometimes it feels like other “educational” content out there is doing that whole thing we learned not to do when we were younger in class: use the “word” in the definition if that makes sense… a lot of other content (not just video) literally leaves you just as clueless as before they sought to “teach” you content.
As an accountant, it's crucial we get a base level understanding of SQL! Its enables me to work with the IT department on an enormous level, writing custom apps to make our day to day lives easier and I can communicate my needs on a level they understand.
I’m not even interested in becoming a network engineer but love this video. Great educational content. Great style, endless cheesy jokes 😂. I do work in cybersecurity but on the sales side.
Perfect timing!!! I’m currently studying Database Management Foundations and learning about SQL for an online class. Gonna add this to my study material arsenal! 🤓
More like what AWS DB do I use with my microservice and can I use partialQL or whatever. Maybe you can create a virtual layer on top of AWS Bracket and create your own language. So many things to DB's it's driving me nuts.
I knew all this information because I read a book on the topic BUT this was GREAT video nonetheless. You covered pretty much everything I learned from the book in 25 min which is impressive.
@@camroth7 it focuses on MySQL examples which the syntax is slightly different than Microsoft SQL server. The concepts are the same as far as I could tell. It was good practice. Im following another video on UA-cam that shows how to download the MySQL secondary environment that is more similar to how the company I work for uses SQL. I found that more helpful. I can share the video link with you if you want.
I've been web developing for almost 2 decades and have always been a little frightened of digging into the MySQL DBs as I know how much havoc a wrong command can do to them. This was the best intro I've seen so far and now makes me much more interested in learning more. Thanks!
Tip for anyone doing simple stuff, when creating your id column, you could do something like: id int(22) PRIMARY KEY AUTO_INCREMENT NOT NULL. Auto_increment will auto assign a id/number to that row whenever a new row is created, starting from 1-inf . That way whenever you make a query to insert a row, as long as you're just doing simple things, you don't have to manually insert the id value. SQL will keep track of it. Just keep in mind that if you ever delete a row (let's say you have 15 rows. Then you delete row with id of 5. The next row that gets inserted will still be 16, not 5 or 6. ID 5 will always be gone unless you delete and re-create your table.
I was just thinking the other day that I really need to start learning SQL, beyond just using it blindly in applications. Great timing and really great intro for me! Looking forward to the next one!
you explained what RDM is so freaking easy that I'm surprised no one has thought of it to explain it that way. THANK YOU. This makes Relational Databases so much easier to understand. :)
Just wanted to add that having strong knowledge of sql and databases in general is extremely helpful for developing queries and detection rules using tools like Splunk (SPL) or Defender (KQL). Great video, please get in the weeds!
Wow I've been teaching myself SQL for a few weeks and actually creating a little DB with a table helped me grasp a lot of things much better! Thanks Chuck
Hey chuck I doubt you'll see this but I recently bought a T420 and have been messing around with linux on it and SQL. This video was perfect for me and very digestible. I appreciate how informative and explanatory your content is while fosterin a warm and welcome learnin environment, keep up the great work!
EXTREMELY useful video, Chuck. Def. made me hungry for MySQL and MS SQL. Easily explained that one of my kids was able to understand it. I'm setting a VM for him today. Again, thank you so much!
I'm so glad my first introduction to SQL was through this video. So much fun doing commands along with you. 100% will continue browsing through the channel to learn more.
Hi i'm a new student in cyber security and i love your content. You explain the materials better then my teachers. I followed your python course already and i loved that to. It would be nice if you do another topic of this but a continuing on from where you left here
SQL is amazing and is quite easy to learn. My first introduction to database storage was probably back in 2006 using mSL (mIRC scripting) with hash tables which was a more primitive type of data storage, but with similarities to SQL. Since then, I use SQL almost every day with some of my side coding projects in Python and C++.
@@h1n1worm As someone whose entire career revolves around sql, this is my reaction as well. The fundamentals are easy to learn. But once you start looking at performance tuning, learning about order of operations, resource locking, indexes, etc. it can get real complicated, real fast. And that's not even touching complex queries that require numerous layers to achieve required results.
This is absolutely phenomenal of a tutorial. I'm going to binge all of your videos like my favorite song and try to memorize it all naturally. This is highly educational and addicting in hands on.
This was lowkey genius! I use my sql to re-run jobs and use pre-built sql queries all the time in my current role. This brief class just tied in everything that wasn't connecting. About 15 years ago i had a class using sql to create databases and i didn't have a clue what i was doing because i was so new to IT. It all just clicked. The lightbulb connected for me. ☺️☺️☺️☺️
NC, I must tell you, in my hobble opinion, you are by far, the best YT instructor in all things IT. I’m currently in school and whenever I don’t understand something and school resources are not completely working for me, I look to see if you have covered it in a video and your content has help out many times, thank you! -Flo….ps, your content is also very entertaining 😆. Please keep it up.
NC, I have been watching your videos for a long time. I am sure you read this all the time. Without being afraid of being repeating stuff you know already, you rock! The amount of knowledge you share is huge. Your family rocks. You don’t hide the issues of a normal life. You inspire and help others. You make money and have fun. You get stressed like any other human. I find myself in a not so great day and wanted to take this out of my chest. Thank you! You are amazing. Hope you keep doing it! Faith/lucky/good things. Anything that move you forward NC! Godspeed.
Yes dude, I wanna see that. This stuff is interesting. It becomes nice if you can combine tables too see for example how many times a certain avenger has orderded some sort of coffee. I wanna see that so lets make it happen! :) This inspires me!
I had a problem understanding relational databases but the example of the three tables: clients, coffees, and list of orders is brilliant thank you so much
Thank you Chuck; I really appreciate this content. I hope you will create more videos about SQL. You planted the seed of curiosity on me about DATABASE. I also must say that I’m filleting your CCNA free course as I’m working to get my first IT certification. I have got a question though, does the combination of CCNA certification and SQL knowledge gives me better odds to land a good IT job?
First of all, I like your way of teaching with lots of fun factors, it really registers in the brain. But I have a suggestion, If you really want to show up SQL, do a series starting from basic to complex, so that people can learn from it. This video is not gonna be learning about SQL. There is a lot to understand for each query and the parameters. Learners will get confused with such bit and byte stories. for example, there are DDL and DML statements and what are they, what do you mean by relational DB and how will you relate each table, primary key, the foreign key concept, etc... It's a gigantic topic, please do that in a proper way. Thanks!
These videos are just an introduction for people that don't know absolutely nothing about SQL. I don't want to become an expert on SQL, but I don't want to be a complete ignorant on it. So these videos are perfect for me. And if some day I want to get more into SQL, I have a basic understanding of what it is.
I am a database specialist. Was trained in oracle 8i many years ago. Many many years later, I am a database consultant specially in MySQL, making complex queries and make database designs for other developers. :) I also happen to make systems from scratch for many companies.
19:48 I understand that this is for beginners just starting with sql, but in my opinion you should always delete with unique value (like "id" in this case). Because later you'll probably have more than one "Jeff". Keep up the good work !
You are the best DB SQL teacher on UA-cam, Thanks !! Today is my first time really looking into learn SQL and you are the JESUS of my new religion. Wow... im following you till the Sun stops shinning. Best regards
I seen this video 6 months ago when you first posted it but ignored it cause I thought it had nothing to do with me, now, here I am 6 months later interviewing for an IT position in 2 days and Im kicking myself for not watching it then. You are definitely ahead of the curve!!
Yup, waiting for the next one. I already knew everything you said but learning with you is FUN and I want to know more than the basics of SQL. I want to be an expert !
I'm currently enrolled in college and my major is cybersecurity . I "learned " MYSQL last semester . I struggled but your videos make it seem so much easier to learn. I have learned more here then I have in college. Thank you
WOW. learning this from my prof (hes actually pretty good) i was almost grasping everything. but seeing it work in real time like this is a completely different view, and it is a HUGE help.
I have just starting learning SQL and came across your video this week!! Thanks so much, you made is so much easier for me to follow and I love Marvel characters 😎Can you please make more videos for us? I LOVE IT!!! 😍
The database application is my favorite kind of application. I have been using Microsoft Access since 2002. Yes, Microsoft Access is a relational database kind of program, but Microsoft Access 2021 is more simpler to use even than was my first favorite Access 2002. I learned to use Microsoft Office XP Professional through Microsoft Office 2021 Professional all by myself.
Keep your database of accounts and passwords secure by using DashLane! Sign up now at www.dashlane.com/networkchuck50 and use the code networkchuck50 to get 50% off dashlane at checkout!
Walkthrough/Commands ⏩ntck.co/SQL
🔥🔥Join the NetworkChuck Academy!: ntck.co/NCAcademy
**Sponsored by Dashlane
0:00 ⏩ Intro
3:06 ⏩ What is SQL?
7:02 ⏩ Let’s make our own database!
10:36 ⏩ and let’s add some tables
16:47 ⏩ Challenge: create some tables by yourself
19:33 ⏩ Let’s remove the imposter in our data!
20:20 ⏩ How do I update my tables?
21:05 ⏩ What if I want to change the order?
21:42 ⏩ How to alter your table
23:39 ⏩ This puts the relation in relational databases
24:19 ⏩ Outro
Wow man. It's like you knew I got a job Monday requiring me to learn SQL
I hate videos where people have noisy keyboards like in this video. You might like mechanical keyboards but the noise is distracting.
Yes please, we want another video.
Also, is there an easy way to install on windows as it is on Linux? One cmd line?
Good day! Im a fan from South Africa, i would like to request for more videos about SQL please! Have a nice day!
The Way You Explaining It's cool 😎 #Coffee table 😍
I have been dealing with IT for about 3 decades and have been doing this professionally since 1998. I have never seen such entertaining, educational and perfectly presented content as on this channel. It's really a lot of fun to watch and also to refresh already known topics as well as to get new topics explained. Please keep up the good work! Thank you from Munich Germany.
Super Thorsten. Klasse.😃😃😃😃😃😃😃😃
We have a really sharp guy on our team here at Cymer, named Torsten and also from Germany. Not sure if that is a common German name or not. Cool either way. Good luck with your long career.
I want to learn SQL too and this video is absoluty hilarious for someone who never heard about SQL. Side Fact: The Colleague who will teach me at my company also is Thorsten but with an H. Thank you from Niedersachsen Germany.
Same here my friend. 1998 was the year it all began for me.
Germany mentioned 🇩🇪🔊🔊🗣️🗣️🗣️🇩🇪 DIESE SEKTION IST JETZT EIGENTUM DES BRD 🇩🇪🇩🇪🇩🇪🇩🇪🔊🔊🔊
This is the only guy that can actually make boring stuff entertaining. You're doing everyone a HUGE favor with these tutorials. Thank you.
This is not boring bro... Learning about computers isn't boring... Speak for yourself....
Yeah okay but I'm still learning the last thing you told me to learn right now
kjjjjjjjjjj
🤣🤣🫂
😅
🤣
Ha ha ha.....start multithreading.
This feels less like a tutorial and more like your buddy decided to sit you down and show you what they've been working on, explaining it all along the way. And I love you for it. Thanks for the fantastic refresher.
A SQL Admin, PostgreSQL engineer , and MySQL architect walk into a NoSQL bar. They left because there were no tables
😅😂
I'm a back-end developer, with 85% of my time spent on MS-SQL DBs, your video is extremely useful for a beginner to understand the basics of DBs and SQL, I think I'll use your approach during training sessions with new hires. Thank you for the video!
So you spend more time on mySQL than you do on a high level programming language?
@@Papi_21 not mySql, but MSSQL, the Microsoft one. And yes, in this company and for this project I mostly do DB work
Is it possible to find a job with knowledge of SQl? I mean I know the basics of JS, HTML and CSS.
@@negros111 Yes many Database Administrators use mainly SQL in their day to day and they make relatively good money for the difficulty level of the job.
Hey are you hiring any remote positions or internships?
I've been in the industry for over 20 years and I think this is the best 101 class I've ever seen when it comes to SQL. Well done and would love to see this as a series and expanded.
I agree
Agree, a great "overview". I was doing a Udacity class on Data Science (I was dealing with several 20M line databases at the time, and obviously Excel can't do that, and neither could MS-Access). The databases were in Oracle, and while I could use the program "Altryx" my company wanted me to take data science classes. They had a bunch (400 or 500) available Udacity class slots available and set me up. The first class started in Excel (using functions virtually nobody uses because there are so many better ways of doing it), and then moved to SQL. I darn near had a meltdown on the SQL. The class was riddled with errors, between the videos, the text, and more. It was VERY poorly presented, and the "said" it would take 40 hour to go through that section. The VIDEO portion alone was 60 hours, and the classwork was easily another 40. Thankfully I was offered a retirement package and took it...I never finished that Udacity class, and let them know I would NEVER use them again after seeing how bad they were. Reading comments from others...I'm not in the minority...LOL.
Chuck did a bang up job for an overview. Would love to see him do more on this.
It says your post is a year old. I'm wondering if this video would now be outdated?
@@brendalg4 Fortunately for you SQL is a long-standing ISO standard and you would already be aware of any implementation-specific details. If it ain't broken, don't fix it
I wish I had a teacher like you when I was in university. I believe we can all agree that the way you teach feels like you are teaching me (us) on a 1:1 basis. Thank you for these great videos and I wish you all the success.
I learned more from this video than I did from an entire semester of a watching paint dry intro to databases class. Thanks Chuck.
Look at Mr. Fancy Pants over there in their freshly painted lecture room :P
@@semitangent So true.
😄😄😄😄😄
Facts
Where you in the correct classroom?
Hey chuck i got introduced to your channel by learning linux 2 years ago when i didn't know anything about it i was only curious and a technology lover and now I've come along road IT is my world and i can't appreciate how good you explain everything it's just top nutch fun ! Please make more SQL tutorials it's really helpful. Wish you the best my friend!
i’ve done some SQL database management in a GUI before but learning to do it through a terminal has been awesome. I would love to see a part two going over primary and foreign keys and database relationships. The way you format your videos is great for learning and i love it, thank you so much for the content you put out. here’s hoping for a part 2
Each row in a database table has (ideally) to have a unique identifier - a unique field. This is the primary key. Its usually a sequential number. If this links to another table, that field that references this field is called a foreign key. So table 'customers' lists your customers. Primary key of 'customer_id'. Another table called 'orders'. Each order belongs to a customer. So in the order table, you'd have a field called 'customer_id'. This would be a foreign key as it points to a primary key (the field in the customer table).
@@chrisjlocke great example💪🏽
Nice
Where would you recommend I learn the GUI version? Thanks
Chuck is the reason I recently decided to transition into I.T in my 40s.... COOLEST I.T Guru ever. Love from London.
Hey Man. I am actually learning SQL right now and this video just gave me a boost that I am going in the right direction. We definitely need a part 2. God bless you!
I am with @Aditya Tiku - we need a part II please =o)
@@rociodevine7512 yes we need it
Where is part 2 ?
@@ThedudeMMXlll Dunno man
Where is part 2?
Today 10/21/24: I learned SqL and created DBS and now table and did some data manipulations. I can’t believe it. I ran my code on Linux (Ubuntu default distro ). Used sudo to install MySQL server. Thank you so much Chuck. Saving me college money with the fact that I love tech so much. You made my transition the easiest with all your skill packed videos. Love from 🇳🇬 . Thank you 👏
Man I have a class coming up for SQL and had no idea what it even was sweet you made this video
awesome!
Best move I've made in my career. I hated operation management so I took a few SQL classes online. In a few months, I got hired as an operations system analyst.
I learned MySQL and Postgre. Now I use Oracle.
When I was in college SQL was the only class I ever got a grade other than an A in (it was a B). I hated it so much. 11 years into my professional career and SQL is my favorite language between any other language I've had to learn. Absolutely love it. It made so little sense to me back in the day, but now I look at other languages and now I think they're structured in less than desirable ways while SQL has figured out the secret sauce of language! Great video!
Yes please Chuck, make more videos about SQL. You read my mind: I just started to make a website with flask for python and a sqlite3 or mySQL database. Thanks for the new video!
I've been in the industry for over 100 years and I also wanted to say this is a great video!
😂
Your tutorials means great to my thirsty passionate course....I don't have money to go in class but won't miss data bundles to watch ur excellent and simple tutorials...really thankful
Keep it up bro 🔥
Just started my SQL journey. Please make more videos to cover the rest! Please!! You have such a great way of making everything so relatable and fun! Would love to see a playlist on your channel
I have been writing simple to medium sql for over 20 years now, and I still watched the hole video because of the great presentation. I did not learn anything new this time, but it´s okay, it was fun anyway.
I am in IT and 19 years old. I have a ton of material I am learning for classes and certifications, and no one comes remotely close to explaining topics well without losing the audience's attention is amazing. Well done, appreciate all the work you do.
ALWAYS backup your table BEFORE inserting/deleting/updating rows! and run select statement in first instance. I work on tables that have millions of records and that is best practice.
In addition to this video, I watched your networking videos. You make it easy to follow & get straight to the point. You don’t make it too wordy like some “educational” material out there or other video makers - thank you for that!
Sometimes it feels like other “educational” content out there is doing that whole thing we learned not to do when we were younger in class: use the “word” in the definition if that makes sense… a lot of other content (not just video) literally leaves you just as clueless as before they sought to “teach” you content.
As an accountant, it's crucial we get a base level understanding of SQL! Its enables me to work with the IT department on an enormous level, writing custom apps to make our day to day lives easier and I can communicate my needs on a level they understand.
I’m not even interested in becoming a network engineer but love this video. Great educational content. Great style, endless cheesy jokes 😂. I do work in cybersecurity but on the sales side.
Perfect timing!!! I’m currently studying Database Management Foundations and learning about SQL for an online class. Gonna add this to my study material arsenal! 🤓
More like what AWS DB do I use with my microservice and can I use partialQL or whatever. Maybe you can create a virtual layer on top of AWS Bracket and create your own language. So many things to DB's it's driving me nuts.
I knew all this information because I read a book on the topic BUT this was GREAT video nonetheless. You covered pretty much everything I learned from the book in 25 min which is impressive.
Hey Luke, what book did you read? I’m wanting to learn SQL myself
@@camroth7 SQL in Easy Steps
By Mike McGrath
@@camroth7 it focuses on MySQL examples which the syntax is slightly different than Microsoft SQL server. The concepts are the same as far as I could tell. It was good practice. Im following another video on UA-cam that shows how to download the MySQL secondary environment that is more similar to how the company I work for uses SQL. I found that more helpful. I can share the video link with you if you want.
Thank you for this! I just started trying to learn a few days ago and this video is a god send!
Socrata channel has a great tutorial
I've been web developing for almost 2 decades and have always been a little frightened of digging into the MySQL DBs as I know how much havoc a wrong command can do to them. This was the best intro I've seen so far and now makes me much more interested in learning more. Thanks!
Tip for anyone doing simple stuff, when creating your id column, you could do something like: id int(22) PRIMARY KEY AUTO_INCREMENT NOT NULL. Auto_increment will auto assign a id/number to that row whenever a new row is created, starting from 1-inf . That way whenever you make a query to insert a row, as long as you're just doing simple things, you don't have to manually insert the id value. SQL will keep track of it.
Just keep in mind that if you ever delete a row (let's say you have 15 rows. Then you delete row with id of 5. The next row that gets inserted will still be 16, not 5 or 6. ID 5 will always be gone unless you delete and re-create your table.
I was just thinking the other day that I really need to start learning SQL, beyond just using it blindly in applications. Great timing and really great intro for me! Looking forward to the next one!
you explained what RDM is so freaking easy that I'm surprised no one has thought of it to explain it that way. THANK YOU. This makes Relational Databases so much easier to understand. :)
Just wanted to add that having strong knowledge of sql and databases in general is extremely helpful for developing queries and detection rules using tools like Splunk (SPL) or Defender (KQL). Great video, please get in the weeds!
i've learned more in this video than in a full year of computatinal science college
Yes, I would like to see a continuation video on SQL. Thanks.
I have wanted to learn SQL for a while. Thank you for the excellent tutorial!
Thank you for watching!
I have been struggling to learn SQL for years, I am a slow learner, this is just brilliant...
That was extremely helpful. Wish they would've shown that in school when we were learning about databases and MySQL.
This video is the primary key to understanding SQL, it's a table making experience, I can watch it several times in a row, that's my study field
Had a whole semester of SQL, and I feel like the teacher could have just used this one video, and the class would have gotten more out of it.
Same here brother! Could've saved us all so much time and money
Really? Im new intonthat stuff
Yes, I spent weeks on SQL and believe that what I learned here will stick better than anything that I learned in that course .
that’s because they want your money more than they want to teach you
Wow I've been teaching myself SQL for a few weeks and actually creating a little DB with a table helped me grasp a lot of things much better! Thanks Chuck
I love the joy of optimizing a query to take only a couple seconds instead of minutes
Creating indexes helps here. Rather than scanning through the whole table, the database can just browse the index.
Hey chuck I doubt you'll see this but I recently bought a T420 and have been messing around with linux on it and SQL. This video was perfect for me and very digestible. I appreciate how informative and explanatory your content is while fosterin a warm and welcome learnin environment, keep up the great work!
It's super useful...please take us to an advanced level in this topic.
EXTREMELY useful video, Chuck. Def. made me hungry for MySQL and MS SQL. Easily explained that one of my kids was able to understand it. I'm setting a VM for him today. Again, thank you so much!
Love this guys energy, very motivational.
Learning Windows SQL as we speak, but I've already learned a lot more from this video than I've seen in 8hrs of class, would love a 2nd part.
I'm setting in my database management class at college right now lol great timing
perfect timing :)
I'm so glad my first introduction to SQL was through this video. So much fun doing commands along with you. 100% will continue browsing through the channel to learn more.
Hi i'm a new student in cyber security and i love your content. You explain the materials better then my teachers. I followed your python course already and i loved that to. It would be nice if you do another topic of this but a continuing on from where you left here
This is the best description of SQL servers I've ever seen.
SQL is amazing and is quite easy to learn. My first introduction to database storage was probably back in 2006 using mSL (mIRC scripting) with hash tables which was a more primitive type of data storage, but with similarities to SQL.
Since then, I use SQL almost every day with some of my side coding projects in Python and C++.
aha, its easy if you dont go deep and try to understand how engine works inside =)
@@h1n1worm As someone whose entire career revolves around sql, this is my reaction as well. The fundamentals are easy to learn. But once you start looking at performance tuning, learning about order of operations, resource locking, indexes, etc. it can get real complicated, real fast. And that's not even touching complex queries that require numerous layers to achieve required results.
@@jw11432 well said,sir.
This is absolutely phenomenal of a tutorial. I'm going to binge all of your videos like my favorite song and try to memorize it all naturally. This is highly educational and addicting in hands on.
I already know SQL, but I can't miss one of your videos! Your way of teaching and the passion you show is unmatched, keep it up!
This was lowkey genius! I use my sql to re-run jobs and use pre-built sql queries all the time in my current role.
This brief class just tied in everything that wasn't connecting. About 15 years ago i had a class using sql to create databases and i didn't have a clue what i was doing because i was so new to IT.
It all just clicked. The lightbulb connected for me. ☺️☺️☺️☺️
I was just waiting for this course plz make part 2 😍💥
Love from India 🤍
NC, I must tell you, in my hobble opinion, you are by far, the best YT instructor in all things IT. I’m currently in school and whenever I don’t understand something and school resources are not completely working for me, I look to see if you have covered it in a video and your content has help out many times, thank you! -Flo….ps, your content is also very entertaining 😆. Please keep it up.
Excellent video! SQL can be intimidating for beginners and I think you presented it in an easy and fun way. I would love to see more on SQL.
Thanks chuck! Because of your passion, millions are getting educated and motivated. You’re awesome!
I really enjoyed doing this and looking forward to a part 2 or another series!
NC, I have been watching your videos for a long time. I am sure you read this all the time.
Without being afraid of being repeating stuff you know already, you rock! The amount of knowledge you share is huge. Your family rocks. You don’t hide the issues of a normal life. You inspire and help others. You make money and have fun. You get stressed like any other human.
I find myself in a not so great day and wanted to take this out of my chest.
Thank you!
You are amazing.
Hope you keep doing it!
Faith/lucky/good things. Anything that move you forward NC!
Godspeed.
Yes dude, I wanna see that. This stuff is interesting. It becomes nice if you can combine tables too see for example how many times a certain avenger has orderded some sort of coffee. I wanna see that so lets make it happen! :) This inspires me!
thanks a bunch, this was my fist step into SQL, you made it fun.
Please please please finish this series 🙏
This is one of the best structured, best recorded, best explained and entertaining videos I've ever watched! Thank you, sir!
Awesome video! Please make more advanced videos for SQL but continue explaining the basics as well. You rock!
I had a problem understanding relational databases
but the example of the three tables: clients, coffees, and list of orders is brilliant
thank you so much
Need more SQL tutorial it's real fun
Chuck you are a savior! I love you! I have no knowledge in SQL at all but after looking through this lesson, i think i learnt something awesome!🥰🥰🥰
As always entertaining and informative!
im currently simultaniously trying to learn python and sql. your teaching style is literally how i think when writing excel fx - easy sub :)
Thank you Chuck; I really appreciate this content. I hope you will create more videos about SQL. You planted the seed of curiosity on me about DATABASE. I also must say that I’m filleting your CCNA free course as I’m working to get my first IT certification. I have got a question though, does the combination of CCNA certification and SQL knowledge gives me better odds to land a good IT job?
Many IT jobs require some level of SQL knowledge as so many applications these days write to databases.
My goodness. Taking a University course on DBM and your video answered all my questions from Chapters 1-3. Thank you!
First of all, I like your way of teaching with lots of fun factors, it really registers in the brain. But I have a suggestion, If you really want to show up SQL, do a series starting from basic to complex, so that people can learn from it. This video is not gonna be learning about SQL. There is a lot to understand for each query and the parameters. Learners will get confused with such bit and byte stories. for example, there are DDL and DML statements and what are they, what do you mean by relational DB and how will you relate each table, primary key, the foreign key concept, etc... It's a gigantic topic, please do that in a proper way. Thanks!
These videos are just an introduction for people that don't know absolutely nothing about SQL. I don't want to become an expert on SQL, but I don't want to be a complete ignorant on it. So these videos are perfect for me. And if some day I want to get more into SQL, I have a basic understanding of what it is.
I am a database specialist. Was trained in oracle 8i many years ago. Many many years later, I am a database consultant specially in MySQL, making complex queries and make database designs for other developers. :)
I also happen to make systems from scratch for many companies.
19:48 I understand that this is for beginners just starting with sql, but in my opinion you should always delete with unique value (like "id" in this case). Because later you'll probably have more than one "Jeff". Keep up the good work !
More SQL videos please!
You are the best DB SQL teacher on UA-cam, Thanks !! Today is my first time really looking into learn SQL and you are the JESUS of my new religion. Wow... im following you till the Sun stops shinning. Best regards
I am finding issue in understanding SQL .
Thanks for the session
Thanks alot 💓
Thanks NetworkChuck!
I am a software dev student and taking database security at the moment.
I will keep watching your awesome videos!
is there a part 2?
I don't think so mahn
2 years later and the man was 100%, database management is the future.
You made me so excited to start learning SQL!! I think this is going to be fun - love how you teach 🎉
Never have I every seen someone so enthusiastic about SQL and databases! You are doing a great job at teaching (:
I seen this video 6 months ago when you first posted it but ignored it cause I thought it had nothing to do with me, now, here I am 6 months later interviewing for an IT position in 2 days and Im kicking myself for not watching it then. You are definitely ahead of the curve!!
Yup, waiting for the next one. I already knew everything you said but learning with you is FUN and I want to know more than the basics of SQL. I want to be an expert !
Thanks, Chuck! --finally --learned a little mySql after wanting to for more than a year. Great vids for application and deeper learning.
This was a very good tutorial, very clearly explained, and a very upbeat attitude. SQL seems to be in high demand right now.
I was using a different tutorial and found this one. This tutorial is much more detailed and I love that.
I'm currently enrolled in college and my major is cybersecurity . I "learned " MYSQL last semester . I struggled but your videos make it seem so much easier to learn. I have learned more here then I have in college. Thank you
WOW. learning this from my prof (hes actually pretty good) i was almost grasping everything. but seeing it work in real time like this is a completely different view, and it is a HUGE help.
you are a life savor , i was trying to understand the basics, and your presentation gave me the confidence!! thank you thank you!!
whenever i wanna learn something
chuck: you need to learn right now!!
I have just starting learning SQL and came across your video this week!! Thanks so much, you made is so much easier for me to follow and I love Marvel characters 😎Can you please make more videos for us? I LOVE IT!!! 😍
This tutorial is AMAZING!
The database application is my favorite kind of application. I have been using Microsoft Access since 2002. Yes, Microsoft Access is a relational database kind of program, but Microsoft Access 2021 is more simpler to use even than was my first favorite Access 2002. I learned to use Microsoft Office XP Professional through Microsoft Office 2021 Professional all by myself.
This is the best tutorial I have seen on SQL for beginners, many thanks.