Professional Training

Prerequisites

Participants should have experience of Querying Microsoft SQL Server 2012, or earlier versions.
In addition to their professional experience, students who attend this training should already have the following technical knowledge: - Basic knowledge of the Microsoft Windows operating system and its core functionality. - Working knowledge of Transact-SQL. - Working knowledge of relational databases. - Some experience with database design.

Who Should Attend

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

At Course Completion

After completing this course, students will be able to:
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Create SQL Server Backups.
- Restore SQL Server databases.
- Use the import/export wizards and explain how they relate to SSIS.
- Work with SQL Server security models, logins and users.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Agent, jobs and job history.
- Configure database mail, alerts and notifications.

Introduction to SQL Server 2012 and its Toolset

Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Preparing Systems for SQL Server 2012

Overview of SQL Server Architecture
Planning Server Resource Requirements
Pre-installation Testing for SQL Server

Installing and Configuring SQL Server 2012

Preparing to Install SQL Server
Installing SQL Server
Upgrading and Automating Installation

Working with Databases

Overview of SQL Server Databases
Working with Files and Filegroups
Moving Database Files

Understanding SQL Server 2012 Recovery Models

Backup Strategies
Understanding SQL Server Transaction Logging
Planning a SQL Server Backup Strategy

Backup of SQL Server 2012 Databases

Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options

Restoring SQL Server 2012 Databases

Understanding the Restore Process
Restoring Databases
Working with Point-in-time recovery
Restoring System Databases and Individual Files

Importing and Exporting Data

Transferring Data To/From SQL Server
Importing & Exporting Table Data
Inserting Data in Bulk

Authenticating and Authorizing Users

Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers

Assigning Server and Database Roles

Working with Server Roles
Working with Fixed Database Roles
Creating User-defined Database Roles

Authorizing Users to Access Resources

Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level

Automating SQL Server 2012 Management

Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs

Monitoring SQL Server 2012 with Alerts and Notifications

Configuration of Database Mail
Monitoring SQL Server Errors
Configuring Operators, Alerts and Notifications