SQL Server 2000 Admin tutorials : learn quickly with this 'SQL Server 2000 Admin' training course.

CBT Training IT Training Course Specialists
 
 Microsoft SQL Server 2000 Admin CD Training Course (Prices exclude VAT)
[to previous page]   [other products in "Databases"]
Microsoft SQL Server 2000 Admin CD Training Course or a generic image.   larger image of Microsoft SQL Server 2000 Admin CD Training Course (if available)
   Product: Microsoft SQL Server 2000 Admin CD Training Course
10 hrs / 154 lessons. For Win Vista, XP, 2000, Mac OS X, OS 9, Linux
Price:
  UK Delivery    £84.95 
  FEDEX delivery outside UK    £129.95 
 
Details: A Few Words About SQL Server
What Is SQL Server? (04:13)
SQL Server Mystique (04:02)
Transact SQL (05:07)
SQL Server History (01:55)

Overview
Overview of Course (05:45)

General Database Information
Main Purpose of a Database (03:26)
What Makes Up a Database (05:34)
Two Main Types of Databases (06:12)
Normalization (03:53)
Denormalization (02:42)
Database Relationships (05:09)
Indexes (05:40)
Proper Design (03:25)

General Administrative Responsibilities
Real World Administration (06:27)
Designing/Building Databases (06:00)
Data Maintenance/Transfer (03:02)
Backup/Restore of Data (03:26)
Security (05:55)

Hardware Requirements
Minimum Hardware Requirements (01:39)
Hardware Compatibility (02:52)
Optimizing Hardware for SQL Server (03:24)

Installing SQL Server 2000
SQL Server 2000 Editions (03:17)
Licensing (03:21)
Multiple Instances (03:26)
Choosing a Security Mode (03:52)
Collation and Sort Selection (04:56)
Network Libraries (03:34)
Installation Methods (03:05)
Upgrading to SQL Server 2000 (03:34)
Default Databases (04:40)
Installation (05:33)
Troubleshooting an Installation (03:43)

SQL Server Security
Security Overview (03:02)
Authentication Modes (04:10)
Roles (04:27)
Assigning Permissions (04:44)
Application Roles (04:16)

System Services
SQL Services (02:48)
SQL Services Issues (04:48)

System Databases
System Databases (03:38)
Sample Databases (02:17)

Data Storage
How SQL Stores Data (05:16)
Fillfactor (02:50)
File and Log Location/Management (03:01)

Administrative Tools
Overview of Admin Tools (04:01)
Exam Considerations (03:36)

Enterprise Manager
Microsoft Management Console (03:08)
Opening & Customizing the Enterprise Mgr (04:46)
Using the Enterprise Manager (04:17)

Query Analyzer
Opening and Exploring the QA (04:42)
Issuing Queries Using the QA (03:22)
Query Analyzer Features (03:59)
Graphical Query Plan (04:35)

Transact-SQL Select Statement
Using a Select Statement (02:04)
Basic Syntax (02:15)
Select Options (03:53)
Important Select Considerations (02:22)

Transact-SQL Insert Statement
Using an Insert Statement (02:34)
Basic Syntax (02:16)
Insert Options/Considerations (03:13)

Transact-SQL Update Statement
Using the Update Statement (02:47)
Basic Syntax/Options (03:47)
Important Update Considerations (02:30)

Transact-SQL Delete Statement
Using the Delete Statement (04:21)
Basic Syntax/Important Considerations (02:53)

Creating a Database
Using the Create Database Statement (07:04)
Database Properties and Options (02:55)
Database Creation Considerations (03:34)
Managing File Growth (03:45)
Shrinking Database Files (04:31)
Sizing the Database (05:01)
Importance of Good Design (03:17)

Transaction Logs
How Transaction Logs Work (03:32)
What Transactions Look Like (03:26)
Location / Location / Location (02:59)
Advantages of Using Transaction Logs (02:43)
Transaction Log Options (04:47)

Filegroups
What Are Filegroups? (02:31)
Advantages of Filegroups (02:23)
Disadvantages of Filegroups (02:29)
Microsofts Recommendation on Filegroups (02:24)

RAID & SQL
RAID Basics (06:41)
SQL and RAID (03:54)

SQL Profiler
What SQL Profiler Does (02:18)
Opening SQL Profiler (04:56)
Using SQL Profiler (03:29)

Operators
What are Operators? (02:51)
Creating an Operator (04:01)
Considerations When Using Operators (02:18)

Jobs
Automating SQL Server (03:11)
Mail Enabling SQL Server 2000 (04:33)
Creating a New Job (03:38)
Scheduling a Job (04:33)
Job Notifications (02:52)
Starting/Stopping a Job (03:36)
Multi Server Jobs (04:06)
Viewing Job History (04:13)

Alerts
What are Alerts (02:53)
Performance Alerts (03:23)
User Defined Alerts (05:20)
Disabling Alerts (02:57)
Considerations When Using Alerts (02:25)

Linked Servers
Using SQL In a Distributed Environment (02:32)
Referring to SQL Server Objects (02:02)
Setting Up a Linked Server Relationship (02:13)

Database Backups
Backup Strategy (02:17)
Database Recovery Models (03:57)
SQL Server Backup (02:36)
Who When and Where (02:16)
System Databases (02:34)
User Databases (05:19)
Performing a Backup (04:34)
Using Multiple Devices (01:50)
SQL Backup Statement (03:42)
Tape Backup (03:47)
Backup Types (02:15)
Transaction Log Backups (02:38)
File and Filegroup Backups (02:54)
Full Backup Strategy (02:56)
Differential Backup Strategy (01:39)
Backup Review (01:30)

Restoring Data
SQL Server Recovery Process (02:07)
Preparing to Restore a Database (03:14)
The SQL Restore Statement (05:50)
Restore Options (02:24)
Restoring Transaction Logs (03:10)
Restoring System Databases (03:10)
Bottom Line on Restoring Data (03:19)

Maintaining High Availability
Determining Requirements (03:55)
Clustering (03:00)
Standby Servers (03:32)
Log Shipping (02:38)

Data Transformation Services
Importing and Exporting Data (02:10)
SQL Data Transport Tools (02:55)
DTS Overview (04:12)
Creating a DTS Package (05:44)
More DTS Package Functionality (03:20)
Defining Transformation Tasks Creating (05:01)
Using DTS in Various Ways (02:22)

Monitoring SQL Server 2000
Performance Issues (02:45)
Monitoring and Tuning Basics (06:24)
Improving Performance (01:50)
Common Monitoring Tasks and Tools (03:42)
What To Monitor (02:49)
Locks (05:10)

Replication Basics
Dealing With Distributed Data (02:10)
SQL Server Replication (03:19)
SQL Server Replication Types (03:32)
SQL Server Replication Models (02:12)
Replication Agents (02:53)
Web Based Data Applications (02:26)
SQL Server Replication Notes (03:03)

Course Wrap-Up
Value of SQL Server knowledge (03:10)
Microsofts MCDBA Certification (05:21)

Similar    
Products:
SQL Server 2005 Update Training for Database Administrators (on DVD)
SQL Server 2005 Update Training for Database Developers
Microsoft SQL Server 2005 Administration Tutorial CBT Course
MCP Exam #70-431 - Implementing & Maintaining a Microsoft SQL Server 2005 Database
MCP Exam #70-441 - Designing Microsoft SQL Server 2005 Databases & Server-Side Solutions

2Gb USB 2.0 Flash Drive on Special Offer.

What's Hot
 ***Special offers ***
 Sage Line 50
 Office 2007 (MCAS)
 C# Developer
 MCDST
 MCP 70-620 (Vista)
 PMP (Proj Mgmt)
 Oracle 10g
 MCSE 2003
 Project 2003
 Crystal Reports 11
 **Recent Additions**
RCS Newsletter
*Verify: 2205351

New Articles

Child Care Courses
MCSE Training Courses
Dedicated Servers
Accounting Software
Choosing Software
Backup Software


Settings, Tip & Tricks
ComputerArticles
Biodiesel Energy
Computer Training
PPE Safety Equipment
Learn English (Basic)

From the Best Seller List : CompTIA Network+ 2005 CBT : CompTIA Network+ 2005 Certification means the individual possesses the knowledge needed to configure and install Network components.

CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2010 RCS Limited. All rights reserved. More ...
RCS Limited for home study/ self study/home learning/CBT/Computer Based Training SSL