Programming a Microsoft SQL Server 2000 Database
Posted: 25 Juli 2002

2073: Five days; Instructor-led

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

Audience
tekst

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; and manage transactions and locks to ensure data concurrency and recoverability.

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:
• 2151, Microsoft Windows 2000 Network and Operating System Essentials
• 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:

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

Familiarity with the role of the database administrator.

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

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

Course Materials
The course materials are yours to keep. The student kit includes a comprehensive workbook and other necessary materials for this class.

The following software is provided for use in the classroom:

• Microsoft SQL Server 2000, Enterprise Edition

Naar boven
Naar cursus overzicht