![]() |
| |
|
| ||
| ||
![]() |
| ONYX offers classes in the following four categories, with an overview listed below. |
|
Web or internet Applications Development: Designed for software developers in a web-enabled environment; especially appropriate for mainframe developers transitioning to web application development. Client/Server Applications Development: Designed for software developers in a client/server environment; that need to understand the interface with software in a distributed processing environment. Mainframe Applications Development: Designed for those who develop, maintain and enhance software in a mainframe environment, especially for legacy systems that are expensive to rewrite. Information Technology Foundation: Designed for non-technical personnel who need a foundation to interface with technical personnel, or technical staff needing pre-requisite courses. |
This class covers the fundamentals of Oracle Applications Express (APEX) including the architecture of APEX and how it works. Students will build a functioning application as they explore the features of this product including basic navigational logic, and UI concepts of APEX application development. Students will also learn the Utilities and SQL Workshop facilities of APEX. This course provides a hands on learning experience thru the lab exercises and demonstrations of some example projects that have been built with APEX. UML Fundamentals - 1 day UML Fundamentals teaches the basics of object-oriented (OO) principles and the Unified Modeling Language (UML). Starting from a discussion about why we build models, the course introduces the principles of abstraction, encapsulation, modularity and hierarchy. These OO principles are then applied to the fundamental modeling concepts in the UML - objects, classes, attributes, operations, and relationships. Students learn the graphical notation for the most used UML diagrams - collaboration, sequence, and class diagrams. Hands-On classroom experience allows for successful application of basic object-oriented modeling techniques. OOAD Using UML - 4 days Learn how to use Object-Oriented techniques to analyze real-world requirements and to design solutions that are ready to code. Students learn how to identify and design objects, classes, and their relationships to each other which includes links, associations, and inheritance. A strong emphasis is placed on diagram notation for use cases, class and object representation, links and associations, and object messages. Implementing Design Patterns - 3 days Design Patterns are proven solutions to recurring problems in object-oriented software systems. This course covers sixteen design patterns and includes detailed programming exercises to allow students to practice implementing selected patterns. Introduction to HTML - 1 day Students will learn how to use good HTML coding practices to create Web pages that work, and will continue to work in the ever-changing world of Web development. In addition, students learn concepts and do tasks that foster the transition from HTML to the most recent XML-based Web authoring language recommendation, XHTML 1.0, which will become the future standard. Cascading Style Sheets, which is a complementary technology to HTML that is changing the face of Web authoring will also be introduced. HTML Level II - 1 day Students will learn how to create Web sites with a variety of HTML elements and attributes, and create well-formed code that complies with the XHTML standard. HTML Level III - 1 day This course is designed to introduce developers to some of the lesser known or "advanced" HTML techniques supported in the 6.0 generation of browsers. With the emergence of more standards-compliant browsers, developers can begin to use these new techniques to build more efficient, usable, and standards-compliant Web sites. In addition, developers can begin to learn and use standards-compliant markup instead of the often messy and invalid code that cross-browser workarounds have required. Introduction to Java Programming - 5 days This intensive, hands-on course emphasizes becoming productive quickly as a Java 1.2 programmer. Students learn how to use Java 1.2 to implement real-world solutions, including both Web applets and server-side applications. Advanced JAVA - 5 days This intensive hands-on course explores advanced Java 1.2 language features and packages. Java programmers will be able to take the content learned and immediately apply it to the problems encountered on the job. J2EE- 5 days This course is an introduction to writing J2EE (Java 2 Enterprise Edition) applications An overview of J2EE technology is provided, followed by hands-on experience using JNDI and JDBC and writing Servlets, JavaServer Pages, and Enterprise JavaBeans. Introduction to PERL - 5 days Perl has been described as C, awk, sed, and shell programming all wrapped into one language. Learn how to take advantage of Perl's power through examples and extensive hands-on exercises. This course introduces object-oriented programming in Perl. Advanced PERL - 4 days Perl has evolved from its beginnings as an eclectic scripting tool for UNIX administrators into one of the most popular, influential, and widely-used computer languages in history. In this course, you will learn how to fully utilize the Perl programming language. Introduction to .NET - 1 day Get a clear understanding of .NET, its origin, architecture, applicability, and its probable impact on the development world. See .NET in action via functional examples and code. Most importantly visualize .NET possibilities for your own development efforts. VB.NET - 5 days Our comprehensive Visual Basic .NET course provides in-depth coverage of Visual Basic .NET features-from fundamental to advanced topics. This new seminar from AppDev will get you up to speed on all the new features and programming requirements including: VB .NET language features, the .NET framework, ADO.NET, object-oriented programming, Windows Forms, XCopy deployment, and much more... ASP.NET- 5 days (levels 1 - 3) Level 1 .NET represents a major advance in the way applications are designed on Windows. This change amounts to much more than just a some language syntax changes and a few new Wizards. This course briefly surveys the breadth of this monumental shift and then builds a foundation on which you can add the rest of your knowledge of .NET technologies like ASP.NET, Web Services, and Visual Studio .NET. Learn the essential things you need to know in order to move on with web programming, Windows application programming, Web Services, and more sophisticated programming with .NET. Level 2 In this course, you'll learn how to use Visual Studio .NET and Visual Basic .NET to build ASP.NET Web pages and XML Web services. You'll gain an understanding of the new architecture behind ASP.NET and how to use the new server controls. You also learn how to use ADO.NET to create data-driven ASP.NET Web forms. Level 3 This course takes you beyond the basics of creating Web pages and XML Web Services with ASP.NET, by presenting the techniques and concepts you'll need to build efficient, full-featured Web applications. You'll learn to inter-operate with non-.NET code, to manage session state, to re-use code by creating your own controls, to improve performance with output caching, to debug your application and trace its activity, to use advanced Web services features, to configure and deploy ASP.NET applications, to authenticate users and limit their access to resources, to handle multi-user data access conflicts, and to support mobile devices. C#.NET - 5 days In this course you will learn how to program .NET applications with C#. The course begins with an introduction to the fundamentals of the language, and quickly moves on to demonstrate how to write object-oriented code using this exciting new language. The heart of the course is a detailed description of writing Windows and Web applications, including Web Services, and interacting with back end databases through ADO.NET. WebSphere Studio - 2 days The course begins with an examination of the framework for developing applications. Such important development issues as database connectivity, profiling, team programming, and the plug?in development environment will be covered. Websphere Server Application Development - 4 days The course begins with an examination of the facilities and tools of IBM's core products: WebSphere Studio, VisualAge for Java, and WebSphere Application Server. A primary objective is to have students' become proficient with the interaction of WebSphere Studio tools and the appropriate use of each tool. The course then focuses on developing and debugging dynamic web content. A series of integrated workshops teach students to write and deploy Java applications using WebSphere Application Server. Topics unique to IBM WebSphere Application Server such as control, servlet deployment, and JavaServer Pages (JSP) will be highlighted. Performance and design issues are highlighted throughout the course. Websphere Application Server Administration - 4 days The course begins with an examination of WebSphere's Application Server installation and configuration options. A primary objective is to have students' become proficient with the steps required for administering and implementing security specific to WebSphere Application Server. A series of integrated workshops teach students to administer a range of different scenarios using WebSphere Application Server. Such important issues as recovery, reporting and workload management will be taught/demonstrated. Performance issues are highlighted throughout the course. WebGain Studio - 4 days The course begins with an examination of the components which comprise the framework of WebGain Studio and the methodology it uses for building Java Applications. A series of integrated walkthroughs and exercises teaches UML basics and StructureBuilder and the techniques for designing applications. Both JSP and EJB will be deployed in the WebGain environment. BEA WebLogic Server Administration - 4 days This course is intended for support personnel, webmasters, and web programmers who will be responsible for managing and configuring BEA WebLogic Server. Experience with Java and distributed systems, although not required, would be helpful. The course begins with an examination of the BEA WebLogic Server architecture and administrative tools and facilities. Students' will install multiple BEA WebLogic server configurations. Performance and security issues will be highlighted throughout the course.
Distributed Process-DATABASE Oracle Overview 1 Day: OR110 (Oracle 9i) or OR510 (Oracle 10g) This course provides an overview of Oracle and a review of relational concepts such as referential integrity, primary keys, foreign keys, locking, and programming considerations. Topics will also include Oracle architecture, SQL, SQL*Plus, TOAD and PL/SQL programming. Data Modeling 2 Days: OR160 with Data Warehouse Concepts 1 Day: OR165 This course introduces the principles and data modeling. It explains how to incorporate business requirements into a logical data model. The components of a logical data model are defined and how to represent this model as an entity relationship diagram. The normalization of data and how to handle complex relationships are also included. There is the option of an added 1 day class on data warehousing principles which includes the concepts of the star schema and the design of fact tables, event tables and dimension tables. Oracle Answers (Seibel Analytics) for End Users 3 Day: OR440 This course introduces students to the querying and analytical capabilities of Oracle Answers which is the Seibel Analytics product that Oracle purchased. Students learn the querying and analytical capabilities of Oracle Answers using Oracle BI Enterprise Edition (OBIEE) with the web interface. Students will learn to create, modify, run, and refine ad hoc queries and incorporate them into interactive dashboards. They will learn to view, chart, and analyze multidimensional data found in their reporting data warehouse. They will also learn about iBots, Briefing Books and BI Delivers. Discoverer Plus for Administrators 2 Day: OR142 (Oracle 9i) or OR545 (Oracle 10g) Oracle Business Intelligence (BI) Discoverer Plus is a web-based utility that can be used to specify queries and access data in the database according to the specifications given. BI Discoverer makes finding the data easier than it often is with other interfaces. This course gives participants hands-on experience with administration tasks for Oracle’s Graphical User Interface (GUI) based ad hoc query and data access tool – Discoverer. Students will build the End User Layer for Discoverer. Discoverer Plus for Endusers 2 Day: OR140 (Oracle 9i) or OR540 (Oracle 10g) This course introduces students to the querying and analytical capabilities of Oracle Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically, how to format query results to create customized reports, and how to export reports to many other applications, including MS Excel, HTML, and Oracle Reports. Oracle Application Development 5 Days: OR145(Oracle 9i) or OR555(Oracle 10g) This course provides developers with the skills necessary to code Oracle SQL queries and develop PL/SQL for procedures, functions and triggers. A brief introduction to relational database and Oracle architecture is provided. The course also includes the skills to create database objects (e.g. tables and indexes). Oracle SQL Fundamentals 3 Days: OR150(Oracle 9i) or OR550(Oracle 10g) This class provides the basic knowledge and skills needed to code SQL statements, and the new features of Oracle. In addition to SQL topics, the course includes relational database management system (RDBMS) concepts such as referential integrity, primary keys, foreign keys, locking, and programming considerations. The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Informix, etc. Workshops are executed using an appropriate interactive tool such as TOAD or SQL*Plus or company standard software. Oracle PL/SQL Programming 2-3 Days: OR151(Oracle 9i) or OR551(Oracle 10g) This introductory course provides you with the skills necessary to develop PL/SQL programs for procedures, functions and triggers. Topics include IF-THEN-ELSE, ELSIF, GOTO, LOOPS, WHILE, Cursor Control and error handling. There is a subsequent intermediate/advanced course; namely PL/SQL Workshop Oracle Database for Developers 2 Days: OR152(Oracle 9i) or OR552(Oracle 10g) This course will provided programmers and developers the understanding of the duties of a Oracle database administrator. On completion of this course, the students will have the foundation to communicate with their DBA’s. Hands-on labs reinforce the learning process. Oracle Database Administration 5 Days: OR153(Oracle 9i) or OR553(Oracle 10g) This course will combine lecture with hands-on programming to facilitate the student's understanding of the duties of a new Oracle database administrator for Oracle. Hands-on labs reinforce the learning process by allowing students to create and manage their own Oracle servers. Oracle Backup and Recovery (RMAN) 3 Days: OR154 (Oracle 9i) or OR554(Oracle 10g) This hands-on class is intended for experienced Oracle administrators who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. Personnel new to backup and recovery or those currently using user-managed backup techniques will benefit from this class. The course is a comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. The Oracle 10g course includes the new features such as Flash Database and others. Both courses contains many working examples and many hands-on workshop. Oracle PL/SQL Workshop 3 Days: OR197(Oracle 9i) or OR597(Oracle 10g) This course provides you with the advanced skills necessary to code Oracle PL/SQL programs with a focus on developing procedures, functions and triggers. Some of the topics include Dynamic SQL, user defined objects, external procedures, object methods, and collections but will depend on the version. Advanced SQL and Performance 3 Days: OR210(Oracle 9i) or OR560(Oracle 10g) This course provides an in-depth study of SQL, and application-based performance guidelines for relational databases with an emphasis on Oracle specific version. Topics include joins and subqueries and tuning through the use of EXPLAIN to examine the optimizer's access path decisions. These skills will be strengthened through extensive workshops and classroom lecture. This class is intended for both developers and DBA's. Oracle Reports 6i 4 days: OR310 This lab-intensive course is designed to lead developers through the steps involved in developing a report in Oracle. The course covers concepts involved in using the GUI report writer to build reports in various formats, which can include buttons, multimedia and OLE2 objects. This course is directed at Version 6i only. Oracle Reports 5 days: OR311(Oracle 9i) or OR510 (Oracle 10g) This course is designed to lead developers through the steps involved in developing a report in Oracle in a client-server environment or a web environment. The course covers the use of default reports, the use of wizards to assist in the rapid development of reports and how to format and output reports for the web using the Web Wizard. The course also covers adding PL/SQL code and parameters to reports to automate them. Oracle Forms 5 Days: OR320 (Oracle 9i) or OR520 (Oracle 10g) This lab-intensive course is designed to lead application software developers through the steps involved in building enterprise-scale Internet applications using the Oracle Forms product. We provide both Oracle 9i and 10g versions of this product. Oracle Data Warehousing 5 Days: OR410 This course considers how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, partitioned tables, materialized views, and others. Emphasis is placed on the parallel execution features of the database and how these can yield significant performance advantages.
Oracle Warehouse Builder 3 Days: OR416
Oracle Warehouse Builder 2 Days: OR418 TOAD Tips and Techniques 1 Day: OR460 Oracle 10g for Experienced
Developers: OR515
Distributed Process-PROGRAMMING
DB2/SQL Application Programming 5 Days This class provides the knowledge and skills needed to use DB2 and SQL in both interactive and embedded formats. It also includes information on DB2 concepts and facilities, referential integrity, locking, primary keys, foreign keys and data integrity, DB2 physical storage and programming considerations. Dynamic SQL is executed through SPUFI or QMF, and embedded SQL is executed using COBOL application programs. DB2 Embedded SQL Programming 2 Days This course provides training for skills needed to code DB2 embedded SQL in COBOL application programs. Topics include how to prepare DB2 programs, access DB2 databases using SQL, retrieve multiple rows of output using cursors and handle commit processing through COBOL programs. Advanced SQL/DB2 Performance 2 Days This course provides in-depth study of SQL especially joins and subqueries, and will strengthened these skills through extensive workshops and classroom lecture. A solid introduction to application-based DB2 performance tuning thru the use of EXPLAIN to examine the DB2 optimizer's access path decisions. COBOL II Programming 5 Days This class provides people with the knowledge and skills needed to code COBOL II application programs. It also covers effective use of the language for report generation using sequential file inputs. The course can easily be divided into two parts; namely a three-day basic, followed by two-day additional COBOL topics. COBOL II Refresher 3 Days This class provides the additional knowledge and skills needed to code COBOL II application programs for people who have basic knowledge of COBOL II. Topics include using VSAM file processing, variable length file processing, internal sort, multi-dimensional table processing, and dedugging techniques. In addition the course also presents principles of structure programming in COBOL coding and also covers effective use of the language. IBM COBOL II (OS 390) 1 Days This class provides the additional knowledge and skills needed to code COBOL II application programs in an IBM OS 390 environment. It is for people who have basic knowledge of COBOL II, and it provides a method for getting and manipulating a true four-digit year in a COBOL Program. Topics include COBOL Intrinsic Functions and LE Callable Functions, which are Year-2000 compliant in their handling of dates. TSO/ISPF 2 Days This course covers ISPF and provides an introduction to using TSO, MVS and SDSF. Students will learn the major functions of these tools in an MVS environment; such as browse, edit, and features available in the library function. They will also learn several valuable shortcuts, which will help make them more productive on the job. MVS JCL 3 Days This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to MVS/ESA. In addition to covering the basics of the JOB, EXEC and DD statements, the course provides the basics for MVS utility programs such as IDCAMS, IEBGENER and IEBCOPY. The course can be taught as a two-day class without the utilities. MVS JCL UTILITIES 2 Days This course provides the basic knowledge of commonly used MVS utility programs such as IDCAMS, IEBGENER, IEBPTPCH, IEBCOMPR, IEBCOPY and SORT/MERGE. The course is an excellent review of JCL and the control statements available for each utility. INTRODUCTION TO VSAM 3 Days This course provides the basic concepts of VSAM file processing and the facilities, such as IDCAMS and JCL usage, which makes VSAM easier to work with. This course also will provide an understanding of how VSAM uses objects such as catalogs, control intervals, control areas, indexes, etc. In addition, participants will practice creating these objects using IDCAMS. VSAM PROGRAMMING 2 Days This course provides the skills needed to code COBOL and COBOL II programs that access VSAM datasets. A pre-requisite to this course is an Introduction to VSAM, which can be added to the programming topics to provide information on both VSAM concepts and programming. CICS COMMAND LEVEL PROGRAMMING 5 Days This class provides the skills needed to code COBOL application programs using the CICS/MVS and CICS/ESA Command Level interfaces. CICS concepts and structures as well as programming detail, such as file control, DB2 access, program control and terminal handling, are included. Other areas of CICS are also presented: queue management, program preparation, testing and debugging. EASYTRIEVE PLUS 3 Days The course presents an introduction to EASYTRIEVE PLUS. The seminar is directed at developers extracting information from files to create reports. The course will utilize lectures, conversations, inquiries, adhoc testing, manual and online error report references, and extensive use of hands-on labs with coding exercises. DOS/VSE JCL 3 Days This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to DOS/VSE, POWER, and JECL. In addition to covering the basics of the JOB, EXEC and DLBL, TLBL, and EXTENDS statements, the course provides the basics for VSE utility programs such as IDCAMS, SORT, and DITTO.
Introduction to Information Technology 3 Days This course provides the basic concepts of information systems and computers as productivity tools. It provides an understanding of the information processing cycle, which includes input, process, output and storage. Networking, relational databases, programming, client server concepts and future trends are also discussed. An emphasis is placed on increasing the comfort level with computer terminology, acronyms and general information. Introduction to Client/Server 3 Days This series provides training for software developers in a Client/Server environment. Topics such as Oracle relational database, Unix, Object Oriented Design and Programming, Visual Basic, C++, and PL/SQL are included. The intended audience is people who develop software in a Client/Server environment, and the pre-requisite is a solid foundation in Information Technology. Introduction to Object Oriented Analysis and Design 1-2 Days This course introduces the features of object-oriented technologies to managers, programmers and analysts. The students will learn the benefits claimed for object-oriented technologies, as well as the reality behind the claims. The most common object-oriented programming languages will be identified. In addition, the role of object-oriented analysis and design will be described. Finally, the students will be given some guidelines to follow for initial object-oriented projects. Introduction to Relational Databases 1 Day This course provides relational concepts and facilities. There is an overview for DB2, Oracle, and SQL Server relational database management systems (RDBMS). In addition to management-level topics, the course includes areas such as referential integrity, primary keys, foreign keys, locking, and programming considerations. SQL Fundamentals 2 Days This class provides the basic knowledge and skills needed to code SQL statements. The SQL information is ANSI standards and can be applied to any relational database management system (RDBMS), including DB2, Oracle, SQL/Server, Informix, etc. Workshops are executed using an appropriate interactive tool such as SPUFI, QMF, SQL/PLUS or company standard RDBMS software. Structured Programming Logic - Part I 3 Days This course provides the concepts and fundamentals for designing structured programs before coding begins. Several methods are introduced for designing and documenting structured programs, such as functional decomposition, hierarchy charts and pseudo-code, as well as flowcharting. Topics include simple reports, summary reports with counts and totals, and programs with complex calculations. Structured walkthroughs are presented with each design. Structured Programming Logic - Part II 3 Days This course provides the concepts and fundamentals for designing structured programs before coding begins. Several methods are introduced for designing and documenting structured programs, such as functional decomposition, hierarchy charts and pseudo-code, as well as flowcharting. Topics include simple reports, summary reports with counts and totals, programs with complex calculations, multi-level control breaks, file updating, and table processing. Structured walkthroughs are presented with each design. Project Management Principles 1-2 Days This course presents methods and techniques that project managers can use to achieve success in the deployment of projects. It is based on the Microsoft Solutions Framework and provides 4 basic planning tools for managing projects; team model, process model, risk management process and the "trade-off triangle." Data Modeling 2 Days This course introduces the principles and data modeling. It explains how to incorporate business requirements into a logical data model. The components of a logical data model are defined and how to represent this model as an entity relationship diagram. The normalization of data and how to handle complex relationships are also included. Process Modeling 3 Days This course provides a practical approach to process modeling activities involved in the analysis phase of the typical systems development life cycle. It is applicable to the process modeling component of most methodologies and topics includes Data Flow Diagramming, Event List Processing, Action Diagrams, Decision Tables and Trees. Techniques for balancing of the process model to the data model is also discussed. Automated CASE tool usage is briefly discussed during the course. It is not applicable to object oriented analysis and design. | |||||||||||
![]() |
![]() |
ONYX Software Development Training 1439 Fairway Court, Chaska, Mn. 55318 |
|
|