TRAINING * CONSULTING * MENTORING * DEVELOPMENT

Jensen Data Systems, Inc. provides Internet and database application training services and development services. We specialize in providing the highest-quality training, consulting, mentoring, and development services.

Contact JDSI via email at JDSI or call (US) 281-359-3311 for more information.

Advantage Database Server Training and Consulting

Official Advantage Database Server Training Partner: Jensen Data Systems, Inc.

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 Delphi 2006 training, Delphi 7 training, and Delphi 6 and earlier training.) We may also be able cover topics not listed online.

For more information, including pricing and scheduling, please contact us: email JDSI or call (US) 281-359-3311.

Advantage Database Server Training Seminars:	# of Days Hands-on	# of Days Lecture-style	Available
Advantage Database Server In Depth New! Covers 8.1 and 8.0 features	3-4 days	3-4 days	Now
Advantage Database Server Jump Start New! Covers 8.1 and 8.0 features	2-3 days	2-3 days	Now
Advantage Database Server and .NET Development New! Covers 8.1 and 8.0 features	3 days	2 days	Now
Using Delphi with Advantage Database Server	3 days	2 days	Now

Advantage Database Server Consulting, Mentoring, and Development

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!

For more information, please contact us: email JDSI or call (US) 281-359-3311.

<top of page>

Advantage Database Server In Depth

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.0 and ADS 8.1
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.0 and ADS 8.1
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