SQL Server 2000 extends the performance, reliability, and ease-of-use of previous versions and provides a database platform that scales up and out to meet the needs of large online transaction processing (OLTP), data warehousing, and e-Commerce applications. It will also scale down to meet the needs of individual desktops and portable devices. This hands-on course will teach you to install and administer SQL 2000, create and manage database files, and understand how to program a basic query. This course is excellent preparation for Microsoft Exam 70-228.

To register, call  1-800-968-8648 or visit http://www.e-bps.com This course can be delivered by the methods below: Classroom Learning $2595 USD

You Learn...

	Plan and Install SQL Server 2000
	Create Databases
	Manage Database Files and Security
	Backup and Restore Databases
	Import and Export Data
	Deploy Transactional Replication
	Write Basic Transact SQL Queries
	Support XML Queries
	Prepare for Microsoft Exam 70-228

Who Would Benefit

Database Administrators working in the Windows 2000 environment.

 

Course Outline

1. SQL Server 2000 Overview

	Client/Server Database Architecture
	Relational Database Objects
	SQL Server Versions
	Graphical Administration Tools
	Enterprise Manager
	Query Analyzer

2. Installing SQL Server 2000

	Processor, Disk, and Memory Requirements
	Operating System Considerations
	Service Accounts
	Enterprise Manager Configuration
	Troubleshooting the Installation Process

3. Introduction to Transact SQL Queries

	SELECT Statement
	INSERT Statement
	UPDATE Statement
	DELETE Statement
	How Queries are Executed ACID Properties Implicit Transaction Explicit Transaction Batches
	Executing Queries Using Query Analyzer Using osql

4. Creating and Managing Database Files

	How Data is Stored
	Database Files
	Transaction Log Files
	Creating Databases
	Managing File Placement on Disk I/O Subsystems
	Filegroups

5. Understanding SQL Server Security

	Authentication Windows 2000 SQL Server
	Server Logins
	Database Users
	Fixed Server Roles
	Database Roles Fixed User Defined
	Statement and Object Permissions
	Application Security

6. Scheduling Administration Tasks

	SQL Server Agent
	MSDB Database
	SQL Agent Mail and SQL Mail
	Automating Administrative Tasks
	Alerts, Jobs, and Operators
	Creating Alerts
	Linked Servers
	Multi-Server Jobs

7. Database Backup

	When to do Backups
	How to do Backups
	Types of Backups Full Differential Transaction Log
	Implementation Techniques

8. Database Recovery

	Automatic Recovery
	The RESTORE Statement
	Restoring From Different Types of Backups
	Restoring User Databases
	Restoring System Databases

9. SQL Server Monitoring Tools

	SQL Server Error Logs
	Windows 2000 Event Viewer
	Windows 2000 System Monitor
	SQL Enterprise Manager
	Transact SQL tools
	SQL Profiler
	SQL Query Analyzer

10. Data Import/Export Tools

	Bulk Copy Program
	Data Transformation Services (DTS) DTS Process DTS Import/Export Wizard DTS Designer dtsrun Utility Transforming and Mapping Data Creating, Executing, and Scheduling a DTS Package
	Transact SQL

11. Database Replication

	Publisher/Subscriber Metaphor
	Replication Types
	Physical Models
	Implementing Transactional Replication

12. High Availability Techniques

	Windows 2000 Clustering
	SQL Server Failover Clustering
	Standby Server Manual via Backup/Restore Process Automatic via Log Shipping

Course Labs

Hands-On Lab 1: Install and use graphical administration tools.

Hands-On Lab 2: Install, verify, and configure an instance of SQL Server 2000.

Hands-On Lab 3: Write and execute basic Transact SQL queries.

Hands-On Lab 4: Create, modify, and delete databases.

Hands-On Lab 5: Create server logins and database users. Assign logins to roles. Implement permissions.

Hands-On Lab 6: Configure messaging. Create jobs, operators, and alerts.

Hands-On Lab 7: Backup databases and transaction logs.

Hands-On Lab 8: Restore databases.

Hands-On Lab 9: Monitor SQL Server using Server Monitor, Enterprise Manager, SQL Profiler, and Query Analyzer.

Hands-On Lab 10: Create and execute a bulk copy job. Create and execute a DTS package.

Hands-On Lab 11: Implement transactional replication.

Hands-On Lab 12: Set up a standby server. Maintain a standby server using log shipping.

 

Suggested Prerequisites

Students should have experience using the Windows 2000 operating system covering topics found in our Windows 2000 Server course and an understanding of relational database concepts.

Microsoft Windows 2000 Server

 

Suggested Follow-ons

There are no follow-ons for this course

 

Certifications

Windows 2000 MCSE Track