Further Details
Module 1: SQL Server Overview
What Is SQL Server
SQL Server Architecture
SQL Server Databases
SQL Server Security
Working with SQL Server
Module 2: Planning to Install SQL Server
Hardware Installation Considerations
SQL Server 2000 Editions
Licensing
Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting
Module 3: Managing Database Files
Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing the Database by Using Hardware-based RAID
Optimizing the Database by Using Filegroups
Optimizing the Database by Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations
Module 4: Managing Security
Implementing an Authentication Mode
Assigning Logins to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Managing Security with Views and Stored Procedures
Managing Application Security
Managing SQL Server Security in the Enterprise
Performance Considerations
Module 5: Performing Administrative Tasks
Configuration Tasks
Upgrading SQL Server
Routine Tasks
Automating Routine Maintenance Tasks
Creating a Database Maintenance Plan for SQL Server
Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs
Module 6: Backing Up Databases
Preventing Data Loss
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods
Planning a Backup Strategy
Module 7: Restoring Databases
SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases
Module 8: Monitoring SQL Server for Performance
Why Monitor SQL Server
Performance Monitoring and Tuning Methodology
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks
Module 9: Transferring Data
Introduction to Transferring Data
Tools for Transferring Data in SQL Server
Introduction to Data Transformation Services
Transforming Data Using DTS
Module 10: Introducing Replication
Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models
Module 11: Maintaining High Availability
Planning and Using Multi-Instances of SQL Server
Maintaining High Availability
Guide price
£695 |
