News & Events
Clarion/SQL Seminar
Jan 27th-29th in Atlanta

Public and Private Seminars
A Private training seminar can be created to help train your people.  We have extensive trainers (all English speaking) that can assist you with your training needs.

Our public seminars will be announced!
    Clarion/Sql Server
    in Atlanta, GA.  Embassy Suites - Buckhead

    • If you need to create business applications, then Clarion is the fastest programming IDE out there in which to accomplish this. If you need to build highly-scaleable business applications then the combination of Clarion and Microsoft's Sql Server make an unbeatable team.

    		Sponsored By: Clarion Magazine
     

    When: Jan 27th-29th 2011
    Where: Embassy Suites - Buckhead:  Atlanta, GA
    Cost: N/A for onsite    Special for live-streaming sessions only $499 (ask questions, get answers, but stay in the comfort of your own house or office)
    Requirements: Clarion 6 or 7, Notebook Computer (recommended), Sql Server 2008  

    Class size is very limited so personal attention can be given

    Syllabus     (each day starts at 9am and ends around 5 or 6pm) except for Thursday...starts at noon

    Day 1

    • Sql Server Intro
    • Sql Language Intro
    • ISAM/RDB comparison
    • Data Types
    • Sql Paradigms
    • MySQL
    • Postgres SQL

    Day 2

    • Creating a Clarion/Sql program
    • Converting a Clarion program to Sql
    • Using Prop:Sql and other efficient methods
    • Triggers
    • Queue Processing with SQL
    • SQL Views
    • Calling Stored Procedures

    Day 3

    • Sql Reporting
    • Maintenance Plans
    • Integration Services (ETL Loads)
    • Analysis Services (Date Warehousing / Cubes)
    • How about the web?
    • Optimizing Sql Server
    • Putting it all together
    • Available Tools

    Optional:

    • If requested - replication can be covered in detail..possibly as an additional 1/2 day session

    If you are new to Sql, then you will leave this seminar armed with the knowledge to create Sql backend Clarion programs. You will have the knowledge to ensure compatibility with a Sql Server backend and have the confidence that your programs are using the best methods.

    If you currently use Sql Server you will find a variety of ways to tackle various programming issues and how to use Sql Server more efficiently. There will be many common (and some uncommon) programming problems presented that will be solved using Sql Server's powerful abilities.

    Questions: Please feel free to contact us