home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Implementing a SQL Server 2005 database

Intended for

Developers that will use SQL Server databases.

Background

Some familiarity with Windows NT workstation. A level of understanding as covered in courses RDBMS concepts and SQL 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 printing and filling in the self-tests (PDF file - 57 KB and PDF file - 56 KB).

Training method

Lecturing with labs.

Course leader

RealDolmen.

Duration

4 days.

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 contact ABIS.

Objectives

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

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