SQL Server 2000 Database Design

Course Description
Course Outline

Course Overview

This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment.

Prerequisites

Windows 2000 Installation and Administration, or equivalent knowledge. You should also know the basics of querying a SQL server by using the SELECT, INSERT, and UPDATE SQL statements.

We offer a range of SQL Server training courses

Overview of SQL Server
Exploring the Components of SQL Server SQL Server Database Structure Understanding the SQL Server Architecture Identifying SQL Server Management Tasks
Exploring Transact-SQL
Working with Transact-SQL Transact-SQL Statements Programming in Transact-SQL
Designing and Implementing Databases
Identifying Database Design Issues Creating Databases Managing Databases
Creating and Managing Tables
Design and Create Tables Maintaining Tables
Designing and Implementing Data Integrity
Understanding Data Integrity Implementing Constraints
Implementing Indexes
Designing Indexing Implementing Indexes Maintaining Indexes
Joining Tables
Querying Multiple Tables Implementing Advanced Table Joins
Designing Advanced Queries
Designing Subqueries Changing Data Through Queries
Designing Views
Creating and Managing Views
Creating Stored Procedures
Designing Stored Procedures Creating Stored Procedures Using Parameters in Stored Procedures Managing Stored Procedures
Using Functions
Working with Aggregate Functions Designing and Creating User-defined Functions
Creating Triggers

Understanding Transactions and Locks
Designing and Implementing Transactions Managing Locks
Implementing Distributed Queries
Creating and Managing Distributed Queries
Optimizing Queries
Exploring the Query Optimizer Using Indexes to Optimize Queries
Analyzing Queries
Analyzing the Performance of Queries

Publisher:	Microsoft
Version:	2000
Length:	4 days
Course-ID:	077462

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Excellent course, most topics were useful and the others were interesting and will be good to know about even if they don't affect my job personally

- IRI