Layout Table~~~~4783~4783~~

MCDBA 21 Sessions - 63 Hours of Interactive Training~
The SQL Server 2000 MCDBA Core Certification from LearnKey includes all training needed to successfully complete the core exam requirements for Microsoft Certified Database Administrator certification. The training series comprises three complete LearnKey training courses: SQL Server 2000 Administration; SQL Server 2000 Implementing Database Design; and Windows Server 2003 Managing a Network Environment. After completing this training series, certification candidates will be prepared to pass MCP exams 70-228, 70-229, and 70-290, successful completion of which fulfill the SQL Server Administration, SQL Server Design, and Networking Systems core exam requirements for MCDBA certification.

Benefits
• You’ll be on your way to Microsoft Certified Database Administrator certification.
• Your IT knowledge and proficiency will open doors and maximize earning potential.
• Gain technical mastery and capitalize on the need for qualified IT professionals.
~~~4783~4784~~

Course Outline Table~~~~4783~4785~~

Managing a Network Environment Session 1~Section A: Introduction
· Course Overview
· Windows 2003 Family
· Windows 2003 Editions
· Standard & Enterprise
· Datacenter & Web

Section B: Installation
· Prerequisite Knowledge
· Hardware Requirements
· Clean Installations
· Upgrade Installations
· Upgrading NT 4.0 Domains
· NT 4.0 Upgrade Issues
· NT 4.0 Upgrade Order
· Upgrading to Active Directory

Section C: Upgrading Windows 2000
· Active Directory
· Adprep/forestprep
· Adprep/domainprep
· Set Up Server 2003
· Windows Setup
· Verify Upgrade
· Functional Levels
· Domain/Forest Levels

Section D: Hardware Support
· Server Class Hardware
· Standard/Wireless
· USB Devices
· View Devices
· Optical Drives
· Hardware Installation
· Driver Signing
· Unsigned Drivers

Section E: Troubleshoot Hardware
· Hardware Problems
· Add Hardware Wizard
· Update Drivers
· Audio
· HAL/Computer Driver
· Other Tools~~~4783~4786~~

Session 2~Section A: Server 2003
· Hard Drives
· Basic Disks
· Dynamic Disks
· More on Basic Disks
· Basic to Dynamic
· Dynamic Conversion

Section B: Basic Dynamic Volumes
· Volume Types
· Spanned vs. Striped
· Disk Management
· Simple Volume
· Spanned Volume
· Striped Volume

Section C: Fault Tolerant Volumes
· Mirrored Volume
· RAID-5 Volume
· Configure Mirror
· Configure RAID-5

Section D: Managing Volumes
· Disk Management Console
· Mount into Directory
· Storage Commands
· DiskPart Utility
· Defrag Utility
· Schedule Defrag

Section E: File Systems
· FAT/FAT32
· NTFS
· NTFS-Based Features
· Format NTFS
· Format FAT32
· File Permissions

Section F: Computer Accounts
· Access Server Resources
· Join Domains
· Create Accounts
· Log onto Domain
· Computer Management
· Computer Account Issues
· DNS Settings
· Reset Account~~~4783~4787~~

Session 3~Section A: User Accounts
· Basic Building Block
· Authentication
· Create Users
· Local User Account
· Active Directory Users
· User Properties
· Verify Resource Access

Section B: Advanced User Accounts
· Create Users Quickly
· Create Template
· Copy Template
· net User Command
· dsadd User Command

Section C: User Account Properties
· Properties
· Account Tab
· Profile Tab
· Account & Password Policies
· Account Lockout Policy
Section D: User Profiles
· Roaming Profile
· Mandatory Profile
· Add Roaming Profile
· Save Profile
· Add Mandatory Profile

Section E: Groups
· Group Categories
· Group Scope
· Windows 2000 Mixed Mode
· Domain Local Group
· Global Group
· Universal Group
· Domain Groups
· Forest Groups

Section F: Managing Groups
· Control Access
· Add Users
· Create Group
· Change Group Scope
· Move Users or Groups
· AD Automation~~~4783~4788~~

Session 4~Section A: NTFS Permissions
· Local File Access
· Permission Inheritance
· Grant Permissions
· Advanced Permissions
· Modify Inheritance
· Effective Permissions

Section B: Share Permissions
· Create Share
· Real World Permissions
· Modify Permissions
· Troubleshooting

Section C: NTFS Features
· Ownership
· View Ownership
· Take Ownership
· Compression
· Quotas
· Apply Compression
· Set Quota
· Test Quota Entries

Section D: Printers
· Permissions
· Print Devices
· Sharing
· Setting Up
· Install on Server
· Share Permissions
· Install on Client
· Manage Printers
· Print Queue
· Print Server Properties

Section E: Windows Licensing
· Site Licensing
· Licensing Tool
· Verify Licensing
· Licensing Server
· Licensing Modes

Section F: Software Update Services
· Install SUS
· Administrative Interface
· Service Packs~~~4783~4789~~

Session 5~Section A: Remote Administration
· Remote Tools
· Install Help
· Add Computer Management
· Remote Assistance
· Using Remote Assistance

Section B: Remote Desktop
· Implementing
· Connection
· Enable & Add Users
· Remote Connection
· Options
· Remote Control

Section C: Web Server
· Web Services
· IIS 6.0
· Install IIS
· Manage Server
· Securing IIS

Section D: Monitoring Servers
· Monitoring Tools
· System Monitor
· Remote Monitoring
· Performance Logs
· Log/Schedule Properties
· Create Logs/Alerts
· View Logs
· Performance Guidelines

Section E: Shadow Copies
· Requirements
· Enable Shadow Copies
· Settings
· Restore Shadow Copies

Section F: Backup
· Backup Options
· Removable Storage
· Backup Process
· Advanced Options
· Scheduled Backups
· Restore Options
· Restore Active Directory
· Restore Data

Section G: Disaster Recovery
· Basic Elements
· Redundancy
· ASR
· Using ASR~~~4783~4790~~

SQL Server 2000 Administration 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~~~4783~4796~~

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 BR>· Using Alter Database BR>· Changing Database Options BR>· Setting Options BR>· Shrink Databases BR>· Examining Databases BR>· Space Estimation BR>· Rules of Thumb for Logs~~~4783~4797~~

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~~~4783~4798~~

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~~~4783~4799~~

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~~~4783~4800~~

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~~~4783~4801~~

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~~~4783~4802~~

SQL Server 2000 Implementing Database Design Session 1~Section A: Introduction
· Overview

Section B: Normalization
· Basic Concept
· Redundancy
· Design Language
· Entity
· First Normal Form
· Primary Keys
· Second Normal Form
· Third Normal Form
· Relationships
· Business Rules
· Normalization Benefits

Section C: Creating a Database
· Database Objects
· Database Creation Process
· Transaction Log
· Create Option
· Create Syntax
· Query Analyzer
· Collate Order
· Enterprise Manager
· Recovery Considerations

Section D: Placing Database Files
· Storage Management
· Hardware RAID
· Filegroups
· Files & Filegroups
· Filegroups Maintenance
· Performance Considerations

Section E: Maintaining Databases
· Growth
· Alter Database
· Database Options
· Shrink Database
· Exam Database
· Space Estimation
· Transaction Log Size
· Rules of Thumb
· Log File Issues
· Extensive Log Activity

Section F: Basic SQL Data Types
· Create Table
· Standard Data Types
· Exact Numerics
· Integer Variables
· Approximate Numerics
· Character
· Variable vs. Fixed
· Unicode~~~4783~4803~~

Session 2~Section A: Advanced SQL Data Types
· Date & Time
· Date Format
· Money
· Invalid Entry
· Binary
· GUID
· BLOB
· Special Data Types

Section B: Creating a Table
· Simply Syntax
· Null or Not Null
· Space Allocation
· Temporary Tables
· Primary Key Values
· Identity Column
· Using Identity Values
· Scope Identity
· Unique Identifier
· Newid Function
· Extended Properties
· Altering & Dropping Tables

Section C: Data Integrity Concepts
· Types
· Data Integrity
· Entity Integrity
· Domain Integrity
· Referential Integrity

Section D: Data Integrity Implementation
· Enforcement
· Constraints
· Generic Constraints
· Defaults
· Check Constraints
· Table vs. Column Constraint
· Column Constraint
· Alter Constraints
· Constraint Options

Section E: Primary Key Constraint
· Implement Primary Key Constraint
· Duplicate Key Values
· Multi-Column Key
· Unique Constraint
· Add Unique Constraint

Section F: Foreign Key Constraint
· Foreign Key Rules
· Cascade Update~~~4783~4804~~

Session 3~Section A: Select Statement
· Basic Select
· Special Identifiers
· 4-Part Naming Convention
· Select Order
· Where Clauses
· Comparison Operators
· Range of Values
· Values in a List
· String Pattern Matching
· String Comparison Operator
· Like Operator
· Not Like Operator
· Null Checking
· Logical Operator
· Not, And, Or Operators
· Dynamic SQL

Section B: Formatting Result Sets
· Sorting
· Order By
· Eliminating Duplicates
· Order By with Distinct
· Column Alias
· Using Literals

Section C: Summarizing Data
· Aggregate Functions
· Aggregate Examples
· Count Distinct
· Group By
· Group By Having
· Having with Aggregates
· Rollups
· Cube

Section D: Functions & Set Options
· System Functions
· Set Options
· Scalar Functions
· Object Properties
· Convert Function
· String Functions
· GetDate Function
· Date & Time Functions
· Row Count Set Option

Section E: Inner Joins
· Joins
· GUI Joins
· Inner Join
· Alias Table Names
· Join Result Options
· Multiple Table Joins~~~4783~4805~~

Session 4~Section A: Outer Joins, Cross Joins & Unions
· Outer Joins
· Left & Right Outer Join
· Cross Join
· Self-Referencing Table
· Self-Reference Outer Join
· Denormalizing
· Unions

Section B: Subqueries
· Rules
· Nested Subquery
· Multiple Value Nested Subqueries
· Distinct Subqueries
· Correlated Subqueries
· Complicated Subqueries

Section C: Insert, Delete & Update
· Insert Statement
· Defaults
· Insert Select
· Truncate Table
· Deleting Records
· Updating Records
· Update with Join

Section D: Indexing
· Heap vs. Clustered
· Data Access
· Clustered Index
· Why Clustered Indexes?
· Non-Clustered Indexes
· Why Non-Clustered Indexes?
Section E: Indexes & Fillfactor
· Creating Indexes
· Computed Columns
· Maintenance Issues
· Full Pages
· Fillfactor

· Execution Plan with Index
· Aggregate with Index
· Clustered Index

Section F: Indexes & Fragmentation
· External Fragmentation
· Data Fragmentation
· Scan Density
· DBCC Index Defrag
· Dropping Index
· Index Hints~~~4783~4806~~

Session 5~Section A: Index Statistics
· Density
· Index Statistics
· Index Statistics Usage
· Updating Statistics
· View Statistics
· Set Statistic Properties
· Using Query Plan
· Update Statistics
· Force Index Usage
· Use Updated Statistics
· Update Statistic Commands
· Show Sysindexes
· Turn On Statistic

Section B: Query Optimization
· Slow Queries
· Query Plan
· Dual Indexes Usage
· And Operators
· Or Operators
· Aggregates
· Joins
· Merge Join
· Entity Relationship Diagram
· Verify Cost
· Force Index
· Search Arguments
· Like Clause

Section C: SQL Profiler
· Event Classes
· Run Profiler
· Tracefile Properties
· Index Tuning Wizard
· Analysis
· Trace Replay
· Access Query Analyzer
· Set Processor Usage
· Query Governor

Section D: Views
· View Details
· Create View
· Using Views
· Updateable Views
· Alter View
· Insert Record
· Check Options
· Update & Delete Records
Section E: Linked Servers
· Query Types
· Setting up the Link
· Login
· Options
· Open Query
· RPC's
· Create Linked Server (Excel)
· Distributed Passthrough Queries
· RPC/Adhoc
· Union Query~~~4783~4807~~

Session 6~Section A: Indexed & Distributed Views
· Indexed View Usage
· Scheme Bound View
· Indexed View
· Data Partitioning
· Partition View
· Create Data Partition
· Create Data Partition View
· Setting Up
· Modify Users View
· Insert, Update & Delete
· View Issues

Section B: Programming SQL
· Global Functions
· Local Variables
· Define a Local Variable
· Define Multi-Local Variables
· Assignment Select Statement
· Variable Value Assignment
· Control of Flow
· Multiple Statement
· While Loop
· Until & Break
· GoTo & WaitFor

Section C: Other Language Elements
· Simple Case Statements
· Searched Case
· Raiserror
· View Logs
· User Messages
· Validate Data
· XPLOG Events
· Commenting

Section D: Transactions
· Rollback
· Transaction Examples
· Partial Rollback
· Nested Transactions
· Avoid Nested
· Implicit
· Implicit Starters
· Error Checking
· Set Implicit On
· Restricted & Best Practices
· Linked Server & Remote Procedure
· Distributed Transaction

Section E: Locks & Lock Types
· Lost & Erroneous Transactions
· Non-Repeatable & Phantoms
· Benefits & Usage
· Lock Types
· Lock Process
· Intent Locks & Bulk Update
· Isolation Levels
· Locked Record Trace
· Set Lock Time Out~~~4783~4808~~

Session 7~Section A: Lock Manipulation
· Lock Hints
· Using Locks
· Deadlock Error
· Avoiding & Handling Deadlocks
· Locking Best Practices

Section B: Cursors
· Cursor Types & Behavior
· Cursor Steps
· Modifying Data
· Using Cursor
· Update Data
· Cursor Best Practices

Section C: Stored Procedures
· Create & Execute
· Using Stored Procedures
· Parameters
· Using Parameters
· Local Variables
· Default Parameter Values
· Output Parameters
· Error Checking
· Testing Stored Procedures
· Return Status
· Plan Sharing & Best Practices

Section D: User Defined Functions
· Function Types
· Calling Functions
· Schema Binding
· Determinism
· Function Syntax
· Calling Scalar Functions
· Using Functions
· Table Value Functions
· Calling Table Functions
· Multi-Statement Table
· Best Practices

Section E: After Triggers
· Plan Trigger Use
· Trigger Functionality
· Inserted, Updated, Deleted Tables
· Using Triggers
· Testing Triggers
· Cascading Updates~~~4783~4809~~

Session 8~Section A: Instead-Of Triggers
· Using Instead-Of Triggers
· Create Trigger
· Nested Triggers
· Instead-Of vs. After

Section B: Data Movement
· DTS Tools
· DTS Packages
· DTS Data Lineage
· DTS Import/Export Wizard · Export to Flat File
· Import Data
· DTS Package Workflow

Section C: Replication
· Replication Roles
· Replication Types
· Merge
· Create Merge Publication
· Subscriptions
· Updating Subscribers
· New Replication Features

Section D: Permissions & Roles
· Object Permissions
· Chain of Ownership
· Permissions & Chain of Ownership
· Row Level Security
· Assign Row Level Security
· Roles
· Understanding Roles
· Application Roles

Section E: XML
· Selecting
· For XML Auto
· For XML Raw
· For XML Explicit
· Open XML
· Additional Resources~~~4783~4810~~

Ordering~~~~4783~4811~~

SQL Server 2000 MCDBA Core Certification 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|681728|LIBRARY LICENCE%3A CD Course|681725|~4783~4812~sql 2000 mcdba exam certification~