SQL Server DBA Training Course - Database AdministrationOverview See also our SQL Server 2005 Administration Training Course Please click here for
a full list of our latest SQL Server 2005 training courses SQL Server DBA Training Course Summary |
What You Will Learn
At the end of the cours the delegate should be able to:
1. Install SQL Server
2. Create databases
3. Import data
4. Set up security
5. Automate jobs and alerts
6. Set up replication
7. Create a robust backup regime
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
5 Days
Target Audience
This course is aimed at DBAs (Database Administrators) using Microsoft SQL Server 2000. SQL Server 7 is also available.
Pre Requisite Skills
Delegates should have a good background knowledge of SQL Server.
Associated courses
SQL Server 2005 training - coming
soon!
SQL Server 2000 Applications Development
training
SQL Server 2000 Database Administration
SQL
Server Performance Tuning
SQL
Server OLAP, DTS, Data Warehouses & Cubes / Analysis Services Training
SQL Design and Information
Retrieval
What is Microsoft SQL Server?
Client/Server Architecture
Microsoft SQL Server - A Brief History
SQL Server 2000 A Review of New Features
Pre-Installation Check List
Installing Microsoft SQL Server 2000
SQL Server Components
Upgrading and Compatibility Issues
Service Packs
Creating Databases and Logs
Using Filegroups
Managing Database Availability
Managing Database Size
Data Transformation Services (DTS)
Modifying DTS Packages
DTS Transformations
BCP The Lowest Common Denominator
Using Backup and Restore to Move Data
SQL Server 2000 Security Overview and Terminology
Windows Authentication Mode
Fixed Server and Database Roles
User-Defined Roles
Database Permissions
Application Roles
Planning Fault Tolerance for SQL Server 2000
Backup Overview
SQL Server 200's Backup Mechanism
Backup Types
Backup Destinations
Performing the Backup
Restoring Databases from Backup
Standby Servers and the Log Shipping Feature
Restoring System Databases
Defining roles within a database
Assigning Rights to users and roles
Automation Overview
Setting up SQLMail
Setting up Operators in Microsoft SQL Server
Jobs, Events and Alerts
Types of Job
Creating User-Defined Error Messages
Setting Up Alerts
Multi-Server Jobs
Replication Overview
Replication Topologies
Microsoft SQL Server 2000 Replication: How it Works
Setting Up Replication
Troubleshooting SQL Server
Monitoring SQL Server
Optimising Microsoft SQL Server 2000
Hardware Optimisation - Memory, CPUs and Disks
SQL Server Configuration options
Optimal Database Design
Client-Side Optimisations
Associated Courses
SQL Server 2005 Applications Development
training course
SQL Server 2005
Database Administration Training Course
SQL Server
2005 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle
/ MySQL users
SQL Server
2005 Business Intelligence Training Course: SSAS & SSIS Analysis and Integration
Services Training Course
Advanced
SQL Server Analysis Services Training Course
SQL Server
2005 Business Intelligence Training Course: SSRS Reporting Services Training
Course
SQL Server 2000
Applications Development training
SQL Server 2000 Database Administration
SQL
Server Performance Tuning
SQL
Server OLAP, DTS & Cubes Training
SQL Design and Information
Retrieval
|
|
|