2073 - Programming a Microsoft SQL Server 2000 Database
Before attending this course, students must have:
Experience using the Microsoft Windows Server 2003 operating system to:
.Connect clients running Microsoft Windows-based operating systems 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 NT file system (NTFS)
.Implement Windows server and client security
.Optimize performance in Windows operating systems
For students who do not meet these prerequisites, the following courses provide the necessary knowledge and skills:
.Course 2274: Managing a Microsoft Windows Server 2003 Environment.
.Course 2275: Maintaining a Microsoft Windows Server 2003 Environment.
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).
Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements)
For students who do not meet these prerequisites, the following course provides the necessary knowledge and skills:
.Course 2071A, Querying Microsoft SQL Server 2000 with Transact-SQL
Familiarity with the role of the database administrator