- 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 Download Media at a specified location
Use ISO packaging, mount and install
After checking your computer, make full installation, select all options and proceed using default settings
Add current user in all cases
For authentication, choose mixed mode authentication (it may be shown as SQL Server and Windows Authentication mode). If you are asked for a user name, use sa, and for the password use passw0rd (we will only use publicly available sample data for testing SQL commands with the project, so we are ok with basic security)
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.