Microsoft SQL Server 2000 Admin
Author:Mark Long / Certified Instructor
Language:english
Category:Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft SQL Server 2000 Admin
Virtual Training CompanyÕs Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in the real world and to help you prepare for the Microsoft Certification Exam 70-228. Mark Long, a Microsoft certified instructor, will teach you installation and building and backing up databases. He begins with general information about databases and general administrative responsibilities. He will then instruct you on the specifics of the administration of SQL Server 2000, such as installation, data storage, and file groups. You will learn the two main administrative tools, enterprise manager and query analyzer, through real-life examples. In this tutorial, you will also learn how to automate the administration and how to monitor the SQL server. To start learning right away, click on one of the movie topics below.
Microsoft SQL Server 2000 AdminMicrosoft SQL Server 2000 Admin: About "Microsoft Publisher 2003" Training Publisher 2003 is a comprehensive solution for creating a wide variety of publications for desktop printing, commercial printing, e-mail distribution, or viewing on the Web. Create a comprehensive selection of business publications using new wizards, such as the Easy Web Site Builder and the E-Mail Newsletter wizard. Or, create print publications, including brochures, newsletters, postcards, CD or DVD labels, and other publications. Create personal publications using an expanded collection of templates, including personal stationery sets and professionally designed greeting cards and invitations. Automatically create a publication that merges pictures and text from a data source (like Microsoft Excel or Microsoft Access) using Catalog Merge to create publications ranging from a datasheet to a sophisticated catalog. Author Kate J. Chase guides you through this comprehensive tutorial, showing you all the possible benefits of this powerful Microsoft program.Listed below are all of the chapter and lesson contents for the Microsoft SQL Server 2000 Admin Try For Free Right Now To help you evaluate our training, we have made some of the tutorials for Microsoft SQL Server 2000 Admin freely available. Click on any of the linked lesson listings below to preview Free! Microsoft SQL Server 2000 Admin
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft SQL Server 2000 Admin

A Few Words About SQL Server

What Is SQL Server?
SQL Server Mystique
Transact SQL
SQL Server History

Overview

Overview of Course

General Database Information

Main Purpose of a Database
What Makes Up a Database
Two Main Types of Databases
Normalization
Denormalization
Database Relationships
Indexes
Proper Design

General Administrative Responsibilities

Real World Administration
Designing/Building Databases
Data Maintenance/Transfer
Backup/Restore of Data
Security

Hardware Requirements

Minimum Hardware Requirements
Hardware Compatibility
Optimizing Hardware for SQL Server

Installing SQL Server 2000

SQL Server 2000 Editions
Licensing
Multiple Instances
Choosing a Security Mode
Collation and Sort Selection
Network Libraries
Installation Methods
Upgrading to SQL Server 2000
Default Databases
Installation
Troubleshooting an Installation

SQL Server Security

Security Overview
Authentication Modes
Roles
Assigning Permissions
Application Roles

System Services

SQL Services
SQL Services Issues

System Databases

System Databases
Sample Databases

Data Storage

How SQL Stores Data
Fillfactor
File and Log Location/Management

Administrative Tools

Overview of Admin Tools
Exam Considerations

Enterprise Manager

Microsoft Management Console
Opening & Customizing the Enterprise Mgr
Using the Enterprise Manager

Query Analyzer

Opening and Exploring the QA
Issuing Queries Using the QA
Query Analyzer Features
Graphical Query Plan

Transact-SQL Select Statement

Using a Select Statement
Basic Syntax
Select Options
Important Select Considerations

Transact-SQL Insert Statement

Using an Insert Statement
Basic Syntax
Insert Options/Considerations

Transact-SQL Update Statement

Using the Update Statement
Basic Syntax/Options
Important Update Considerations

Transact-SQL Delete Statement

Using the Delete Statement
Basic Syntax/Important Considerations

Creating a Database

Using the Create Database Statement
Database Properties and Options
Database Creation Considerations
Managing File Growth
Shrinking Database Files
Sizing the Database
Importance of Good Design

Transaction Logs

How Transaction Logs Work
What Transactions Look Like
Location / Location / Location
Advantages of Using Transaction Logs
Transaction Log Options

Filegroups

What Are Filegroups?
Advantages of Filegroups
Disadvantages of Filegroups
Microsofts Recommendation on Filegroups

RAID & SQL

RAID Basics
SQL and RAID

SQL Profiler

What SQL Profiler Does
Opening SQL Profiler
Using SQL Profiler

Operators

What are Operators?
Creating an Operator
Considerations When Using Operators

Jobs

Automating SQL Server
Mail Enabling SQL Server 2000
Creating a New Job
Scheduling a Job
Job Notifications
Starting/Stopping a Job
Multi Server Jobs
Viewing Job History

Alerts

What are Alerts
Performance Alerts
User Defined Alerts
Disabling Alerts
Considerations When Using Alerts

Linked Servers

Using SQL In a Distributed Environment
Referring to SQL Server Objects
Setting Up a Linked Server Relationship

Database Backups

Backup Strategy
Database Recovery Models
SQL Server Backup
Who When and Where
System Databases
User Databases
Performing a Backup
Using Multiple Devices
SQL Backup Statement
Tape Backup
Backup Types
Transaction Log Backups
File and Filegroup Backups
Full Backup Strategy
Differential Backup Strategy
Backup Review

Restoring Data

SQL Server Recovery Process
Preparing to Restore a Database
The SQL Restore Statement
Restore Options
Restoring Transaction Logs
Restoring System Databases
Bottom Line on Restoring Data

Maintaining High Availability

Determining Requirements
Clustering
Standby Servers
Log Shipping

Data Transformation Services

Importing and Exporting Data
SQL Data Transport Tools
DTS Overview
Creating a DTS Package
More DTS Package Functionality
Defining Transformation Tasks Creating
Using DTS in Various Ways

Monitoring SQL Server 2000

Performance Issues
Monitoring and Tuning Basics
Improving Performance
Common Monitoring Tasks and Tools
What To Monitor
Locks

Replication Basics

Dealing With Distributed Data
SQL Server Replication
SQL Server Replication Types
SQL Server Replication Models
Replication Agents
Web Based Data Applications
SQL Server Replication Notes

Course Wrap-Up

Value of SQL Server knowledge
Microsofts MCDBA Certification

01 A Few Words About SQL Server
0101 What Is SQL Server?
0102 SQL Server Mystique
0103 Transact SQL
0104 SQL Server History

02 Overview
0201 Overview of Course

03 General Database Information
0301 Main Purpose of a Database
0302 What Makes Up a Database
0303 Two Main Types of Databases
0304 Normalization
0305 Denormalization
0306 Database Relationships
0307 Indexes
0308 Proper Design

04 General Administrative Responsibilities
0401 Real World Administration
0402 Designing/Building Databases
0403 Data Maintenance/Transfer
0404 Backup/Restore of Data
0405 Security


05 Hardware Requirements
0501 Minimum Hardware Requirements
0502 Hardware Compatibility
0503 Optimizing Hardware for SQL Server

06 Installing SQL Server 2000
0601 SQL Server 2000 Editions
0602 Licensing
0603 Multiple Instances
0604 Choosing a Security Mode
0605 Collation and Sort Selection
0606 Network Libraries
0607 Installation Methods
0608 Upgrading to SQL Server 2000
0609 Default Databases
0610 Installation
0611 Troubleshooting an Installation

07 SQL Server Security
0701 Security Overview
0702 Authentication Modes
0703 Roles
0704 Assigning Permissions
0705 Application Roles

08 System Services
0801 SQL Services
0802 SQL Services Issues

09 System Databases
0901 System Databases
0902 Sample Databases

10 Data Storage
1001 How SQL Stores Data
1002 Fillfactor
1003 File and Log Location/Management

11 Administrative Tools
1101 Overview of Admin Tools
1102 Exam Considerations

12 Enterprise Manager
1201 Microsoft Management Console
1202 Opening & Customizing the Enterprise Mgr
1203 Using the Enterprise Manager

13 Query Analyzer
1301 Opening and Exploring the QA
1302 Issuing Queries Using the QA
1303 Query Analyzer Features
1304 Graphical Query Plan

14 Transact-SQL Select Statement
1401 Using a Select Statement
1402 Basic Syntax
1403 Select Options
1404 Important Select Considerations

15 Transact-SQL Insert Statement
1501 Using an Insert Statement
1502 Basic Syntax
1503 Insert Options/Considerations

16 Transact-SQL Update Statement
1601 Using the Update Statement
1602 Basic Syntax/Options
1603 Important Update Considerations

17 Transact-SQL Delete Statement
1701 Using the Delete Statement
1702 Basic Syntax/Important Considerations

18 Creating a Database
1801 Using the Create Database Statement
1802 Database Properties and Options
1803 Database Creation Considerations
1804 Managing File Growth
1805 Shrinking Database Files
1806 Sizing the Database
1807 Importance of Good Design

19 Transaction Logs
1901 How Transaction Logs Work
1902 What Transactions Look Like
1903 Location / Location / Location
1904 Advantages of Using Transaction Logs
1905 Transaction Log Options

20 Filegroups
2001 What Are Filegroups?
2002 Advantages of Filegroups
2003 Disadvantages of Filegroups
2004 Microsofts Recommendation on Filegroups

21 RAID & SQL
2101 RAID Basics
2102 SQL and RAID

22 SQL Profiler
2201 What SQL Profiler Does
2202 Opening SQL Profiler
2203 Using SQL Profiler

23 Operators
2301 What are Operators?
2302 Creating an Operator
2303 Considerations When Using Operators

24 Jobs
2401 Automating SQL Server
2402 Mail Enabling SQL Server 2000
2403 Creating a New Job
2404 Scheduling a Job
2405 Job Notifications
2406 Starting/Stopping a Job
2407 Multi Server Jobs
2408 Viewing Job History

25 Alerts
2501 What are Alerts
2502 Performance Alerts
2503 User Defined Alerts
2504 Disabling Alerts
2505 Considerations When Using Alerts

26 Linked Servers
2601 Using SQL In a Distributed Environment
2602 Referring to SQL Server Objects
2603 Setting Up a Linked Server Relationship

27 Database Backups
2701 Backup Strategy
2702 Database Recovery Models
2703 SQL Server Backup
2704 Who When and Where
2705 System Databases
2706 User Databases
2707 Performing a Backup
2708 Using Multiple Devices
2709 SQL Backup Statement
2710 Tape Backup
2711 Backup Types
2712 Transaction Log Backups
2713 File and Filegroup Backups
2714 Full Backup Strategy
2715 Differential Backup Strategy
2716 Backup Review

28 Restoring Data
2801 SQL Server Recovery Process
2802 Preparing to Restore a Database
2803 The SQL Restore Statement
2804 Restore Options
2805 Restoring Transaction Logs
2806 Restoring System Databases
2807 Bottom Line on Restoring Data

29 Maintaining High Availability
2901 Determining Requirements
2902 Clustering
2903 Standby Servers
2904 Log Shipping

30 Data Transformation Services
3001 Importing and Exporting Data
3002 SQL Data Transport Tools
3003 DTS Overview
3004 Creating a DTS Package
3005 More DTS Package Functionality
3006 Defining Transformation Tasks Creating
3007 Using DTS in Various Ways

31 Monitoring SQL Server 2000
3101 Performance Issues
3102 Monitoring and Tuning Basics
3103 Improving Performance
3104 Common Monitoring Tasks and Tools
3105 What To Monitor
3106 Locks

32 Replication Basics
3201 Dealing With Distributed Data
3202 SQL Server Replication
3203 SQL Server Replication Types
3204 SQL Server Replication Models
3205 Replication Agents
3206 Web Based Data Applications
3207 SQL Server Replication Notes

33 Course Wrap-Up
3301 Value of SQL Server knowledge
3302 Microsofts MCDBA Certification

Sponsors