We will install SQL Server on a Windows 10 computer (64-bit operating system). We will download and install latest free version of SQL Server. SQL Server 2019 Express Edition.
There are two components to this: SQL Server the back end, and SQL Server Management Studio (SSMS) the front end - and it's all free.
We will download and restore the sample AdventureWorks database. Connect and test the server and database with simple query. Let's see how to install it, and start writing your own SQL statements.
Topics covered in this video:
0:00 - Introduction SQLServer
0:26 - Download SQLServer Installer
0:40 - Begin SQLServer Installation
1:26 - Download SSMS
1:58 Install SSMS
2:38 Launch SSMS connect to server
3:21 - Download sample database
3:47 - Restore database
4:31 - Query database
SQL Server download link: https://www.microsoft.com/en-us/Download/details.aspx?id=101064
Sample database link: https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms