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

• 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

• 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

 

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

Copyright © 2007 Learn Maintenance, Inc.