Application Development

Caché Foundations
5 days, $2600/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 teaches programmers how to use the tools and techniques within the Caché development environment to build high-performance transactional applications. It covers the major features of server-side development. Students master the important features of Caché by building an object-oriented application.

Prerequisites

Prerequisites Recommendation

Programming experience

Required

Caché ObjectScript

Recommended

Object-oriented programming

Helpful

SQL

Helpful

 

Next Steps

Module Descriptions

Module 1: Overview

  • Caché
  • Benefits
  • Platforms
  • Versions
  • Features
  • History

Module 2: Development Introduction

  • Introduction to classes and methods
  • Introduction to ObjectScript
  • Namespaces, databases, and packages
  • Persistent and serial classes
  • Errors

Module 3: Development Setup

  • Development sandbox
  • Namespace and database setup
  • Resource and role setup
  • User setup
  • ODBC setup
  • Remote System Access setup

Module 4: Architecture

  • Namespaces and databases
  • Globals and routines
  • System databases
  • Naming conventions

Module 5: Classes

  • OOP/SQL correspondence
  • Classes revisited
  • Multiple inheritance
  • ObjectScript patterns, dates, times
  • Class compilation
  • $System

Module 6: Properties

  • Properties
  • Datatypes
  • Reference properties
  • Foreign keys
  • Cloning objects
  • Accessor and mutator methods
  • Computed properties
  • Embedded SQL

Module 7: Unit Testing

  • Unit testing
  • Benefits
  • Framework
  • Macros

Module 8: 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
  • Macros

Module 10: Streams and Files

  • Streams
  • Files

Module 11: Queries

  • Sets of results
  • Cursor-based embedded SQL
  • Dynamic SQL
  • SQL stored procedures
  • Command line shell
  • Views
  • Other SQL features

Module 12: Indexes and Tuning

  • Indexes
  • Indexing options
  • Collation
  • Index types
  • Query performance tuning
  • ObjectScript bit strings
  • Index methods

Module 13: Methods

  • Inherited methods
  • Scripting languages
  • Method attributes
  • OOP callback methods
  • SQL triggers
  • ProcedureBlock methods
  • Code mode
  • Special method syntax

Module 14: Debugging

  • Debugging with Studio
  • Debugging with ZBreak

 

Return to the Education Schedulearrow icon