Data Down Under

Shopping cart

0 Product(s) in cart

Total $0.00

» Checkout

Home » Software » SoftVelocity

Clarion Training - Course #7 - SQL Programming Series

Start with a refresher on SQL and then go all the way to expert level!

Course VII — SQL Programming Series
Covers all the most popular SQL backends!

This training course has detailed coverage for MS SQL, SQL Anywhere, Oracle, Firebird, PostgreSQL, MySQL, Pervasive SQL, and using ODBC to connect to any backend.

You'll learn best design practices for SQL applications, how to customize connections using Driver strings, the correct use of Prop:SQL to implement direct SQL Queries (both the how-to and when-to).

You'll discover the power of TurboSQL for obtaining optimal performance. You'll understand how to call Stored Procedures, and the differences between server-side Triggers and client-side Triggers. You'll learn Date-Time field handling, and designing the best KEY and INDEX files for optimizing Browses and update Forms. The course also discusses the advantages and disadvantages of each SQL backend.

Course 7 has been designed as the ultimate reference for building SQL applications using Clarion. This course will serve as a how-to guide for you to write any kind of SQL application, and it includes valuable information on how to install and configure both the server and client and how to adjust the configuration to avoid problems with firewalls.

Become an SQL Expert in Nine (9) Easy to Follow Sessions!

Introduction to SQL—Develop an understanding of SQL and the statements necessary to effectively retrieve information from SQL supported databases

IDE SQL Tools—Be familiar with the Clarion IDE tools
available when accessing SQL tables. Understand Driver Strings, OWNER (Connection) Strings, User Options, Column Options (Driver Switches), External Name, Relationships (Server Side), File Import and Conversion Wizard, DCT Synchronizer, Application Template Support, Extended Browse Options, Template Query Tools, Add-On Driver Support, Understand the process to use when migrating ISAM tables to a target SQL database.

Clarion and Microsoft SQL—A detailed look at Clarion's support of Microsoft SQL. Targets latest SQL Server 2005 version, including MARS and Identity support.

Clarion and Pervasive.SQL—A detailed look at Clarion's support of Pervasive.SQL. Including Advantages and Disadvantages using Pervasive.SQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and use of PROP:SQL with Stored Procedures.

Clarion and Oracle—A detailed look at Clarion's support of Oracle. Optimize the data dictionary to use only the fields you need, clarify key names, manipulate dates. Adding the 'IsIdentity' Column Option. Client-Side Triggers. Application Best Practices. Use native SQL code as filter criteria with SQL().Use Group By, Order By, and Aggregate Functions. Much more!

Clarion and SQL Anywhere (Sybase)—A detailed look at Clarion's support of Sybase. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings, PROP:SQL and Stored Procedures. TurboSQL and much more!

Clarion, ODBC, and MySQL—A detailed look at Clarion's support of ODBC and MySQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and PROP:SQL. Connection and Driver String Support for ODBC.

Clarion, Firebird and PostgreSQL—A detailed look at Clarion's support of Firebird and PostgreSQL through ODBC. Advantages and Disadvantages using Firebird/PostgreSQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and PROP:SQL.

SQL Design Tips and Best Practices.
General Tips for all SQL Drivers. Tips on Starting Your First SQL System. Property Syntax, VIEW, Indexing Tips. Tracing Tools, Add-on Driver Support. Specific tips regarding ODBC. Proper Joins, Scalar Functions, and using the ODBC API. Much more!

Get the most out of your SQL backend —
Continue your training with Course VII,
the SQL Programming Series

Who Can Benefit?

Professionals who want to quickly expand their knowledge
Organizations looking to train their staff quickly and efficiently
Managers who want to gain insight into the capabilities of the language
Clarion developers updating from older versions of Clarion

Course VII — SQL Programming Series
Covers all the most popular SQL backends!

Course 7 of the Training on Demand series starts in with a with a refresher on SQL and then takes you all the way to expert level. For each backend the course covers (MS SQL, SQL Anywhere, Oracle, Firebird, PostgreSQL, MySQL, Pervasive SQL, and ODBC to connect to any backend) the course discusses each backends advantages and disadvantages, application design best practices, customizing connections using Driver strings, the use of Prop:SQL to implement direct SQL Queries (both how-to and when-to), the use of TurboSQL for optimal performance, how to call Stored Procedures, the differences between server-side Triggers and client-side Triggers, proper Date-Time field handling, designing the proper KEY and INDEX files, and optimizing Browses and update Forms.

Module	Topic Outline
Session 1: Introduction to SQL What is SQL? How can I use SQL with Clarion? Understand the general terminology used with SQL, the declarative statements common to all SQL databases. Develop an understanding of SQL and the statements necessary to effectively retrieve information from SQL supported databases. Be familiar with the Clarion language support for SQL. Understand the common techniques in Clarion for communicating with a target SQL table, and much more.	Introduction to SQL Why Use SQL? Which SQL backend should I Use? A Quick introduction to SQL syntax Data Manipulation Language (DML) Data Definition Language (DDL) Data Control Language (DCL) Common SQL Functions Summarizing information: Aggregates, Totals, and SubTotals SQL Extensions - Programming Constructs Stored Procedures Beyond the SQL Standards How a SQL Query is Processed An SQL Starter Tutorial Using SQL with Clarion Applications Clarion Language Support for SQL Driver Communication Techniques Handling NULLs Summary & Self Test Flash Movies How to use this Interactive Self-Study System Course 7 Introduction
Session 2 — IDE SQL Tools Be familiar with the Clarion IDE tools available when accessing SQL tables, including: Built-In Driver and Dictionary Support, Driver Strings, OWNER (Connection) Strings, User Options, Column Options (Driver Switches), External Name, Relationships (Server Side), File Import and Conversion Wizard, DCT Synchronizer, Application Template Support, Extended Browse Options, Template Query Tools, Add-On Driver Support, Understand the process to use when migrating ISAM tables to a target SQL database.	IDE SQL Tools Introduction Lesson Objectives Getting Started Dictionary Support File Import and Conversion Wizards SQL Table Properties The Driver Owner String Builder SQL Column and Key Properties User Options Relationships and Triggers Dictionary Synchronizer The Dictionary Property Editor SQL Application Support Template Supported SQL Queries Template Support for SQL Aggregate Functions Template Query Tools SoftVelocity's Power Drivers with SQL Tutorial Converting from ISAM to SQL Convert the Data Definitions (Create an SQL Script) Converting the data Lesson Summary and Self Test Flash Movies Single File Convert QBE Button Control Template QBE List Control Template
Session 3: Clarion and Microsoft SQL A detailed look at Clarion's support of Microsoft SQL. History and Overview of Microsoft SQL. Advantages and Disadvantages using Microsoft SQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings. Targets latest SQL Server 2005 version, including MARS and Identity support..	Clarion and Microsoft SQL Introduction A Brief Overview of Microsoft SQL Getting Started Configuring the Server Configuring the Client Importing Tables Customizing the Table Properties Choosing the Best Client/Server Data Types Creating the right KEY and INDEX files Date-Time field Handling Importing the new SQL Server 2005 Schemas Stored Procedures Triggers Using TurboSQL Tips for working with Microsoft SQL Optimizing Browse Procedures Example Application Summary & Self-Test Flash Movies Creating a Trigger Example Program Part I Example Program Part II
Session 4: Clarion and Pervasive.SQL A detailed look at Clarion's support of Pervasive.SQL. History and Overview of Pervasive.SQL. Advantages and Disadvantages using Pervasive.SQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and use of PROP:SQL with Stored Procedures.	Clarion and Pervasive.SQL Introduction Lesson Objectives A Brief History of Pervasive.SQL Getting Started Configuring the Server Configuring the Client Importing Tables Customizing the Table Properties Choosing the Best Client/Server Data Creating the Right KEY and INDEX files Date-Time Field Handling Stored Procedures Triggers Using TurboSQL Avoidiing Pitfalls Example Applications Summary & Self-Test Flash Movies How to use this Interactive Self-Study System New Database New Table via SQL
Session 5: Clarion and Oracle A detailed look at Clarion's support of Oracle. History and Overview. Installation, Client and Server Configuration. Importing tables into Clarion. Customizing using Driver Strings and PROP:SQL. Optimize the data dictionary to use only the fields you need, clarify key names, manipulate dates. Adding the 'IsIdentity' Column Option. Client-Side Triggers. Application Best Practices. Use native SQL code as filter criteria with SQL().Use Group By, Order By, and Aggregate Functions. Much more!	Clarion and Oracle Introduction Lesson Objectives A Brief History of Oracle Getting Started Configuring the Server Configuring the Client Importing Tables Optimization of the Dictionary Creating the right KEY and INDEX files Date-Time field Handling Stored Procedures Triggers Example Application Tips and Pitfalls Summary & Self-Test Flash Movies Oracle Example Application; putting it all together
Session 6: Clarion and SQL Anywhere (Sybase) A detailed look at Clarion's support of Sybase. Overview of Sybase. Advantages and Disadvantages using Sybase. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings, PROP:SQL and Stored Procedures.	Clarion and SQL Anywhere (Sybase) Introduction Lesson Objectives A Brief History of SQL Anywhere Getting Started Configuring the Server Configuring the Client Importing Tables Choosing the Best Client/Server Data Creating the right KEY and INDEX files Date-Time field Handling Stored Procedures Triggers SQL Anywhere with Prop:SQL Using TurboSQL Tips and Pitfalls Summary & Self Test Flash Movies How to use this Interactive Self-Study System
Session 7: Clarion, ODBC, and MySQL A detailed look at Clarion's support of ODBC and MySQL. Introduction to ODBC. Why use ODBC? Connection and Driver String Support for ODBC. History and Overview of MySQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and PROP:SQL.	Clarion, ODBC, and MySQL Clarion and ODBC Introduction Lesson Objectives What is ODBC? ODBC Component Layers ODBC or Native? Importing an ODBC File Definition Supported ODBC Driver Strings The ODBC Connect String ODBC Summary Clarion and MySQL Introduction to MYSQL A Brief History of MySQL Getting Started Configuring the Client Configuring the Server Importing Tables Choosing the Best Client/Server Data Types Creating the right KEY and INDEX files Date-Time field Handling Stored Procedures Triggers Example MySQL Applications Summary & Self-Test Flash Movies How to use this Interactive Self-Study System
Session 8: Clarion, Firebird and PostgreSQL A detailed look at Clarion's support of Firebird and PostgreSQL through ODBC. History and Overview of Firebird/PostgreSQL. Advantages and Disadvantages using Firebird/PostgreSQL. Installation, Client and Server Configuration. Importing tables into Clarion. Application Best Practices. Customizing using Driver Strings and PROP:SQL.	Clarion, Firebird and PostgreSQL Clarion and Firebird A Brief History of Firebird Getting Started Configuring the Server Configuring the Client Importing Tables Choosing the Best Client/Server Data Types Creating the right KEY and INDEX files Date-Time Field Handling Stored Procedures Triggers Using TurboSQL Miscellaneous Tips and Other Issues Summary Self Test and Reference Flash Movies How to use this Interactive Self-Study System
Session 9: SQL Design Tips and Best Practices General Tips for all SQL Drivers. Tips on Starting Your First SQL System. Property Syntax, VIEW, Indexing Tips. Tracing Tools, Add-on Driver Support. Specific tips regarding ODBC. Proper Joins, Scalar Functions, and using the ODBC API. Much more!	SQL Design Tips and Best Practices Getting Started Clarion Property Syntax with SQL Your First Embedded SQL Project SQL and the Clarion VIEW SQL and Case Sensitivity Improving Your Filtering Performance Considerations Tracing Tools Stored Procedures with Parameters Miscellaneous Tips Using the "Power" Drivers with your SQL Application IMDD and SQL DFD and SQL ODBC Specific Tips Open Source and ODBC - Which to choose? Testing an ODBC Application The ODBC Log File Using a DSN-less Connection Keys (Indexes) and ODBC Improving Record Selection Performance Indexing multiple fields Deciding which Indexes to Create Improving Join Performance ODBC Scalar Functions The ODBC API Lesson Summary and Self-Test Flash Movies IMDD SQL Example Dynamic File Driver Example

Price: $299.00 ( $328.90 Inc. GST)

185.38 USD

« Previous | Next »