Other Topics

Select the title to review a description of the course. Please note that these courses can often be adapted for virtual delivery and modified based on the target audience and goals of your program. Please contact us to discuss your training needs and we will work with you to identify and craft the best solution.
  • Data Warehousing and Business Intelligence Reporting
    • Data Warehousing and Business Intelligence Reporting

      Course Number: 724-DJ
      Recommended Duration: 3 or 4 days

      Intended Audience: This course is designed for technical staff, team leaders and project managers who need to understand how to design a data warehouse and access it via popular BI Reporting Tools.

      Course Overview

      This course provides participants with the skills necessary to design a data warehouse. The course discusses Dimensional Modeling and Star Schemas. The design of Staging Area, Fact and Dimension tables are featured. The Oracle 10G database is used in this course in several student workshops. A brief SQL refresher, the use of Oracle DB Functions and Oracle Materialized Views are covered. If the customer has the licenses to Business Objects or Cognos, the development of BI reports running against the classroom data warehouse can be included.

      Objective

      At the end of this course, student will be able to:
      • Design and create a Data Warehouse to meet key business objectives
      • Build and load the Data Warehouse
      • Design and implement BI reports using Business Objects/Cognos

      Prerequisites

      Participants should have some experience with relational database management systems. The database system featured in this course is Oracle 10G.

      Topics


      Data Warehouse design
      • Data Warehousing concepts
      • Designing BI reports and key process indicator
      Data Warehouse Build
      • Building the staging area
      • Designing the dimension and fact tables
      • Creating tables, indexes, functions and materialized views
      • SQL review
      • Extract/transform/load
      • Designing transformations using SQL
      • Data quality and auditing
      • Implementation readiness
      • BI reporting and Business Objects
      • Creating Universes using Designer
      • Creating reports using Web Intelligence
      • Running reports in InfoView
      • BI reporting with Cognos
      • Creating Frameworks using Framework Manager
      • Creating Reports Query Studio and Report Studio

      Share with others

  • Design Patterns in MATLAB
    • Design Patterns for MATLAB

      Course Number: 552-TES
      Recommended Duration: 5 days

      Course Overview

      The course covers the 23 design patterns in the book "Design Patterns" (by Gamma, Helm, Johnson, and Vlissides), and 3 others added by the instructor.

      Objectives

      You will learn to write programs that are extensible, flexible, maintainable, modular, portable, reusable, and understandable.

      Prerequisites

      Complete an introductory course in MATLAB and have one year experience programming in MATLAB. Also, you must be able to do the following in MATLAB:
      • define a class
      • define/invoke a constructor, a member function, and a static member function
      • define a class to be publicly derived from another class

      Topics

      • Introduction
      • Object-Oriented Guidelines
      • What type are you?
      • Clone
      • Disable Copy/Assignment
      • Memento
      • Template Method
      • Chain of Responsibility
      • Prototype
      • Factory Method and Factory Class
      • Abstract Factory (Class)
      • Flyweight
      • Singleton
      • Mediator
      • Proxy
      • Façade
      • Adapter
      • Iterator
      • All of Me
      • Observer
      • Strategy
      • State
      • Bridge
      • Decorator
      • Composite
      • Builder
      • Interpreter
      • Visitor
      • Null Object
      • Command
      • Conclusion

      Share with others

  • Object Oriented Analysis & Design
    • Object Oriented Analysis & Design

      Course Number: 674-TES
      Recommended Duration: 4 days

      Intended Audience: Software analysts, designers, and developers; business analysts, and technical managers.

      Course Overview

      Object-oriented analysis, design, and development is one of the leading technologies used to build platform-independent, maintainable, and flexible applications. OOAD begins with the specification of a system, and ends with a detailed description of a software implementation for that system. To write today's client/server applications that run in heterogeneous environments, OOAD techniques are a must. Moreover, if you already program in C++, this workshop will enable you to be even more effective. Understanding these de facto standards will give you a real competitive advantage. This hands-on workshop is the best and quickest way for designers and developers to learn how to use object-oriented analysis and design (OOAD) techniques to develop robust software systems. You will learn how to analyze a problem, develop and specify a detailed design, and diagram an entire software system using UML notation.

      Objectives

      This workshop will teach you how to:

      Work with concepts like classes, objects, polymorphism, and inheritance
      Design robust, portable, and maintainable software systems
      Specify, design, and represent the control flow of a complex software application using UML
      Know whether to use data-oriented analysis or event-oriented analysis
      Understand more fully abstraction, clases, modularity, and information hiding
      Use OOAD hands-on - approximately 40% of the workshop is devoted to labs
      Prerequisites
      Experience in software analysis, design, and programming will enable you to more fully benefit from this workshop, but such experience is not absolutely required.

      Topics

      • Introduction
      • Concepts and notation
      • The process of analysis
      • Specifying polymorphism
      • The process of design
      • Implications and opportunities
      • Case studies

      Share with others

  • Object Oriented Analysis & Design with UML
    • Object Oriented Analysis & Design with UML

      Course Number: 504-TES
      Recommended Duration: 4 or 5 days, depends on how the labs are done

      Intended Audience: Software analysts, designers, developers, business analysts and technical managers.

      Course Overview

      You will learn how to construct software systems that are flexible, maintainable, reusable and responsive to changes in user requirements. You will learn how to read and write UML diagrams that describe such software systems.

      Prerequisiste

      No prerequisites however the more programming you have done, the more you will benefit from an improved approach to designing complex software systems.

      Topics

      • Introduction
      • Iteration
      • Encapsulation
      • Information Hiding
      • Object
      • Operation
      • Collaboration
      • Sequence Diagrams
      • Attribute
      • Relationships
      • Link
      • Composition
      • Class
      • Instance
      • Association
      • Multiplicity
      • Inheritance
      • Concrete/Abstract Class
      • Multiple Inheritance
      • Interface/Implementation
      • Polymorphism
      • UML Design
      • Iterations 2 through 4
      • Reuse
      • Case Tools
      • Portability
      • Persistence
      • Class Libraries
      • Performance Tuning
      • References
      • Glossary
      • UML Syntax
      • UML to C++ and Java
      • The 9 Diagrams of UML

      Share with others

  • Object Oriented Concepts
    • Object Oriented Concepts

      Course Number: 713-JK
      Recommended Duration: 1 day

      Intended Audience: Programmers and systems designers who need to understand Object Oriented terminology and processes, and who need to build systems using Object Oriented tools.

      Objectives

      Students who complete this course will understand the basic constructs and concepts of object oriented methodologies, and the benefits that these methodologies offer in application development.

      Prerequisites

      Attendees should have a basic understanding of data processing systems as well as some experience in programming or system design.

      Topics

      • Objects and classes
      • Abstraction
      • Encapsulation
      • Inheritance
      • Polymorphism
      • Overloading
      • Task management
      • Event-driven tasks and clock-driven tasks
      • Object Oriented Data Bases
      • Type Hierarchies
      • Public and private components of classes
      • Reusability
      • Introduction to Unified Modeling Language (UML)
      • UML case diagrams
      • UML action diagrams
      • Object Oriented vs. Relational database
      • Examples of Object Oriented Data Bases
      • Object Oriented Programming
      • Object Oriented Programming Languages: Java, C#, C++, Smalltalk, etc...
      • Pros and cons of Object Oriented Application Development
      • Available class libraries and services

      Share with others

  • Advanced Excel Workstation Skills
    • Advanced Excel Workstation Skills

      Course Format

      A combination of online courses that are supplemented with live help from instructors to enhance participant learning while reducing total classroom time and costs.
      • 5 Pre-recorded lessons with Quick Challenge Questions to test understaning
      • Graded workshop assignments
      • Virtual help from live instructors

      Course Time

      12 Hours Total
      • 2 Hours to View Lessons – 30-40 minutes per lession
      • 10 Hours of Hands on Workshop Practice – 2 hours per assignment
      Suggested delivery schedule is 5 weeks. 1 lesson per week.

      Pre-Requisites

      Basic familiarity with EXCEL such as setting up spreadsheets and using functions like Sum()

      Course Overview

      The advanced Excel Workstation Skills course provides a comprehensive overview of the functionality that makes Excel such a powerful tool in the workplace. The course provides practical information for using Excel to solve real world problems and to increase productivity.

      The course is broken into five concise lessons that can be accessed at anytime from anywhere which are supplemented with hands on workshop assignments and help and grading from live instructors.

      Key Topics

      Lesson 1: Formulas & Functions – Working with powerful, but often missed, formulas and functions that can be used for analysis and calculations when adding up the rows just isn’t enough. Functionality covered:
      • SumIf
      • CountIf
      • DSum
      • Date Functions
      • Absolute versus Relative Referencing
      Lesson 2: Making Data Easier to Manage – Reducing spreadsheet errors by minimizing data entry and using Excel Functionality to check for errors. Functionality covered:
      • Named Ranges
      • Vlookup
      • Hlookup
      • Match and Index
      • Data Validation
      • Spreadsheet Protection
      Lesson 3: Creating Basic Reports – Formatting and organizing data. Functionality covered:
      • Left/Right
      • Trim
      • Subtotaling
      • Concatenate
      • Filtering
      • Sorting
      Lesson 4: Making Sense of Data – Using tools within Excel to better understand the story behind the raw data and best practices for what types of data are best displayed with which tools. Functionality covered:
      • Tables 
      • Pivot Tables 
      • Charts and Graphs
      • Conditional Formatting
      Lesson 5: Working with Macros – Using Macros to automate common tasks (improve quality, improve efficiency). This lesson provides an introduction to recording and modifying macros. We touch on basic Visual Basic constructs such as: If…then…else, looping, checking conditions, declaring and assigning values to variables, and selecting sheets, cells and ranges.

      Share with others

  • Service Oriented Architecture (SOA) Overview
    • Service Oriented Architecture (SOA) Overview

      Course Number: 658-JK
      Recommended Duration: ½ day

      Intended Audience: Information professionals needing an understanding of Service Oriented Architecture.

      Course Overview

      Information professional learn the concepts and terminology of Service Oriented Architecture.

      Objectives

      The target for Service Oriented Architecture (SOA) is having a set of collaborating services available for invocation. Incorporating Service Oriented Architecture into Information Technology will enable agility and flexibility in meeting modern business information needs. SOA aligns IT systems to Business Processes. This session introduces the core concepts of Service Oriented Architecture, how services act as components in creating/modifying technology systems, and how services impact future business planning.

      Prerequisites: None

      Topics

      • Why We Need Architecture
      • Components of Service-Oriented Architecture
      • Service providers, consumers, and repositories
      • Loose Coupling
      • Inter-operability between Disparate Systems
      • Reusable Components
      • SOA compared to other Architectures
      • Implementing a Service-Oriented Architecture
      • What is an Enterprise Service Bus (ESB)?
      • Middleware Solutions (WebSphere MQ, AMQ, etc...)
      • J2EE and .NET Solutions
      • Legacy Systems and SOA
      • SOA Issues
      • SOA Governance
      • Web Services and SOA
      • Standards supporting Web Services
      • Platform Independence
      • Integration issues
      • Implementing Applications with SOA
      • Cost of development vs expected savings
      • Business Process Management and SOA
      • IT Alignment with Business
      • SOA Architect and SOA Project Manager roles

      Share with others

  • Service Oriented Architecture (SOA) with Web Services
    • Service Oriented Architecture (SOA) with Web Services

      Course Number: 659-JK
      Recommended Duration: 1 day

      Intended Audience: Information professional needing an understanding of Service Oriented Architecture and Web Services. Specific technologies are discussed and compared, but, no programming background is required.

      Course Overview

      Information professional learn the concepts and terminology of Service Oriented Architecture and how SOA is implemented using Web Services.

      Objectives

      The target for Service Oriented Architecture (SOA) is having a set of collaborating services available for invocation. Today, Web Services are providing the backbone of Service Oriented Architecture for most organizations. This session introduces the core concepts of Service Oriented Architecture and Web Services. Attendees will learn how web services may be used as part of an overall SOA strategy including the strengths and weaknesses of different implementations.

      Prerequisites: None

      Topics

      • Why We Need Architecture
      • Components of Service-Oriented Architecture
      • Service providers, consumers, and repositories
      • Loose Coupling, Inter-operability, and Reusability
      • SOA compared to other Architectures
      • Implementing a Service-Oriented Architecture with Web Services
      • What is an Enterprise Service Bus (ESB)?
      • .NET Solutions
      • J2EE Solutions
      • Legacy Systems, Web Services, and SOA
      • Standards supporting Web Services
      • XML, SOAP, WSDL, and UDDI/UBR
      • Java and Web Services
      • Microsoft .NET and Web Services
      • Platform Dependence/Independence
      • ntegration issues
      • Implementing Applications with SOA and Web Services
      • Security and deployment issues

      Share with others


Please click here to return to the Technical Skills page.