Software Training Back to Course Listings
Back to Course Categories

Course Name Programming a Microsoft SQL Server 2000 Database
Course No. 2073
Course Description

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

Who Should Attend This course is intended for those who are responsible for implementing Microsoft SQL Server 2000 and writing Transact-SQL code.
Prerequisites
  • 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
Length 40 hours
Class Size Up to 12
CEU's Awarded 3.5

This course helps you prepare for the Microsoft Certified Professional exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Format Hands-on Workshop. One lab station for every participant.

Learning Objectives Participants will learn 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

Course Customization Call 1-800-777-0753 for a detailed outline or for information about tailoring this course to your specific needs.
For scheduling please call your
Customer Representative at 1-800-777-0753.

 

Home | Information Request | Resource Library | Store | Courses 
College Transfer Credit and CEU's | Client Relationship | Training Methodology

Copyright Learn Maintenance, Inc.