Description
This fast-track, hands-on course teaches students how to use Sybase Transact SQL Server for application development. This course is useful for programmers using 4GL tools, such as PowerBuilder or Visual Basic as well as those using high-level languages, such as C or C++.

Audience
Programmers and database administrators developing or managing applications in a Sybase environment.

Prerequisites
Attendance at Arkoa’s Introduction to SQL and Transact SQL or a similar course, or practical experience with major features of ANSI SQL89 or SQL92 is required.

Hardware and Software
Sybase Adaptive Server installed on Unix or Windows NT. The Sybsyntax database should be installed for on-line help with SQL. It should be possible to load a 3.5” DOS-formatted solution diskette for use in the course.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Use key features of Sybase Adaptive Server’s Transact SQL
• Create, maintain, and manipulate database tables
• Optimize application performance through the use of procedural extensions to SQL, stored procedures, and triggers
• Enhance Adaptive Server performance

Fundamental Concepts and Terminology

SQL Server Fundamentals

• Sybase approach to client/server
• Sybase tables and stored procedures

Interactive SQL

• Using Sybase ISQL

Transact SQL Fundamentals

• Defining, retrieving, and modifying data

Defining Data

• Data types and user data types
• Creating tables and indexes
• Constraints and rules
• Views
• Defaults
• Security features

Manipulating Data

• Predicates
• Subqueries
• Analyzing data by grouping rows
• Temporary tables
• String, date, mathematical, system, and string functions

Transactions and Locking

• Database recovery
• Deadlock and optimistic locking

Procedural Extensions

• Writing procedural code with SQL
• Using cursors

Stored Procedures

• Creating and managing stored procedures
• Security, integrity, and performance

Triggers

• Event-driven processing
• Creating, viewing, and executing triggers

Performance Issues

• Factors, approach, and fundamentals
• Table, index, and query design
• Concurrency control