Overview
Learning Outcomes
In this module, you will complete the following exercises:
- Exercise 1 – Install SQL Server 2012 Express
- Exercise 2 – Configure SQL Server Basic Security
After completing this lab, you will be able to:
- Create an SQL service account for SQL Server 2012 Express.
- Perform a basic installation of SQL Server 2012 Express.
- Install SQL Server Management Studio.
- Attach a sample database in SQL Server.
- Enable logins and users.
- Configure database level roles.
- Manage SQL Server configuration.
Exam Objectives
The following exam objective is covered in this lab:
- Identify application servers – database servers.
Note: Our main focus is to cover the practical, hands-on aspects of the exam objectives. We recommend referring to course material or a search engine to research theoretical topics in more detail.