Sybase school training courses in Austin, TX (public, in-house or online)

This course introduces students to advanced techniques used to develop fully functional, well‑performing business applications using PowerBuilder 8. Upon successful completion of this course, the student should be able to:

· Create standard reports, including graphs, crosstabs, and multi-column reports.

· Create RichText, nested, and composite style reports.

· Manipulate the properties and behavior of the DataWindow control.

· Access and m...

Full archival course description>>

This series is designed to introduce database administrators to using and managing Sybase System 11. It covers an overview of Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11. It discusses using SQL Server to create, manage, and access database information, and the tasks and commands of a system administrator. Additional topics covered in this series include management of user accounts and groups, granting and revoking permissions, basic T-SQL p...

Full archival course description>>

This series describes the changes and additions learners will encounter when they move from earlier versions to PowerBuilder 9. It addresses the use of tools such as OrcaScript, InfoMaker, and DataWindows.

Audience:
This series is for developers who know and use PowerBuilder who want to learn the new features of PowerBuilder 9, enhancing their ability to build client/server applications.

Features:
A glossary provides a reference for definitions of unfamiliar terms.
A skil...

Full archival course description>>

Students will understand the data types used in Sybase database tables, how to modify data and execute queries through the use of Sybase SQL’s Data Manipulation Language (DML). There are several hands-on labs in this course that will provide the student with the opportunity to practice and perfect the knowledge of Sybase that they will gain during this course.

Relational database concepts
Client/server architecture
Creating tables
Simple queries
Qualified queries
Aggregates
Joins
Unions
Subqueries
Modifying data in tables
Using temporary tables and system tables
Using constraints, defaults, and rules to enforce data integrity
Writing Transact-SQL code with functions, variables, and control-of-flow statements

Creating and using cursors
Managing transactions
Writing stored procedures functions, and trigge...

Full archival course description>>