Jensen Data Systems, Inc. provides Advantage Database Server training by Jensen Data Systems President Cary Jensen, Ph.D., one of the world's leading ADS trainers and co-author of the book Advantage Database Server: A Developer's Guide (Sybase, Inc., 2007). With onsite training, we can come to your site and it has never been more affordable. Get training for up to 12 developers for a competitive daily flat rate. Onsite training can be delivered using either lecture-style or hands-on techniques, and you can choose from a large selection of available topics.

Following are seminars available for Advantage Database Server. Select from our available seminars or have us put together a custom training seminar that covers just the topics you need. You can also combine ADS topics with other topics such as Delphi development, .NET development, or Web development. (See also Delphi 2007 training, Delphi 2006 training, Delphi 7 training, and Delphi 6 and earlier training.) We may also be able cover topics not listed online for Delphi 2009, Delphi Prism

Need assistance in the design, development, and/or deployment of your applications? Need a hand solving a problem? We can help. Jensen Data Systems provides consulting and mentoring on using Advantage Database Server. We can also combine training with consulting, focusing on your particular application. Let's work side-by-side on your application and get those problems solved!

The Advantage Database Server In Depth seminar provides focused training on using the Advantage Database Server by iAnywhere Solutions. This seminar uses Cary Jensen's book, Advantage Database Server: A Developer's Guide (Sybase, Inc., 2007) along with an accompanying seminar workbook that contains additional material about ADS. The seminar focuses on how to build client/server applications faster and better using the Advantage Database Server.

Featured Seminar Topics Include:

• Overview of ADS
• Building Scalable Solutions Using Advantage Local Server (ALS) and Advantage Database Server (ADS)
• Why ADS Applications Are Better
• Features New to ADS 8 and ADS 9
• Building ADS Databases
• Using the Advantage Data Architect (ARC)
• Importing Existing Data into ADS Tables
• Building ADS Data Dictionaries
• Indexes and FTS Indexes (Full Text Search Indexes)
• Encrypting Tables and Databases
• Defining Referential Integrity and Creating Constraints
• Creating Views
• Controlling User Access Using Users and Groups
• Using Stored Procedures (Advantage Extended Procedures)
• Writing SQL Scripts
• User Defined Functions
• Using Triggers
• Backing Up and Restoring Data
• Implementing Replication
• Using ADS from Your Favorite Development Tool
  

Seminar Length: 3-4 days for hands-on training; 3-4 days for lecture-style training. The extra day will depend on the amount of time you would like to spend on the topic "Using ADS from Your Favorite Development Tool."
Coursebook and Code Examples: All seminar attendees will need a copy of the book Advantage Database Server: A Developer's Guide by Cary Jensen and Loy Anderson (Sybase, Inc., 2007, ISBN: 978-1425977269). This book can be purchased from Amazon (click here) and various other bookstores. We can help you purchase books if needed. Attendees receive an accompanying seminar workbook that contains additional material about ADS, Attendees receive all code examples presented during the seminar as well as extra code examples. A two-user developer version of Advantage Database Server 8.1 is available with the book.
Prerequisites: A basic familiarity with programming. Familiarity with databases is helpful but not required.
<top of page>

Advantage Database Server Jump Start

The Advantage Database Server Jump Start seminar provides focused training on using the Advantage Database Server by Sybase iAnywhere. This seminar uses Cary Jensen's book, Advantage Database Server: A Developer's Guide (Sybase, Inc., 2007) along with an accompanying seminar workbook that contains additional material about ADS. The seminar focuses on how to build client/server applications faster and better using the Advantage Database Server. The Advantage Database Server Jump Start seminar is a shorter version of the Advantage Database Server In Depth seminar. The Jump Start seminar covers all of the topics, but the In Depth seminar goers into much greater detail into topic areas.

Featured Seminar Topics Include:

• Overview of ADS
• Building Scalable Solutions Using Advantage Local Server (ALS) and Advantage Database Server (ADS)
• Why ADS Applications Are Better
• Features New to ADS 8 and ADS 9
• Building ADS Databases
• Using the Advantage Data Architect (ARC)
• Importing Existing Data into ADS Tables
• Building ADS Data Dictionaries
• Indexes and FTS Indexes (Full Text Search Indexes)
• Encrypting Tables and Databases
• Defining Referential Integrity and Creating Constraints
• Creating Views
• Controlling User Access Using Users and Groups
• Using Stored Procedures (Advantage Extended Procedures)
• Writing SQL Scripts
• User Defined Functions
• Using Triggers
• Backing Up and Restoring Data
• Implementing Replication
• Using ADS from Your Favorite Development Tool

Seminar Length: 2-3 days for hands-on training; 2-3 days for lecture-style training. The Advantage Database Server Jump Start seminar covers all of the topics listed here, but the Advantage Database Server In Depth seminar goes into much greater detail into topic areas.
Coursebook and Code Examples: All seminar attendees will need a copy of the book Advantage Database Server: A Developer's Guide by Cary Jensen and Loy Anderson (Sybase, Inc., 2007, ISBN: 978-1425977269). This book can be purchased from Amazon (click here) and various other bookstores. We can help you purchase books if needed. Attendees receive an accompanying seminar workbook that contains additional material about ADS, Attendees receive all code examples presented during the seminar as well as extra code examples. A two-user developer version of Advantage Database Server 8.1 is available with the book.
Prerequisites: A basic familiarity with programming. Familiarity with databases is helpful but not required.
<top of page>

Advantage Database Server and .NET Development

Learn how to access your Advantage data in the Microsoft .NET framework in this intense seminar written and presented by award-winning trainer and author Cary Jensen. This seminar begins with an in-depth look at ADO.NET, the powerful new data access mechanism in the .NET framework class library (FCL). It continues with a detailed demonstration of the Advantage .NET Data Provider. Topics discussed include connecting to ADS and ALS, executing queries and stored procedures, using DataTables and DataSets, understanding the AdsCommandBuilder, and using the powerful new AdsExtendedReader. In addition, you will learn to how to write, install, and execute triggers and Advantage Extended Procedures (AEPs) in .NET languages such as C#, Delphi for .NET, and VB for .NET. This seminar's aim is to provide you with a solid understanding of data access with .NET and the Advantage Database Server. We can tailor this seminar to focus on your development language of choice: C# in Visual Studio, C# in CodeGear's Borland Developer Studio for .NET, or Delphi 2006 for .NET in CodeGear's Borland Developer Studio for .NET.

Featured ADS and .NET Development Seminar Topics Include:

• Overview of the Microsoft .NET Framework
  Common Language Runtime (CLR)
  Common Type System (CTS)
  The .NET Framework Class Library (FCL)
  The Common Intermediate Language (CIL)
• Benefits of the .NET Framework
  Security
  Consistency
  Deployment
  Platform Independence
• Data Access in .NET without ADO.NET
• ADO.NET and the Advantage .NET Data Provider
• ADO.NET Data Access Interfaces
  IDbConnection
  IDbCommand
  IDataReader
  IDbDataAdapter
  CommandBuilder
• ADO.NET Data Storage Classes
  DataSet
  DataTable
  DataRow
  DataColumn
  DataRelation
  DataView
  Constraints
  DataRowView
• Accessing Data with the Advantage .NET Data Provider
  Connecting to Data
  Making the Connection
  Connecting to Advantage Database Server
  Adding References to Advantage.Data.Provider
  Creating Instances of AdsConnection, AdsDataAdapter, and so forth
  Setting their Properties and Call Methods
  Dropping and Configuring an AdsDataAdapter Component
  Adding Additional Method Calls
• Executing IDbCommand Queries
  Executing Queries that Return No Data
  Executing Queries that Return One Value
  Getting Readonly Result Sets
  Selecting Record Sets into Memory
• Working with IDbDataAdapters
• Introduction to DataSets
• Creating and Using DataViews
• CurrencyManagers and Controls
  Adding, Deleting, Canceling Changes to, and Resolving Edits
• Writing Triggers in Delphi for .NET, C#, and VB for .NET
  Defining Triggers
  Creating an SQL Trigger
  Creating a Compiled Trigger
• Writing Advantage Extended Procedures (AEPs) in Delphi for .NET, C#, and VB for .NET
  Advantages and Disadvantages
  AEP Examples
  Strongly Naming an Assembly
  Installing Assemblies into the Global Assembly Cache (GAC)
• Bonus: Top Ten Techniques for Microsoft .NET Framework Database Developers
• 1. Adding Expression DataColumns to a DataTable
• 2. Working with Intermediate DataColumn Expressions
• 3. Programmatically Navigating DataSets and DataTables
• 4. Creating Calculated Fields Programmatically
• 5. Understanding BindingManagers
• 6. How to Create a Data Module
• 7. Using DataViews
• 8. Using IDbParameters to Avoid the SQL Script Hack
• 9. Synchronizing DataSets and XMLDataDocuments
• 10. Computing Expressions on Filtered Subset of Records

Seminar Length: 3 days for hands-on training, 2 days for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with databases as well as a basic familiarity with a programming language.
<top of page>

Using Delphi and Advantage Database Server
This seminar begins with a general overview of the ADS architecture. During this section we will install the Advantage Database Server, the Advantage Local Server (ALS), the Data Architect, and the Delphi-related ADS components. In this section you will learn how to import existing data into ADS tables, create and modify ADS tables, create data dictionaries, create users and groups, define constraints, write views, and configure referential integrity. We will also show you how to secure your database from unwanted access, as well as to define table-level and field-level rights. Also included in this section is a discussion of Advantage Replication, the new database replication technology from iAnywhere (formerly Extended Systems), permitting you to keep your data up-to-date across multiple locations. Taken together, these topics provide you with everything you need to know to begin implementing your own remote database server solutions using ADS today.

The remainder of this seminar focuses on using ADS with Delphi. Topics covered here include configuring ADSConnection components, accessing data using the ADSTable, writing SQL queries for use with ADSQuery components, executing views, writing and debugging Advantage Extended Procedure (AEP) stored procedures, and programmatically manipulating your data dictionaries. Following is a list of some of the topics covered in this workshop:

• Building Scalable Solutions Using Advantage Local Server and Advantage Database Server
• Understanding Database Replication
• Defining a Database Using the Data Architect (ARC)
• Defining Tables and Indexes
• Defining Referential Integrity and Creating Constraints
• Importing Existing Data into ADS Tables
• Encrypting Tables and Databases
• Controlling User Access Using Users and Groups
• Understanding the ADS Delphi Components
• Implementing Standard Database Solutions in Delphi Using ADS
• Understanding ADO and the Advantage OLE DB Provider
• Configuring and Using the Advantage ODBC Driver
• Building Advantage Extended Procedure Stored Procedures Using Delphi
• And Much, Much More

Seminar Length: 2 days for hands-on training, 1 day for lecture-style training
Coursebook and Code Examples: All seminar attendees receive a 90+ page detailed coursebook along with all code examples presented during the seminar as well as extra code examples.
Prerequisites: A basic familiarity with databases as well as a basic familiarity with either Delphi, C#, or C++.
<top of page>

JDSI HOME