Overview

Introduction

Welcome to the Install and Configure a Database Server Practice Lab. In this module you will be provided with the instructions and devices needed to develop your hands-on skills.

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 objectives are covered in this lab:

  • Identify application servers - database servers

Lab Duration

It will take approximately 60 minutes to complete this lab.

Exercise 1 - Install SQL Server 2012 Express

A database is a collection of information organized in a way that a computer program can quickly select desired pieces of data using a special query language. Databases have become an integral part of storing massive amounts of information by organizations and end-users that there is a need to quickly access important data virtually from any device such as computers and mobile devices.

A database server refers to the back-end system that runs proprietary software and hosts multiple instances of a database normally used for business applications.

In this exercise, you will perform a basic installation of SQL Server 2012 Express that will create a database instance and attach a sample database that you can use with SQL Server.

Exercise 2 - Configure SQL Server Basic Security

You can secure your SQL Server databases by creating a SQL Server login and mapping the login to a database user thereby permitting them to connect to a specific database on the instance of SQL Server. You can then grant or deny permissions to the user inside the database accordingly. For example, you can create a login named ‘SQLLogin’ and map the ‘SQLLogin’ to a user in the AdventureWorks2012 database. This authorizes the login to use the AdventureWorks2012 on the instance of SQL Server. You can then grant or restrict permissions such as read, write, select on the AdventureWorks2012 database objects accordingly to the AdventureWorks2012 user based on his role. Note that the database user is the identity of the login while it connects to a database.

In this exercise, you will learn the following in SQL Server 2012 Express:

  • Create logins and users for a database using T-SQL and using SSMS
  • Grant database permissions and roles using T-SQL and using SSMS

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.