Implementing a SQL Server 2005 database

At the end of the course, students will be able to:

  • Describe the elements of SQL Server 2005
  • 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, create and maintain indexes
  • Create, use, and maintain data views
  • Implement user-defined functions
  • Design, create, and use stored procedures and triggers
  • Program across multiple servers by using distributed queries, distributed transactions, and partitioned views
  • Optimize query performance
  • Analyze queries and manage transactions and locks to ensure data concurrency and recoverability

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

Developers that will use SQL Server databases.

Background

Some familiarity with Windows NT workstation. A level of understanding as covered in course SQL and relational databases fundamentals is required i.e. the writing of basic SQL statements and having insight in relational systems. You can test yourself to see if you have enough background by filling in the online selftest on our website.

Main topics

  • SQL Server Overview
  • Overview of Programming SQL Server
  • Creating and Managing Databases
  • Creating Data Types and Tables
  • Implementing Data Integrity
  • Planning Indexes
  • Creating and Maintaining Indexes
  • Implementing Views
  • Implementing Stored Procedures
  • Implementing User-defined Functions
  • Implementing Triggers
  • Programming Across Multiple Servers
  • Optimizing Query Performance
  • Analyzing Queries
  • Managing Transactions and Locks

Training method

Lecturing with labs.

Duration

4 days.

Course leader

an ABIS partner.


SESSION INFO AND ENROLMENT