Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft SQL Server tutorials are based around administrating the SQL server in a real life environment. This training CD is also an excellent resource for people wishing to take and pass the Microsoft 70 – 288 exam. Certified instructor Mark Long gives users an excellent insight into SQL admin, the training is presented using narrated QuickTime videos and easy to follow examples. Topics covered on this training course include: installation, file groups, data storage, using the query analyzer, enterprise manager admin tools, using the monitor and a lot more. Related titles Microsoft SQL Server

Associated Tutorials: Microsoft SQL Server | ASP.NET | Microsoft Visual Basic .NET | Microsoft Visual Studio .Net | Microsoft SQL Reporting Services | Microsoft Visual Basic 2008

Microsoft SQL Server Tutorial CD / DVD

When you order this Microsoft SQL Server Video Tutorial CD You'll Receive...
Over 10 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft SQL Server from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" Thank you for making training videos for normal people! Learning to use my computer has never been easier. "Kirsten Marlatt, Atlanta GA

Microsoft SQL Server Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 10 Hours in Duration and Covers 154 Lessons.
A Few Words About SQL Server Overview General Database Information
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$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

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

Later Title Available
A more recent video tutorial is available
Microsoft SQL Server 2008 Tutorial »

About this Microsoft SQL Server Training CD

Title Microsoft SQL Server
Tutor Mark Long
Other tutorials by Mark Long
Videos 154 Lessons- Video run time: 10 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2002
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
345 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

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.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft SQL Server from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Exchange Tutorials | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Microsoft SQL Server Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.