Learn SQL in 1 Hour - SQL Basics for Beginners
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- 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...
TH-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
th-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
Facebook: / sqltrainingonline
Twitter: / sql_by_joey
Linkedin: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com - วิทยาศาสตร์และเทคโนโลยี
![SQL Tutorial for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
![[TH] VCT Pacific Stage 2 - Playoffs Lower Bracket Final // PRX vs DRX](http://i.ytimg.com/vi/5HwO1bQyAx4/mqdefault.jpg)
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:
th-cam.com/video/05ZivSteGJg/w-d-xo.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)
th-cam.com/video/CqpURYqK_wU/w-d-xo.html
thanks man, appreciate it !
@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.
We have been working with our team and have a great team that we can do
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.
You did a great job.
It's pretty simple and straightforward.
The best part is that it's free on TH-cam.😎😎
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.
what course teaches sql?
bro dont be happy, go learn html, css... sql is the easies coding lang
@@owensurett9970 Was database management
@@jasonelcr Implying html and css are difficult?
@@Digger-Nick lol
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!!!
[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
Thanks a lot!!
Thank you so much for your Capital Letter SYNTAX, REMEMBER
You da real MVP.
Some heroes don't wear capes.
Amrit Sharma Poudel aa
Your 1 hour video taught me more than my online class has in 6 weeks. Thank you so much!
Ok
Good video. Good pace, good voice, good mood, good examples I'm learning. Thank you.
The one-hour video covers almost all the basic keys. It is absolutely the great class for beginners. Thanks a lot!
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
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.
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.
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.
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
Easy to follow. No pausing needed.
Clear concise and only what is required.
This will become the default SQL tutorial on youtube.
Using this for interview preparation
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.
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.
Very straight forward of teaching that most of the beginners needs..
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
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!!!
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.
Your voice and your style of teaching is impeccable.
It's my first video of SQL. Definitely a very clear and a good start. Thanks for making this helpful and educational video!
This video maybe is the only comprehensive and understandable MS SQL beginner's guide on TH-cam.
Thanks for making this. You've earned a new subscriber.
Thanks for the refresher course. It been a few years since I wrote any SQLand this was helpful!
One hour class taught me more than a month's class!
Thank you Joey :)
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. :)
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!
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.
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.
Iabahshswhhwhqh1hdhehe8
S
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.
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
Very good video. As a beginner I thank you for this trainning, it really helpped me a lot. Thank you.
Since you commented on this 3 years ago do you somehow feel you mastered sql
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
;
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!!!
You broke it down beyond my expectations. Covered so much in an hour. You're a genius
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!
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.
.
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
I have watched all 52 videos on sql and they give me life. Thank You.
Thank You Joey. It was very helpful. I appreciate people like you doing this for us.
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.
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!
This is one of the most satisfying content that I have found in my BI journey. Looking forward to going through the playlist.👌
Fantastic insight. Very very good in breaking things down. I will sign up for your 10hour lecture ...thanks
Good Video and ease to understand SQL in span of an hour. Thank you Joey
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.
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.
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
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
which university?
Brilliant video. You are very good at explaining these concepts in beginner-friendly terms and at a nice relaxed pace.
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!!
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.
Thanks for this Joey, much appreciated!
This was a great refresher. You are a good teacher. Thank you.
You're an amazing tutor!!!... As a rookie to SQL, you've just made this more simpler for me.... Thanks Joey
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!!
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.
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.
Our teacher recommended this video to us.
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.
Great fresher lesson! Adequate speed, clear voice and to the point. Awesome!
Awesome tutorial. Thank you, Joey, for the amazing topic coverage and explanation!! Very helpful!! :) :)
Thank you somuch Joey, I learnt a lot in your one hour tutorial.
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.
It was very helpful Joey Blue, thanks :)
Super helpful! Thanks a lot, you are amazing in the way of keeping the audience focus for 1-hour straight
This is such a helpful guide, 3 months of school into 1 clip!
Great video, make more of it!!!
Perhaps the best SQL starter tutorial out there.
Thank you !
Thanks...Joey Subscribed....
No trash talking, straight jump into the point ... Like it ...
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
I watched in 2024!!!
I am watching now as completely beginner 😅
Me also
simply amazing outstanding
I'm taking an online SQL course. This has helped immensely. Thanks so much!
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!
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 👍👍
I have an exam tomorrow, thanks for the review, wish me luck.
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.
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.
Hello Anthony, I'm curious, did you reach your goal of becoming a DBA?
really such an Amazing Tutorial .... and Amazing Style of teaching. very helpful for my final year project. :-)
I have an interview tomorrow and my SQL knowledge is rusty af. Gonna watch this video and it helps me 😭😭
How did it go?
@@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
Is everything going ok?
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 😊😊
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.
🙌🏽Thank you, thank you... I am the novice beginner and was stressing in my class until I came across this video.
thank you. I have a job interview tomorrow and needed to brush up on my database queries. I appreciate the video!
Thank you for making this video. I'm gonna get out there and be somebody. Seriously, very informative!
This tutorial is so helpful to those who are starting to be in love in sql programming. Thank you so much sir
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!
so once i know sql like the back of my hand i can start applying to those 300k software jobs right XD
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!
Great video!! Covered up every single thing I was not able to understand at school. Thanks man!!
for the first time in my life i watched the whole educational video, thanks for the wonderful content and info.
select *
from CitiesOfTheWorld
where CityName = 'Goddard'
***RETURNS empty table***
R B Thank you Sir 👍 I have learn a lot today
It's a city in Lineage 2
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.
True
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.
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.
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...
Anyone watching this in 2022? 💖
🙋♀️
2023!
2023👍
2023
2023
This was bad a$$! Thanks a lot Joey. I learned more from this than I have an entire semester
The best SQL tutorial for beginners in TH-cam!
aY BIGMAN, this sql video was SICK FAM!!! keep up the good work. MY GUY
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.
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.
Thanks joey! , you have made it easier for me to understand SQL fundamentals.
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.
Really great tutorial! It took me a lot more than an hour to do it, but brilliant stuff. Thanks for doing that.
I have never come across such a phenomenal SQL video in my lifetime..Dude you are the BOMB!Learned more than i got from my Indian Prof.!
I rarely write comments,but this video after watching so many others finally clarified most of the things i needed about SQL!
Thank you,sir and wish you all the best! :)
I am a beginner. This is a great tutorial. Very useful!! Thank you
this video helped me more than my work book. I feel ready for my exams. thanks