Microsoft SQL Server 2000 Admin Training Video - Tutorial CD

The visual nature of this Microsoft SQL Server 2000 Admin training DVD / CD video tutorial ensures that users of all levels can learn faster than with any other method of training, users will also benefit from a much higher retention rate then with conventional forms of training. All tutorials are created using expert authors and recorded with studio quality audio and video, users can expect to receive the same high standard of training that would be taught on a dedicated classroom based course, but for a fraction of the cost.

Users have total control over the speed at which they learn, lessons can be stopped, rewound or fast forwarded at any time, this video tutorial is structured to accommodate both beginner and intermediate users, ideal for people that need to fit comprehensive training into a busy schedule. To sample a free demo of this Microsoft SQL Server 2000 Admin training video click one of the links below. This tutorial is the ideal way to Learn Microsoft SQL Server 2000 Admin at your own pace.

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

This Microsoft SQL Server 2000 Admin Training video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that bring a high degree of visual clarity to even the most complex applications. Being over 10 hours long this Microsoft SQL Server 2000 Admin Training on CD / DVD is extremely comprehensive and easy to follow. Video Tutorial taught by Experts - Low Cost

- Easy to Learn
Evaluate the high quality of this Tutorial
try a free demo Below.

Benefits

  • Works on PC or Mac
  • Professional Tutition by Experts
  • Self-Paced Learning Interface
  • Builds Practical Skills Quickly
  • Rapid Learning - High Retention
  • Free Certificate with each Tutorial

Client Testimonials

  • Your excellent training courses have been a boon to my business. The fact that I can keep my work force on the job, supporting our customers, and still advance their capability has proven to be one of the best investments I have made since I started my business
    Marc Rothwell
    Columbus, OH

Just Released Training

Try for Free!

Topics covered on this Tutorial Video
are Listed Below:-

A Few Words About SQL Server Overview General Database Information

The purchased version of this Training contains all the movies listed below as well as all the featured Movies above. add to cart US$ 99.95

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

When you order this Microsoft SQL Server 2000 Admin Training CD you'll receive:-

An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft SQL Server 2000 Admin Training - VIDEO INFO

Microsoft SQL Server 2000 Admin

Mark Long / Certified Instructor

10 hours - 154 Movies

US$ 99.95

Win 7 ,Vista, XP, 2000, 98. Mac OS X

Ground / 2 day / Next Day

33369
414 In Stock
Purchase Orders from Schools, Colleges and Government accepted

Multi User Version Available

This training video is also available in Multi User format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.
$500

Benefits of this Training Video

  • Learn Microsoft SQL Server 2000 Admin in the shortest time possible
  • Self paced tutorial, training on video, learn at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you dont even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The tutorials can be rewound, fast forwarded or stopped at any time
  • Learn Microsoft SQL Server 2000 Admin from the comfort of your own desk.

Prove your Skills. Free Certification

  • With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.

Related Tutorial Videos

Microsoft SQL Server 2000 Admin Related Videos


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: