Layout Table~~~~2786~2786~~

SQL Server 2000 Administration 7 Sessions - 21 Hours of Interactive Training~
With the SQL Server 2000 Administration training course from LearnKey, network administrators will learn techniques for installing, configuring, and administering SQL Server 2000. Expert instructor Wayne Snyder’s friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this training course, you'll be prepared for successful system administration and be ready to pass the MCP exam that provides core credit toward MCDBA certification and an elective credit toward MCSE certification.

Benefits
• Gain technical mastery of server administration and increase your IT credibility..
• Your IT knowledge and proficiency will open doors and maximize earning potential.
• LearnKey courses meet or exceed the requirements to pass MCP exam 70-228.~~~2786~2787~~

Course Outline Table~~~~2786~2788~~

Session 1~Section A: Introduction
· SQL Server Goal
· SQL Platforms
· SQL Server

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

Section C: Installation
· Basic Install
· Post Installation
· Register Server
· Check & Verify Logins
· Network Libraries
· Startup Option
· Start & Stop Services
· Verify Directories

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

Section E: Upgrade from 6.5
· Requirements
· One or Two Computer Upgrade
· Consolidation
· Data Transfer Method
· Upgrade Checklist
· Upgrade Wizard

Section F: Upgrade Methods
· Hardware & Software Requirements
· Installation Upgrade
· Post Upgrade
· Warning
· Online Database Upgrade
· Online Upgrade Exceptions
· Upgrade & Replication
· Online Database Upgrade
· Installation Upgrade

Section G: 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~~~2786~2802~~

Session 2~Section A: Database Security
· Adding Users
· New User & Login
· Special Users
· Disable Guest
· Database User Command

Section B: Database Permissions
· 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

Section C: 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

Section D: 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

Section E: Altering a Database
· Using Alter Database
· Changing Database Options
· Setting Options
· Shrink Databases
· Examining Databases
· Space Estimation
· Rules of Thumb for Logs~~~2786~2801~~

Session 3~Section A: 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

Section B: 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

Section C: Indexes
· Indexes & Data Storage & Access
· Clustered Index
· Planning Clustered Index
· Non-Clustered Index
· Non-Clustered with Clustered

Section D: Index Maintenance
· Creating Indexes
· Empty Pages
· Full Pages
· Fill Factor
· Drop an Index
· Tips for Using Indexes
· Using Indexes

Section E: Stored Procedures
· Planning Stored Procedures
· Create & Execute
· Using Stored Procedures~~~2786~2800~~

Session 4~Section A: Triggers
· Planning Use of Triggers
· After Trigger
· Inserted or Deleted Table
· Create Triggers
· Using Triggers
· After vs. Instead of

Section B: Views
· Planning Use of Views
· Details of Views
· Customize View
· Insert in Views
· Indexed View
· Set Stats & Execution Plan
· Partitioned Views

Section C: 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

Section D: 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

Section E: Filegroup & Optimize Backups
· Filegrouping
· Large Database Backup
· Filegroup Scenario
· Optimizing Backups
· Stripped Backup
· Backup Performance~~~2786~2799~~

Session 5~Section A: 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

Section B: High Availability Solutions
· 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

Section C: Relocating Data
· Attach or 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

Section D: Replication Overview
· Why Replication
· Replication vs. DTS
· Roles & Language
· Publications & Articles
· Publisher & Subscriber
· Remote Distribution~~~2786~2798~~

Session 6~Section A: Types of Replication
· Snapshot
· Transactional
· Merge
· Updating Subscribers
· New Replication Features
Section B: 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

Section C: Linked Servers
· Distributed Query
· Setting Up a Linked Server
· Linked Server Options
· Troubleshooting Linked Servers
· Changing Data
· Create Linked Server
· Link to Excel Spreadsheet

Section D: Server Automation
· Setup Mail Integration
· Test Mail Integration
· Create Operator
· Create Jobs
· Advanced Options & Create Steps
· Notifications
· Using Jobs~~~2786~2797~~

Session 7~Section A: 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

Section B: SQL Mail Integration
· SQL Mail Setup
· Using SQL Mail
· Triggers
· Mail Troubleshooting

Section C: Monitoring SQL Server
· 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
Section D: Optimizing Database Performance
· External Fragmentation
· Data Fragmentation
· Index Statistics
· Using Indexes
· Query Statistics
· Execution Plans
· Optimize Queries
· Re-Compiling Stored Procedures

Section E: IIS Virtual Directory
· Creating the Virtual Directory
· Configure XML Support
· Using Internet Explorer with SQL~~~2786~2796~~

Ordering~~~~2786~2794~~

SQL Server 2000 Administration (70-228) Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|411258|PER USER%3A ONLINE Course|525|LIBRARY LICENCE%3A CD Course|411255|~2786~2795~exam certification~