|
|
|
Microsoft SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training Online Course
Microsoft SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Total Time: 13 hour(s)
The SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training online Course is designed to help learners prepare to take and pass Microsoft's exam number 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition. This series teaches learners how to install SQL Server 2000 and configure advanced options. The series also teaches learners how to manage databases and objects, create a disaster recovery plan, troubleshoot data integrity issues, extract and secure data, automate tasks, and Optimise performance.
| |
Try A Free Demo
|
Live Labs Available
|
24/7 Tutor Available
|
Need help? Click Here
|
| |
 |
 |
 |
 |
 |
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Training Online Course Lessons:
1 Basic Concepts and Installation
Understand basic database structure and terminology
Identify basic requirements for installing the various editions of SQL Server 2000
Select an installation type and desired components
Understand the file path structure
Identify the network libraries used for connection to an instance
Install a named instance
|
Duration 2 hours |
2 Advanced Installation
Add and remove components
Uninstall an instance of SQL Server 2000
Perform a remote installation
Create an unattended installation file for deployment on multiple servers
Add and remove nodes from a virtual server
Perform SQL Server 2000 upgrades
|
Duration 2 hours |
3 Creating and Managing Databases
Plan proper data and log file placement for a new database
Understand how to create and use filegroups
Create and delete a database using GUI and command-line methods
Restrict database access to Single-User Mode and restore normal access
Perform Attach and Detach operations on a database
Use the Enterprise Manager to modify existing database objects, including tables, views and stored procedures
|
Duration 2 hours |
4 Disaster Recovery and Data Integrity
Recognize the differences among the three primary database backup types
Plan database backup scheduling based on backup type and recovery model selection
Determine when each of the three recovery methods should be used
Identify the types of integrity found in database implementations
Use SQL Server 2000 and Windows 2000 tools to troubleshoot transactions and perform integrity checks
Perform system monitoring using the SQL Profiler, Enterprise Manager, and Transact-SQL command-line actions
|
Duration 2 hours |
5 Extracting and Securing Data
Import data into a database using the insert and bulk insert commands
Perform bulk imports, exports, and updates using the bcp utility
Create and schedule DTS packages
Create logins under Windows and SQL Server Authentication
Grant, revoke, and deny connections rights and access permissions
Create and remove user-defined database roles
|
Duration 2 hours |
6 Automation and Performance
Manage a multiserver administration configuration
Configure the SQL Server Agent
Create automated Jobs, Alerts, and Operators
Monitor system performance
Create and use a performance baseline to identify performance variance
Defragment indexes on tables and indexed views
Optimise bulk copy process performance
|
Duration 2 hours |
7 Practice Exams
Practice for the MCDBA/MCSA/MCSE 70-228 Exam
|
Duration 1 hours |
|
Telephone: 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!)
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL
|
|
|
