you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

  Рет қаралды 1,398,192

NetworkChuck

NetworkChuck

Күн бұрын

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!
We know databases sound scary, but luckily NetworkChuck is here to hold your hand as he walks you through the mystical world of relational databases. He will show you how to use the love language of relational databases, SQL. You will even learn how to create your very own database! So buckle in, grab a cup of coffee and get ready to conquer your fear of databases!
Walkthrough/Commands ⏩ntck.co/SQL
🔥🔥Join the NetworkChuck Academy!: ntck.co/NCAcademy
**Sponsored by Dashlane
SUPPORT NETWORKCHUCK
---------------------------------------------------
➡️NetworkChuck membership: ntck.co/Premium
☕☕ COFFEE and MERCH: ntck.co/coffee
Check out my new channel: ntck.co/ncclips
🆘🆘NEED HELP?? Join the Discord Server: / discord
STUDY WITH ME on Twitch: bit.ly/nc_twitch
READY TO LEARN??
---------------------------------------------------
-Learn Python: bit.ly/3rzZjzz
-Get your CCNA: bit.ly/nc-ccna
FOLLOW ME EVERYWHERE
---------------------------------------------------
Instagram: / networkchuck
Twitter: / networkchuck
Facebook: / networkchuck
Join the Discord server: bit.ly/nc-discord
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
AFFILIATES & REFERRALS
---------------------------------------------------
(GEAR I USE...STUFF I RECOMMEND)
My network gear: geni.us/L6wyIUj
Amazon Affiliate Store: www.amazon.com/shop/networkchuck
Buy a Raspberry Pi: geni.us/aBeqAL
Do you want to know how I draw on the screen?? Go to ntck.co/EpicPen and use code NetworkChuck to get 20% off!!
#SQL #Database #Relational

Пікірлер: 1 700
@NetworkChuck
@NetworkChuck Жыл бұрын
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
@joshuawatson5632
@joshuawatson5632 Жыл бұрын
Wow man. It's like you knew I got a job Monday requiring me to learn SQL
@mediaplayer1594
@mediaplayer1594 Жыл бұрын
I hate videos where people have noisy keyboards like in this video. You might like mechanical keyboards but the noise is distracting.
@robertcenusa8636
@robertcenusa8636 Жыл бұрын
Yes please, we want another video. Also, is there an easy way to install on windows as it is on Linux? One cmd line?
@masterlinnn2876
@masterlinnn2876 Жыл бұрын
Good day! Im a fan from South Africa, i would like to request for more videos about SQL please! Have a nice day!
@CjGaming7171
@CjGaming7171 Жыл бұрын
The Way You Explaining It's cool 😎 #Coffee table 😍
@shreyasnair7949
@shreyasnair7949 Жыл бұрын
Yeah okay but I'm still learning the last thing you told me to learn right now
@samucancld
@samucancld Жыл бұрын
kjjjjjjjjjj
@sohampednekar1405
@sohampednekar1405 Жыл бұрын
🤣🤣🫂
@clintojoemon5936
@clintojoemon5936 Жыл бұрын
😅
@Nakoo95
@Nakoo95 Жыл бұрын
🤣
@_Raphael_CIA
@_Raphael_CIA Жыл бұрын
Ha ha ha.....start multithreading.
@torstenklimaschewski4398
@torstenklimaschewski4398 Жыл бұрын
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.
@Luis-vo7ls
@Luis-vo7ls 11 ай бұрын
Super Thorsten. Klasse.😃😃😃😃😃😃😃😃
@danb8606
@danb8606 6 ай бұрын
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.
@HansJochenUndermaier12221
@HansJochenUndermaier12221 3 ай бұрын
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.
@CyberNancy
@CyberNancy 2 ай бұрын
Same here my friend. 1998 was the year it all began for me.
@la6beats
@la6beats Ай бұрын
Germany mentioned 🇩🇪🔊🔊🗣️🗣️🗣️🇩🇪 DIESE SEKTION IST JETZT EIGENTUM DES BRD 🇩🇪🇩🇪🇩🇪🇩🇪🔊🔊🔊
@smofog6982
@smofog6982 7 ай бұрын
This is the only guy that can actually make boring stuff entertaining. You're doing everyone a HUGE favor with these tutorials. Thank you.
@s3dghost
@s3dghost 18 күн бұрын
This is not boring bro... Learning about computers isn't boring... Speak for yourself....
@orangedrag
@orangedrag Жыл бұрын
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.
@rodrigoesteban7657
@rodrigoesteban7657 5 ай бұрын
I agree
@WreckDiver99
@WreckDiver99 3 ай бұрын
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.
@philb.1899
@philb.1899 Жыл бұрын
I learned more from this video than I did from an entire semester of a watching paint dry intro to databases class. Thanks Chuck.
@semitangent
@semitangent Жыл бұрын
Look at Mr. Fancy Pants over there in their freshly painted lecture room :P
@nduri2
@nduri2 Жыл бұрын
@@semitangent So true.
@rudyabeyta5319
@rudyabeyta5319 Жыл бұрын
😄😄😄😄😄
@deandregraham3853
@deandregraham3853 Жыл бұрын
Facts
@mrmotomoto
@mrmotomoto Жыл бұрын
Where you in the correct classroom?
@shadowraven941
@shadowraven941 Жыл бұрын
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
@chrisjlocke
@chrisjlocke Жыл бұрын
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).
@intuitiveclass6401
@intuitiveclass6401 Жыл бұрын
@@chrisjlocke great example💪🏽
@rken100
@rken100 Жыл бұрын
Nice
@RobertHagelberg
@RobertHagelberg Жыл бұрын
Where would you recommend I learn the GUI version? Thanks
@AndreaTani
@AndreaTani Жыл бұрын
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!
@Papi_21
@Papi_21 Жыл бұрын
So you spend more time on mySQL than you do on a high level programming language?
@AndreaTani
@AndreaTani Жыл бұрын
@@Papi_21 not mySql, but MSSQL, the Microsoft one. And yes, in this company and for this project I mostly do DB work
@negros111
@negros111 Жыл бұрын
Is it possible to find a job with knowledge of SQl? I mean I know the basics of JS, HTML and CSS.
@chaseisonthecase2122
@chaseisonthecase2122 10 ай бұрын
@@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.
@kylerowland1227
@kylerowland1227 9 ай бұрын
Hey are you hiring any remote positions or internships?
@MrCoolCats
@MrCoolCats 9 ай бұрын
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.
@petephelp971
@petephelp971 Жыл бұрын
Man I have a class coming up for SQL and had no idea what it even was sweet you made this video
@NetworkChuck
@NetworkChuck Жыл бұрын
awesome!
@GeoBurdo
@GeoBurdo Жыл бұрын
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.
@valterpereiracjr
@valterpereiracjr Жыл бұрын
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.
@ImaITman
@ImaITman Жыл бұрын
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!
@adityatiku7617
@adityatiku7617 Жыл бұрын
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!
@rociodevine7512
@rociodevine7512 Жыл бұрын
I am with @Aditya Tiku - we need a part II please =o)
@funornot5400
@funornot5400 Жыл бұрын
@@rociodevine7512 yes we need it
@jvlozano11
@jvlozano11 10 ай бұрын
Where is part 2 ?
@subarunatsuki1902
@subarunatsuki1902 10 ай бұрын
@@jvlozano11 Dunno man
@kiwifrenchie6036
@kiwifrenchie6036 9 ай бұрын
Where is part 2?
@focusmicro
@focusmicro Жыл бұрын
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.
@arjeshkarmacharya9303
@arjeshkarmacharya9303 2 ай бұрын
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.
@parabellum4622
@parabellum4622 7 ай бұрын
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.
@MeMyselfAndBob
@MeMyselfAndBob Жыл бұрын
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!
@TheKingCanuck
@TheKingCanuck Жыл бұрын
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!
@ThrdCardofDeath
@ThrdCardofDeath Жыл бұрын
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.
@cityonthemoon36
@cityonthemoon36 Жыл бұрын
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
@davinelm1545
@davinelm1545 Жыл бұрын
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!
@exeqt
@exeqt Жыл бұрын
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.
@cdmsvt
@cdmsvt Жыл бұрын
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
@pedrosilvamusician
@pedrosilvamusician Жыл бұрын
I'm so happy to see that this is actually really simple to use. Always thought that, you know, it was something mega complicated. As someone who already worked a lot with comandlines, powershell and a lot of messing around with .ini files from games, I can honestly say this is really simple and easy to use. Thanks a lot Chuck
@thedocbryantshow
@thedocbryantshow Жыл бұрын
Absolutely want more on SQL. I'm wanting to make the move from nursing to IT, and our database department is growing. Also, thanks to your channel, I've started working toward my JNCIA. Thanks for all the good info.
@7777xm
@7777xm Жыл бұрын
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.
@mednidalloucif5843
@mednidalloucif5843 7 ай бұрын
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!
@csmith1560
@csmith1560 Жыл бұрын
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.
@p4r4b3llum
@p4r4b3llum Жыл бұрын
That was extremely helpful. Wish they would've shown that in school when we were learning about databases and MySQL.
@jasonstahl73
@jasonstahl73 Жыл бұрын
Excellent video. I already knew this through my own research when I needed it for a past job. But with your other videos (and other youtube videos) and following them in my home lab, I have managed to land an Associate Linux Admin position with a company where my many years of computer repair and technical support would not be enough for the position. I have to move to another city now, but I'll be making nearly double what I've made in the past. I'm super excited to be able to learn more and you were a part of it. Thank you so much.
@kevinfalzon
@kevinfalzon 11 ай бұрын
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
@aaki5585
@aaki5585 Жыл бұрын
Thanks chuck! Because of your passion, millions are getting educated and motivated. You’re awesome!
@isaiahbundi7207
@isaiahbundi7207 Жыл бұрын
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
@rahanajai6467
@rahanajai6467 Жыл бұрын
Keep it up bro 🔥
@redsun5826
@redsun5826 Жыл бұрын
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! 🤓
@victormendoza3295
@victormendoza3295 Жыл бұрын
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.
@Tignite91
@Tignite91 Жыл бұрын
Never have I every seen someone so enthusiastic about SQL and databases! You are doing a great job at teaching (:
@thomassweatii622
@thomassweatii622 Жыл бұрын
This video is awesome. I didn't realize how much I knew about SQL already and the similarities it shared with other things I've been exposed to. Please keep these vids coming!
@darkr70
@darkr70 Жыл бұрын
As someone who has 0 basics in IT and learning python at a basic level, I did understand everything you said and im very gratefull for the way you explain things
@klfrost7
@klfrost7 Жыл бұрын
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.
@michaelsauer3482
@michaelsauer3482 Жыл бұрын
Same here brother! Could've saved us all so much time and money
@lRemingtonx
@lRemingtonx Жыл бұрын
Really? Im new intonthat stuff
@ezra3457
@ezra3457 Жыл бұрын
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. :)
@jurickgustina9131
@jurickgustina9131 Жыл бұрын
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
@johnwhiting9661
@johnwhiting9661 Жыл бұрын
Yes, I would like to see a continuation video on SQL. Thanks.
@dorothyglade9087
@dorothyglade9087 Жыл бұрын
Hey Chuck, this was great! Thank you. Yes, I would definitely love to see another video that dives a little deeper into relational databases!
@Qeris
@Qeris Жыл бұрын
I just needed a refresher course on SQL and this was just what I needed! Thanks, Chuck!
@rockdya8588
@rockdya8588 Жыл бұрын
Awesome video! Please make more advanced videos for SQL but continue explaining the basics as well. You rock!
@bonesyt1427
@bonesyt1427 Жыл бұрын
I really enjoyed doing this and looking forward to a part 2 or another series!
@francisansah2754
@francisansah2754 Жыл бұрын
Very helpful! Thank you for making this video very simple yet detailed intro to SQL. I'm starting to feel confident in my SQL skills now. Much Appreciated 🙏🏽
@IMakeStuff92
@IMakeStuff92 5 ай бұрын
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.
@antondovydaitis2261
@antondovydaitis2261 Жыл бұрын
SQL, and databases in general, are one of the most important useful computer skills one could possibly learn, and it is not difficult. Relational Databases for the win.
@LovelyJordy
@LovelyJordy Жыл бұрын
I’m learning SQL as we speak. 🧚🏼‍♀️ great video. Thank you for sharing your knowledge with us!
@vpatterson87
@vpatterson87 6 ай бұрын
super dope i know im late but I spun up my Linux VM also and followed along and moved the Project to my Github your so super NETWORK chuck. I'm a noob but learning some of your content keeps me on my toes. Much appreciation my guy.
@johnjacobjingleheimerschmi2108
@johnjacobjingleheimerschmi2108 Жыл бұрын
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!!
@michaelrodriguez6210
@michaelrodriguez6210 Жыл бұрын
Thank you for this! I just started trying to learn a few days ago and this video is a god send!
@Trazynn
@Trazynn Жыл бұрын
Socrata channel has a great tutorial
@kiravd5392
@kiravd5392 Жыл бұрын
Love this guys energy, very motivational.
@thebozzIDW
@thebozzIDW Жыл бұрын
I have to say your teaching style is great, easy to follow and easy to retain all the information you bring up... I am looking forward to the sequel to this video :D
@lauriea2971
@lauriea2971 Жыл бұрын
I used to use something like sql in college in my microcomputer specialist course when I was useing Dbase IV. I love that program. For my final project I created a in school bulletin board program with a password program built in it. It was fun to use.
@bobbybologna3029
@bobbybologna3029 Жыл бұрын
Man I've been wanting to figure out SQL for some projects but never got around to it, another video elaborating on it is always welcome, especially since you show how to work with it out of the terminal, I've used GUI managers before but they melt my brain lol
@ElvenJustice
@ElvenJustice Жыл бұрын
"GUI managers before but they melt my brain"?? really? wow I think it's the other way around. in a GUI I can SEE wtf's going on, but on a command line? I feel like 5a 5 y/o at the controls of the space shuttle and all the control labels are missing.
@cosmos1324
@cosmos1324 Жыл бұрын
This tutorial is AMAZING!
@pierreleonsimard
@pierreleonsimard Жыл бұрын
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 !
@noredine
@noredine Жыл бұрын
I love the joy of optimizing a query to take only a couple seconds instead of minutes
@chrisjlocke
@chrisjlocke Жыл бұрын
Creating indexes helps here. Rather than scanning through the whole table, the database can just browse the index.
@davidcordero9864
@davidcordero9864 Жыл бұрын
I really enjoy your teaching style and energy Chuck. Yes, do some more MySQL vids!
@joeperez8645
@joeperez8645 11 ай бұрын
Thanks 👍 That was my first introduction to SQL. I can see it's potential uses and I want to keep learning more.
@11ph22il
@11ph22il Жыл бұрын
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
@quinnhancock3660
@quinnhancock3660 Жыл бұрын
Nice! I've been waiting for a video on this!
@luke2042
@luke2042 Жыл бұрын
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.
@cameronroth7304
@cameronroth7304 Жыл бұрын
Hey Luke, what book did you read? I’m wanting to learn SQL myself
@luke2042
@luke2042 Жыл бұрын
@@cameronroth7304 SQL in Easy Steps By Mike McGrath
@luke2042
@luke2042 Жыл бұрын
@@cameronroth7304 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 KZbin 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.
@tamrockz
@tamrockz 2 ай бұрын
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!!! 😍
@MrTheChris96
@MrTheChris96 Жыл бұрын
Just did it, waiting for the next one Chuck. Keep it up!
@proclaimed75
@proclaimed75 Жыл бұрын
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!
@chulsoun6458
@chulsoun6458 Жыл бұрын
It's super useful...please take us to an advanced level in this topic.
@bikerchrisukk
@bikerchrisukk Жыл бұрын
Good stuff Chuck, small story. Worked for company that had 12 staff, wrote down time spent on projects in a spreadsheet. "Accounts" would print that spreadsheet, open up a word doc and manually type in fees. I decided to spend 6 months to learn PHP and MySQL to create a time sheet system, I was really pleased with myself. Punchline: Showed to directors, they said we shouldn't use it, because it might make accounts redundant. Hmm. At least I learnt a new thing though and got paid doing it!
@fishworld2383
@fishworld2383 Жыл бұрын
Wssp big bro, you've definitely gave quite the drive in I.T for me, I want thank you gratefully dude, you have know idea. Your a perfect technologist in my eye.good stuff
@clownpocket
@clownpocket Жыл бұрын
Thanks for showing us. I learned a lot. You have a talent for making complex subjects simple. I’m an old linux user and always wondered about SQL, what it is and how it works. Amazing.
@kriss3d
@kriss3d Жыл бұрын
I would strongly recommend setting up a linux with mysql and some python for this. Its so satisfying.
@mookieblaylock9414
@mookieblaylock9414 Жыл бұрын
I'm setting in my database management class at college right now lol great timing
@NetworkChuck
@NetworkChuck Жыл бұрын
perfect timing :)
@drewup7456
@drewup7456 Жыл бұрын
This is awesome! I'm on the 4th course on Google data analyst certificate and this helps for my aide big time. I subbed.
@daliborizer
@daliborizer Жыл бұрын
Please more videos about SQL. Something I should have known already but learned so much just by watching this video. Thank you Chuck.
@creatorx3795
@creatorx3795 Жыл бұрын
I know SQL, but you are very good teacher! Everything you say is interesting and understandable! ❤❤
@Goaboyz
@Goaboyz Жыл бұрын
This was most required. Thanks
@miguelcarrilho4744
@miguelcarrilho4744 Жыл бұрын
@NetworkChuck can't even tell how many times I studied for my degree exams using your vids, thx Chuck!!
@Promitheas13
@Promitheas13 Жыл бұрын
Love all of your lessons. I think databases are very important to know. Just keep it coming.
@bussaner
@bussaner Жыл бұрын
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 !
@Lucas-cx4yi
@Lucas-cx4yi 6 ай бұрын
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.
@farooqkota8692
@farooqkota8692 Жыл бұрын
Need more SQL tutorial it's real fun
@kevinvanhessche4120
@kevinvanhessche4120 Жыл бұрын
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.
@Kward1718
@Kward1718 5 күн бұрын
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. ☺️☺️☺️☺️
@John-li2qi
@John-li2qi Жыл бұрын
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
@h1n1worm Жыл бұрын
aha, its easy if you dont go deep and try to understand how engine works inside =)
@jw11432
@jw11432 Жыл бұрын
@@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.
@h1n1worm
@h1n1worm Жыл бұрын
@@jw11432 well said,sir.
@TeamSQL
@TeamSQL Жыл бұрын
I was just waiting for this course plz make part 2 😍💥 Love from India 🤍
@michaelangelo2720
@michaelangelo2720 Жыл бұрын
love to see the next part! Thanks for the time making this video...
@unorthodocs1103
@unorthodocs1103 Жыл бұрын
I would love to see a video on database relationships. I've not found anything on the topic that I can understand and have been doing databases the hard way for years lol. Your videos are awesome and love the way you explain things. I haven't dabbled in the tech stuff in a while and it's awesome to watch videos like this explaining how to do stuff I use to do back in the day.
@wingkeung9979
@wingkeung9979 Жыл бұрын
Please please please finish this series 🙏
@Bloome_BlueFolf
@Bloome_BlueFolf Жыл бұрын
As always entertaining and informative!
@samsonkiflom5954
@samsonkiflom5954 Жыл бұрын
Thank you chuck! I know SQL but this time I know how to teach it to a complete beginner. I learned this from your video. Thank you! Please create the rest of the video ;)
@Rejoin_2023
@Rejoin_2023 Жыл бұрын
This is the best tutorial I have seen on SQL for beginners, many thanks.
@edwinjonah
@edwinjonah Жыл бұрын
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!
@ArcLove
@ArcLove Жыл бұрын
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?
@chrisjlocke
@chrisjlocke Жыл бұрын
Many IT jobs require some level of SQL knowledge as so many applications these days write to databases.
@kopilkaiser8991
@kopilkaiser8991 Жыл бұрын
❤️ I have revised my knowledge of SQL and databases as well enjoyed learning from your different approach to teach. You are interesting and fun. As well as being funny, you are a really great teacher.
@sayakarar
@sayakarar Жыл бұрын
@NetworkChuck it is an amazing tutorial as always. I love the way you teach, it intrigues the passion for learning and makes learning a enjoying experience. I would love if you make a tutorial series on SQL, it is much needed.
@epicnan1855
@epicnan1855 Жыл бұрын
when creating a table with a number as ID in MySQL, you can add *AUTO_INCREMENT* after the datatype. with this, you don't have to manage the 'ID' field (don't insert a value) since it automatically inserts numbers from 1 to infinity. this is especially important for integrity since you can be sure no ID is duplicate, even if you implement the primary keys wrongly.
@tabularasa0606
@tabularasa0606 Жыл бұрын
Correct, but you move beyond absolute beginner level with that.
@epicnan1855
@epicnan1855 Жыл бұрын
@@tabularasa0606 that's why it's in tje comments and not the video ;) people who are interested in it now can see it and research it also my name is just yours but epic lmao (i only put "epic" there because i figured it'd be easier to find myself)
@AbhinusWonderWorld
@AbhinusWonderWorld Жыл бұрын
Super video Chuck Your videos are awesome And informative Chuck
@dilpreetkohli6630
@dilpreetkohli6630 Жыл бұрын
Thanks, man this one was great. This a quick help for kali users apt-get install msql-server command will not work, but instead, they can try apt-get install mariadb-server followed by sudo mysql and it should work
@user-vd4kq5tf9d
@user-vd4kq5tf9d Ай бұрын
this is so much more helpful than any other sql video. thank you!!
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2 МЛН
3 Levels of WiFi Hacking
22:12
NetworkChuck
Рет қаралды 1,3 МЛН
INO IS A KIND ALIEN😂
00:45
INO
Рет қаралды 14 МЛН
Final muy inesperado 😨
01:00
Juan De Dios Pantoja
Рет қаралды 54 МЛН
host ALL your AI locally
24:20
NetworkChuck
Рет қаралды 89 М.
you need to learn Python RIGHT NOW!! // EP 1
17:42
NetworkChuck
Рет қаралды 2,2 МЛН
Hacking the world’s most popular database
35:42
NetworkChuck
Рет қаралды 141 М.
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 1,8 МЛН
i created malware with Python (it's SCARY easy!!)
25:18
NetworkChuck
Рет қаралды 2,2 МЛН
MySQL - The Basics // Learn SQL in 23 Easy Steps
17:17
Fireship
Рет қаралды 751 М.
The Birth of SQL & the Relational Database
20:08
Asianometry
Рет қаралды 172 М.
SQL Injections are scary!! (hacking tutorial for beginners)
10:14
NetworkChuck
Рет қаралды 1,3 МЛН
MySQL Tutorial for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 11 МЛН
Интел подвинься, ARM уже в ПК!
14:06
PRO Hi-Tech
Рет қаралды 158 М.
С Какой Высоты Разобьётся NOKIA3310 ?!😳
0:43
Что если бы Apple делала зубные щётки?
0:59