TIM-5020 v5

Microsoft.com (2021). SQL Server Express With Management Studio. Microsoft.

Step 1: Download SQL Server Express
1. https://www.microsoft.com/en-us/sql-server/sql-server-downloads?rtc=1
2. Click the Download Now Button under Express (free edition).
3. Double click the file you downloaded to install.
4. Select the Basic installation type.
5. Follow steps, noting the name of the server (write it down) and accept the default options. Restart your computer.

Step 2: Download SQL Server Management Tools
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

To download SQL Server Management Studio, click the link under Download SSMS.
1. Double click the file you downloaded to install.
2. Follow the installation steps, selecting the default options. Select the server name you noted from Step 1 above and Windows authentication. Click Connect.

Microsoft.com (2021). SQL Server Management Studio: Quickstarts| Connect and query SQL Server. Microsoft.

This web page shows how to use SQL Server Management Studio to create a new database. Windows Authentication (the default) is recommended.

Johnson, E. (2019). Database fundamentals livelessons [Video file]. Addison-Wesley Professional.

This video explains what data definition language (DDL) is, the differences between data types, and how to create tables, views, and stored procedures.

Petkovic, D. (2020). Microsoft SQL Server 2019: A beginner's guide (7th ed.). McGraw-Hill.

Read Chapter 3: Front-End Tools for Database Design.
This chapter describes two front-end tools for the Database Engine: SQL Server Management Studio (SSMS) and Azure Data Studio. (Note: SSMS will be used for the assignments in this class.)