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.
[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
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.
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.
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 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.
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
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 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.
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
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.
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
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.
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!
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.
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.
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.
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.
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!!
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.
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 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.
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!
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 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. :)
@@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.
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.
I learned SQL on my own and got a job making almost $100k a year writing reports for primary care facilities here in the Midwest. The database has about 4700 tables but in reality about 200 are used in reporting with 20 core tables. Some queries are a few hundred lines. But mostly under 50.
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.
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)
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!
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.
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! :)
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!
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!
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
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 👏
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.
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.😎😎
[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
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
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.
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
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!
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
;
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 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.
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
Good video. Good pace, good voice, good mood, good examples I'm learning. Thank you.
Very straight forward of teaching that most of the beginners needs..
I have watched all 52 videos on sql and they give me life. Thank You.
Your voice and your style of teaching is impeccable.
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. 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.
No trash talking, straight jump into the point ... Like it ...
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?
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?
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.
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!
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.
This is one of the most satisfying content that I have found in my BI journey. Looking forward to going through the playlist.👌
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
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
One hour class taught me more than a month's class!
Thank you Joey :)
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.
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.
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!!!
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
This was bad a$$! Thanks a lot Joey. I learned more from this than I have an entire semester
It's my first video of SQL. Definitely a very clear and a good start. Thanks for making this helpful and educational video!
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
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 👍👍
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!!
Our teacher recommended this video to us.
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.
Thanks for the refresher course. It been a few years since I wrote any SQLand this was helpful!
This tutorial is so helpful to those who are starting to be in love in sql programming. Thank you so much sir
Perhaps the best SQL starter tutorial out there.
Thank 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!!!
Brilliant video. You are very good at explaining these concepts in beginner-friendly terms and at a nice relaxed pace.
Great lecture...I once worked with the SQL team in Redmond and have not done much with the application in seven years.
thank you. I have a job interview tomorrow and needed to brush up on my database queries. I appreciate the video!
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.
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!
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 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. :)
Thank you for sharing your experience, I did sql in uni but in 1 hr I must say you did an exceptional job.
Thank You Joey. It was very helpful. I appreciate people like you doing this for us.
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.!
Good Video and ease to understand SQL in span of an hour. Thank you Joey
One of the best SQL courses that i have seen yet
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 😊😊
The best SQL tutorial for beginners in RUclips!
I watched in 2024!!!
I am watching now as completely beginner 😅
Me also
Same here!
I'm here now
same here, im new !
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.
I have an exam tomorrow, thanks for the review, wish me luck.
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!
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 is such a helpful guide, 3 months of school into 1 clip!
Great video, make more of it!!!
This was a great refresher. You are a good teacher. Thank you.
I learned SQL on my own and got a job making almost $100k a year writing reports for primary care facilities here in the Midwest. The database has about 4700 tables but in reality about 200 are used in reporting with 20 core tables. Some queries are a few hundred lines. But mostly under 50.
Thank you for making this video. I'm gonna get out there and be somebody. Seriously, very informative!
You broke it down beyond my expectations. Covered so much in an hour. You're a genius
Fantastic insight. Very very good in breaking things down. I will sign up for your 10hour lecture ...thanks
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.
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)
Thanks for this Joey, much appreciated!
You're an amazing tutor!!!... As a rookie to SQL, you've just made this more simpler for me.... Thanks Joey
It was very helpful Joey Blue, thanks :)
You are the good teacher.
I would love to watch more videos thanks.
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!
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.
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.
wow, learnt more in 1 hour than i did in 12 hours of lectures. Thank you sir ^^
really such an Amazing Tutorial .... and Amazing Style of teaching. very helpful for my final year project. :-)
I'm taking an online SQL course. This has helped immensely. Thanks so much!
simply amazing outstanding
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 Subscribed....
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! :)
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
I am a beginner. This is a great tutorial. Very useful!! Thank you
so once i know sql like the back of my hand i can start applying to those 300k software jobs right XD
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!
Anyone watching this in 2022? 💖
🙋♀️
2023!
2023👍
2023
2023
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!
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
for the first time in my life i watched the whole educational video, thanks for the wonderful content and info.
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 👏
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.
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
Great fresher lesson! Adequate speed, clear voice and to the point. Awesome!
Simple and straight to the point. Thanks Joey
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…