Title Language  : 

Find a Course... Try for Free!

 

Microsoft SQL Server 2000 Database Programming Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

«« Hide This
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)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft SQL Server 2000 Database Programming
Author: Mark Long
SKU: 33373
ISBN: 1932072039
Duration: 8 hrs / 102 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products