Sybase SQL Server and Open Client Development

Course Length: 5 Days

Key Objectives

Course Overview

This course covers SQL through Open Client (TM) db-Library topics beginning with a review of Client/Server Computing and database design concepts. Database objects and Transact SQL (TM) are covered extensively in a series of lectures and laboratory sessions. Fifty percent of the course is hands- on time from programming stored procedures and triggers to an exhaustive coverage of Open Client (TM), making this a complete training for those new to SQL Server (TM) development. Step-by-step cookbook approaches led by the instructor, informal exercises, and full laboratory sessions make this a complete and lasting learning experience.

Audience

This course is designed for database and applications programmers, project leaders, and managers who want a deep understanding of how to develop with Sybase (TM) in production environments or develop an Applications Programming Interface around the database.

Prerequisite

Course Content

Part 1: Sybase SQL Server

Client/Server Computing

Database Design

Databases and Objects

Accessing Data With Transact-SQL

Modifying Data With Transact-SQL

Programming With Transact-SQL

Backup and Recovery

Users and Permissions

Part 2: Open Client / dbLib Programming

Cookbook Approach

Error and Message Handler

Result Processing

Remote Procedure Calls

Row Buffering

Miscellaneous

Bulk Copy

Two-Phase Commit


| Bluestone Home | Sales | Technical Support | Request Info |
This site is maintained by webmaster@bluestone.com