Who Should Attend:

Web designers and programmers, software engineers, systems analysts, applications programmers, computer science students, and participants interested in acquiring the technical skills required to administer Microsoft SQL 2000 Server.

Prerequisites:

A basic understanding of SQL.

Objectives:
This hands-on module equips students with the knowledge to administer Microsoft SQL2000 Server. Upon completion of this module, the participant should be able to understand basic database concepts, create and configure user data bases, and perform backups and other administrative tasks.

Contents:

Overview of SQL2000 Server: Overview of Databases and Instances; Internal Database Structures; Internal Memory Structures; Background Processes. External Structures; Logical Modeling Conventions.

Installing SQL2000 Server: Installation process.

Preparing to Use SQL2000 Server: Understanding System and User Databases.

Creating and Configuring User Database: Managing the Development Process. Monitoring Multiple Databases: Common Problem Areas; Target Selection; The End Product; Creating Command Center Database; Monitoring Memory Objects. Managing Large Databases: Setting Up Environment; Managing Transactions.

Backing Up and Restoring SQL Server: Space Usage Within Rollback Segments; Monitoring Rollback Segment Usage; Choosing Number and Size. Capabilities, Logical Backups; Physical Backups; Integration of Backup Procedures; Recovery; Media (Disk) Failure; Recovering Accidentally Dropped or Altered Objects; Parallel Recovery; Recovery Manager.

Performing Administrative Tasks: Security Capabilities; Implementing Security; Limiting Available Commands: Product User Profiles; Password Security During Logins; Password Encryption and Trickery; Auditing; Protecting the Audit Trail; Security in a Distributed Environment.

Monitoring SQL Server Performance and Activity: Tuning Application Design; Tuning SQL; Tuning Memory Usage; Tuning Data Storage; Tuning Data Manipulation; Tuning Physical Storage; Tuning Logical Storage; Reducing Network Traffic.