Learn SQL in 1 Hour - SQL Basics for Beginners

  Рет қаралды 3,646,412

Joey Blue

Joey Blue

Күн бұрын

A crash course in SQL. How to write SQL from scratch in 1 hour.
In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.
PREREQUISITES
You will need a database to practice on. The training uses SQL Server Developer Edition, but you can use MySQL, Oracle or any other relational database.
Install SQL Server Developer Edition:
• Installing Microsoft S...
You will also need a tool to write the SQL that you will send to the database. You can use SQL Server Management Studio (SSMS), Oracle Developer, TOAD, PHPMyAdmin, or any other tool you would like. I am using SSMS in this video.
Install SQL Server Management Studio (SSMS)
• Installing Microsoft S...
TABLE OF CONTENTS
00:00 - Intro
00:48 - Overview
03:27 - Discuss Management Studio
05:10 - Create Database
07:26 - Create Table
10:29 - Insert Data
17:43 - Select Statement
19:00 - Where Clause
22:25 - Update Statement
24:33 - Delete Statement
27:41 - Adding Comments
29:33 - Adding Columns
32:38 - Drop Table
33:17 - Add Primary Key
36:00 - Create Products Table
38:54 - Create Orders Table
45:37 - Foreign Keys
50:30 - Joins
56:50 - Functions/Group By
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
www.sqltrainingonline.com/lear...
KZfaq NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
kzfaq.info_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

Пікірлер: 1 000
@joeyblue1
@joeyblue1 3 жыл бұрын
TABLE OF CONTENTS 00:00​ - Intro 00:48​ - Overview 03:27​ - Discuss Management Studio 05:10​ - Create Database 07:26​ - Create Table 10:29​ - Insert Data 17:43​ - Select Statement 19:00​ - Where Clause 22:25​ - Update Statement 24:33​ - Delete Statement 27:41​ - Adding Comments 29:33​ - Adding Columns 32:38​ - Drop Table 33:17​ - Add Primary Key 36:00​ - Create Products Table 38:54​ - Create Orders Table 45:37​ - Foreign Keys 50:30​ - Joins 56:50​ - Functions/Group By PREREQUISITES You will need a database to practice on. The training uses SQL Server Developer Edition, but you can use MySQL, Oracle or any other relational database. Install SQL Server Developer Edition: kzfaq.info/get/bejne/ZpuKnNmE2cureps.html You will also need a tool to write the SQL that you will send to the database. You can use SQL Server Management Studio (SSMS), Oracle Developer, TOAD, PHPMyAdmin, or any other tool you would like. I am using SSMS in this video. Install SQL Server Management Studio (SSMS) kzfaq.info/get/bejne/edegiLWK1rHDp4k.html
@aryanjuneja5719
@aryanjuneja5719 3 жыл бұрын
thanks man, appreciate it !
@spayne0729
@spayne0729 3 жыл бұрын
@joeyblue dumb question alert. I took a class in Oracle SQL and T-SQL. Is this either? My teachers were awful and I didn't learn enough to save my life they just took my money so the reviews on this video I want to watch and take notes.
@AnoopSreenath
@AnoopSreenath 2 жыл бұрын
We have been working with our team and have a great team that we can do
@duowang1480
@duowang1480 Жыл бұрын
Thanks very much for the beginner to learn SQL skills. After AVG computation, the 'total' column is the average and the middle column is the total.
@princegupta-ls9st
@princegupta-ls9st Жыл бұрын
You did a great job. It's pretty simple and straightforward. The best part is that it's free on KZfaq.😎😎
@austincotter8525
@austincotter8525 5 жыл бұрын
Youre a god. You taught me more in an hour than my professor has all semester, and earned me an 84 on a test that I otherwise would have scored anywhere between 0 and -100 on. So thank you.
@owensurett9970
@owensurett9970 4 жыл бұрын
what course teaches sql?
@jasonelcr
@jasonelcr 4 жыл бұрын
bro dont be happy, go learn html, css... sql is the easies coding lang
@austincotter8525
@austincotter8525 4 жыл бұрын
@@owensurett9970 Was database management
@Digger-Nick
@Digger-Nick 4 жыл бұрын
@@jasonelcr Implying html and css are difficult?
@FritzMusicNow
@FritzMusicNow 4 жыл бұрын
@@Digger-Nick lol
@fantasyd1928
@fantasyd1928 6 жыл бұрын
[5:20] Create Database [6:18] Activate Database USE database_name [7:28] Create Table CREATE TABLE table (col1_name col1_type, col2_name col2_type) [10:27] Insert Data INSERT INTO table (col1, col2, col3) VALUES (val1, val2, val3) [17:47] Select Data SELECT columns FROM table WHERE condition(s) Note: for multiple conditions, use AND, OR [20:44] WHERE clause examples with operator LIKE with wildcard %, _ [22:30] Update Data UPDATE table SET col = … WHERE some condition(s) [26:35] Delete Data Delete table WHERE some condition(s) [27:41] Comment One-line comment -- your comment Multi-line comments /* your comments your comments */ [29:25] Add column(s) ALTER TABLE table_name ADD column_name column_type [33:13] Drop table [40:00] Prepare tables: orders, Customer, Products [46:30] Add foreign key for table ALTER TABLE tb_name ADD FOREIGN KEY (tb1_col) REFERENCES tb2(tb2_id); Notes: set two foreign keys for CustomerID, ProductID within table orders, reference to tables Customer and Products respectively. We can also create foreign keys when we create table [50:32] Joins and Relationships [50:10] Example: Inner join & alias [52:29] Refresh Local Cache to avoid red lines, Ctrl + Shift + R [57:14] Function SUM() [58:05] Group by [1:00:03] Funtion AVG() SELECT column AS column_name FROM table_x AS alias_x INNER JOIN table_y AS alias_y ON alias_x.id = alias_y.id INNER JOIN table_z AS alias_z ON alias_z.id = alias_z.id GROUP BY column Notes: AS is optional
@surabhibhatnagar4976
@surabhibhatnagar4976 5 жыл бұрын
Thanks a lot!!
@foysalmoinuddingonichowdhu9122
@foysalmoinuddingonichowdhu9122 4 жыл бұрын
Thank you so much for your Capital Letter SYNTAX, REMEMBER
@amritsharmapoudel959
@amritsharmapoudel959 4 жыл бұрын
You da real MVP.
@sujithmedari1852
@sujithmedari1852 4 жыл бұрын
Some heroes don't wear capes.
@sulochanapaudyal340
@sulochanapaudyal340 4 жыл бұрын
Amrit Sharma Poudel aa
@jason7139
@jason7139 6 жыл бұрын
Your 1 hour video taught me more than my online class has in 6 weeks. Thank you so much!
@krishnazole51
@krishnazole51 Жыл бұрын
Ok
@pamelamalthouse237
@pamelamalthouse237 5 жыл бұрын
Brilliant I have learned more in under 1 hour than I did participating on a course for 3. Excellent so glad I found the video... easy to grasp the idea and the video is great Thanks
@sandyfraser100
@sandyfraser100 2 жыл бұрын
Can you help a complete dumbo here, I cant get out with my emails in outlook, it was working just fine with right password and everything in place unchanged, so I thought deleting my old 2003 microsoft office and re install, but no luck, then I completely deleted every single thing to do with 2003, and installed 2007 which has went in ok, yet, I still cant get out, and got a warning about SQL, any ideas come to hand please.
@riseofthelady
@riseofthelady 3 жыл бұрын
As my career changes, it is a real plus to find your videos. Patiently explained and gone thru. I don't feel overwhelmed or stressed. You make it seem as though I've been in the wrong field all along. Thanks!!!
@FINANCI
@FINANCI 6 жыл бұрын
Good video. Good pace, good voice, good mood, good examples I'm learning. Thank you.
@hanglishi9697
@hanglishi9697 5 жыл бұрын
The one-hour video covers almost all the basic keys. It is absolutely the great class for beginners. Thanks a lot!
@Rahee11
@Rahee11 4 жыл бұрын
Thanks. This is the best introduction on SQL I found so far. It starts simple and gradually builds on the simple start. Really helpful for beginners like me.
@Sowrdfish8
@Sowrdfish8 6 жыл бұрын
Easy to follow. No pausing needed. Clear concise and only what is required. This will become the default SQL tutorial on youtube.
@barathwaj1137
@barathwaj1137 9 ай бұрын
Using this for interview preparation
@andrewpeterson4219
@andrewpeterson4219 6 жыл бұрын
Thanks Joey! I am experienced with SQL and will occasionally work through this hour as a warm up on the fundamentals. You've done a great job sir.
@OphidianAngel
@OphidianAngel 5 жыл бұрын
Thanks alot for the clear instruction. I've been struggling with SQL for some while but somehow while watching your video(s) I noticed I'm becoming more and more handy with SQL and it's actions. Much appreciated! Greetings from The Netherlands.
@sandyfraser100
@sandyfraser100 2 жыл бұрын
Can you help a complete dumbo here, I cant get out with my emails in outlook, it was working just fine with right password and everything in place unchanged, so I thought deleting my old 2003 microsoft office and re install, but no luck, then I completely deleted every single thing to do with 2003, and installed 2007 which has went in ok, yet, I still cant get out, and got a warning about SQL, any ideas come to hand please.
@zinedinhadzajlija6225
@zinedinhadzajlija6225 5 жыл бұрын
I'm watching this tutorial and simultaneously doing my project that's due in 10 hours or so. You just earned yourself a subscriber mate ❤️ Edir: I got full marks, God bless you
@emanjavascript8358
@emanjavascript8358 4 жыл бұрын
Very straight forward of teaching that most of the beginners needs..
@sourabhpawar3856
@sourabhpawar3856 6 жыл бұрын
Really helped me out. It has been really long time i haven't written any SQL query this helped me in refreshing stuff. Good work sir.
@bongo6985
@bongo6985 3 жыл бұрын
Iabahshswhhwhqh1hdhehe8
@bongo6985
@bongo6985 3 жыл бұрын
S
@patientson
@patientson 6 жыл бұрын
Your voice and your style of teaching is impeccable.
@kevinclarke3485
@kevinclarke3485 6 жыл бұрын
You are sooooo good, buddy... even for a rusty DBA who's been away from SQL and hands-on database management for a long time
@paulapericozzi5660
@paulapericozzi5660 6 жыл бұрын
Thanks for the refresher course. It been a few years since I wrote any SQLand this was helpful!
@tttggg63
@tttggg63 6 жыл бұрын
Very good video. As a beginner I thank you for this trainning, it really helpped me a lot. Thank you.
@abdirahmanabdulahi5318
@abdirahmanabdulahi5318 2 жыл бұрын
Since you commented on this 3 years ago do you somehow feel you mastered sql
@marensvare507
@marensvare507 5 жыл бұрын
This is a great overview! I'm totally new to SQL but was handed some work projects with it and have been trying to grasp the fundamentals of what was going on. This is super helpful!
@zhangxian5730
@zhangxian5730 6 жыл бұрын
It's my first video of SQL. Definitely a very clear and a good start. Thanks for making this helpful and educational video!
@tanjatesic7923
@tanjatesic7923 3 жыл бұрын
Thank you so much Joey for this fantastic SQL tutorial!!! It helped me so much to refresh my previous knowledge of SQL. You simplified this topic in such great, manageable chunks and easy to absorb. This great tutorial is an excellent starting point in SQL and helps people now to build up more knowledge if they wish to. I am so grateful for this. I will subscribe to your channel now. Best wishes from London, UK. :)
@khehrainder
@khehrainder 5 жыл бұрын
One hour class taught me more than a month's class! Thank you Joey :)
@jonlaniyan2055
@jonlaniyan2055 Жыл бұрын
Absolutely brilliant. Learnt so much in an hour. Now I won't be lost when discussions about foreign keys, joins strings and everything SQL related is being had. Thanks so much Joey!!!
@adeelahmad5599
@adeelahmad5599 6 жыл бұрын
Tears in my eyes as I write this comment. I have never found any tutorial like this before. Such a soothing voice and method of teaching SQL, you have covered my whole semester in under 1 hour and 2 minutes. Thank you, Thank you Thank you. .
@techcanyon411
@techcanyon411 6 жыл бұрын
watching video is not enough,you might need to read more in the school liabrary or bought a text book of it.i could remember vividly when i started learning PHP i started watching diff youtube video wish i thought i could be more versatile but until i decided to bought the text book,that is when i understand alot of PHP rules and priciples and guildline of coding,error handling e.t.c
@anirudhsuresh3775
@anirudhsuresh3775 5 жыл бұрын
Thank You Joey. It was very helpful. I appreciate people like you doing this for us.
@stevodoe4900
@stevodoe4900 6 жыл бұрын
I only got 22 minutes in so far, but I must say it's been more helpful than a few hours of reading I've done. I would highly recommend everyone subscribes and checks out his other videos as well. Because if you are anything like me, reading boring SQL books tend to go way over my head since I'm more a "visual" learner / who needs to practice as well. My advice for people struggling with SQL watch the video without doing anything just watch what he does. And, then re-watch it again and follow along the examples (tweaking them a little so you can understand and apply the information). I would say this is truly the first time I've been interested in learning SQL. Because it's taught at a beginner level, and at a beginner pace which is exactly what I need. Overall, very well done! I appreciate all the work put into these videos, so thank you for that! Would love to see some beginner C# videos as well if that's your cup of tea since I really enjoy the teaching style.
@janhendrikbredee7491
@janhendrikbredee7491 4 жыл бұрын
Thank you very much for helping me transfer from Acces to SQL Server in such a short time. Excellent pace of presentation. You have already covered 80% of the things that I need for my projects at work.
@breezelord
@breezelord 5 жыл бұрын
Huge thanks, completed entire tutorial. I just want to light a candle for anyone (like me) that pressed F5 on the youtube video instead of SQL mgmt studio several times throughout watching. May your BP levels now be lowered once completed. Sam
@agakhdir7843
@agakhdir7843 4 жыл бұрын
;
@sanjeev143143143
@sanjeev143143143 6 жыл бұрын
Thank you for this great tutorial. It has very good pace. I looked at the end first and then I thought OMG, its very complicated and how I am going to understand this in one hour. But, you made is so simple and brick by brick from beginning. Awesome and Thanks again.
@aravindappaji5215
@aravindappaji5215 4 жыл бұрын
thank you Joey. I haven't written any SQL query since my degree and this helped me in refreshing stuff. I would recommendd this video to beginners
@elroycrasto
@elroycrasto 5 жыл бұрын
This video helped me learn all of this within 2 hrs where I only had 12hrs to study, the fact that you made this video from recording it to editing and uploading it on the same day is *mind-blowing* !!!, hats off to that.
@amolgandal564
@amolgandal564 5 жыл бұрын
What a way to teach SQL in simplistic manner, really liked the explanation, video and content. Great job Joey, keep inspiring folks across the globe with your knowledge sharing. Thank you so much. Take care!
@HennaSahota
@HennaSahota 6 жыл бұрын
dude thank you so much i was legit drowning in tears the other day thinking i was gonna fail this course but this video really simplified things to a point where i could clearly understand and follow what was going on. My prof is good but goes too fast & just thinks we know what she's talking about so seriously thank you so much
@techcanyon411
@techcanyon411 6 жыл бұрын
watching video is not enough,you might need to read more in the school liabrary or bought a text book of it.i could remember vividly when i started learning PHP i started watching diff youtube video wish i thought i could be more versatile but until i decided to bought the text book,that is when i understand alot of PHP rules and priciples and guildline of coding,error handling e.t.c
@jagrajcheema5504
@jagrajcheema5504 5 жыл бұрын
which university?
@olakunleoni1514
@olakunleoni1514 4 жыл бұрын
You broke it down beyond my expectations. Covered so much in an hour. You're a genius
@darefatir
@darefatir 5 жыл бұрын
Super helpful! Thanks a lot, you are amazing in the way of keeping the audience focus for 1-hour straight
@olumideafariogun8032
@olumideafariogun8032 6 жыл бұрын
Fantastic insight. Very very good in breaking things down. I will sign up for your 10hour lecture ...thanks
@tobiasrasmussen4347
@tobiasrasmussen4347 2 жыл бұрын
Brilliant video. You are very good at explaining these concepts in beginner-friendly terms and at a nice relaxed pace.
@beingheardmedia6339
@beingheardmedia6339 4 жыл бұрын
Thank you. This was brilliant. I"ve been tryign to learn SQL for years. This was very simple and clear. You explained the primary and foreign keys so well; they've been stumbling blocks for me. You also explained the data types so simply. I had been logjammed before but now I think I can try moving forward again.
@pavanbugatha5394
@pavanbugatha5394 6 жыл бұрын
Good Video and ease to understand SQL in span of an hour. Thank you Joey
@annamartin56
@annamartin56 6 жыл бұрын
This was a great refresher. You are a good teacher. Thank you.
@quantomic1106
@quantomic1106 4 жыл бұрын
This video maybe is the only comprehensive and understandable MS SQL beginner's guide on KZfaq. Thanks for making this. You've earned a new subscriber.
@lizds1
@lizds1 4 жыл бұрын
Thanks! I'm new to SQL (have to learn for work) and this helped a lot! Will be checking out your website and some of the other videos!
@andrew1984uk
@andrew1984uk 4 жыл бұрын
Thanks for this Joey, much appreciated!
@prixy92
@prixy92 5 жыл бұрын
Awesome tutorial. Thank you, Joey, for the amazing topic coverage and explanation!! Very helpful!! :) :)
@bi-c0ninafricanlimited259
@bi-c0ninafricanlimited259 3 жыл бұрын
Thank you somuch Joey, I learnt a lot in your one hour tutorial.
@sandyfraser100
@sandyfraser100 2 жыл бұрын
Can you help a complete dumbo here, I cant get out with my emails in outlook, it was working just fine with right password and everything in place unchanged, so I thought deleting my old 2003 microsoft office and re install, but no luck, then I completely deleted every single thing to do with 2003, and installed 2007 which has went in ok, yet, I still cant get out, and got a warning about SQL, any ideas come to hand please.
@collinclark1330
@collinclark1330 5 жыл бұрын
Joey, this video really helped me prep for my new Dba position here in Wichita. Thanks a ton for the awesome videos!! I can’t stop watching them!!
@aimilios4794
@aimilios4794 4 жыл бұрын
Probably the best tutorial for SQL and SSMS. It helps me a lot as a Beginner. Literally in less than 2 hours i learned all the beginners staffs about SQL. Also, Your voice and your style of teaching is amazing.!! Thank you very much!!!
@marjanminou
@marjanminou 4 жыл бұрын
just wanted to say I wish I had checked this out first before buying a different udemy course on sql....this was so neatly succinct within the right amount of overview/detail that I would love to support you by buying your course now, as a thank you for offering this amazing introduction for free.
@sandyfraser100
@sandyfraser100 2 жыл бұрын
Can you help a complete dumbo here, I cant get out with my emails in outlook, it was working just fine with right password and everything in place unchanged, so I thought deleting my old 2003 microsoft office and re install, but no luck, then I completely deleted every single thing to do with 2003, and installed 2007 which has went in ok, yet, I still cant get out, and got a warning about SQL, any ideas come to hand please.
@ibroximaliyev1569
@ibroximaliyev1569 6 ай бұрын
I watched in 2024!!!
@nandishns5021
@nandishns5021 2 ай бұрын
I am watching now as completely beginner 😅
@madhurisweety1262
@madhurisweety1262 2 ай бұрын
Me also
@sirajhashmi8121
@sirajhashmi8121 4 жыл бұрын
Thanks for an amazing crash course on SQL Basics. This video helped me understand lot of basic database knowledge and how SQL plays an integral part in the whole relational databases.
@kolawoleilesanmi9203
@kolawoleilesanmi9203 2 жыл бұрын
You're an amazing tutor!!!... As a rookie to SQL, you've just made this more simpler for me.... Thanks Joey
@TheSowut
@TheSowut 5 жыл бұрын
Perhaps the best SQL starter tutorial out there. Thank you !
@spfeelmypulse
@spfeelmypulse 6 жыл бұрын
Thanks...Joey Subscribed....
@poojasingla9365
@poojasingla9365 6 жыл бұрын
Great fresher lesson! Adequate speed, clear voice and to the point. Awesome!
@belchchitura5116
@belchchitura5116 Жыл бұрын
This is one of the most satisfying content that I have found in my BI journey. Looking forward to going through the playlist.👌
@whymizan
@whymizan 6 жыл бұрын
simply amazing outstanding
@65MaX73
@65MaX73 11 ай бұрын
I have an interview tomorrow and my SQL knowledge is rusty af. Gonna watch this video and it helps me 😭😭
@JS-kb4bk
@JS-kb4bk 11 ай бұрын
How did it go?
@65MaX73
@65MaX73 11 ай бұрын
​@@JS-kb4bk They didn't even ask me SQL questions.. I said I have PostgreSQL experience and they said that's too powerful for their needs 🤣in the end they asked me to do some frontend and backend for their app "as a test"... Im gonna do it but won't document anything just in case
@sowhat1191
@sowhat1191 6 ай бұрын
Is everything going ok?
@65MaX73
@65MaX73 6 ай бұрын
Hey yeah! Landed that job 3 months ago :D and they extended my contract for another 6 months. Really happy how it turned out considering that's my very first job as a developer@@sowhat1191 😊😊
@nicolemwanaidi1488
@nicolemwanaidi1488 5 жыл бұрын
I have watched all 52 videos on sql and they give me life. Thank You.
@shahlaalhamy4914
@shahlaalhamy4914 6 жыл бұрын
Thank you so much for this amazing video. I've been trying to find something like this for a long time to learn SQL on my own and this is perfect.
@rajas9352
@rajas9352 4 жыл бұрын
It was very helpful Joey Blue, thanks :)
@jonashjelmblink90
@jonashjelmblink90 5 жыл бұрын
Our teacher recommended this video to us.
@vaishnavitolpady2133
@vaishnavitolpady2133 5 жыл бұрын
This video was a refresher for me. Its been 3 years from the time I used to write SQL code and this video has helped me a lot to brush up my knowledge as well as learn new things.
@AMan-yo3sy
@AMan-yo3sy 4 жыл бұрын
This was amazing, I built a whole imaginary webshop using this and a bit of google searching. Great foundation here for anyone interested in getting into this stuff! Thank you for making this available for free!
@kausarkhan1466
@kausarkhan1466 4 жыл бұрын
I have an interview tomorrow... this video helped me to refresh everything in easiest way only in one hour... ur voice and teaching style is superb 👍👍
@Drayafenandez
@Drayafenandez 5 жыл бұрын
thank you. I have a job interview tomorrow and needed to brush up on my database queries. I appreciate the video!
@sz2585
@sz2585 5 жыл бұрын
Thanks Joey! I have a DB test tomorrow and missed most of course. With this video I’m back up to speed, real good man.
@SahirJafri
@SahirJafri 3 жыл бұрын
Wow! I learned so much in only one hour! You are so organized and your teaching style and voice makes it so easy to learn and concentrate! God Bless you!!
@tasmiaanwar4742
@tasmiaanwar4742 6 жыл бұрын
really such an Amazing Tutorial .... and Amazing Style of teaching. very helpful for my final year project. :-)
@rp7302
@rp7302 4 жыл бұрын
Thank you for making this video. I'm gonna get out there and be somebody. Seriously, very informative!
@emmanuelkemakolam7073
@emmanuelkemakolam7073 5 жыл бұрын
Thanks joey! , you have made it easier for me to understand SQL fundamentals.
@madziakk77
@madziakk77 5 жыл бұрын
Nice voice :D I'm starting my SQL adventure with your crash course. And I can add, that it is not easy to pleased my learning needs. You are a really good teacher! Thank you
@ToasTFresh
@ToasTFresh 4 жыл бұрын
I have an exam tomorrow, thanks for the review, wish me luck.
@brianhoskins1979
@brianhoskins1979 5 жыл бұрын
Excellent introductory foundation. I have only minor constructive criticism: When setting up the Customer table, you added an 'Age' column. Now, I know the purpose was just to have some columns and data to play with and you were not concerned with database design. But since you are offering a short course for people to be able to build on, I think it would have been worth at least mentioning that in practice Age would probably be a poor column to add as it would not track the real-time ages of actual customers, and for that you'd need to use a birthdate instead. Cheers!
@gofftershnit
@gofftershnit 5 жыл бұрын
I actually have to take a Database Fundamentals course this next semester, so thanks Joey. This helps explain things, as well as refresh my memory of C# and some programming.
@Robert8455
@Robert8455 6 жыл бұрын
Nice job Joey Blue. This was a good refresher for me. I thought you were easy to understand, ran a good pace and didn't waste a lot of time.
@rb0610
@rb0610 5 жыл бұрын
select * from CitiesOfTheWorld where CityName = 'Goddard' ***RETURNS empty table***
@vidakorfa487
@vidakorfa487 5 жыл бұрын
R B Thank you Sir 👍 I have learn a lot today
@VirtualCrime
@VirtualCrime 4 жыл бұрын
It's a city in Lineage 2
@Osky305
@Osky305 3 жыл бұрын
so once i know sql like the back of my hand i can start applying to those 300k software jobs right XD
@derxan9496
@derxan9496 4 жыл бұрын
Great video!! Covered up every single thing I was not able to understand at school. Thanks man!!
@sergengansop7543
@sergengansop7543 2 жыл бұрын
Thank you joey for this video. I just started a DATABASE class few days ago. But I was lost until I star LISTENING to your video to learn more about concepts .Now after washing this tutorial I'm getting it a little by little.
@cartergirl3of3
@cartergirl3of3 6 жыл бұрын
nice, but not really for beginners. A lot of things were'n't explained. For people who know very basic SQL but not for people who know nothing.
@buksie11
@buksie11 5 жыл бұрын
True
@Codrean
@Codrean 5 жыл бұрын
True. It was good in my case for refreshing the initial concepts I learned months ago, but it is not the best class for really beginners.
@jp216
@jp216 2 жыл бұрын
Anyone watching this in 2022? 💖
@MsKay287
@MsKay287 2 жыл бұрын
🙋‍♀️
@SurrounDyou
@SurrounDyou Жыл бұрын
2023!
@MrSj840
@MrSj840 Жыл бұрын
2023👍
@eltorocornal2649
@eltorocornal2649 Жыл бұрын
2023
@innocentchiwandah6731
@innocentchiwandah6731 Жыл бұрын
2023
@dergimorka6126
@dergimorka6126 4 жыл бұрын
am very glad to mess around with my laptop and found this amazing and brilliant way teaching I learn a lot of stuff to be honest thank u very much sir!
@jenh3183
@jenh3183 5 жыл бұрын
I'm taking an online SQL course. This has helped immensely. Thanks so much!
@shrutisanghavi8137
@shrutisanghavi8137 4 жыл бұрын
Joey Blue is very gifted in teaching. I am a teacher trying to learn SQL on my own and the video and directions are so easy to follow.
@srmoss24ify
@srmoss24ify 5 жыл бұрын
🙌🏽Thank you, thank you... I am the novice beginner and was stressing in my class until I came across this video.
@mrachel16
@mrachel16 5 жыл бұрын
Thank you sooo much for the video. I have my lab exam in few days and this makes the joins so easy for me to understand! Thank you,thank you...
@marczenkner9667
@marczenkner9667 3 жыл бұрын
Really great tutorial! It took me a lot more than an hour to do it, but brilliant stuff. Thanks for doing that.
@liondk1589
@liondk1589 4 жыл бұрын
This is such a helpful guide, 3 months of school into 1 clip! Great video, make more of it!!!
@mohieali7317
@mohieali7317 5 жыл бұрын
Awesome video, well organized. So simple but very professional. Thank You Joey
@happybits
@happybits Жыл бұрын
Thanks Joey for a great and practical video about the most important parts of SQL. I work as a teacher in programming and database design. Me and my students have great value of this course, keep up the good work.
@jacquelinefay7775
@jacquelinefay7775 5 жыл бұрын
Best tutorial I have found thus far. I started a course a few weeks ago and have been so lost. This was a great start and I feel much better about the course now. I saw how long this was and wasn't sure I could stay focused through the whole thing, but really the way it was executed was amazing. Thanks
@anthonyifedirah9672
@anthonyifedirah9672 4 жыл бұрын
King Joey..You have been officially crowned the King of my City. I am a SQL beginner and the goal is to be a DBA in four months. Your one hour training has been really beneficial to me. It is easy to understand. May you keep shinning in all that you do.
@ProsperAni
@ProsperAni Жыл бұрын
Hello Anthony, I'm curious, did you reach your goal of becoming a DBA?
@specificgravity-thedancing9700
@specificgravity-thedancing9700 2 жыл бұрын
This is the most i've learned about any subject in this little time. Thanks for the hard work and great video!! Go Joey Blue!
@AkoPoSiMikestro
@AkoPoSiMikestro 3 жыл бұрын
This tutorial is so helpful to those who are starting to be in love in sql programming. Thank you so much sir
@puja6964
@puja6964 2 жыл бұрын
thanks Joey so much for such a beautifully crafted tutorial.I just finished my revision through this video.
@mylespowell2221
@mylespowell2221 4 жыл бұрын
aY BIGMAN, this sql video was SICK FAM!!! keep up the good work. MY GUY
@sinaestiak2916
@sinaestiak2916 6 жыл бұрын
No trash talking, straight jump into the point ... Like it ...
@murphydublin
@murphydublin 5 жыл бұрын
Yes! It is a good tutorial for just one hour. Thank you Joey
@JJLCM
@JJLCM 5 жыл бұрын
This was perfect. Will certainly buy the course. Definitely seems worth it. This was a really great video.
@JV-fm5ul
@JV-fm5ul 5 жыл бұрын
for the first time in my life i watched the whole educational video, thanks for the wonderful content and info.
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 2 МЛН
DO YOU HAVE FRIENDS LIKE THIS?
00:17
dednahype
Рет қаралды 105 МЛН
3M❤️ #thankyou #shorts
00:16
ウエスP -Mr Uekusa- Wes-P
Рет қаралды 15 МЛН
Red❤️+Green💚=
00:38
ISSEI / いっせい
Рет қаралды 65 МЛН
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2 МЛН
SQL Server Management Studio (SSMS) | Full Course
1:22:44
Joey Blue
Рет қаралды 538 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,4 МЛН
SQL Beginner to Advanced in One Hour | CareerFoundry Webinar
1:08:28
Alex The Analyst
Рет қаралды 207 М.
God-Tier Developer Roadmap
16:42
Fireship
Рет қаралды 7 МЛН
SQL Tutorial for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 11 МЛН
Зачем ЭТО электрику? #секрет #прибор #энерголикбез
0:56
Александр Мальков
Рет қаралды 443 М.
Что не так с раскладушками? #samsung #fold
0:42
КРУТОЙ ТЕЛЕФОН
0:16
KINO KAIF
Рет қаралды 5 МЛН
Clicks чехол-клавиатура для iPhone ⌨️
0:59
Сколько реально стоит ПК Величайшего?
0:37