SQL Tutorial for Beginners
In this step-by-step tutorial, learn how you can write your own SQL queries. You don’t need any prior knowledge and we’re going to use all free tools. By the end of this video, you’ll know how to retrieve data from databases. At the end, I’ll show you a neat trick to write some of the most complex queries with very little effort.
SQL stands for structured query language. It’s a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It’s basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don’t need a degree in computer science. And once you know it, you’ll have another superpower that you can use at work.
👋 Additional resources
– Download & install Microsoft SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
– Download & install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15
– Sample database to follow along: https://1drv.ms/u/s!AmxrofZZlZ-whNsNYa3M9O0USq1WhQ?e=r06ifZ
– Sample data in Excel format including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ-whNsGOcpx-aZS1RN2yA?e=My4Otp
– SQL Functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver15
⌚ Timestamps
0:00 Introduction
0:37 Why learn SQL?
1:49 What is SQL?
2:25 What is a database?
3:09 Relational database management systems
4:11 Install Microsoft SQL Server
6:51 Install SQL Server Management Studio
7:26 Connect to server
8:13 Object Explorer
9:26 Restore sample database
10:42 Tables
14:33 Primary keys
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join & outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query designer
44:09 Wrap up
📃 Watch related playlists
– Playlist with all my videos on SQL: https://youtube.com/playlist?list=PLlKpQrBME6xLJxrKUNTty3Ne8j_B0QYUT
🚩 Connect with me on social
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://bit.ly/KevinStratvertDiscord
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/
🙏 Request How To Tutorial Videos
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
#stratvert
windows server
For some reason after I uploaded your sample database, it did not populate the database diagrams. Anyhow this was great I'd love to see more of these kinds of videos from you like how to creat a new database.
At 30:40, could you also use 'A*'? What is the difference between the * wildcard and the % wildcard? One is looking at data elements while the other is looking a strings?
Hey man, I’m learning about SQL and database concepts for the first time and I gotta say, this video was very easy to follow. I tend to get distracted when watching tutorials, but the way you made this video made it easy for me to focus! Thank you!
I cannot install the server
hii, i just learned it today but it said that the databases cannot be restored. can anyone answer me on how to make it right, please?
This was a great refresher. Thankyou so much. Subscribed, and looking forward to watching more of your content. Stay awesome dude!
Thanks bro..really I mean it..
Hi Kevin, do you have a video about creating a tables in SQL?
This has really helped me in preparing for my test. Thanks Kevin Stratvert.
9:42 first of thank you for the video but please i am stuck at this particular part of the video the duration of the video where am having issues is here I can’t find the kcc backup file please can someone help me out please once i click on add no file shows
Such a helpful tutorial! Thank you!
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.
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
yoooo I'm so happy i watched all of this till the end 44:56 it was worth it I was started to get a little worried but thank you !!!
26:47 one could also say
where NOT State = 'WA'
which is intuitive if you're familiar with Python
Hello Kevin, you may or not read this, but firstly I appreciate the video, it was really good.. as requested by you about which other videos we would want to see you make … i suggest you make a video detailing the start of a Data base from scratch to developing an ER diagram.
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. YouTube wouldn't let me edit my comment cause it returned error. Keven, if you see this feel free to re-pin this comment. Thanks!
Thank you Kevin. I didn't know it, but this is exactly what I needed to get back on track with my life. for real. I can do this.
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 "as" in the owner field and click "OK". The problem should be solved!
If this doesn't work, instead of entering "as", click on the "…", then "Browse…", and then select [DESKTOP-xxxx]. Click OK and the database diagram should appear
Does anyone know if the sample database is still working? It seems I have downloaded it successfully, but when I follow the steps laid out in the video to restore the database the file doesn't show up anywhere. I have moved the file around to various locations and still nothing. I'm starting to think the file is no longer valid, and the SQL server is not recognizing it. Thanks for any advice!