clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif
   Master Microsoft SQL Server 2000 Database Programming - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
Virtual Training Company's Microsoft SQL Server 2000 Database Programming tutorial is the perfect tool for learning how to use SQL Server 2000 in the real world and to help you prepare for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features you will find, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft exam, and he takes you step by step over the material you must know, including creating a database and tables. You will learn about data integrity, including primary and foreign keys and constraints, using Transact SQL to retrieve and modify data, how to import and export data, and how to link servers together. Once you have that down, move onto programming business logic and topics such as creating, executing, and altering stored procedures. Mark Long finishes the course by teaching you how to optimize access to your data with indexes, query optimizer, and SQL profiler. To start learning right away, click on one of the movie topics below.
Microsoft SQL Server 2000 Database Programming Training
Access the complete Microsoft SQL Server 2000 Database Programming Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft SQL Server 2000 Database Programming plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft SQL Server 2000 Database Programming from our PC and Mac compatible CDRom. The affordable price of $99.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft SQL Server 2000 Database Programming
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft SQL Server 2000 Database Programming
Description: Click here to open / close full description
Virtual Training Company's Microsoft SQL Server 2000 Database Programming tutorial is the perfect tool for learning how to use SQL Server 2000 in the real world and to help you prepare for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features you will find, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft exam, and he takes you step by step over the material you must know, including creating a database and tables. You will learn about data integrity, including primary and foreign keys and constraints, using Transact SQL to retrieve and modify data, how to import and export data, and how to link servers together. Once you have that down, move onto programming business logic and topics such as creating, executing, and altering stored procedures. Mark Long finishes the course by teaching you how to optimize access to your data with indexes, query optimizer, and SQL profiler. To start learning right away, click on one of the movie topics below.

-Close-
Instructor: Mark Long/Certified Instructor (more by this author)
Instruction: 102 Tutorials - Duration: 8 hrs
First Release: 2002-08-20
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $99.95
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft SQL Server 2000 Database Programming
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft SQL Server 2000 Database Programming
 
Below is content list for all of the lessons included with the Microsoft SQL Server 2000 Database Programming Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

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

Course Description
movie image Course Description

Logical Data Modeling
movie image Logical Database Design
movie image Naming Conventions
movie image Normalization
movie image Logical Layers
movie image Accessing Data


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
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
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

Global Sales
1623 Military Road #703
Niagara Falls, NY, USA
14304-1745
1-877-882-2262 or sales@vtcGlobalSales.com
VTC Canada
200 N. Service Rd W., Suite 1-377
Oakville, ON, Canada
L6M 2Y1
905-465-1263 or sales@vtcCanada.com


©2008 VTC Global Sales / VTC Canada All Rights Reserved.