MCP 70-228 SQL Server 2000 Administration
Exam 70–228
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise
This course will give the student the skills required to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, the student will be able to pass the Microsoft 70-228 exam, Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition, which is one of the core electives in the Microsoft's MCSE 2003 and one of the core exams in the Microsoft MCDBA certification program.
Learning Segments:
Introduction
Chapter One - Overview
SQL Server In A Nutshell
Objects
Introduction To Databases
Chapter Two - Installation
Enterprise Manager/Query Analyzer
SQL Server Agent Service
Introduction To Instances
Installation Wrap-Up
Chapter Three - Authentication & Security
The SQL House
Other Logins And Users
Roles
Permissions
SQL Hierarchy
Chapter Four - Databases And Tables
Creating A Database
Recovery Model
Altering A Database
Filegroups
Tables
Chapter Five - Backing Up & Restoring Databases
4 Backup Methods
Safety Check
Recovery vs. Norecovery
Specific Point In Time
Wrap-Up
Chapter Six - Jobs, Alerts, & Operators
Configuring Email
Operators
Jobs
Alerts
Conclusion
Chapter Seven - Data Transformation Services
Import/Export Wizards
DTS Designer
Executing A Package
Chapter Eight - Replication
Replication Roles
Replication Types
Replication Agents
Push & Pull Subscriptions
Topologies
Chapter Nine - Monitoring & Tuning
Event Viewer
System Monitor
Current Activity Window
Query Execution Plan
Profiler
Index Tuning Wizard
DB Maintenance Plan Wizard
Chapter Ten - Test Information
Resources
Testimonials
“I’m pleased to tell you that I have passed both A+ exams to day. Your online training and exam prep material did a great job in preparing me to pass!”
Neil Bottomley, Poole, Dorset.
“Great news guys, I passed my ICND part 2 exam. I am now CCNA. You guys have helped to keep me motivated and keep on going even when things were looking really tough.”
Dave Cooper
“15 months ago I was made redundant from a bus company. Now I have a new career as a Microsoft Systems Administrator earning £35,000 a year. I have got LiveTrain Learning to thank for providing me with the learning materials and support to start in an entirely new career direction”
Trevor Linch MCSE, Winchester, Kent
“The quality of the training materials is very impressive and they provide a lot more than just the paper based courseware you would normally get for spending twice as much with other companies. I find the video lectures and demonstrations very informative. Most of all I like the fact that I get lots of hands on practice!”
Irene Vincent, Worthing, Sussex
“We used to send our staff away to learn Microsoft Office at £400 per day; we can now provide each staff member with the same instructor-led style training on site for a fraction of that price”
Sue Herbert, Personnel Manager, Datalink
“This course is very well presented. The instructor is clear and concise, provides a wealth of knowledge and explains the real world applications. The CEH course is definitely for anyone who is serious about Computer Security. I would recommend this course to anyone presently doing programming who wishes to get a better understanding of the different classes of a hacker and the procedures in which a "cracker" (Black Hat Hacker) goes through to gain access into any system. I am enjoying going through this course-- and I am going to complete it ahead of time!”
Paul Turnbull, Manchester