SQL Server 2000 System Administration

Computer Training Solutions
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course teaches you how to install, configure, administer, and troubleshoot Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-228, Installing, Configuring, and Administrating Microsoft SQL Server 2000 Enterprise Edition.

Performance-Based Objectives

Understand the capabilities of Microsoft SQL Server 2000

Install Microsoft SQL Server

Design, create, and manage databases

Create and manage database objects

Design and configure security on SQL Server

Transfer data between SQL servers and configure XML support

Back up a SQL server’s databases

Restore database backups

Automate administrative tasks

Design, implement, and manage replication between SQL servers

Configure fault-tolerance through Failover Clustering and standby servers

Optimise the performance of SQL Server




Lesson 1: Introduction to Microsoft SQL Server

Topic 1A: Exploring the Components of SQL Server

Task 1A-1: Exploring the Features of Microsoft SQL Server

Task 1A-2: Discussing the Components of SQL Server

Task 1A-3: Identifying the Default Databases and System Tables

Task 1A-4: Understanding the SQL Server Architecture

Topic 1B: Administering SQL Server

Task 1B-1: Determining SQL Server Administration Tasks

Task 1B-2: Identifying Administrative Utilities


Lesson 2: Installing SQL Server

Topic 2A: Identifying the Requirements for Installing SQL Server

Task 2A-1: Choosing the Hardware and Software for SQL Server 2000

Task 2A-2: Selecting Your Server’s Hardware

Task 2A-3: Identifying Where to Install SQL Server

Task 2A-4: Choosing Installation Options for SQL Server

Topic 2B: Installing SQL Server

Task 2B-1: Creating and Configuring a Service Account for SQL Server

Task 2B-2: Performing Unattended Installations

Task 2B-3: Using the SQL Server Service Manager to Manage the SQL Services

Topic 2C: Exploring the SQL Server Installation

Task 2C-1: Starting SQL Server Enterprise Manager

Task 2C-2: Viewing the System Databases Within SQL Server Enterprise Manager

Task 2C-3: Creating and Working with a Database Diagram

Task 2C-4: Using SQL Server Enterprise Manager to Configure Your Server

Topic 2D: Troubleshooting the SQL Server Installation

Task 2D-1: Testing the SQL Server Installation

Task 2D-2: Viewing the SQL Server Log


Lesson 3: Designing and Implementing Databases

Topic 3A: Developing a Strategy for Implementing Databases

Task 3A-1: Discussing SQL Server Terminology

Task 3A-2: Identifying the Space Requirements for Databases

Task 3A-3: Viewing Space Statistics

Task 3A-4: Optimizing Database Performance

Topic 3B: Creating Databases

Task 3B-1: Using Transact-SQL to Create a New Database

Task 3B-2: Using SQL Server Enterprise Manager to Create a New Database

Task 3B-3: Changing the Default Filegroup

Task 3B-4: Using SQL Server Enterprise Manager to Configure a Database

Task 3B-5: Using Stored Procedures to View Database Information

Topic 3C: Managing Databases

Task 3C-1: Configuring SQL Server to Automatically Expand a Database

Task 3C-2: Manually Expanding a Database and its Transaction Log

Task 3C-3: Configuring SQL Server to Automatically Shrink a Database File

Task 3C-4: Deleting a Database


Lesson 4: Creating and Managing Tables

Topic 4A: Creating Tables

Task 4A-1: Designing Tables

Task 4A-2: Choosing Data Types for a Table

Task 4A-3: Identifying the Role of Constraints in a Table

Task 4A-4: Using SQL Server Enterprise Manager to Create a Table

Task 4A-5: Modifying the Structure of a Table

Topic 4B: Using Transact-SQL to Work with Tables

Task 4B-1: Using the INSERT Statement to Add Rows to a Table

Task 4B-2: Using the UPDATE Statement

Task 4B-3: Using the DELETE Statement

Task 4B-4: Formatting Columns in a Query


Lesson 5: Designing and Configuring SQL Server Security

Topic 5A: Identifying the Security Features of SQL Server

Task 5A-1: Identifying the SQL Server Security Components

Task 5A-2: Configuring Your Server¡¯s Authentication Mode

Task 5A-3: Configuring Encryption

Topic 5B: Creating Login Accounts

Task 5B-1: Creating a Login Account for a Windows Account

Task 5B-2: Denying Login Privileges

Task 5B-3: Creating and Testing a SQL Server Login Account

Task 5B-4: Assigning Login Accounts to Server Roles

Topic 5C: Assigning Login Accounts as Database Users

Task 5C-1: Assigning a Login Account as a Database User in SQL Server Enterprise Manager

Task 5C-2: Adding a Database User to a Database Role

Task 5C-3: Creating a User-defined Database Role

Topic 5D: Implementing Statement and Object Permissions

Task 5D-1: Comparing Permission Types

Task 5D-2: Granting Statement Permissions

Task 5D-3: Granting Object Permissions

Task 5D-4: Denying Statement Permissions

Task 5D-5: Denying Object Permissions

Task 5D-6: Revoking Statement and Object Permissions

Task 5D-7: Creating and Using an Application Role

Task 5D-8: Creating and Using a View

Topic 5E: Defining Linked Servers

Task 5E-1: Defining a Linked Server

Task 5E-2: Configuring Linked Server Security


Lesson 6: Importing and Exporting Data

Topic 6A: Introduction to Data Transfer

Task 6A-1: Comparing the Data Transfer Utilities

Task 6A-2: Creating a DTS Package by Using the DTS Import/Export Wizard

Task 6A-3: Using DTS Designer to Modify a Package

Topic 6B: Bulk Data Transfers

Task 6B-1: Using bcp to Generate a Transfer File

Task 6B-2: Using bcp to Import a Transfer File

Topic 6C: Configuring XML Support

Task 6C-1: Creating a Virtual Directory for SQL Server

Task 6C-2: Running a URL Query


Lesson 7: Backing Up SQL Server Databases

Topic 7A: Planning Backups

Task 7A-1: Planning to Back Up Your Server

Task 7A-2: Reviewing the Backup Process

Task 7A-3: Backing Up Databases

Topic 7B: Performing a Backup

Task 7B-1: Creating a Permanent Backup Device

Task 7B-2: Performing a Backup of the Master Database to a Permanent Backup Device

Task 7B-3: Performing a Parallel Backup of the Class_mgr Database

Task 7B-4: Performing a Filegroup Backup

Task 7B-5: Scheduling an Automatic Backup of the Msdb Database

Topic 7C: Designing Your Backup Strategy


Lesson 8: Restoring SQL Server Databases

Topic 8A: Restoring User-defined Databases

Task 8A-1: Observing an Automatic Recovery

Task 8A-2: Reviewing User-initiated Database Recovery

Task 8A-3: Creating Tables and Backing Up

Task 8A-4: Simulating a Failed Database

Task 8A-5: Restoring the Class_mgr Database

Topic 8B: Recovering System Databases

Task 8B-1: Simulating a Master Database Failure

Task 8B-2: Instructor Demo: Removing the Read-only Attribute From the SQL Server Installation Files

Task 8B-3: Restoring the Master Database


Lesson 9: Automating SQL Server Administration

Topic 9A: Configuring SQL S ...''

Phone:08456 44 1234

School Address:

Aurora House, 5-6 Carlos Place, Mayfair, London W1K 3AP, UK
Telephone: 08456 44 1234
Email: training@it-uk.com


Jobs & Resumes: London
Houses & Roommates: London

Publisher 2003
QuarkXpress 5 Introduction
QuarkXpress 5 Intermediate/Advanced
QuarkXpress 6 Introduction
QuarkXpress 6 Intermediate/Advanced
Sage Line 50 - Accounts Introduction
Sage Line 50 - Accounts Intermediate
Sage Line 50 - Payroll
SQL Server 2000 Database Design
SQL Server 2000 Transact-SQL
Visual Basic 6
Microsoft Visio 2000
Microsoft Visio 2002 (XP)
Microsoft Visio 2002 (XP) Intermediate/Advanced
Microsoft Word 2002 (XP)
Microsoft Word 2002 (XP) Intermediate
Microsoft Word 2002 (XP) Advanced
Microsoft Word 2003
Microsoft Word 2003 Intermediate

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.