KT-2073 Programming a Microsoft SQL Server 2000 Database Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Programming a Microsoft SQL Server 2000 Database


Description: 

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

Audience

This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.

After completing this course, students will be able to:

  • Describe the elements of SQL Server 2000.
  • 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.
  • Design, create, and use stored procedures.
  • Implement user-defined functions.
  • 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.

 
Click here to view the Course Outline
     
Prerequisite: 

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

 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.