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 OverviewCourse IntroSQL Server TerminologySQL 2000 && Windows 2000SQL 2000 FeaturesSQL Applications (2/3/n Tier)Transact SQLCourse DescriptionCourse DescriptionLogical Data ModelingLogical Database DesignNaming ConventionsNormalizationLogical LayersAccessing DataCreating a DatabaseCreating a Database
Database Parameters
Data File Placement
Creating Tables
Data Types Explained
Data Types Used
NULLS
Altering Tables
Generating Values
Generating Scripts
Data IntegrityTypes of Data Integrity
Enforcing Data Integrity
Primary Key
Foreign Key
Unique Constraints
Check Constraints
Default Constraints
Disabling Constraints
Cascading Referential Integrity
Using Transact SQLQuery Analyzer
Transact SQL Elements
Language Elements
Functions
Controlling Logic Flow
Commenting TSQL
Batches
Transactions
Scripts
XML (Brief XML tutorial)
Transact SQL SpecificsSELECT
Grouping Data with SELECT
Summarizing Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query)
Data Import/ExportImporting and Exporting Data
Data Import/Export Methods
Using DTS
Heterogenous DataDistributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML
Stored ProceduresWhat 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 FunctionsWhat is a UDF?
Creating a UDF
UDF Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF
TriggersWhat is a Trigger?
When to Use Triggers/Considerations
Creating a Trigger
Under the Hood
Nesting Triggers
ViewsWhat is a View?
Creating and Using a View
Advantages of Views
IndexesIndex 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 OptimizerQuery Optimizer
Cost Limit
Viewing STATISTICS
Graphical Execution
General Query Guidelines
SQL ProfilerSQL Profiler
Using the SQL Profiler
LockingDatabase Locking
Locking Levels
Lock Types
Session Locking Options
Deadlocks
Displaying Locking Info
Click here to find out more about the Microsoft SQL Server 2000 Database Programming Training CD 
