JCK - A Veteran-Owned Small Business
EXCELLENCE IN DATA ARCHITECTURE

since 1989

America Support You
4348 Pine Grove Ave
Fort Gratiot MI USA
48059-3732
V: 810 982-8639
Business Event Analysis & Modeling (BEAM™)

BEAM™ for Decision Support Systems

Extended Relational Analysis (ERA™)

Structured Query Language (SQL)

Course Offerings

Schedule & Registration



What is User Focused Data Architecture?




The industry standard data access language.

Whether your system is client/server, web-based, SOA, or even an old green-screen mainframe application, it's probably based on a database that uses Structured Query Language.

If your data is stored in a SQL database, that means you can usually access the data directly without having to go through your application. Why would you want to do that? There may be many reasons, like:

  • Ad-hoc reporting - Your production system may not produce all the reports you wish, or you may wish to enhance ones that it already has.
  • Decision support systems - You may want to reformat your data into more useable structures, or feed other systems from your various production environments. You may want to summarize or analyze your data in new ways.
  • System Enhancements - You may want to develop new systems that "tap into" existing systems, or add capabilities like web reporting.
SQL is the key to all these efforts and more. Fortunately, SQL is easy for technical and non-technical staff to learn.

Why learn SQL?

Structured Query Language is the common language of database systems. Though different vendors such as Oracle and IBM have slightly varied dialects, a knowledge of basic SQL will enable you to "get beneath" your operational systems and question the data directly to get the answers you need.

If you're like most organizations, you cannot get the information you need because you are swimming in raw data. Thousands of records to sort through, reams of reports that require manual scanning wouldn't it be nice to be able to quickly narrow down and summarize all that to get just the information you need to answer your questions? That's what SQL can do for you.
 

Back | More