Jump to course:

Systems Admin for Microsoft SQL Server

Overview

SQL Server is one of the most widely used database management systems. Learning to administer and support SQL Server will provide you with the skills needed to support users of this database. This course provides you with the knowledge and skills required to install, configure, administer, and troubleshoot Microsoft SQL Server client/server database management system.

Pre-Requisites

An understanding of basic relational database concepts. Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).Familiarity with the role of the database administrator.

Learn To

Describe SQL Server architecture
Plan for a SQL Server installation
Install SQL Server
Configure SQL Server; manage files and databases
Choose a login security method
Configure login security
Plan and implement database permissions
Back up databases
Restore databases
Automate administrative tasks using SQL Server Agent
Import, export and transform data
Monitor and maintain SQL Server performance
Replicate data from one SQL Server to another

… and much more

Course Content

SQL Server Overview
Installing and configuring SQL Server
Configuring SQL Server Agent and SQL
Enterprise managerManaging SecurityRevoking access
Managing Permissions
Managing Application Security
Implementing permissions
Managing Database files
Viewing and changing database options using Transact SQL
Backing up databases
Performing differential backup
Restoring databases
Creating jobs and operators
Using SQL Mail
Creating alerts
Assigning a fail-safe operator
Publishing SQL Server Data on the Web
Transferring Data
Importing data from a query
Modifying DTS package using DTS designer
Monitoring SQL Server
Implementing replication
Maintaining Replication

Objectives

On course completion users will be comfortable in administering the Microsoft SQL Server databases system. Plan for a SQL Server installation. Install SQL Server. Configure SQL Server; manage files and databases. Choose a login security method. Configure login security. Plan and implement database permissions. Back up databases.

Audience

Anyone needing to become familiar with administering and configuring SQL Server. An understanding of relational database concepts and the role of a database administrator are assumed.

Duration

5 Days