InterAxiom Training Services
Ask IT
recruiters how difficult it is to hire qualified staff in new technology areas
and the response is usually "impossible.”
Many of these difficulties arise from the high demand and small supply
of specialized resources in our Internet economy. Basic economics dictate that staying competitive means, at a
minimum, staying current with technology.
To achieve this, companies either outsource portions of IT projects to
consulting companies specializing in technology or offer education to their
employees. Enhancing the talent of
existing IT staff through timely classroom and on-the-job training fills this
technology gap and provides more interesting and varied career paths for
employees.
InterAxiom’s proven hands-on training is based on many years’ experience working on high-caliber Web-based and Decision Support System projects. InterAxiom’s training goals provide attendees with a working knowledge – not just a theoretical understanding – that allows them to immediately apply their new skills to current projects. All InterAxiom trainers are experienced consultants who apply the training sessions to solutions relevant to your business goals.
Decision Support System Concepts (DSS Concepts) is a 2-day training
course given by InterAxiom consultants.
Course objectives are to prepare the client for identifying/prioritizing
cost justifying, planning, and developing a DSS.
Topics include:
Benefits of Attending:
·
Understand
the critical success factors that make or break DSS Projects
·
Learn
how to avoid the common risks inherent to DSS projects
·
Obtain
a blueprint for successful DSS implementation
Who Should Attend:
DSS Customers (end users) will learn:
·
How
their involvement is essential for the success of a Data Warehouse project
·
How
to more accurately plan, estimate, and manage their involvement in the project
·
How
to recognize "dirty data" and how to triage data cleansing
Developers will learn:
·
How
the ETL (extract-transform-load) process differs from the data delivery process
·
How
their roles and responsibilities have shifted
Project Managers will learn:
·
How
to recognize and mitigate risks on a Data Warehouse project
· How to establish a core team and what roles and responsibilities have to be assigned
Dimensional Modeling is a 2- to 3-day course
that addresses the key issues involved in designing the database structures
necessary to support both anticipated and unanticipated analytical
requirements. Attendees learn the basic
techniques of Dimensional Data Warehouse Design, which ensures that the data in
their DSS will be accessible by the business community and still provide
optimal performance. Attendees leave with the understanding of how different
design choices affect both the usability and performance of their database
design.
Topics include:
·
Design challenges
facing data warehouse designers
·
An overall data
architecture for the data warehouse
·
Dimensional modeling
for the data warehouse
·
Hands-on design
experience
Benefits of Attending:
·
Understand why data warehouse structures are different from
transactional systems
·
Learn the critical techniques for designing effective data
warehouses
·
Obtain a blueprint for modeling data warehouses
Who Should Attend:
·
Data Modelers new to
dimensional modeling
·
Managers seeking to
understand Dimensional Data Warehouse Design
·
Data Warehouse
designers
· Data Warehouse Architects and Developers
Introduction to SQL Course is a 1-day course that provides attendees a sound understanding of Relational Database and
SQL concepts. Knowing SQL is essential to using products from
Microsoft, Oracle, Sybase, Informix, and database vendors. The course concentrates on teaching SQL
fundamentals to enable attendees to insert,
update, and delete rows from databases.
Topics include:
·
Fundamental
concepts
o Usage Scope
o Data definition
o Data manipulation - populating
tables
o Data manipulation - simple data
retrieval
o
Data
manipulation - qualified data retrieval and simple joins
Benefits of Attending:
·
Understand SQL concepts
·
Learn general SQL constructs
·
Obtain a blueprint for manipulating data in relational
databases
Who Should
Attend:
·
Business Users,
Architects or Application Developers new to SQL
·
Database Administrators
· Managers or Team Leaders seeking an appreciation of SQL capabilities
Writing Effective Transact SQL
Training is a 2-day course that covers the language extensions of Transact SQL
and teaches attendees how to write effective code. It is strongly recommended that attendees complete the 1-day
“Introduction to Structured Query Language” training before this course.
Topics include:
·
Transact-SQL
Fundamentals
·
Language
Elements – Data types, Variables, Conditional Processing
·
Cursors
·
Temporary
Objects
·
Functions
and Extensions
·
Stored
Procedures
·
Error
Handling
Benefits of Attending:
·
Understand
Transact-SQL’s extensive features and functionality
·
Learn
Transact-SQL constructs
·
Obtain
a blueprint for effectively coding in Transact-SQL
Who Should Attend:
·
Business
Users, Architects or Application Developers planning to code in Transact-SQL
·
Database
Administrators
·
Managers
or Team Leaders seeking an appreciation of Transact-SQL capabilities
Writing Effective PL/SQL Training is a 2-day
course that teaches attendees how to write effective code for both server and
client-side processing. It is strongly
recommended that attendees complete the 1-day “Introduction to Structured Query
Language” training before this course.
Topics include:
·
Definitions,
Features, General Rules & Structure
·
Blocks
& Sub-blocks
·
Variables
& Constants
·
Assigning
values to variables
·
Scoping
variables
·
Composite
data types: PL/SQL Tables & PL/SQL Records
·
Using
SQL and Transactional Processing in PL/SQL
·
Sets,
Operators, and Compound statements
·
Control
Structures: If statements, Loops, Labels & GOTO Statements
·
Cursors
·
PL/SQL
Error Handling: Exceptions
·
Error
Reporting in PL/SQL
·
PL/SQL
Subprograms
Benefits of Attending:
·
Understand PL/SQL’s extensive features and functionality
·
Learn PL/SQL constructs
·
Obtain a blueprint for effectively coding in PL/SQL
Who Should
Attend:
·
Business Users,
Architects or Application Developers planning to code in PL/SQL
·
Database Administrators
·
Managers or Team
Leaders seeking an appreciation of PL/SQL capabilities