Create and deliver your own elearning using eduslide.net

Browse thousands of lessons. Create your own and share the knowledge.

Sign up for a free eduslide account !
Create your own courses.
Access thousands of lessons.

Microsoft SQL Server 2000 Database Programming

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.

Author: Vtc

SQL Server Overview

Course Intro

SQL Server Terminology

SQL 2000 & Windows 2000

SQL 2000 Features

SQL Applications (2/3/n Tier)

Transact SQL

Course Description

Course Description

Logical Data Modeling

Logical Database Design

Naming Conventions

Normalization

Logical Layers

Accessing Data

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

Course options

Search

Channels

 

Tags

Activity

 No Entry Found