**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**



SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Online Course Tutorial Details

Total Lessons: 7
Total Time: 13 hour(s)
Subscription Term: 12 month(s)

Click Here to buy the 70-228 Online Course Tutorial Now!

Summary:

The SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 series 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 optimize performance.



Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment



Lesson 1 Basic Concepts and Installation - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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





Lesson 2 Advanced Installation - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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





Lesson 3 Creating and Managing Databases - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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





Lesson 4 Disaster Recovery and Data Integrity - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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







Lesson 5 Extracting and Securing Data - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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





Lesson 6 Automation and Performance - 2 hours

Objectives: After completing this lesson, students will be able to:
* 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
* Optimize bulk copy process performance







Lesson 7 Practice Exam - 2 hours

Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate thier current skill level for the SQL Server 2000 Admin 70-228 Exam