Microsoft SQL Server 2000 Programming Tutorial Video

Details

This Microsoft SQL Server tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Microsoft SQL Server Video Training

Contents

All the topics covered by this Microsoft SQL Server Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

SQL Server Overview
  Course Intro Demo
 SQL Server Terminology Demo
 SQL 2000 & Windows 2000 Demo
 SQL 2000 Features Demo
 SQL Applications (2/3/n Tier) Demo
 Transact SQL Demo

Course Description
  Course Description Demo

Logical Data Modeling
  Logical Database Design Demo
 Naming Conventions Demo
 Normalization Demo
 Logical Layers Demo
 Accessing Data Demo


If you purchase the CD all the contents listed below are also included.

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

Microsoft SQL Server Tutorial Video Information

Product Title: Microsoft SQL Server
Trainer: Mark Long
Other Training courses by this author
Movie Details: 102 Lessons- Video run time: 8 Hours
Price North America $99.95
Price for Europen Sales £79.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

109 In Stock

BUY THIS VIDEO

Benefits of this training method
  • Unique accelerated learning, master Microsoft SQL Server in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Associated Titles:

Microsoft Transact SQL Training | Microsoft SQL Server Tutorials | ASP.NET Training Video | Microsoft Visual Basic .NET Tutorials | Microsoft Visual Studio .Net Training Video| Data Modeling Tutorials

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.

Best Selling Titles - Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Microsoft SQL Server Training Courses