Administering SQL Server

Objectives: Designed for new and prospective SQL Server administrators, this course will enable delegates to install, configure and perform essential administrative tasks on a SQL Server RDBMS system.

Pre Requisites: A general understanding of database theory (e.g. Access) as well as basic NT/2000 network administration skills.

Duration: 2 days

The topics covered are as follows:

1 Introduction
• SQL Server 2000
• Transact SQL

2 Installing SQL Server 2000
• Versions of SQL Server
• System Requirements
• Setting up the Service Logon Account
• Performing the Installation
• Licensing Modes

3 Verifying the Installation
• The SQL Server Service Manager
• The SQL Query Analyser

4 Overview of SQL Server
• The Enterprise Manager
• The System Databases
• Database Objects
• The SQL Server Agent

5 Microsoft Access and SQL Server
• Connecting to a SQL Server Database with Access
• Creating a View
• Upsizing an Access Database to SQL Server

6 Server Logins
• Authentication Modes
• Built-in Logins
• Windows Logins
• SQL Logins

7 SQL Server Security
• Authentication Modes
• Fixed Server Roles
• Fixed Database Roles
• Granting access to a Database
• Database Owner (dbo)
• Assigning Permissions

8 Backing up Databases
• Transaction Log
• Recovery Models
• Simple Recovery
• Full and Bulk Logged Recovery
• Types of Backup
• Creating Backups

9 Restoring Databases
• Restoring Using Simple Recovery
• Restoring Using Full Recovery
• Restoring to the Point of Failure
• Restoring to a Point in Time
• Restoring the Master Database

10 Automating Administrative Tasks
• Configuring SQL Agent
• Creating Jobs

11 Troubleshooting and Performance Monitoring
• Windows Performance Monitor
• SQL Profiler

microcomputing serves the Tyne & Wear, Northeast England region, with software training courses arranged for all types of companies in Sunderland, Washington, Gateshead and Newcastle as well as County Durham, Northumberland and the Teeside area with courses for organisations in Middlesbrough, Darlington and Stockton.