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: ruclips.net/video/05ZivSteGJg/видео.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) ruclips.net/video/CqpURYqK_wU/видео.html
@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.
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.
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
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
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.
This video maybe is the only comprehensive and understandable MS SQL beginner's guide on RUclips. Thanks for making this. You've earned a new subscriber.
[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
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.
When you have been sleeping during class coz the other course has taken all your energy and u realize that tomorrow is the final test and you haven't even looked att the course material. This guy saves ya life
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
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
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!!!
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!
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.
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.
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.
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.
Thank you for making SQL clearer to understand. I don't think it is hard, but if no one explains to you where to use a column and a table... and the brackets and use them to get a space, well I was taught by my instructor if you cannot get the name right, use the brackets and that will make the red marks go away.
@@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
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 😊😊
I was tinkling how will I do well in SQL but your teacher has create a path for me now I can tell you that I know the way out; thank You love your class time.
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.
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.
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!!!
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!!!
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!!
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!
Great tutorial, here you see the real essentials of Querying Crystal Clear. For those of you wondering how to enable line numbers in the Query Editor goto: Tools>Options>All Languages check: Line Numbers (version: Microsoft SQL Server Management Studio 17)
Been getting burned in interviews cause I have SQL proficiency on my resume and it's been a while since I've used it. Got an interview in 3 hours, you rock!!
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.
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.
Not recommended for beginners ! Only for that already has took few lessons and basics in sql , it's like a second lever tutorial , thanks for sharing and making this available on RUclips, outstanding work 👏
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. :)
Hi Joey, Thanks for this info, has been helping me in learning SQL! I have picked up so far two discrepancies for those using Linux (Mysql) of late... in my aspect - I am using MariaDB (mySql in Manjaro Linux), and some syntax is different or not allowed in your tutorial. So far, 1) When you DELETE data from a table (multiple entries) it will not let you just using DELETE tablename.... instead in MariaDB using MySQL Workbench Ver 8 (oracle), you need to use the Syntax - DELETE Customer from dbname; --- then it will delete all the data. Second one I just picked up at 34:18 into your tutorial, is for the Primary Key - identity is now replaced by - AUTO_INCREMENT - it does not allow identity(1,1). If I pick up any more I will post here as I go through (For anyone who has a similar issue, otherwise its great, thanks again!!
Last Issue --- SUM -- I have been looking --- my SUM results bring results like 421.7300100326538 and 991.8500270843506 ---- How can I sum or change to round to 2 decimal places? If I make a change to the column Price in a table --- Like changing it from type FLOAT to INT or another as a test --- what command do I use like ALTER (1) and (2) what would fix this issue for the end SUM? Thanks again.
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.
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!
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/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:
ruclips.net/video/05ZivSteGJg/видео.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)
ruclips.net/video/CqpURYqK_wU/видео.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 RUclips.😎😎
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
Your 1 hour video taught me more than my online class has in 6 weeks. Thank you so much!
Ok
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
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
Recommende some SQL and php books ....I shall follow
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
;
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.
This video maybe is the only comprehensive and understandable MS SQL beginner's guide on RUclips.
Thanks for making this. You've earned a new subscriber.
[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
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.
The one-hour video covers almost all the basic keys. It is absolutely the great class for beginners. Thanks a lot!
When you have been sleeping during class coz the other course has taken all your energy and u realize that tomorrow is the final test and you haven't even looked att the course material.
This guy saves ya life
Litterly me Today
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
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.
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?
No trash talking, straight jump into the point ... Like it ...
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!!!
I have watched all 52 videos on sql and they give me life. Thank You.
I watched in 2024!!!
I am watching now as completely beginner 😅
Me also
Same here!
I'm here now
same here, im new !
Good video. Good pace, good voice, good mood, good examples I'm learning. Thank you.
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!
Very straight forward of teaching that most of the beginners needs..
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?
Your voice and your style of teaching is impeccable.
This is one of the most satisfying content that I have found in my BI journey. Looking forward to going through the playlist.👌
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.
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.
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.
This was bad a$$! Thanks a lot Joey. I learned more from this than I have an entire semester
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 the good teacher.
I would love to watch more videos thanks.
One hour class taught me more than a month's class!
Thank you Joey :)
Thank you for making SQL clearer to understand. I don't think it is hard, but if no one explains to you where to use a column and a table... and the brackets and use them to get a space, well I was taught by my instructor if you cannot get the name right, use the brackets and that will make the red marks go away.
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
Great lecture...I once worked with the SQL team in Redmond and have not done much with the application in seven years.
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 😊😊
I was tinkling how will I do well in SQL but your teacher has create a path for me now I can tell you that I know the way out; thank You love your class time.
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
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.!
Our teacher recommended this video to us.
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.
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
Thank you for sharing your experience, I did sql in uni but in 1 hr I must say you did an exceptional job.
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.
This tutorial is so helpful to those who are starting to be in love in sql programming. Thank you so much sir
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 👍👍
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!!!
thank you. I have a job interview tomorrow and needed to brush up on my database queries. I appreciate the video!
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!!!
I have an exam tomorrow, thanks for the review, wish me luck.
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!!
It's my first video of SQL. Definitely a very clear and a good start. Thanks for making this helpful and educational video!
The best SQL tutorial for beginners in RUclips!
Thanks for the refresher course. It been a few years since I wrote any SQLand this was helpful!
One of the best SQL courses that i have seen yet
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!
Great tutorial, here you see the real essentials of Querying Crystal Clear.
For those of you wondering how to enable line numbers in the Query Editor goto:
Tools>Options>All Languages
check: Line Numbers
(version: Microsoft SQL Server Management Studio 17)
Perhaps the best SQL starter tutorial out there.
Thank you !
This tutorial was very useful for me. Because no onecover everything in a single video like you did.
Brilliant video. You are very good at explaining these concepts in beginner-friendly terms and at a nice relaxed pace.
Been getting burned in interviews cause I have SQL proficiency on my resume and it's been a while since I've used it. Got an interview in 3 hours, you rock!!
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.
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. It was very helpful. I appreciate people like you doing this for us.
Great teaching , I am 72 year old, difficult to understand, , your teaching is superb, easy to learn
Good Video and ease to understand SQL in span of an hour. Thank you Joey
Not recommended for beginners ! Only for that already has took few lessons and basics in sql , it's like a second lever tutorial , thanks for sharing and making this available on RUclips, outstanding work 👏
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. :)
God bless you. I love your way of simplified things. and I hope someday I'll be like you. best wishes
Thank you for making this video. I'm gonna get out there and be somebody. Seriously, very informative!
Sir you really really are a great teacher I have never seen anyone else teach this much in one hour
This was a great refresher. You are a good teacher. Thank you.
we're learning the insert clause in like the 6th week of class over here. great video.
Fantastic insight. Very very good in breaking things down. I will sign up for your 10hour lecture ...thanks
Hi Joey, Thanks for this info, has been helping me in learning SQL! I have picked up so far two discrepancies for those using Linux (Mysql) of late... in my aspect - I am using MariaDB (mySql in Manjaro Linux), and some syntax is different or not allowed in your tutorial. So far, 1) When you DELETE data from a table (multiple entries) it will not let you just using DELETE tablename.... instead in MariaDB using MySQL Workbench Ver 8 (oracle), you need to use the Syntax - DELETE Customer from dbname; --- then it will delete all the data. Second one I just picked up at 34:18 into your tutorial, is for the Primary Key - identity is now replaced by - AUTO_INCREMENT - it does not allow identity(1,1). If I pick up any more I will post here as I go through (For anyone who has a similar issue, otherwise its great, thanks again!!
at 48:15 - Deleting of invalid CustomerID --- entry 21 --- in MariaDB the correct Syntax would be - delete from Orders where OrderID=21;
Last Issue --- SUM -- I have been looking --- my SUM results bring results like 421.7300100326538 and 991.8500270843506 ---- How can I sum or change to round to 2 decimal places? If I make a change to the column Price in a table --- Like changing it from type FLOAT to INT or another as a test --- what command do I use like ALTER (1) and (2) what would fix this issue for the end SUM? Thanks again.
Thanks for this Joey, much appreciated!
This is such a helpful guide, 3 months of school into 1 clip!
Great video, make more of it!!!
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 :)
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
really such an Amazing Tutorial .... and Amazing Style of teaching. very helpful for my final year project. :-)
Ditto on the below comment. I learned more in half and hour watching and actually performing the queries, than on any other course. Fantastic Job
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 introduction, was not familiar with SQL at all but now it feels i got all i need to get started!
so once i know sql like the back of my hand i can start applying to those 300k software jobs right XD
I like how you left your mistakes in there and then showed how to fix them. Very typical of the actual coding process.
simply amazing outstanding
i really appreciate the work done in you tube than the one learnt in class
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
This is a great refresher on SQL for me. Literally has 90% of what SQL is used for day-to-day.
Thanks...Joey Subscribed....
You broke it down beyond my expectations. Covered so much in an hour. You're a genius
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.
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.
Anyone watching this in 2022? 💖
🙋♀️
2023!
2023👍
2023
2023
Love the video. Helped me get the basics of SQL server. I learned MySQL first and this helped me get going on my project. Thanks for sharing…
You're an amazing tutor!!!... As a rookie to SQL, you've just made this more simpler for me.... Thanks Joey
wow, learnt more in 1 hour than i did in 12 hours of lectures. Thank you sir ^^
for the first time in my life i watched the whole educational video, thanks for the wonderful content and info.
One of the best I came Across on Intro to Database and specifically using SQL Server. You got a subscriber buddy!