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 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.
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é. |
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-18
Post-Foundations Recommended Education
- Use the free Caché QuickStart tutorials (Java, .net) in the Tutorials section of the Documentation to learn how to start building a user interface for Caché applications.
Module Descriptions
Module 1: Overview
Caché
Benefits
Platforms
Versions
Features
History
PartnersModule 2: Introduction to Classes
Methods
ObjectScript introduction
Namespaces
Databases
Packages
Persistent classes
Inheritance
Object reference (OREF)
Properties
Instance methods
Objects
Tables
Storage
Data population
SQL class queries
Class documentation
ErrorsModule 3: Development Setup
Development sandbox
Namespace and database setup
Resource and role setup
User setup
ODBC setup
Remote System Access setup
Developer’s CornerModule 4: Architecture
Namespaces and databases
Globals and routines
System databases
Naming conventionsModule 5: Classes
OO/SQL correspondence
Classes revisited
ObjectScript patterns, dates, times
Class compilation
$SystemModule 6: Properties
Properties
Datatypes
Reference properties
Foreign keys
Cloning objects
Accessor methods
Computed properties
Embedded SQLModule 7: Unit Testing
Unit testing
Benefits
Framework
MacrosModule 8: Collections
Collections
List collections
Array collections
Object collections
Data population
ObjectScript delimited strings, lists, random numbersModule 9: Relationships
Relationships
Swizzling related objects
SQL implicit joins
Many-to-many relationships
Performance optionsModule 10: Streams and Files
Streams
FilesModule 11: Queries
Sets of results
Cursor-based embedded SQL
Dynamic SQL
SQL stored procedures
Command line shell
Views
Other SQL featuresModule 12: Indexes and Tuning
Indexes
Indexing options
Collation
Index types
ObjectScript bit strings
Index methods
Query performance tuningModule 13: Methods
Inherited methods
Scripting languages
Signature
Arguments
ObjectScript $data/$get functions
Private methods
Class/Instance methods
Macros
OOP callback methods
SQL triggers
ProcedureBlock methods
Code mode
Special method syntaxModule 14: Debugging
Debugging with Studio
Debugging with ZBreakModule 15: Inheritance
Inheritance
Polymorphism
Abstraction
Multiple inheritanceModule 16: Objects
Object-oriented programming
Registered objects
Persistent and Serial objects
Non-registered classes
Object storageModule 17: Databse Integrity
Concurrency
Transaction processingModule 18: Polymorphism
Persistent objects
Serial objects

