Hi Kevin. I'm a retired software architect with lots of experience of SQL, and only watched the video to see what you were presenting to newbies. I wanted to let you know that it's an excellent introduction to something many might be hesitant about. Great job!
To those who can not locate the KCC file when trying to add it in the Database. Copy paste or Move the File to the Backup folder which is located in Microsoft SQL server ---> MSSQL16.MSSQLSERVER ---> MSSQL. These files are located where you originally downloaded the whole software probably in Local disk C ---> Program Files. This will then automatically show the KCC file when you try to select it to add it in the Database like Kevin told in the video. Hope this helps.
For those who are following along and could not open the database diagram: Right-click "KCC" in the Object Explorer, then select "Properties". Under "Select a page", select "Files". Enter "sa" in the owner field and click "OK". The problem should be solved! I made a typo in my comment a year ago, where "sa" was "as" due to autocorrect. However, that comment has since helped a lot of you with opening the diagram. RUclips wouldn't let me edit my comment cause it returned error. Kevin, if you see this feel free to re-pin this comment. Thanks!
It works if I type "sa", but if I type "as" it says that it cannot find the princial "as", because it does not exist or you do not have permission, Error 15151
16:08 If you're getting an error like I did, do the following: 1) Right click KCC and select properties 2) Select Files 3) On the row of "Owner:" select the "..." at the end 4) Browse -> check [sa] -> OK Now you should be good!
I’m a stay at home mom looking to learn some new skills and enter the work place. It’s been incredibly daunting and all the other SQL lessons I’ve taken skim over important information and don’t describe things clearly. This was SOOO helpful!!! Thank you so much!
how was it helpful can you explain? we work in Excel files not bak formats. The link he provided for file is not even working. What did you accomplish from this video Exactly?
yeah it did work. did you download the batch file or the flat file? Also did you store it in the correct file path where the server looks?@@sunnysingh347
I'm an old, mostly self taught DBA/Database-Developer that started working with SQL Server in 1998. I'm also a former Navy Instructor that wrote and taught a 200 hour course on microprocessors and how to program them way back in 1977 and have been teaching a whole lot of different things, including a lot of things about SQL Server and T-SQL. With that, I'll also say that I'm not easily impressed. And, with that being said.... You probably hear this all the time but now I have to say it. This is an absolutely brilliant introduction to SQL and SSMS and the order of revelation is perfect. Having put together presentations on the subject, I also have a deep understanding of, even with the best of tools, how long it takes to put to craft, crop, and publish a video of such incredible content. Very, VERY well done, good Sir.
Kelvin, I never thought one day I'd ever think about SQL. I always knew it's for the IT guys!!! Everyone can learn it? I can only Believe this because I trust you!!! You present complex matters into a plan language. Thanks
when I was at university I totally blew up learning sql, and my teacher (very wise woman) told me - "you're barely passed your test but YOU HAVE TO know sql anyways". Back then I answered that I don't need it because of specifics of my work, but my ignorance finally kicked me in the butt 15 years later. And now I've finally nailed it. Thanks so much for this video!
@@shayanzaidi2836 oh wow - I was just watching to gain a skill for work purposes - now feels like a daunting task haha. Currently unemployed but have experienced in HR and HRIS systems - hopefully learning this will help me land a new HRIS job!
On a job hunt as a result of the massive tech layoffs sweeping the country right now and this just made me so much more comfortable applying to jobs that demand SQL knowledge.
Totally agree. I just had an interview where the main function for the IS role was SQL and well.. This helps to feel comfortable if they call me for a second interview.
Kevin, please, please, please make more SQL content? I work in the database but there is so much more to learn. I just love your approach when it comes to learning new skills and your videos are so easy to follow. My goal is to become certified by the end of this year. Thank you so much for this!
Kevin is real teacher. He is intelligent and has the skill of conveying knowledge to you in an easy way. He makes difficult things look easy. One of the best I have ever seen. Some other teachers in this field in classrooms and youtube just dont know how to teach and waste everyones time. Kevin you are the best
Learning this for a job interview this week, thank you! It's a SQL heavy job, but I didn't put anthing SQL related on my resume and they still called me back so knowing the basics to mention in the interview will be a big help!
Thanks for such a superb, easy to understand video. I'm new to SQL and never knew it was so beginner-friendly; your content was most helpful. Just 2 points I'd like to add for others who may be interested in checking this out too. 1. If you have trouble finding the KCC.bak file using Database restore, Goto SQL config manager and change the "Log On as" setting of the SQL Server to "Local System". 2. For some reason my Database Diagrams folder would not expand, couldn't figure out a fix, however the query design editor will show the tables & primary keys anyways. Thanks again!
Me neither, I cant expand database diagrams folder 2. For some reason my Database Diagrams folder would not expand, couldn't figure out a fix, however the query design editor will show the tables & primary keys anyways
You have a gift for making complex subjects look very simple. As a software specialist, I’m sure this video took quite a few hours to put together. You started with baby steps but by the end, there was some quite advanced material being covered and I learned a few things that I didn’t previously know. Something for everybody - thank-you!
This tutoral is straight to the point. Everything was explained perfectly - not too short which becomes confusing and not too long which becomes boring - just perfect! Thanks!
Kevin, I LOVE writing SQL. I did it for 17 years and now I'm making videos using MS Access. I wouldn't do a beginner's video using SQL Server but you nailed it. Great job, cheers!
I literally became comfortable with knowing how I will be using SQL & I’ve only watched 30mins of it. Clear & precise instructions & explanations of shortcuts! Highly recommend this video to any beginner!
OMG, from my work place I thought SQL looked too difficult so I abandoned trying to use it to find certain data. I had no idea that there was a query wizard that is actually easier to use than MS Access. This changes everything. THANK YOU KEVIN ! And yes, SQL training would be great.
SQL is used extensively in all business, even if you want to build WordPress sites SQL is behind all wordpress software and controls all of the content in your sites, being able to write queries is truly a 'superpower' and this video is among the better ones to introduce the rudiments
i was trying to learn the sql from a platform but i didn't understand them what were they talking, because i'm completely new to sql, so i quit that online program and searched on youtube and found your channel which was already subscribed by me for some other purpose, and i lovvvvvvvvvveeee this i get each and every point you teach. thank you so much Kevin
I watched this 4 times already and I am going to watch at least 10 more to memorize all the queries listed in this video! Thanks so much Kevin for the awesome video and can't wait to learn more about SQL in your next videos!
Been out of work for the past year looking after my Son and this video gave me a great refresher on everything having not used SQL in that time. I feel much better going back to work now. Unlike C# I find my SQL knowledge gets worse of I don't use it because it's so different to use.
Out of all the tutorials available, this one is the most straightforward and user-friendly. Kevin, I appreciate you for generously sharing your expertise.
I wanted to learn how to code in SQL for job opportunities because that's what 90% of applications require for what I am planning to go into. This video is unbelievably helpful, I just learned how to do decently complex tasks in 45 minutes with (albeit some struggle with the .bak file but otherwise) no experience. Thank you for what you do!
EXCELLENT EXCELLENT EXCELLENT tutorial with all necessary details needed for a beginner like me...I'm taking a SQL course on Udemy but this is easier to understand. THANK YOU SO MUCH!
I'm just starting a Data Science bootcamp in the UK , London and wanted to get some basic understanding of SQL as I will be studying it. This video is very simple whilst a good amount of knowledge and benefits in it. Genuinely appreciate it. Thanks
Kevin , It was a great session for a very beginners like me who is zero in coding . Wherever I stuck somewhere you helped me a lot eg. I stuck in macros - seen many videos which i couldn't able to understand but your explanation is extraordinary. As like that SQL learnt new many constraints and shortcuts too Thank you so much 🙏
Thanks Kevin, your attention to detail and delivery in all your videos is first class, very professional and as always so informative and easy to follow, your efforts make all our lives so much easier.
FYI to those who are having issues like me who is coming from other DBMS - you do not have to put dbo. in front when you're doing joins or most other statements. It works just the same.
Kevin, THANK YOU!!! I have been trying for the last couple of months to learn SQL. I understand putting in the steps, but I need the "why" . Tonight you made it click. You have no idea how thrilled I am. Thank you so so much for your fantastic explanation. I wIsh I were paying you for a course instead of what I'm taking. You're very patient and explain it all so it makes sense.
Hi Kevin, I don't have any background in IT but, your videos are really helpful for beginners like me to understand the basic concept of SQL. Once again thank you so much for this awesome video. I am waiting for more videos based on SQL please and thank you.
Hello Kevin - I just wanted to learn SQL and your presentation is so easy to understand SQL. Your detailed instructions took away my fear of learning SQL, I'm hooked! THANK YOU!
Thank you so much Kevin. Once again top of the line. If I could afford you I would hire you to lecture my students. I will suffice with using your tutorials to enhance my own courses. Now I only need a few about Sharepoint Spaces.
I have to say, I'm loving the pace of this video. Ive bewn putting off leaening database for so long that, I decided to motivate myself by putting on a long tutorial video and just passively absorbing, and I am surprised by how much I'm able to follow along without having to pause and tinker with things myself yet. I'm nearly a graduated computer science major who missed taking Database and ran out of credits. So i guess I'm on my own for learning database. So here I am.
Kevin, you're the best! I've been watching your videos from powerBI, Python, teams etc. I'm currently taking a bootcamp and have been struggling in writing the JOINs. I understood the concept but struggled with the placements. Thank you! I would love to see you do videos on java as that is my next stack.
Very good tutorial. A single comment: in mathematical language, a table is called "Relation", that is why we use the term Relational Database because the main object is the table, not because the tables can have relationships.
Based on my limited knowledge in SQL (I only learned it before so I could creates simple queries on our Access database), I'd say the Query Editors are quite similar but MS SQL is more complex and powerful. I'm looking forward to your tutorials and hopefully you'll cover more functions or at least the most commonly used ones. Thank you, Kevin! ;)
This was such an easy to follow tutorial! As a beginner, SQL sounded a bit intimidating but this video made me feel like I could master this in no time! Thank you.
Amazing! Thank you for Crystal clear instructions and explanations on SQL tutorial. I plan on downloading the two software you mentioned and start writing SQL tomorrow. Thank you Kevin!
I am just starting to learn SQL and I have to say - that is the best course that I’ve ever seen covering what most view as a complex thing to learn!!! You gained a new follower!!
Well done sir. Clear, carefully explained, insightful, and a wonderful introduction. I constantly refer students as an example while teaching logic. Your handle on and way of explaining the basics of sentential is commendable to say the least. Thank you.
At the start of the video I was like ... "Man! What is SQL I need to get prepared to go through many books and tutorials.." *BOOM* After video "Man! It is really easy to be done ...WOW!! I am enjoying it!!"..... Thanks Startvert It was really helpful and so so so easy to understand.
Amazing please kindly upload videos related to Windows Server Administration and troubleshooting, Office 365 Administration and troubleshooting as it will be very very helpful
I literally have an exam tomorrow about this and I know nothing. This video helped me SO much, its so well explained and easy to understand. Thank you Kevin!
For those getting backend database error when trying to load the database diagram, download the preview version for SSMS 19 and not the latest release of 18.12. If you already installed 18.12, uninstall it before installing the preview version 19. I guess the latest version of SQL is incompatible with the latest release of SSMS? Seems like a major oversight.
I am doing a datacamp course, but now I have a visual of what is expected of me I can better get to grips of what they are offering me. Thanks, that was really helpfull.
Hi Kevin, Thank you for your time. This video is very informative and clearly explained compared to most of the other videos out there. keep up the good work and don't change your format this video is very clear and doesn't just speed by skipping over basic concepts that can help bring the audience up to speed while they obtain a solid foundation. Thanks again Kevin You Rock!!!
Kevin thank you so much. You reduce my fair of SQL in less than a hour. I was use to looking for queries online but you showed me easiest way to do SQL and is not that hard as it seems to be. Thank you
Kevin billions of thanks to you for your flawless teaching !!! I deliberately watch every advertisement on your Video so that you can get at least something from me (I hope this is the way RUclips works) and I also will share this video with my friends and recommend your name to increase your viewership, subscriber count etc (feel free to ask for anything else I can do for you) !!!
Hey Kevin, I subbed to the channel this was a great introductory video. Im interested in sports analytics and this would be great for me in terms of organizing and filtering my sports stats. I would love to see you do a tutortial using sports statistics.
Wow. Im a sql newbie but access teradata vantage on the regular and run sql already written. Im aiming to understand whats been writen and how to trouble shoot when sql doesnt run. Your teaching is the best ive found on youtube so far, simple logical and kept me focused through the whioe video. Subscribed. Thank you
This part of your tutorial "9:26 Restore sample database" is not working for me I cannot access the KCC file on my desktop where I downloaded it to for easy access.
Kevin this is me Neil! I am trying this out but am facing a problem. I downloaded your database and can view the tables but when I expand the database diagram menu it shows an error. It says: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. Please help Sir.... your tutorial is great but I cannot continue :(
To solve, I went in to Properties of the database - Then under "Select Page" click on "Files". Under database name the "Owner" was blank. Click on the 3 ellipse to open the "Database Owner" window. Click on browse next to "Enter the object names to select (examples)". Scroll down to where the object is [sa] and click "ok". Click "ok" on the next window and finally click on "ok". as this will have the owner in the once blank box. This worked for me, I hope it will work for you as well.
Your tip was a game-changer for me! I got 9 out of 10 and it's the best I've done in a while. I'm still practicing, but I feel like I'm making real progress thanks to your guidance. Thank you!
Hi Kevin. I'm having an issue following along when trying to recover the sample database. In your video, the sample database file is already there ready to add. However, when I try to find my sample file I cannot find the file using any file path or manually trying to retrieve it.
Great Video. I actually learned Power BI by necessity at work and i want to up my skills by learning SQL. I can say that i have an advantage because i already know relational database and linking multiple tables which i do also in Power Bi. I thought SQL is hard. After i finish your video, i gain some confidence. Thanks a lot.
Normally, I dont comment on tutorials, but yours is an exception. Was a little scared learning and working with MS SQL, but your tutorial helped me a lot. Subscribed.
As someone who's worked with Unreal Engine and is going to be applying to a regular programming job, this is hands down one of the best tutorials I have ever seen. Fan-bloody-tastic ☝🏻
Hi Kevin, I'm a beginner in the field of data analysis. I love watching your videos because you teaching method is interesting and very easy to follow. More power to your elbow.💪💪💪
I would love to see this become a series. I stumbled across your channel after being assigned a SQL project at work and it has been well over 10 years since I last used this program for data analysis. Thank you for such a great introductory video.
Kevin you're tuturial enlighten me to pursue my learning in doing sql. The way you present is much easier than the one i studies during my lecture, its a great help for me. thank youu soo much for coaching us..
Hallo Kevin thank you for this video and making SQL look soo easy, by the time the video was coming to an end in my mind I was already telling myself how easy SQL is and when I started I was actually dreading watching the video because I have always said SQL is hard. Thank you for showing me that this is not as hard as I have been thinking and I hope to become certified in SQL.
Hello Kevin, there is no waste on your video. I am a little bit new to SQL Server, but your video just open up wide my mind. I appreciate for you making this video.
I was recently cut from my job. I needed to build my tech skills as I've been a 'manual' tester for over a decade. I came across your SQL Tutorial and must say, this is such a great beginner's tutorial video. Your description, explanations, details and examples make me want to learn more. I've had some basic SQL skills and after watching and listening to your tutorial, it all came back. I look forward to more of your training videos, Kevin. Thank you!
Thanks for the informative tutorial teacher Kevin! A little bit struggle at the first part until after 4:05; then things got clear to me so much. This gave me a better picture on my major, and also subjects we required to learn in college (such as statistics, econometrics - which also shares some terms similar like in SQL language). This introduction to SQL beginner was so good, that when I came back to W3S to continue the lesson I managed to understand different commands and usage of different functions. The diagrams and keys were notable too, it helped me figure out the primary keys connecting to different columns. Anw, thanks for the informative guide, proud to be your new subscriber!
I haven't used the long in a while, but this tutotial gave me a very good refresher on how to get back to it in not time. Thank you very much for the content.
Thank you so much for this video! I studied this throughout university but didn't get to use this in my current job. I'm trying to further my career and most jobs I'm interested in heavily use SQL so I need to brush up on my skills.
![SQL Course for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
![Stromae, Pomme - “Ma Meilleure Ennemie” (from Arcane Season 2) [Official Visualizer]](http://i.ytimg.com/vi/1F3OGIFnW1k/mqdefault.jpg)
Hi Kevin. I'm a retired software architect with lots of experience of SQL, and only watched the video to see what you were presenting to newbies. I wanted to let you know that it's an excellent introduction to something many might be hesitant about. Great job!
Thanks for the note, Simon!
He's right, as a newbie, I'm quite hesitant! Lol thanks for the video Kevin
Hi Simon Dobson, is it Ok to pick your brain on something related to Software development?
software architect?? pfffft. Im a software god/oracle PHD.
@@Adam_Bosscoe hmmm.
To those who can not locate the KCC file when trying to add it in the Database. Copy paste or Move the File to the Backup folder which is located in Microsoft SQL server ---> MSSQL16.MSSQLSERVER ---> MSSQL. These files are located where you originally downloaded the whole software probably in Local disk C ---> Program Files. This will then automatically show the KCC file when you try to select it to add it in the Database like Kevin told in the video. Hope this helps.
Thanks! This worked perfectly for me :D
Thank you ! This helped :)
Thanks!
thank you so much!! :D
THANK YOU!
For those who are following along and could not open the database diagram: Right-click "KCC" in the Object Explorer, then select "Properties". Under "Select a page", select "Files". Enter "sa" in the owner field and click "OK". The problem should be solved!
I made a typo in my comment a year ago, where "sa" was "as" due to autocorrect. However, that comment has since helped a lot of you with opening the diagram. RUclips wouldn't let me edit my comment cause it returned error. Kevin, if you see this feel free to re-pin this comment. Thanks!
Thank you, sir! that fixed it.
How do i double like this? Thank you so much!
Thank you!
It works if I type "sa", but if I type "as" it says that it cannot find the princial "as", because it does not exist or you do not have permission, Error 15151
this comment should definitely be pinned! thank u so much, I really appreciate your help and clear instructions
16:08 If you're getting an error like I did, do the following:
1) Right click KCC and select properties
2) Select Files
3) On the row of "Owner:" select the "..." at the end
4) Browse -> check [sa] -> OK
Now you should be good!
Thank you, This really helped!
Thanks bro. saved me a headache.
THANK YOU SM
Hero!
comment saved me, thanks
I’m a stay at home mom looking to learn some new skills and enter the work place. It’s been incredibly daunting and all the other SQL lessons I’ve taken skim over important information and don’t describe things clearly. This was SOOO helpful!!! Thank you so much!
how was it helpful can you explain? we work in Excel files not bak formats. The link he provided for file is not even working. What did you accomplish from this video Exactly?
yeah it did work. did you download the batch file or the flat file? Also did you store it in the correct file path where the server looks?@@sunnysingh347
That’s awesome that this video helped ! Did you find a coding job using SQL?
hey are u currently working a position related to SQL? how has the job been?
you're pretty
I'm an old, mostly self taught DBA/Database-Developer that started working with SQL Server in 1998. I'm also a former Navy Instructor that wrote and taught a 200 hour course on microprocessors and how to program them way back in 1977 and have been teaching a whole lot of different things, including a lot of things about SQL Server and T-SQL. With that, I'll also say that I'm not easily impressed. And, with that being said....
You probably hear this all the time but now I have to say it. This is an absolutely brilliant introduction to SQL and SSMS and the order of revelation is perfect. Having put together presentations on the subject, I also have a deep understanding of, even with the best of tools, how long it takes to put to craft, crop, and publish a video of such incredible content.
Very, VERY well done, good Sir.
Kelvin, I never thought one day I'd ever think about SQL. I always knew it's for the IT guys!!! Everyone can learn it? I can only Believe this because I trust you!!! You present complex matters into a plan language. Thanks
when I was at university I totally blew up learning sql, and my teacher (very wise woman) told me - "you're barely passed your test but YOU HAVE TO know sql anyways". Back then I answered that I don't need it because of specifics of my work, but my ignorance finally kicked me in the butt 15 years later. And now I've finally nailed it. Thanks so much for this video!
This is 2 of my university courses summarized in a 45 minute video. So impressive and so helpful! Thanks, Kevin
University?😭 im watching this for my grade 9 term two end of term assesment
@@heynotizzy7493 good for you, man! This isn't something that was covered by my school back then, so you're getting really ahead of us oldies lmao
@@shayanzaidi2836 i wish i was at the level of you oldies because i currently have a C in computer science
@@shayanzaidi2836 oh wow - I was just watching to gain a skill for work purposes - now feels like a daunting task haha.
Currently unemployed but have experienced in HR and HRIS systems - hopefully learning this will help me land a new HRIS job!
@@heynotizzy7493 how did it go???
On a job hunt as a result of the massive tech layoffs sweeping the country right now and this just made me so much more comfortable applying to jobs that demand SQL knowledge.
Totally agree. I just had an interview where the main function for the IS role was SQL and well.. This helps to feel comfortable if they call me for a second interview.
Kevin, please, please, please make more SQL content? I work in the database but there is so much more to learn. I just love your approach when it comes to learning new skills and your videos are so easy to follow. My goal is to become certified by the end of this year. Thank you so much for this!
yes kevin plz come up with complete series
Hello Chantel, Please don't be offended by my question, please i can one get entry job as DBA? I will appreciate you feedback.
Did you become certified after all?
Hey did you commit or nah @chantelruss6063
I’m wondering too. Are certified yet ? In SQL ? Or database? Or Data analytics? And is it enough?
Kevin is real teacher. He is intelligent and has the skill of conveying knowledge to you in an easy way. He makes difficult things look easy. One of the best I have ever seen. Some other teachers in this field in classrooms and youtube just dont know how to teach and waste everyones time. Kevin you are the best
Learning this for a job interview this week, thank you! It's a SQL heavy job, but I didn't put anthing SQL related on my resume and they still called me back so knowing the basics to mention in the interview will be a big help!
How did it go?
Thanks for such a superb, easy to understand video. I'm new to SQL and never knew it was so beginner-friendly; your content was most helpful. Just 2 points I'd like to add for others who may be interested in checking this out too. 1. If you have trouble finding the KCC.bak file using Database restore, Goto SQL config manager and change the "Log On as" setting of the SQL Server to "Local System". 2. For some reason my Database Diagrams folder would not expand, couldn't figure out a fix, however the query design editor will show the tables & primary keys anyways. Thanks again!
you answered my query for not able to KCC file! Thanks @sajikr3438
Thank you for this! Saved me tons of time researching why I couldn't find the .bak file.
Me neither, I cant expand database diagrams folder
2. For some reason my Database Diagrams folder would not expand, couldn't figure out a fix, however the query design editor will show the tables & primary keys anyways
I did this and the KCC.bak file still doesn't show up in the directory.
Best comment so far, This is exactly what I needed to do. Thank you so much!
You have a gift for making complex subjects look very simple. As a software specialist, I’m sure this video took quite a few hours to put together. You started with baby steps but by the end, there was some quite advanced material being covered and I learned a few things that I didn’t previously know. Something for everybody - thank-you!
Indeed, I learned so much from you Kevin. Thank you so much.
Me too
This tutoral is straight to the point. Everything was explained perfectly - not too short which becomes confusing and not too long which becomes boring - just perfect! Thanks!
Kevin, I LOVE writing SQL. I did it for 17 years and now I'm making videos using MS Access. I wouldn't do a beginner's video using SQL Server but you nailed it. Great job, cheers!
Hi, I need help on my bet project on excel
I literally became comfortable with knowing how I will be using SQL & I’ve only watched 30mins of it. Clear & precise instructions & explanations of shortcuts! Highly recommend this video to any beginner!
OMG, from my work place I thought SQL looked too difficult so I abandoned trying to use it to find certain data. I had no idea that there was a query wizard that is actually easier to use than MS Access. This changes everything. THANK YOU KEVIN ! And yes, SQL training would be great.
SQL is used extensively in all business, even if you want to build WordPress sites SQL is behind all wordpress software and controls all of the content in your sites, being able to write queries is truly a 'superpower' and this video is among the better ones to introduce the rudiments
This explained the join process easier in 5 minutes than 2 full days of class in college.
Nicely done.
i was trying to learn the sql from a platform but i didn't understand them what were they talking, because i'm completely new to sql, so i quit that online program and searched on youtube and found your channel which was already subscribed by me for some other purpose, and i lovvvvvvvvvveeee this i get each and every point you teach. thank you so much Kevin
Please do more SQL content!? Databases, everything. Something I'm trying to learn along with web development this year.
I totally agree with you! I love working with databases.
Indeed. More of this please! :) Appreciated all your trips and tricks on all of your vids.
Yes, I second this comment. Would love to see more SQL, and databases content too.
@@brand1974 I just posted a video on how I created a stored procedure on my channel. Check it out.
Yes, please! More SQL content :)
As a new student to SQL you've made things way too easy bro 😊 best training ❤
I watched this 4 times already and I am going to watch at least 10 more to memorize all the queries listed in this video! Thanks so much Kevin for the awesome video and can't wait to learn more about SQL in your next videos!
Been out of work for the past year looking after my Son and this video gave me a great refresher on everything having not used SQL in that time. I feel much better going back to work now. Unlike C# I find my SQL knowledge gets worse of I don't use it because it's so different to use.
Out of all the tutorials available, this one is the most straightforward and user-friendly. Kevin, I appreciate you for generously sharing your expertise.
I wanted to learn how to code in SQL for job opportunities because that's what 90% of applications require for what I am planning to go into. This video is unbelievably helpful, I just learned how to do decently complex tasks in 45 minutes with (albeit some struggle with the .bak file but otherwise) no experience. Thank you for what you do!
Im in the same boat. Any idea how you will tell them you will write on your resume that you know SQL? As we won't have a certificate or anything
EXCELLENT EXCELLENT EXCELLENT tutorial with all necessary details needed for a beginner like me...I'm taking a SQL course on Udemy but this is easier to understand. THANK YOU SO MUCH!
Coursera's is so murky I filed a BUG REPORT.
I'm just starting a Data Science bootcamp in the UK , London and wanted to get some basic understanding of SQL as I will be studying it. This video is very simple whilst a good amount of knowledge and benefits in it. Genuinely appreciate it. Thanks
Kevin you removed the obstacle of learning code with this amazing tutotial. SQL is no longer a mystery for me. Thanks for coaching us.
太好了，45分钟，只看一遍，做点笔记就ok了。谢谢谢谢，开门见山，没有废话👍
Kevin ,
It was a great session for a very beginners like me who is zero in coding .
Wherever I stuck somewhere you helped me a lot eg. I stuck in macros - seen many videos which i couldn't able to understand but your explanation is extraordinary. As like that SQL learnt new many constraints and shortcuts too
Thank you so much 🙏
I like how the fact that you're practical and down to Earth really gives meaning to the subject alltogether
Thanks Kevin, your attention to detail and delivery in all your videos is first class, very professional and as always so informative and easy to follow, your efforts make all our lives so much easier.
I am barely in and love your video already-1) assuming no knowledge 2) using free tools so continuous learning is an option. Many thanks!
I've watched a lot SQL introduction for beginners and no doubt this is the best one, hopefully we can get some more videos on SQL, thanks Kevin!
I have worked in technology for a while now but never got around to learning SQL. This is awesome, thank you!!
You read my mind! I was asking a friend if he can help me learn SQL just today! Thanks Kevin.
FYI to those who are having issues like me who is coming from other DBMS - you do not have to put dbo. in front when you're doing joins or most other statements. It works just the same.
This is wonderful, I learned more in this video then I have in a week of trying to learn from other sources. I would love more SQL videos!
Kevin, THANK YOU!!! I have been trying for the last couple of months to learn SQL. I understand putting in the steps, but I need the "why" . Tonight you made it click. You have no idea how thrilled I am. Thank you so so much for your fantastic explanation. I wIsh I were paying you for a course instead of what I'm taking. You're very patient and explain it all so it makes sense.
Hi Kevin, I don't have any background in IT but, your videos are really helpful for beginners like me to understand the basic concept of SQL. Once again thank you so much for this awesome video. I am waiting for more videos based on SQL please and thank you.
I am getting back to University after 10 years came to refresh what I had learned. Very good recap. Thank you for the great job
Hello Kevin - I just wanted to learn SQL and your presentation is so easy to understand SQL. Your detailed instructions took away my fear of learning SQL, I'm hooked! THANK YOU!
Thank you so much Kevin.
Once again top of the line.
If I could afford you I would hire you to lecture my students.
I will suffice with using your tutorials to enhance my own courses.
Now I only need a few about Sharepoint Spaces.
I have to say, I'm loving the pace of this video. Ive bewn putting off leaening database for so long that, I decided to motivate myself by putting on a long tutorial video and just passively absorbing, and I am surprised by how much I'm able to follow along without having to pause and tinker with things myself yet.
I'm nearly a graduated computer science major who missed taking Database and ran out of credits. So i guess I'm on my own for learning database. So here I am.
Awesome Kevin! For me this tutorial is "SQL" (Super Quality Learning)! Thank you so much! 😊👍
Bro you are a godsend. I am getting back into sql after taking 2 years off and this was perfect to jog my memory. I appreciate your effort man
Kevin, you're the best! I've been watching your videos from powerBI, Python, teams etc. I'm currently taking a bootcamp and have been struggling in writing the JOINs. I understood the concept but struggled with the placements. Thank you! I would love to see you do videos on java as that is my next stack.
Very good tutorial. A single comment: in mathematical language, a table is called "Relation", that is why we use the term Relational Database because the main object is the table, not because the tables can have relationships.
Based on my limited knowledge in SQL (I only learned it before so I could creates simple queries on our Access database), I'd say the Query Editors are quite similar but MS SQL is more complex and powerful. I'm looking forward to your tutorials and hopefully you'll cover more functions or at least the most commonly used ones. Thank you, Kevin! ;)
Thank you so much for this the Way you write it down and explain it is so amazing and easy
This was such an easy to follow tutorial! As a beginner, SQL sounded a bit intimidating but this video made me feel like I could master this in no time! Thank you.
Amazing! Thank you for Crystal clear instructions and explanations on SQL tutorial. I plan on downloading the two software you mentioned and start writing SQL tomorrow. Thank you Kevin!
I am just starting to learn SQL and I have to say - that is the best course that I’ve ever seen covering what most view as a complex thing to learn!!! You gained a new follower!!
Well done sir. Clear, carefully explained, insightful, and a wonderful introduction. I constantly refer students as an example while teaching logic. Your handle on and way of explaining the basics of sentential is commendable to say the least. Thank you.
At the start of the video I was like ... "Man! What is SQL I need to get prepared to go through many books and tutorials.." *BOOM* After video "Man! It is really easy to be done ...WOW!! I am enjoying it!!"..... Thanks Startvert It was really helpful and so so so easy to understand.
Amazing please kindly upload videos related to Windows Server Administration and troubleshooting, Office 365 Administration and troubleshooting as it will be very very helpful
I literally have an exam tomorrow about this and I know nothing. This video helped me SO much, its so well explained and easy to understand. Thank you Kevin!
For those getting backend database error when trying to load the database diagram, download the preview version for SSMS 19 and not the latest release of 18.12. If you already installed 18.12, uninstall it before installing the preview version 19. I guess the latest version of SQL is incompatible with the latest release of SSMS? Seems like a major oversight.
Thank you. This worked for me. Had already fixed the first issue of not being able to expand Database Diagrams then ran into this lol.
I am doing a datacamp course, but now I have a visual of what is expected of me I can better get to grips of what they are offering me. Thanks, that was really helpfull.
This is an amazing introductory training to SQL!!!!
My database class has turned into a DIY class so I'm really grateful for videos like this!
Hi Kevin, Thank you for your time. This video is very informative and clearly explained compared to most of the other videos out there. keep up the good work and don't change your format this video is very clear and doesn't just speed by skipping over basic concepts that can help bring the audience up to speed while they obtain a solid foundation. Thanks again Kevin You Rock!!!
Kevin thank you so much. You reduce my fair of SQL in less than a hour. I was use to looking for queries online but you showed me easiest way to do SQL and is not that hard as it seems to be. Thank you
I loved the way you explained it. Very intensive. Loved and Subscribed. ❤️🤗
Kevin billions of thanks to you for your flawless teaching !!! I deliberately watch every advertisement on your Video so that you can get at least something from me (I hope this is the way RUclips works) and I also will share this video with my friends and recommend your name to increase your viewership, subscriber count etc (feel free to ask for anything else I can do for you) !!!
Hey Kevin, I subbed to the channel this was a great introductory video. Im interested in sports analytics and this would be great for me in terms of organizing and filtering my sports stats. I would love to see you do a tutortial using sports statistics.
Wow. Im a sql newbie but access teradata vantage on the regular and run sql already written. Im aiming to understand whats been writen and how to trouble shoot when sql doesnt run. Your teaching is the best ive found on youtube so far, simple logical and kept me focused through the whioe video. Subscribed. Thank you
This part of your tutorial "9:26 Restore sample database" is not working for me I cannot access the KCC file on my desktop where I downloaded it to for easy access.
Same here oo😢😢😢
@@egharevbauwaila1020 did you figure it out yet?
Thank you so much Kevin! I just finished the Google Data Analytics course and I'm still a bit confused on SQL so this was very helpful. Thank you!
Kevin this is me Neil! I am trying this out but am facing a problem. I downloaded your database and can view the tables but when I expand the database diagram menu it shows an error.
It says: Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Please help Sir.... your tutorial is great but I cannot continue :(
To solve, I went in to Properties of the database - Then under "Select Page" click on "Files". Under database name the "Owner" was blank. Click on the 3 ellipse to open the "Database Owner" window. Click on browse next to "Enter the object names to select (examples)". Scroll down to where the object is [sa] and click "ok". Click "ok" on the next window and finally click on "ok". as this will have the owner in the once blank box. This worked for me, I hope it will work for you as well.
@@dk81535TA Thank you so much! I had the same problem and it worked for me! :)
@@dk81535TA Thank You that worked for me as well :)
@@dk81535TA Thank you. This worked for me.
@@dk81535TA 2 years later and still helping, thank you!
I apologize if my question is so simple. I am just starting out with SQL. This video is great, thank you again.
Please Keep sql with python ....Tutorial
Your tip was a game-changer for me! I got 9 out of 10 and it's the best I've done in a while. I'm still practicing, but I feel like I'm making real progress thanks to your guidance. Thank you!
Hi Kevin, I have been having trouble importing data from excel or any other source. It keeps telling me operation could not be completed
Okay, the query designer just blew my mind. I never knew that was available, after 5 years of writing queries.
Hi Kevin. I'm having an issue following along when trying to recover the sample database. In your video, the sample database file is already there ready to add. However, when I try to find my sample file I cannot find the file using any file path or manually trying to retrieve it.
I'm having the same issue; did you ever recover the file?
@@lukeloeffler1 no, I was lucky enough to take a SQL class at work.
Great Video. I actually learned Power BI by necessity at work and i want to up my skills by learning SQL. I can say that i have an advantage because i already know relational database and linking multiple tables which i do also in Power Bi.
I thought SQL is hard. After i finish your video, i gain some confidence.
Thanks a lot.
You covered the toughest thing that I’ve been having trouble with, the date intervals! Thank you!
This is the best video for any beginer hoping to learn SQL.
Normally, I dont comment on tutorials, but yours is an exception. Was a little scared learning and working with MS SQL, but your tutorial helped me a lot. Subscribed.
As someone who's worked with Unreal Engine and is going to be applying to a regular programming job, this is hands down one of the best tutorials I have ever seen. Fan-bloody-tastic ☝🏻
Hi Kevin, I'm a beginner in the field of data analysis. I love watching your videos because you teaching method is interesting and very easy to follow. More power to your elbow.💪💪💪
"Free tools" are my favourite kind of tools. Thank you for this, Kevin.
I would love to see this become a series. I stumbled across your channel after being assigned a SQL project at work and it has been well over 10 years since I last used this program for data analysis. Thank you for such a great introductory video.
So far, best introduction to SQL I've come across. Looking forward to more content.😊
Kevin you're tuturial enlighten me to pursue my learning in doing sql. The way you present is much easier than the one i studies during my lecture, its a great help for me. thank youu soo much for coaching us..
I'm about to get into an interview for a job that requires basic SQL knowledge, and this was really helpful
How did it go?
as a truck driver this video inspired me to change careers
Hallo Kevin thank you for this video and making SQL look soo easy, by the time the video was coming to an end in my mind I was already telling myself how easy SQL is and when I started I was actually dreading watching the video because I have always said SQL is hard. Thank you for showing me that this is not as hard as I have been thinking and I hope to become certified in SQL.
Hi Kevin. I want to become an SQL administrator, this is helping me so much with getting my foot in the game. Thank you 🎉
I had no idea about the "Design Query in Editor" function. What a day to be alive!
Its commendable that your explanations can be understood by a layman. Thank you so much 🎉
Hello Kevin, there is no waste on your video. I am a little bit new to SQL Server, but your video just open up wide my mind. I appreciate for you making this video.
I was recently cut from my job. I needed to build my tech skills as I've been a 'manual' tester for over a decade. I came across your SQL Tutorial and must say, this is such a great beginner's tutorial video. Your description, explanations, details and examples make me want to learn more. I've had some basic SQL skills and after watching and listening to your tutorial, it all came back. I look forward to more of your training videos, Kevin. Thank you!
Thanks for the informative tutorial teacher Kevin! A little bit struggle at the first part until after 4:05; then things got clear to me so much. This gave me a better picture on my major, and also subjects we required to learn in college (such as statistics, econometrics - which also shares some terms similar like in SQL language). This introduction to SQL beginner was so good, that when I came back to W3S to continue the lesson I managed to understand different commands and usage of different functions. The diagrams and keys were notable too, it helped me figure out the primary keys connecting to different columns. Anw, thanks for the informative guide, proud to be your new subscriber!
I haven't used the long in a while, but this tutotial gave me a very good refresher on how to get back to it in not time. Thank you very much for the content.
Thank you so much for this video! I studied this throughout university but didn't get to use this in my current job. I'm trying to further my career and most jobs I'm interested in heavily use SQL so I need to brush up on my skills.
the content of the video is amazing, in Spanish we say "no tiene desperdicio". And Kevin... thank you so much for your delightful pronunciation