Technology:

Windows 2000 / SQL 2000

Course:
Programming a Microsoft SQL Server 2000 Database

MS-2073 (Exam 70-229)

Type:

DBA/Development

Duration:

5 Days

Description:

Delivery Method:

Instructor led

 

Summary Description:

 

Audience:

This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server™ 2000.

 

 

Network administrators with some limited knowledge and/or experience using Windows 2000 Professional or Server. A good understanding of the concept of Directory Services is necessary.

Objectives:

 

Comments:

This course will help the student prepare for the following Microsoft Certified Professional exams:

                                Exam 70-229, Designing and Implementing Databases with                                       Microsoft SQL Server 2000 Enterprise Edition

 

ü        Experience using the Microsoft Windows® 2000 operating system

ü        An understanding of basic relational database concepts

ü        Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).

ü        Familiarity with the role of the database administrator.

Topics Covered:

By the end of this course, the student should 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 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;

ü        Analyze queries / Optimize query performance;

ü        Manage transactions and locks to ensure data concurrency and recoverability.

 

Prerequisites:

 Student should be able 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.

ü        Implement Windows 2000 security.

 

 

Additional Prerequisites:

For students who do not meet the previous prerequisite, the following courses provide students with the necessary knowledge and skills:

MS-2151, Microsoft Windows 2000 Network and O/S Essentials  MS-2152, Implementing Windows 2000 Professional and Server

ü        An understanding of basic relational database concepts, including:

o         Logical and physical database design.

o         Data integrity concepts.

o         Relationships between tables and columns (PK, FK, one-to-one, one-to-many, many-to-many).

o         How data is stored in tables (rows and columns).

ü        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:

MS-2071, Querying Microsoft SQL Server 2000 with Transact-SQL

ü        Familiarity with the role of the database administrator.