Microsoft SQL Server 2000 Database Programming Training - FREE Tutorials

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD

Creating a Database
Creating a Database
Database Parameters
Data File Placement
Creating Tables
Data Types Explained
Data Types Used
NULLS
Altering Tables
Generating Values
Generating Scripts

Data Integrity
Types of Data Integrity
Enforcing Data Integrity
Primary Key
Foreign Key
Unique Constraints
Check Constraints
Default Constraints
Disabling Constraints
Cascading Referential Integrity

Using Transact SQL
Query Analyzer
Transact SQL Elements
Language Elements
Functions
Controlling Logic Flow
Commenting TSQL
Batches
Transactions
Scripts
XML (Brief XML tutorial)

Transact SQL Specifics
SELECT
Grouping Data with SELECT
Summarizing Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query)

Data Import/Export
Importing and Exporting Data
Data Import/Export Methods
Using DTS

Heterogenous Data
Distributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML

Stored Procedures
What 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 Functions
What is a UDF?
Creating a UDF
UDF Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers
What is a Trigger?
When to Use Triggers/Considerations
Creating a Trigger
Under the Hood
Nesting Triggers

Views
What is a View?
Creating and Using a View
Advantages of Views

Indexes
Index 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 Optimizer
Query Optimizer
Cost Limit
Viewing STATISTICS
Graphical Execution
General Query Guidelines

SQL Profiler
SQL Profiler
Using the SQL Profiler

Locking
Database Locking
Locking Levels
Lock Types
Session Locking Options
Deadlocks
Displaying Locking Info

CLICK HERE TO BUY THIS TUTORIAL ON CD