PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Adobe Fireworks CS4 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials Please do not hesitate to contact us for download help.

Microsoft SQL Server 2000 Database Programming Tutorial

 Professionally created, self-study video training.

About this Tutorialshow details
Presented using step by step video training movies, expert author Mark Long describes all the basic to advanced techniques, principles and concepts in an easy to follow manner and shows you how to use MS SQL Server 2000 in the real world. This tutorial is focused to help you pass the Microsoft Certification Exam 70-229 - an exam needed to achieve the MCDBA certification. You can sample this visual training method right now, click any of the blue linked lessons below for FREE SQL Database video tutorials...
Try this training now - See below for FREE tutorials
LATER VERSION AVAILABLE
We also have the
Microsoft SQL Server 2005 Tutorial


Each Course on 1 or 2 CDs
For Mac and PC


FREE Shipping on all Orders


Microsoft SQL Server 2000 Database Programming Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Mark Long / Certified Instructor
Duration: 8 hrs / 102 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33373
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world
IN STOCK
- All CDs Shipped Carriage FREE -
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and techniques
  Simplistic terms and minimal jargon.
  Step by step video training from your own desktop via CD ROM or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Microsoft SQL Sever 2000 Admin | Microsoft Access 2003 | Complete Range of Microsoft Video Tutorials | MySQL | Microsoft .NET Framework 2.0 | Microsoft SQL Server 2008 | Complete Range of Microsoft SQL Server Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Tutorial Overview

Welcome
Terminology You Should be Aware of
SQL 2000 and Windows 2000
SQL 2000 Features Explained
SQL Applications (2/3/n Tier)
Transact SQL - Overview

Course Description
Chapter Overview

Logical Data Modeling
Chapter Overview
Naming Conventions
Normalization - Overview
Logical Layers Explained
Accessing Data in SQL

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Creating a Database
Chapter Overview
Database Parameters Explained
Data File Placement
The Creation of Tables
Data Types - Overview
Data Types Used
NULLS - an Explanation
How to Alter Tables
Generating Values and Scripts - Lesson 1
Generating Values and Scripts - Lesson 2

Data Integrity
Data Integrity - The Types
How to Enforce Data Integrity
Primary Key Explanation
Foreign Key Explanation
Unique Constraints - Overview
Check Constraints - Overview
Default Constraints
Disabling Constraints
Cascading Referential Integrity Explained

Working with Transact SQL
Query Analyzer (QA)
Transact SQL Elements Explored
Language Elements Explained
Functions in SQL
How to Control Logic Flow
Comment TSQL
Batches
Transactions Overview
Scripts
XML - Overview

Transact SQL Specifics
SELECT
How to Group Data with SELECT
How to Summarise Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query)

Data Import/Export
Chapter Overview
Data Import and Export Methods
Utilising DTS

Heterogenous Data
Chapter Overview and Distributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML

Stored Procedures
Chapter Overview and Explanation
How to Create and Execute Stored Procedures
How to Alter and Drop Stored Procedures
Inputting Parameters
Return Values using Output Parameters
Recompiling Stored Procedures
Error Handling Explained
The Permissions Required
Stored Procedures - The Guidelines

User Defined Functions
Chapter Overview and Explanation
The Creation of a UDF
UDF - The Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers
Chapter Overview and Explanation
Correctly Using Triggers and Considerations
How to Create a Trigger
Under the Hood
Nesting Triggers Explained

Views
Chapter Overview and Explanation
How to Create and Use a View
Views - The Advantages

Indexes
Chapter Overview and the Fundamentals
Indexes Overview
Indexing - some Guidelines
Selectivity
The Creation of an Index
Index Options
Maintaining and Rebuilding Indexes - Lesson 1
Maintaining and Rebuilding Indexes - Lesson 2
Statistics
Index Tuning Wizard
Graphical Query Plan Explained

Query Optimizer
Chapter Overview and Explanation
Cost Limit
View STATISTICS
Graphical Execution
Query Guidelines Explained

SQL Profiler
Chapter Overview and Explanation
Working with the SQL Profiler

Locking
Chapter Overview and Explanation
How to Lock Levels
Lock Types Explained
Session Locking Options
Deadlocks
How to Display Locking Info


CLICK HERE TO BUY THIS CD