Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server

SmartCert's 70-228 course provides students with the knowledge and skills that are needed to  install, configure, and administer Microsoft's SQL Server.   When you pass the Installing, Configuring, and Administering Microsoft SQL Server exam, you achieve Microsoft Certified Professional (MCP) status. You also earn credit toward the following certifications:

- Core credit toward Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification

- Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification

- Elective credit toward Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification

- Elective credit toward Microsoft Certified Systems Administrator on Microsoft Windows 2000 certification

As a Microsoft Certified Partner, SmartCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  SmartCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Learning segments

Module One - Overview

SQL Server In A Nutshell
Objects
Introduction To Databases

Module Two - Installation

Enterprise Manager/Query Analyzer
SQL Server Agent Service
Introduction To Instances
Installation Wrap-Up

Module Three - Authentication & Security

The SQL House
Other Logins And Users
Roles
Permissions
SQL Hierarchy

Module Four - Databases And Tables

Creating A Database
Recovery Model
Altering A Database
Filegroups
Tables

Module Five - Backing Up & Restoring Databases

4 Backup Methods
Safety Check
Recovery vs. Norecovery
Specific Point In Time
Wrap-Up

Module Six - Jobs, Alerts, & Operators

Configuring Email
Operators
Jobs
Alerts
Conclusion

Module 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

Module Nine - Monitoring & Tuning

Event Viewer
System Monitor
Current Activity Window
Query Execution Plan
Profiler
Index Tuning Wizard
DB Maintenance Plan Wizard

Module Ten - Test Information

Resources