SQL Server 2000 Systems Administration - SQ2A

Description
With the SQL Server 2000 Administration training course from ATS ( 7 CD-Rom Multimedia Bundle), network administrators will learn techniques for installing, configuring, and administering SQL Server 2000. This friendly CD-Multimedia presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you'll be prepared for successful system administration and be ready to pass exam 70-228, which provides core credit toward MCDBA certification and elective credit toward MCSE certification upon successful completion.

Course Outline

Module 1

Introduction
SQL Server Goal
SQL Platforms
SQL Server

Installation Options
System Requirements
Architecture
Enhancement
Server Editions
Multiple Instances
Installation
Options
File Locations
Collation
Sort Order
Domain Login
Network Protocol
Unattended Setup

Installation
Basic Install
Post Installation
Register Server
Check/Verify Logins
Network Libraries
Startup Option
Start/Stop Services
Verify Directories

Troubleshooting
Installations Basic Steps
Common Install
Failures
SQL Agent Issues
Client Issues
Named Pipes
TCP/IP

Upgrade from 6.5
Requirements
One/Two Computer Upgrade
Consolidation
Data Transfer Method
Upgrade Checklist
Upgrade Wizard

Upgrade Methods
Overview
Hardware/Software Requirements
Installation Upgrade
Post Upgrade
Warning
Online Database
Upgrade
Online Upgrade Exceptions
Upgrade & Replication
Online Database
Upgrade
Installation Upgrade

Server Security
Basic Steps
Logon Methods
Authentication Mode
SQL Login Commands
Group Usage
Add NT User
Connect Using NT
Add SQL User
Add NT Group
Validate Login
Deny Access

Module 2

Database Security
Adding Users
New User & Login
Special
Users
Disable Guest
Database User Command

Database Permissions
Overview
Object Permission
Permission Rules
Object References
Chain of Ownership
Chain Issues
Dbo Ownership
Roles
Server Fixed Roles
Database Fixed Roles
Create a Role
Permissions Accumulate
Application Role
Use of Application Roles
Creating a Role

Creating Databases
Databases in SQL Server
Master/Model

Temp db/MSdb/Distribution
Database Objects
File Types/Pages
Transaction Log
Create Database Options
Syntax× Recovery
Considerations
Create a Database

Placing Database Files
Storage Management
RAID Options
RAID 1
RAID 0 on RAID 1
RAID 5
Filegroups
Files in Filegroup
Create Filegroups
Using Filegroups
Filegroups & Maintenance
Performance Considerations

Altering a Database
Using Alter Database
Changing
Database Options
Setting Options
Shrink Databases
Examining
Databases
Space Estimation
Rules of Thumb for Logs

Module 3

Constraints
Default Constraint
Create Default Constraint
Check Constraint
Check Constraint Abilities
Using Check
Constraints
Add Records Using Check Constraints
Table Level
Constraints
Primary Key Constraints
Create Primary Key Constraints
Multiple Column Primary Key
Unique Constraints

Foreign Key Constraints
Planning Foreign Keys
Foreign Keys & Table Actions
Rules for Foreign Keys
Create Foreign Keys
Using Foreign Keys
Create Table Level Constraint
Altering Tables
Disabling Constraints

Indexes
Overview
Indexes & Data Storage/Access
Clustered Index
Planning Clustered Index
Non?Clustered Index
Non?Clustered with Clustered

Index Maintenance
Creating Indexes
Empty Pages
Full Pages
Fill Factor
Drop an Index
Tips for Using Indexes
Using Indexes

Stored Procedures
Overview
Planning Stored Procedures
Create/Execute
Using Stored Procedures

Module 4

Triggers
Overview
Planning Use of Triggers
After Trigger
Inserted/Deleted Table
Create Triggers
Using Triggers
After vs. Instead of

Views
Overview
Planning Use of Views
Details of Views
Customize View
Insert in Views
Indexed View
Set Stats/Execution
Plan
Partitioned Views

Database Backup
Why Backups
Backup Models
Full Recovery
Bulk?Logged Recovery
Simple Recovery
Permissions Required
Backup Methods
Backup Timing
Full Backup
Using Dump Device
Backup Options
Tape Option
Create Backup
Enterprise Manager
Differential Backup

Backup Transaction Logs
Why Backup Logs
Normal Log Backup
Truncate Only/No Log
Log Full
Long Transactions
View from Enterprise Manager
Backup No Truncate
Standard Scenario

Filegroup/Optimize Backups
Overview
Filegrouping
Large Database Backup
Filegroup Scenario
Optimizing Backups
Stripped Backup
Backup Performance

Module 5

Restore & Recovery
Automatic Recovery
Transaction Log with Recovery
Restore Process
Check Media
Restore Steps
Restore Options
Restoring Log
Restoring Master
Restore Scenario
Restore Database
Restore Logs
Basic Restore Commands

High Availability Solutions
Overview
Standby Server Log
Shipping
Starting SQL Agent
Setup Log Shipping
Setup Backup
Criteria
Troubleshooting Log Shipping
Log Ship Role Change
User/Login Mapping
Cluster Server
Windows Clustering
SQL Clustering
Active/Passive Cluster
Active/Active Cluster
Log vs. Cluster

Relocating Data Overview
Attach/Detach Database
DTS
Create DTS Package
DTS Tasks/Steps
Transform Data
Data Lineage
Use DTA Wizard
DTS Designer
Verify Metadata
DTS Workflow
Change Data Type
Export/Import DTS
Import File
Bulk Insert/BCP

Replication Overview
Why Replication
Replication vs. DTS
Roles & Language
Publications/Articles
Publisher/Subscriber
Remote Distribution

Module 6

Types of Replication
Overview
Snapshot
Transactional Merge
Updating Subscribers
New Replication Features

Implementing Replication
Planning
Designing
Distributor Setup
Configuring a Distributor
Publisher Setup
Configuring a Publisher
Create Publication
Push Subscription
Replication Monitor
Alerts
Updating Subscribers
Troubleshooting Replication
Internet/Heterogeneous Replication

Linked Servers
Distributed Query
Setting Up a Linked Server
Linked Server Options
Troubleshooting Linked Servers

Changing Data Create Linked Server
Link to Excel Spreadsheet

Server Automation
Overview
Setup Mail Integration
Test
Mail Integration
Create Operator
Create Jobs
Advanced Options/Create Steps
Notifications
Using Jobs

Module 7

Managing Automation
Alerts
Using Raise Error
Error Log/NT Event Log
XP?Log Events
Create Alerts
Respond to Alerts
Multiple Operator Notification
Performance Monitor Alert
Failsafe
Operator/Master Server Wizard
Alert Response Delay
Automation
Troubleshooting

SQL Mail Integration
SQL Mail Setup
Using SQL Mail
Triggers
Mail Troubleshooting

Monitoring SQL Server
Overview
Memory Monitoring
Processor Monitoring
Disk I/O Monitoring
System Monitor
SQL Server Monitoring
Optimize Processor Use
Monitoring Locks
SP_WHO Command
Locks in Enterprise Manager
Deadlock (1205) Error
Profiler
Using Profiler
Server Configuration
DBCC

Optimizing Database Performance
External Fragmentation
Data Fragmentation
Index Statistics
Using Indexes
Query Statistics
Execution Plans
Optimize Queries
Re-Compiling Stored Procedures

IIS Virtual Directory
Creating the Virtual Directory
Configure XML Support
Using Internet Explorer with SQL
Security Auditing Methods
C2 Auditing
C2 vs. SQL Profiler
Additional Resources

Price £975 (Bundle of 7)

Complementary Courses
SQD1 - SQL Server Implementing Data Base Design
SQD1 - SQL Server for Developers Part 1
SQD2 - SQL Server for Developers Part 2
SQD3 - SQL Server for Developers Part 3
SQ2D - SQL Server DTS Data Transformation Services
SXM2 - XML SQL Server 2000

<<Back <<Contact Us