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

QuickCert'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.

For training on Microsoft SQL Server 2005, consider the MCITP Database Adminstrator or MCITP Database Developer Certifications.

* PLEASE NOTE: This course and exam were discontinued by Microsoft on March 31, 2009.  The exam date has been extended to May 31, 2009 for those already registered. Please see your nearest Prometric exam center for availability. QuickCert is offering this course for general training purposes only.

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

* PLEASE NOTE: This course and exam were scheduled for discontinuation by Microsoft on March 31, 2008.  The exam date has been extended to May 24, 2008.

For More Information E-Mail us at sales@quickcert.com
or call us at 1.888.840.2378

GET IN THE LEAD —
get certified today!

Experience the benefits of classroom learning - anytime, anywhere!  QuickCert's expert instruction and multi-media courseware is guaranteed to get you certified- or your money back!

QUICKCERT TRAINING PACKAGES INCLUDE:

Instructor-Led Training

Demos and Lab Learning

Multi-Media Presentations

Practice Exams and Test Simulators

Self-Paced Navigation

DVD or Online Delivery

Toll Free Educational Support

Money-Back Guarantee

Compatibility with NT | 95 | 98 | 2000 | ME | XP | 2003 | 2007 | Vista

FREE DEMOS!

TRY OUR COURSES NOW