Microsoft SQL Server 2000 Database Programming Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft SQL Server 2000 Database Programming are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft SQL Server 2000 Database Programming freely available. Click on any of the linked lesson listings below to preview FREE!
To help you evaluate our training, we have made some of the tutorials for Microsoft SQL Server 2000 Database Programming freely available. Click on any of the linked lesson listings below to preview FREE!
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.
Choose your media type:
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.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
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) |
Title Information / Pricing
Title: | Microsoft SQL Server 2000 Database Programming |
Author: | Mark Long |
SKU: | 33373 |
ISBN: | 1932072039 |
Release Date: | 2002-08-20 |
Price: | |
Duration: | 8 hrs / 102 lessons |
Work Files: |
No |
Captions: | No |
Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
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)
Select Bandwidth
Now Shipping
Client Testimonials
The tutorials about toon boom studio were extraordinary. I've learned the program in only 4-5 days. Also a lot of workflow tips and resources...
Stelios Chatzopoulos