Facebook LinkedIn Twitter
 














Training Registration



   Advanced SQL for Elite

Sample Agenda

DAY ONE:

Morning: Introduction & Overview

  • Overview of Elite
    • Purpose of Class
    • Key Tables in Elite Professional Billing System (EPBS) & Financial Management System (FMS)
    • Transaction Tables vs. Summary Tables

      (Morning Break)
  • Review of Introduction to SQL
    • Tools
      • Accessing the database and your queries
      • Saving Queries
      • Saving Your Output
    • Writing Queries
      • Review general SQL commands
      • Hands On Exercises

  • Q & A
Afternoon: Advanced SQL Statements
  • Data Manipulation Language
    • Exists/Not Exists - Differences between In/Not In
    • More Aggregates
    • Substrings
    • Using These Commands to Analyze Elite Data With Hands On Exercises
    • (Afternoon Break)
  • More Data Manipulation
    • Date Manipulation
    • Complex Joins with Multiple Tables
    • Self Joins
    • More Analysis of Elite Data with Hands On Exercises

  • Review of Day and Q & A

DAY TWO:

Morning

  • Review of Advanced SQL Statements from Day One

  • Data Definition Language
    • Create Tables/Views
      • Data Types
    • (Morning Break)
  • Continue with Data Definition Language
    • Create Temporary Tables
      • Microsoft SQL Server
      • Informix
    • Updating and Inserting data into temp tables
    • Deleting from tables
    • Hands On Exercises
Afternoon
  • Applying what we've learned to Elite Data
    • Reviewing queries from other Data Fusion Classes
    • Reviewing queries from Data Fusion's News Letter
    • Setting limits with your Elite Data - Never perform Update/Insert/Delete commands on Elite tables!!!

  • Common Needs for Advanced Queries
  • Hands On Exercises
  • Review of Day and Q & A