2073 - programming a microsoft sql server 2000 database - general

course description
this course provides students with the technical skills required to program a database solution by using microsoft sql server 2000.

at course completion

at the end of the course, students will be able to:

• describe the elements of sql server 2000;
• design a sql server enterprise application architecture;
• describe the conceptual basis of programming in transact-sql;
• create and manage databases and their related components;
• implement data integrity by using the identity column
• property, constraints, defaults, rules, and unique identifiers;
• plan for the use of indexes; create and maintain indexes;
• create, use, and maintain data views;
• implement user-defined functions;
• design, create, and use stored procedures;
• create and implement triggers;
• program across multiple servers by using distributed queries, distributed transactions, and partitioned views;
• optimize query performance;
• analyze queries;
• manage transactions and locks to ensure data concurrency and recoverability.

microsoft certified professional exams

this course will help the student prepare for the following microsoft certified professional exam:
exam 70-229, designing and implementing databaseswith microsoft sql server 2000 enterprise edition

prerequisites

before attending this course, students must have:
experience using the microsoft windows® 2000 operating system to:

• connect clients running windows 2000 to networks and the internet.
• configure the windows 2000 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 the ntfs file system.
• implement windows 2000 security.
• optimize performance in windows 2000.

for students who do not meet this prerequisite, the following courses provide students with the necessary knowledge and skills:
course 2151, microsoft windows 2000 network and operating system essentials
course 2152, implementing microsoft windows 2000 professional and server
an understanding of basic relational database concepts, including:
*logical and physical database design.
*data integrity concepts.
*relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many).
*how data is stored in tables (rows and columns).

for students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:
course 1609, designing data services and data models
*knowledge of basic transact-sql syntax (select, update, and insert statements).
*for students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:
course 2071, querying microsoft sql server 2000 with transact-sql
*familiarity with the role of the database administrator.