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.

Macromedia Dreamweaver MX2004 Tutorials Adobe Photoshop video Tutorials

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

Microsoft SQL Server Tutorial CD / DVD

When you order this Microsoft SQL Server Video Tutorial CD You'll Receive...
Over 8 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
" I spent a lot of time trying to figure it on my own but I was going about everything the wrong way...your tutorial gave me a proper introduction to the software and it's much easier than I thought...thank you. "Leonard Howell, British Columbia

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 8 Hours in Duration and Covers 102 Lessons.
SQL Server Overview Course Description Logical Data Modeling
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Creating a Database
  • Creating a Database
  • Database Parameters
  • Data File Placement
  • Creating Tables
  • Data Types Explained
  • Data Types Used
  • NULLS
  • Altering Tables
  • Generating Values
  • Generating Scripts
Data Integrity
  • Types of Data Integrity
  • Enforcing Data Integrity
  • Primary Key
  • Foreign Key
  • Unique Constraints
  • Check Constraints
  • Default Constraints
  • Disabling Constraints
  • Cascading Referential Integrity
Using Transact SQL
  • Query Analyzer
  • Transact SQL Elements
  • Language Elements
  • Functions
  • Controlling Logic Flow
  • Commenting TSQL
  • Batches
  • Transactions
  • Scripts
  • XML (Brief XML tutorial)
Transact SQL Specifics
  • SELECT
  • Grouping Data with SELECT
  • Summarizing Data with SELECT
  • INSERT
  • UPDATE
  • DELETE
  • XML (XML in query)
Data Import/Export
  • Importing and Exporting Data
  • Data Import/Export Methods
  • Using DTS
Heterogenous Data
  • Distributed Queries
  • Linked Servers
  • OPENQUERY
  • OPENROWSET/OPENXML
Stored Procedures
  • What Is a Stored Procedure?
  • Creating and Executing Stored Procedures
  • Altering and Dropping Stored Procedures
  • Input Parameters
  • Returning Values with Output Parameters
  • Recompiling Stored Procedures
  • Error Handling
  • Permissions Required
  • Guidelines for Stored Procedures
User Defined Functions
  • What is a UDF?
  • Creating a UDF
  • UDF Guidelines
  • Scalar UDF
  • Multi-Statement UDF
  • InLine UDF
Triggers
  • What is a Trigger?
  • When to Use Triggers/Considerations
  • Creating a Trigger
  • Under the Hood
  • Nesting Triggers
Views
  • What is a View?
  • Creating and Using a View
  • Advantages of Views
Indexes
  • Index Basics
  • Indexes in SQL Server 2000
  • Guidelines for Indexing
  • Selectivity
  • Creating an Index
  • Index Options
  • Maintaining Indexes
  • Rebuilding Indexes
  • Statistics
  • Index Tuning Wizard
  • Graphical Query Plan
Query Optimizer
  • Query Optimizer
  • Cost Limit
  • Viewing STATISTICS
  • Graphical Execution
  • General Query Guidelines
SQL Profiler
  • SQL Profiler
  • Using the SQL Profiler
Locking
  • Database Locking
  • Locking Levels
  • Lock Types
  • Session Locking Options
  • Deadlocks
  • Displaying Locking Info

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 102 Lessons- Video run time: 8 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
292 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 Server | 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.