- Microsoft SQL Server Developer Edition
- Microsoft SQL Server Management Studio
- AdventureWorks sample databases
For Windows, download the latest version of MSSQL Server Developer edition from the webpage section "free specialized edition". This is software free to use for non-production work and requires no registration.
Execute the SQL2022-SSEI-Dev.exe, choose Express Installation
For Windows, download the latest version of MSSQL Server Management Studio. This is software free to use and requires no registration.
Once it is installed, run it and it will connect to the SQL Server that you installed in the previous step
For authentication, choose SQL server authentication, and enter the user name and password which you created in the previous step for the SQL Server
Go to this page and download the following two databases (they are free to download and use):
Be careful with the database names, there are many databases available on that page with similar looking names. Be sure that you have selected the right ones.
The installation of the databases in MSSQL Server will be shown in one of the course sessions.