GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

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.

 

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert Microsoft Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server Training Package:

Delivery Format	Instructor Led Modules	eBook	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
NT | 95 | 98 | 2000 | ME | XP | 2003| Vista | Windows 7

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

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

 

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.

 

 

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo