◊ SQL SERVER 2000 ADMIN ONLINE TRAINING SERIES
Online SQL Server 2000 Admin Training
Database » SQL Server
Check out these great money-saving course packages:
Only $99.95
SQL Server 2000 Admin MCDBA MCSA MCSE 70-228 Series (13 hours)
ONLINE SQL Server 2000 Admin MCDBA MCSA MCSE TRAINING FEATURES
- Learn SQL Server 2000 Admin MCDBA MCSA MCSE online with these interactive online SQL Server 2000 Admin MCDBA MCSA MCSE courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the SQL Server 2000 Admin MCDBA MCSA MCSE courses
- Retake the SQL Server 2000 Admin MCDBA MCSA MCSE courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:1 Basic Concepts and Installation
Time: 2 hours
This course provides a brief review of database structure, implementation, and the basic databases within SQL Server 2000 installations. It also gives an overview of the available versions of SQL Server 2000 and their uses. The basic requirements for planning a SQL Server 2000 installation are presented.
Objectives
- 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
Topics
- Database Basics
- Client/Server Topologies
- Editions and Installation Options
- Instances and Components
- Network Libraries and Collations
- Services and Authentication
- Installation Checklist
- Basic Installations
2. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:2 Advanced Installation
Time: 2 hours
This course covers basic installation procedures and options for both default and named instance installations of SQL Server 2000. Additional topics include advanced installation procedures, configuration options, and upgrade implementations of SQL Server 2000, all of which may be included on the certification exam.
Objectives
- 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
Topics
- Subinstallations
- Components
- Remote installation
- Unattended installation
- Uninstalling SQL Server 2000
- Failover Clustering
- Upgrading
3. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:3 Creating and Managing Databases
Time: 2 hours
This course discusses the basic creation of databases and database objects within a SQL Server 2000 instance. The tools provided in SQL Server 2000 installations for creating these are the SQL Server Enterprise Manager, a graphical user interface (GUI) management tool, and the SQL Query Analyzer, allowing the option of either using templates or command-line methods. Additional topics include the maintenance of SQL Server 2000 databases and database objects using the SQL Server Enterprise Manager and command-line functions available in the SQL Query Analyzer utility.
Objectives
- 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
Topics
- Basic Requirements
- Creating and Deleting Databases
- The CREATE and DROP DATABASE Commands
- Creating Objects
- Managing Databases
- The ALTER DATABASE Command
- Managing Objects
4. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:4 Disaster Recovery and Data Integrity
Time: 2 hours
This course explains the processes used in backing up and restoring databases and database files within an instance of SQL Server 2000 using the SQL Server Enterprise Manager and the SQL Query Analyzer. Additional topics include troubleshooting transactions and options for checking data integrity using the SQL Server Enterprise Manager or the SQL Query Analyzer for command-line actions.
Objectives
- 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
Topics
- Recovery Planning
- Backups
- Restoration
- Data Integrity
- Monitoring
- DBCC Statements
5. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:5 Extracting and Securing Data
Time: 2 hours
This course covers the use of bulk insertion and update tools including both command-line and graphical user interface tools, such as the Data Transformation Services (DTS) utility. Additional topics include SQL Server 2000 security modes, connection authentication, access authorization, and the assignment and revocation of permissions on a user and role basis. Methods employing the SQL Server Enterprise Manager, as well as command-line options for use within the SQL Query Analyzer, are emphasized.
Objectives
- 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
Topics
- Importing Individual Records
- Importing Multiple Records
- The bcp Utility
- Data Transformation Services
- Distributed Data Operations
- Authentication Basics
- Creating and Managing Logins
- Authorization Basics
- Creating and Managing Roles
6. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:6 Automation and Performance
Time: 2 hours
This course covers the capabilities included in SQL Server 2000 for automating routine tasks, allowing the database administrator to concentrate on development and tasks too complex for automation. Command-line options are available for most automation capabilities, but the graphical user interface (GUI) management tools access in the SQL Server 2000 Enterprise Manager provides the most robust and rapidly deployed automation options. Additional topics include an overview of the tools and techniques for monitoring SQL Server 2000 operations and a discussion of some of the common SQL Server performance optimization considerations that are included in the exam. There are as many specific configurations for performance optimization as there are installations of SQL Server 2000.
Objectives
- 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
Topics
- Automation basics
- Administration agents
- Creating automation components
- Database maintenance planning wizard
- Optimizing performance
- Index defragmentation
- Bulk copy optimization
7. SQL Server 2000 Admin MCDBA MCSA MCSE 70-228:7 Practice Exams
Time: 1 hours
This course provides two practice exams for the Microsoft SQL 2000 Administration 70-228 certification exam.
Objectives
- Practice for the MCDBA/MCSA/MCSE 70-228 Exam
Topics
- Taking the MCDBA/MCSA/MCSE 70-228 Exam
- Key Facts
- Practice Exam
Resources for SQL Server 2000 Admin
