VTC - Microsoft SQL Server 2000 Database Programming

VTC - Microsoft SQL Server 2000 Database Programming


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

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.

********************CONTENTS********************

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)

http://rapidshare.com/files/118202852/warung-warez.blogspot.com.VTC_-_Microsoft_SQL_Server_2000_Database_Programming.rar