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. You also earn credit toward the following certifications:
- Core credit toward MCDBA: Microsoft Certified Database Administrator on Microsoft SQL Server 2000 certification
- Elective credit toward MCSE 2000: Microsoft Certified Systems Engineer on Microsoft Windows 2000 certification
- Elective credit toward MCSE: Microsoft Certified Systems Engineer on Microsoft Windows NT 4.0 certification
- Elective credit toward MCSA 2000: Microsoft Certified Systems Administrator on Microsoft Windows 2000 certification
As a Microsoft Certified Partner, QuickCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
* 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.
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
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
CD-ROM or Online Delivery
Toll Free Educational Support
Money-Back Guarantee
Compatibility with NT | 95 | 98 | 2000 | ME | XP | 2003 | 2007 | Vista
FREE DEMOS!