UW Computer Training

M2734: Updating Your Database Development Skills to Microsoft SQL Server™ 2005

Description:
This three-day instructor-led course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.

Prerequisite:
Before attending this course, students must have:

• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
• Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
  • Knowledge of SQL Server 2000/7.0:
  • Database and server architecture.
  • Database Security
  • Transact SQL
  • Query Engine
  • DDL
  • DML
  • Optimization
  • Schema and Objects
  • Programming Objects
  • UDF
  • Triggers
  • Stored Procedures
  • Optimization
  • SQL XML
  • .NET Development (Visual Basic .NET or C# .NET)
  • ADO.NET
• In addition, it is recommended, but not required, that students have completed:
  • Course 2073, Programming a Microsoft SQL Server 2000 Database.

Course Fee:
$1152