Top Section Deleted
Start with a refresher on SQL and then go all the way to expert level!
Course VII — SQL Programming SeriesCovers 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!
Get the most out of your SQL backend — Continue your training with Course VII, the SQL Programming Series
Who Can Benefit?
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.
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.
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.
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..
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.
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!
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.
Session 7: Clarion, ODBC, and MySQL
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.
Copyright © 2011 Data Down Under
Designed by 1st Logo Design
