Sybase school training courses in Dover, DE (public, in-house or online)

Merrimack College Institute of Professional and Executive Education plans to soon offer technical training on:
Sybase Adaptive Server
IQ-M for the Web-enabled Data Warehouse
Sybase USA PATRIOT Act Compliance Solution
Call 978-837-5154 for further information.

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

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

SYBASE overview
SYBASE operating environment
SYBASE Objects
SYBASE Interactive
SQL - Data Manipulation Language
Simple SQL Queries
Functions
JOIN
Subquery
UNION
SQL - Data Definition Language
Tables, Views, Synonyms
INSERT, UPDATE, DELETE
SYBASE Data Dictionary
What You Can Expect
At the end of this course, participants will be able to:

Understand Relation Database Concepts.
Use the Interactive SYBASE.
Use SQL in all aspects of SYBASE. ...

Full archival course description>>