|
|
|
|
|
|
|
SQL Server 2000 Administration (Exam 70-228) CBT Course |
|
|
|
[to previous page]
[other products in "No Longer Available"]
|
| |
|
| Product: |
SQL Server 2000 Administration (Exam 70-228) CBT Course
Learn how to install and configure a SQL 2000 Server, create SQL 2000 databases, manage, monitor and troubleshoot SQL 2000 databases, extract and transform data and manage and monitor SQL 2000 security. Prepare for MCSD exam 70-228.
|
Price:
excl. VAT |
|
|
|
| Level 1 1.0 An Overview of SQL Server - 1.1 Why use SQL Server?
- 1.2 Graphical Tools
- 1.3 Transact SQL
- 1.4 Database Objects
- 1.5 Security
- 1.6 Services
- 1.7 Capacities
- 1.8 Connectivity
- 1.9 Other Features
2.0 Installing SQL Server 2000 - 2.1 Operating Systems
- 2.2 Versions & Configurations
- 2.3 Multiple Instances
- 2.4 Licensing
- 2.5 File Locations
- 2.6 Sort Orders
- 2.7 Types of Installations
- 2.8 Installation Checklist
- 2.9 Performing an Installation
- 2.10 Upgrading
- 2.11 Troubleshooting an Upgrade
- 2.12 Unattended Installations
3.0 Database Setup & Maintenance - 3.1 Database Objects
- 3.2 System Stored Procedures & Functions
- 3.3 Database Layout
- 3.4 Database Files & File Groups
- 3.5 Transaction Log
- 3.6 Database Growth
- 3.7 Creating Databases using Enterprise Manager
- 3.8 Creating Databases using
T-SQL - 3.9 Sp-helpdb
- 3.10 Expanding a Database
- 3.11 Shrinking a Database
- 3.12 Database Options
- 3.13 Recovery Models
- 3.14 Database Space Planning
- 3.15 Multiple Disk Usage
Level 2 1.0 Security - 1.1 Introduction to Security
- 1.2 Authentication
- 1.3 Creating Logins
- 1.4 Server Roles
- 1.5 Assigning Server Roles
- 1.6 Database Roles
- 1.7 Managing Database Roles
- 1.8 Permissions
- 1.9 Managing Permissions
- 1.10 Views & Security
- 1.11 Stored Procedures & Security
- 1.12 Application Roles
2.0 Operators, Jobs, Alerts & Mail - 2.1 Definitions
- 2.2 SQL Server Agent Configuration
- 2.3 Operators
- 2.4 Jobs
- 2.5 Alerts
- 2.6 SQL Mail
- 2.7 Troubleshooting
Level 3 1.0 DBCC - 1.1 Maintenance Statements
- 1.2 Pin Statements
- 1.3 Trace Flags
- 1.4 Informational Statements
- 1.5 Check Statements
- 1.6 Old Statements
2.0 Backup & Restore - 2.1 Why do a Backup?
- 2.2 Considerations of the backup process
- 2.3 Managing the Backup Devices
- 2.4 System database backup
- 2.5 Multiple Backup Devices
- 2.6 Backup Planning
- 2.7 Media Choices
- 2.8 Backup Types
- 2.9 Backup Scenarios
- 2.10 Copying/Moving
- 2.11 Stand-by servers& Clustering
- 2.12 Performing a backup
- 2.13 Restore a Backup
3.0 Database Maintenance Plan Wizard - 3.1 What is the DMPW?
- 3.2 Running the Wizard
- 3.3 Jobs created by the wizard
4.0 Web Assistant - 4.1 What is the Web Assistant?
- 4.2 Running the Web Assistant
- 4.3 Using a Template file
- 4.4 Triggers generated by Web Assistant
5.0 SQL Server Configuration Options - 5.1 SQL Server Registration Properties
- 5.2 SQL Server Properties Dialog
Level 4 1.0 Transferring Objects & Scripting - 1.1 Methods of Data Transfer
- 1.2 DTS Designer
- 1.3 Copy Database Wizard
- 1.4 sp_attach_db & sp_detach_db
- 1.5 Scripting Objects
2.0 Error Logs - 2.1 Windows Event Logs
- 2.2 SQL Server Error Logs
- 2.3 Demo of Windows Logs
- 2.4 Demo of SQL Server Logs
3.0 Distributed Management Objects - 3.1 DMO Object Hierarchy
- 3.2 Logging into SQL Server
- 3.3 Loading a list of Databases
- 3.4 Loading Tables
- 3.5 Users & Table Scripts
- 3.6 Indexes & Columns
4.0 Tips & Tricks - 4.1 General Tips & Tricks
|
|
|
 |
|
|
|
|
| Quick Links |
|
|
|
| RCS Newsletter |
|
|
|
| Our Customers |
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language |
|
|
| Copyright 2002-2011 RCS Limited. All rights reserved. More
... |
