Application Development

Caché Foundations
5 days, $2400/student

  • Classroom opens at 8:30am
  • Classes run from 9am - 5pm
  • Classes taught on the latest version of Caché
  • Register for this course

Overview

The Caché Foundations course and labs teach programmers how to use the tools and techniques within the Caché development environment to build high-performance transactional applications. The course focuses on server-side programming, and the various labs focus on using advanced features as well as other languages that interact with Caché. Students master the important features of Caché by building a complete object-oriented application.

Caché Foundations

Caché Foundations replaces Caché Core (v5.0). It covers the major features of server-side development. Although much of the information is similar, students who have taken Caché Core in the past would still benefit from attending Caché Foundations.

Prerequisites

Prerequisites Recommendation

Programming experience

Absolutely essential

Caché ObjectScript

Recommended. Complete the ObjectScript tutorial included within Caché.
Caché is available as a free download.

SQL

Useful

Object-oriented design and programming

Useful

Agenda

Part 1: Introduction. Modules 1-7.
Part 2: Properties and SQL. Modules 8-12.
Part 3: Methods. Modules 13-14.
Part 4: Applied Programming. Modules 15-19

Post-Foundations Recommended Education

 

Module Descriptions

Module 1: Overview

Caché
Partners
Benefits
Platforms
Features
History

Module 2: Introduction to Classes

Classes
Methods
ObjectScript: First commands
Namespaces
Databases
Packages
Persistent classes
Properties
Instance methods
Objects
Tables
Data population
SQL: Class queries
Class documentation
Errors

Module 3: Development Setup

Development sandbox
Memory setup
Namespace and database setup
Resource and role setup
User setup
ODBC setup
Remote System Access setup
Developer’s Corner

Module 4: Architecture

Namespaces and databases
Globals and routines
System databases
Data integrity
Naming conventions

Module 5: Classes

OO/SQL Correspondence
Classes revisited
ObjectScript: Patterns, Dates, Times
Class compilation
Package mapping

Module 6: Properties

Properties
Object reference (OREF)
Reference properties
SQL: Embedded SQL

Module 7: Unit Testing

Unit testing
Benefits
Framework
Macros

Module 8: Simple Collections

Collections
List collections
Array collections
Object collections
Data population
ObjectScript: Delimited Strings, Lists, Random numbers

Module 9: Relationships

Relationships
Swizzling related objects
SQL: Implicit joins
Many-to-many relationships
Performance options

Module 10: Streams and Files

Streams
Files

Module 11: Queries

Sets of results
Collation
Cursor-based embedded SQL
Dynamic SQL
Command line shell
Views

Module 12: Indexes and Tuning

Indexes
Indexing options
Collation
Index types
ObjectScript: Bit Strings
Index methods
IDKEY index
Query performance tuning

Module 13: Methods

Inherited methods
Scripting languages
Signature
Arguments
ObjectScript: $data/$get functions
Private methods
Class/Instance methods
Macros
Pair programming
ProcedureBlock methods
Code mode
Special method syntax
Accessor methods

Module 14: Debugging

Debugging with Studio
Debugging with ZBreak

Module 15: Inheritance

Object-oriented programming
Encapsulation
Inheritance
Polymorphism
Abstraction
Multiple inheritance

Module 16: Objects

Object oriented design
Registered objects
Persistent and Serial objects
Cloning objects
Object concurrency
Object storage

Module 17: Common Business Logic

Computed properties
OOP callback methods
SQL: triggers
SQL: stored procedures
Transaction processing
SQL concurrency
Bulk operations
Non-registered classes

Module 18: Polymorphism

Persistent objects
Serial objects

Module 19: Datatype Classes

Datatype classes
Validation
Conversion
Custom datatype classes
Class attributes

 

 

Return to the Education Schedulearrow icon