Shopping cart  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 »

 

 
 

Copyright © 2011 Data Down Under

Designed by 1st Logo Design