In this step-by-step tutorial, you will learn how to write your own SQL queries. You don't need any prior knowledge and we will only use free tools. By the end of this video, you will know how to retrieve data from databases. At the end, I will show you a great trick that will help you write some of the most complex queries with very little effort.

SQL stands for Structured Query Language. It's a language you can use to communicate with 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 about it is that anyone can learn how to write SQL queries. You definitely don't need a computer science degree. And once you can do it, you'll have another superpower to use at work.

Additional resources
– Download and install Microsoft SQL Server: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
– Download and install SQL Server Management Studio (SSMS): https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfromMSDN&viewsql-server-ver15
– Sample database to participate in: https://1drv.ms/u/s!AmxrofZZlZ-whNsNYa3M9O0USq1WhQ?er06ifZ
– Sample data in Excel format, including flat file and tables: https://1drv.ms/x/s!AmxrofZZlZ-whNsGOcpx-aZS1RN2yA?eMy4Otp
– SQL functions: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?viewsql-server-ver15

time stamp
00:00 Introduction
00:37 Why learn SQL?
01:49 What is SQL?
02:25 What is a database?
03:09 Relational database management systems
04:11 Install Microsoft SQL Server
06:51 Install SQL Server Management Studio
07:26 Connect to the server
08:13 Object Explorer
09:26 Restore sample database
10:42 Tables
14:33 Primary key
15:57 Database diagrams
17:57 Data types
18:30 Select
24:50 Filtering with where
32:02 Inner join and outer join
38:21 Order by
39:01 Functions including getdate, sum, count
41:02 Group by
41:20 Bonus: Query Designer
44:09 Summary

View similar playlists
– Playlist with all my videos about SQL: https://youtube.com/playlist?listPLlKpQrBME6xLJxrKUNTty3Ne8j_B0QYUT

NEWSLETTER
– Get the latest high-quality tutorials and tips and tricks videos delivered to your inbox every week: https://kevinstratvert.com/newsletter/

CONNECT WITH ME
– Official website: http://www.kevinstratvert.com
– 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/

TOOLS AND DISCOUNTS
️ Voicemod AI Voice Changer 5% discount https://link.xsolla.com/KZBi89AY
Squarespace websites https://squarespace.syuh.net/XYaqYM
Grammar https://grammarly.go2cloud.org/SH3nL
️ Shopify https://shopify.pxf.io/XY9rPa
Introduction https://affiliate.notion.so/rffva4tr71ax
️ Figma https://psxid.figma.com/lqjg97licpry
Text-to-Speech by ElevenLabs https://try.elevenlabs.io/taqepq60mptr

MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

Subscribe on YouTube
https://www.youtube.com/user/kevlers?sub_confirmation1

SUPPORT THE CHANNEL
– Click the THANK YOU button in each video!
– Amazon affiliate link: https://amzn.to/3kCP2yz

DISCLOSURE
Some links are affiliate links, when you purchase through these links I receive a small commission to support the videos on this channel. The price for you is the same.

#stratvert #sql

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.