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