|
SQL
Server 2000 System Administration
Price:
US $1,995, UK £1,499 + VAT | Duration: 5 days
Learn
how to deliver exceptional performance and scalability to your
business
information systems-and prepare for the Microsoft® Certified
Professional (MCP) exam. Work at your own pace through a system
of lessons and hands-on exercises to gain practical experience
installing, configuring, and troubleshooting SQL Server™ 2000.
As you build these real-world database administration skills,
you're also preparing
for MCP Exam 70-228 -an elective for MCSE/MCSA certification and
a core exam on the MCDBA track.
An
understanding of basic relational database concepts. Knowledge of
basic Transact-SQL syntax (SELECT, UPDATE and INSERT statements).
Familiarity with the role of the database administrator.
- Install or
upgrade to SQL Server 2000
- Configure
database options-capacity, connectivity, and performance
- Automate
data transfer and manipulation with Data Transformation Services
(DTS) packages
- Use SQL Server
replication services
- Manage security-authentication,
logins, permissions, and alerts
- Monitor and
fine-tune system performance with tools such as SQL Server Agent,
SQL Profiler, and the Windows® System Monitor
- Perform backups
and restorations
This course provides
delegates with the knowledge and skills required to install, configure,
administer and troubleshoot Microsoft SQL Server.
The course provides
extensive hands-on practical experience to build and develop competence
and abilities in tasks such as installation, backup, recovery and
managing security using SQL Server's tools
Overview
of SQL Server 2000
What Is
SQL Server 2000? | What Are the SQL Server 2000 Components? | What
Is the Relational Database Architecture? | What Is the Security
Architecture?
Installing
SQL Server 2000
Planning to Install SQL Server 2000 | Deciding SQL Server 2000 Setup
Configuration Options | Running the SQL Server 2000 Setup Program
| Using Default, Named, & Multiple Instances of SQL Server 2000
| Performing Unattended & Remote Installations of SQL Server
2000 | Troubleshooting a SQL Server 2000 Installation
Preparing
to Use SQL Server 2000
§ Reviewing the Results of Installation
§ Starting, Stopping, Pausing, & Modifying SQL Server 2000
Services
§ Working with Osql, SQL Query Analyzer, & SQL Server Enterprise
Manager
Upgrading
to SQL Server 2000
Preparing to Upgrade | Performing a Version Upgrade from SQL Server
7.0 | Performing an Online Database Upgrade from SQL Server 7.0
| Performing a Version Upgrade from SQL Server 6.5
Understanding
System and User Databases
Understanding the Database Architecture | Understanding the Transaction
Log Architecture | Understanding & Querying System & Database
Catalogs
Creating
& Configuring User Databases
Creating a User Database | Setting Database Options | Managing User
Database Size Using Automatic File Growth Appropriately | Placing
Database Files on Multiple Disks
Populating
a Database
Transferring & Transforming Data | Introducing Microsoft Data
Transformation Services (DTS) | Transferring & Transforming
Data with DTS Graphical Tools | Working with DTS Packages | Using
the Bulk Copy Program (Bcp) & the BULK INSERT Transact-SQL Statement
Developing
a Data Restoration
Understanding Data Restoration Issues | Understanding the Types
of Database | Understanding the Restoration Process
Backing Up
and Restoring SQL Server
Understanding Backup Terms, Media, & Devices | Backing Up Databases,
Files, Filegroups, & Transaction Logs | Restoring a User
Managing
Access to SQL Server 2000
Understanding the Authentication Process | Understanding the Authorization
Process | Creating & Managing Logins
Managing
SQL Server Permissions
Granting Database-Specific Permissions | Using Application Roles
| Designing an Access and Permissions Strategy
Performing Administrative Tasks
Performing Configuration Tasks | Setting Up Additional Features
| Performing Maintenance
Automating
Administrative Tasks
Defining Operators | Creating Jobs | Configuring Alerts | Creating
a Database Maintenance Plan | Creating Multiserver Jobs
Monitoring
SQL Server Performance & Activity
Developing a Performance Monitoring Methodology | Choosing Among
Monitoring Tools | Performing Monitoring Tasks
Using SQL
Server Replication
Introducing Replication | Planning for Replication | Implementing
Replication | Monitoring & Administering Replication
Maintaining
High Availability
Using Standby Servers | Using Failover Clustering
Exercises include
installing and configuring SQL Server 2000, managing application
security, managing database files, backing up databases, restoring
databases, creating jobs, operators & alerts, publishing SQL
Server data on the Web, importing and exporting data, monitoring
SQL, implementing, maintaining and troubleshooting replication.
|
SQL Server
Training Courses
