Audience
Designed for individuals in the design and administration of relational databases.
Topics
Unit 1: SQL Server Administration
- Server Features
- Administrative Tasks
- Server Tools
- Server Basic Concepts
Unit 2: Installation and Configuration
- Pre-Installation
- Installation
- Post-Installation
Unit 3: Managing with SQL Server
- Devices and Databases
- SQL Security
- Backup and Restore
- Scheduling and Alerts
Unit 4: Replicat
Objectives
Upon completion of this course, the student will be able to:
Install and configure SQL Server Create, delete, and edit devices, databases and transactions Create users and groups Assign permissions to users, objects and statements Describe the auto-recovery features of SQL Server Describe the procedures for backing up and restoring Describe the process of scheduling tasks in managing an SQL database Recognize the process of setting alerts in managing an SQL database Describe the process of setting alerts using SQL Server Recognize the purpose of replication, the purpose in enterprise database manager Describe the process of replication using SQL Describe the tolls for measuring performance ina SQL managed database Recognize the features and use of several client utilities and ODBC compatible applications