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://discord.gg/kHuujY2pZf
– 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

source