Microsoft SQL Server Systems Administration

Length: 5 Days
Prerequisites:  Prior knowledge of SQL, Basic Knowledge, Relational Database Theory


Overview

Learn the basics of installing, monitoring and maintaining a Microsoft SQL Server. At the conclusion of this course,
you will be able to perform any systems administration task.

Key Benefits:  When you complete this course you will have database administration procedures. You will also
know the features of Microsoft SQL Server. When you get back to your desk you will be able to perform tasks from
installation to maintaining and backing up and restoring your database. Other skills will include managing access to
the database by all users as well as how to monitor the performance.


Outline


Chapter 1. Introduction to SQL Server Administration

•  Microsoft SQL Server Overview
• SQL Server Administration
• Administrative Challenges
• Distribute Management Framework
• SQL Server Administration Tools

Chapter 2. Restoring Databases

• Methods of Recovery
• Recovering User Databases After a Media Failure
• Restoring a Database & its Log
• Restoring the Master Database

Chapter 3.  Installation

• Installing SQL Server
• Installation Requirements
• Installing Server Software
• Starting & Stopping SQL Server
• Logging into SQL Server
• Verifying the Installation
• System Databases
• Post-Installation Configuration
• Testing the Installation
• Upgrading
• Upgrade the Wizard
• SQL Server Agent
• Alerts Operators & Jobs

Chapter 4.  Importing, Exporting & Distributing Data

• Using the Transfer Management Interface
• Using the Bulk Copy Program
• Moving Data Using the Backup & Restore Commands
• Distributing Data on Removable Media

Chapter 5. Scheduling Tasks & Setting Alerts

• Task Scheduling & Alerts Overview
• SQL Executive
• Managing Task Scheduling
• Implementing SQLmail
• Managing Alerts
• Using Alerts Management Server

Chapter 6.  Managing User Accounts

• Introduction to Database Access
• Planning for Database Access
• Managing Database Groups
• Managing Login IDs & Database Users
• Displaying User Information

Chapter 7. Monitoring and Tuning

• Goals of Monitoring and Tuning
• Factors that Impact Performance
• SQL Performance Monitor Overview
• Monitoring and Tuning Memory
• Creating tempdb in Memory
• Monitoring Locks

Chapter 8. Permissions

• Permission Hierarchy
• Granting and Revoking Permissions
• Ownership Chains
• Permissions on Views
• Permission on Stored Procedures
• Displaying Information on Permissions

 Chapter 9.  Replication

• Distributed Data Overview
• Benefits of Replication
• Types of Replication Scenarios
• Replication Server Event Processing
• Setting Up Replication
• Using SQL Enterprise Manager

Chapter 10  Backup

• Implementing Backups
• Using SQL Enterprise Manager
• Obtaining on Dump Devices

Chapter 11.  Remote Data Access

• Executing Remote Procedure Calls
• Configuring for RPCs
• Accessing Remote Data
• Configuring SQL Server for Distributed Queries

Chapter 12. Transferring Data

• INSERT statement
• SELECT INTO
• BCP Program
• BULK INSERT Statement
• Data Transformation Service

Chapter 11.  Security

• Security Authentication
• SQL Server Authentication
• Adding/Dropping Logins
• NT Authentication
• Dropping NT User Groups
• Passwords
• Default Databases
• Roles Aliases
• Permissions
• Viewing Logins

Chapter 12.  Disaster Recovery

• Types
• Loss of Hardware
• Loss of SQL Server
• Loss of Power
• Loss of Data
• Remedies
• Disaster/Remedy Grid

Chapter 13.  Preventive Maintenance

• What, When, Where & Why Server Level & Database Level

Chapter 14.   Wizards

• Defining
• Show/Hide
• Create
• Complete
• Manage

Back to Course Listing