Username: 
Password: 
Microsoft SQL Server 2000 Database Programming Tutorials

Online Contents For This Title

We have made some of the video tutorials for Microsoft SQL Server 2000 Database Programming freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   Title 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. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. 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. Then move on to 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.

SQL Server Overview
  Course Intro (03:14)
  SQL Server Terminology (04:00)
  SQL 2000 & Windows 2000 (04:49)
  SQL 2000 Features (06:02)
  SQL Applications (2/3/n Tier) (06:00)
  Transact SQL (06:00)
Course Description
  Course Description (05:48)
Logical Data Modeling
  Logical Database Design (05:44)
  Naming Conventions (04:14)
  Normalization (06:00)
  Logical Layers (04:02)
  Accessing Data (03:01)
Creating a Database
  Creating a Database (07:46)
  Database Parameters (04:06)
  Data File Placement (04:06)
  Creating Tables (05:53)
  Data Types Explained (04:54)
  Data Types Used (06:55)
  NULLS (04:52)
  Altering Tables (05:06)
  Generating Values (05:34)
  Generating Scripts (06:47)
Data Integrity
  Types of Data Integrity (04:32)
  Enforcing Data Integrity (05:26)
  Primary Key (05:05)
  Foreign Key (03:39)
  Unique Constraints (05:11)
  Check Constraints (05:17)
  Default Constraints (05:05)
  Disabling Constraints (04:30)
  Cascading Referential Integrity (07:26)
Using Transact SQL
  Query Analyzer (04:38)
  Transact SQL Elements (03:40)
  Language Elements (04:45)
  Functions (04:50)
  Controlling Logic Flow (05:07)
  Commenting TSQL (03:37)
  Batches (04:50)
  Transactions (04:13)
  Scripts (04:16)
  XML (Brief XML tutorial) (06:03)
Transact SQL Specifics
  SELECT (05:46)
  Grouping Data with SELECT (04:27)
  Summarizing Data with SELECT (05:24)
  INSERT (05:38)
  UPDATE (04:40)
  DELETE (03:47)
  XML (XML in query) (04:59)
Data Import/Export
  Importing and Exporting Data (02:55)
  Data Import/Export Methods (01:46)
  Using DTS (08:14)
Heterogenous Data
  Distributed Queries (04:20)
  Linked Servers (03:03)
  OPENQUERY (02:14)
  OPENROWSET/OPENXML (04:22)
Stored Procedures
  What Is a Stored Procedure? (03:34)
  Creating and Executing Stored Procedures (04:46)
  Altering and Dropping Stored Procedures (05:40)
  Input Parameters (06:14)
  Returning Values with Output Parameters (03:47)
  Recompiling Stored Procedures (03:46)
  Error Handling (04:00)
  Permissions Required (04:12)
  Guidelines for Stored Procedures (04:57)
User Defined Functions
  What is a UDF? (03:19)
  Creating a UDF (03:03)
  UDF Guidelines (02:24)
  Scalar UDF (05:59)
  Multi-Statement UDF (06:49)
  InLine UDF (05:37)
Triggers
  What is a Trigger? (02:41)
  When to Use Triggers/Considerations (03:53)
  Creating a Trigger (05:41)
  Under the Hood (03:16)
  Nesting Triggers (02:54)
Views
  What is a View? (02:28)
  Creating and Using a View (04:13)
  Advantages of Views (02:50)
Indexes
  Index Basics (04:33)
  Indexes in SQL Server 2000 (03:26)
  Guidelines for Indexing (05:03)
  Selectivity (03:13)
  Creating an Index (04:50)
  Index Options (04:24)
  Maintaining Indexes (03:06)
  Rebuilding Indexes (02:49)
  Statistics (02:39)
  Index Tuning Wizard (07:36)
  Graphical Query Plan (03:13)
Query Optimizer
  Query Optimizer (04:48)
  Cost Limit (03:06)
  Viewing STATISTICS (05:31)
  Graphical Execution (04:46)
  General Query Guidelines (03:52)
SQL Profiler
  SQL Profiler (03:03)
  Using the SQL Profiler (06:51)
Locking
  Database Locking (03:50)
  Locking Levels (03:48)
  Lock Types (03:10)
  Session Locking Options (02:48)
  Deadlocks (04:35)
  Displaying Locking Info (04:26)

This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.


Tutorial Information

Title: Microsoft SQL Server 2000 Database Programming
Author: Mark Long
SKU: 33373
ISBN: 1932072039
Release Date: 2002-08-20
Duration: 8 hrs / 102 lessons
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

Subscription / Purchase Information

This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.


Also Available in CD format

Single User: US$ 99.95      Purchase/Add to Cart

Select Bandwidth