This course provides students with the technical
skills required to program a database solution
by using Microsoft SQL Server 2000.
Target Audience
This course is intended for SQL Server database
administrators, implementers, system engineers, and
developers who are responsible for writing queries.
Topics
SQL Server Overview, Overview of Programming SQL
Server, Creating and Managing Databases, Creating
Data Types and Tables, Implementing Data Integrity,
Planning Indexes, Creating and Maintaining Indexes,
Implementing Views, Implementing Stored Procedures,
Implementing User-defined Functions, Implementing
Triggers, Programming Across Multiple Servers,
Optimizing Query Performance, Analyzing Queries,
Managing Transactions and Locks.
Prerequisites
Experience using the Microsoft Windows operating
system to: Connect clients running Windows to
networks and the Internet, Configure the Windows
environment, Create and manage user accounts, Manage
access to resources by using groups, Configure and
manage disks and partitions, including disk striping
and mirroring, Manage data by using NTFS, Implement
Windows security, Optimize performance in Windows,
An understanding of basic relational database
concepts.
