Submit DB2 Questions

Enrollment

Knowledge Base

Contact You

DB2 UDB New York Schedule   Programming Languages Schedule

Mainframe Schedule   Cost Analysis

DB2 and Oracle SQL and PL/SQL

Starting with DB2 version 9.7, IBM supports Oracle SQL and PL/SQL. IBM has aligned the syntax and semantics with the locking mechanisms, data types, SQL, procedural language residing on the server, and the client interfaces used by the applications.

IBM has resolved the concurrency control with Oracle by reading the currently committed version of the changed row and retrieving the locked row from the log. In most cases, since the change has not been committed, the row will still be in the log buffer. However, even if the row has been written out and overwritten in the log buffer, DB2 will know exactly where to find it. The single I/O will bring the required version into the bufferpool. Additional lock avoidance techniques have been added which eliminate a reader holding a lock under CS isolation.

DB2 supports a library of functions compatible with Oracle for operating on data. Mismatched types or mismatched semantics of the types can seriously impact the ability to enable an application to another RDBMS. In order to allow Oracle applications to run on DB2, a number of data types commonly used in Oracle's PL/SQL have been added in DB2 9.7. When an application is ported from one product to another, the SQL and procedural language is translated from one SQL dialect to the other. The DB2 engine includes a PL/SQL compiler along with the SQL PL compiler. Both compilers produce virtual machine code for DB2's SQL Unified Runtime Engine.

In addition to the foundation DB2 design, application development, and database administration courses for the z/OS, z/VSE, z/VM mainframe operating systems, SYS-ED offers a comprehensive multi-platform DB2 curriculum and specialized courses which teach the DB2 APIs.

DB2 Release 10 Workshops

SYS-ED workshops demonstrate and explain:

• data types for decimal floating point and spatial data.
• built-in function compatibility within the DB2 family and for third party and open source databases.
• XML functions for Java and web applications.
• Java Universal Driver.
• How to use REORG for improved performance and availability.
• New partitioning, clustering, and index options.
• Dataset level Flashcopy support for multiple utilities for improved CPU utilization and reductions in elapsed time.
• zIIP-enabled RUNSTATS to perform page-level and auto-sampling rates.

The DB2 courseware provided in SYS-ED instructor-led and distance-learning training services are highly respected. The sample programs and exercises were developed, updated, and tailored to teach DB2 on multiple platforms. SYS-ED's DB2 courseware is updated with information from the CETi knowledge base, and FAQ's frequently asked questions. The principles of adult learning have been applied to the subject matter: interpreting and translating content into performance objectives, narrative descriptions, and diagrams which explain. The full complement of training medium is used to help business and information technology professionals learn. As part of presenting an instructor-led DB2 course at the client location, courseware is evaluated and organized for subsequent use in a web-based infrastructure and delivery medium. This service is provided free of charge.

Mainframe in Transition -
State of the Market

Alternative to the Information Technology Training
Offered by the Software Companies

Longstanding Consultancy Experience
in Information Technology

Portfolio of DB2 Clients

Industry Standard Courses

Recognized Experts in DB2

SYS-ED is software company independent. Our mission is to provide the expertise for developing skilled employees that will be responsible for administering, coding applications, updating, and optimizing DB2 UDB databases.

Caveat Emptor

• Review the DB2 learning paths.
• Read the technology assessments and CFAQs - course frequently asked questions.
• Examine the content in our DB2 UDB courseware and training aids.
• Utilize our DB2 skillset assessments.
• Interview our systems consultant/instructor.

SYS-ED has been conducting courses in the public domain since 1980; however, there have been changes in the laws and regulations governing computer training in the state of New York. The schedule on our websites reflects a projected time frame for licensure with the New York State Department of Education - Bureau of Proprietary School Supervision and submission and approval of curriculum.

Content Delivery Selection

Get on the Fast Track .......

Mainframe Catalog

News for Immediate Release

Consulting companies recommend SYS-ED in conjunction with distance-learning for DB2 UDB programming, database administration, and web enablement training.

DB2 UDB Application Development and Web Enablement Training Program

All IT personnel will need to learn new skills for the z/OS environment in order to implement the next generation of technologies - DB2 UDB, WebSphere MQ, WAS, and Rational. Training will cut across generations - some very experienced people will be learning web enablement technologies; while first generation IT staff will be using ISPF, JCL, and “tried and tested” mainframe programming languages, such as COBOL for the first time. Training programs based upon the use of various training techniques have been chosen for suitability to the particular course material and audience as well as scheduling and class size requirements.

The following methods will be used for introductory material for personnel, most operator training, and programmer training on selected topics.

• Distance-learning will be used for introductory training for personnel, most operator training, and programmer training on selected subjects.
• SYS-ED in New York will be used for their 3-day DB2 UDB Stored Procedures, 4-day DB2 Java Programming, 4-day DB2 UDB: Systems Performance and Tuning, 4-day WebSphere MQ System Administration, and 4-day WAS: WebSphere Application Server courses.
• IBM Education Center offerings will be used for specialized operations training.

The plan is to have the entire programming staff and four or five people from operations complete the distance-learning training and then take the SYS-ED instructor-led courses. Based upon feedback from this group, we will either confirm this mix or make adjustments as needed.

On a long range basis, we plan that all of the programmers and operators will be trained in both z/OS and the new web technologies. The exact schedule will depend on the other workloads of the staff. System programmer education would be mostly completed during this period, although specialized courses may be taken later in the year.

Evolving IT - Interrelated Technologies

Information technology training for organizations is more complex and challenging than ever before. There is a substantial investment in infrastructure and applications specific to their operations. New industry standard protocols, web server and web enabled technologies require development from scratch or integration with the existing system software and enterprise databases. There will be long term implications regarding the strategic mix of commercial and open source software which is selected, along with decisions on whether to maintain and upgrade the existing legacy applications, while retrofitting and transitioning to the new technologies. SYS-ED trained a significant portion of the first generation of DP personnel. And looks forward to training their IT successors in the 21st century.

Select a DB2 UDB Course Category.

Selecting/invoking a category will provide the courses within the category. Selecting/invoking on a course will provide the audience, topics, and fee.

DB2 UDB: Database Administration	DB2 UDB: Application Programming
DB2 UDB: Performance and Tuning	DB2 UDB: Transition
IBM SOA Development Software
WebSphere MQ	WebSphere Application Server
Java	Rational

DB2 UDB Training in New York

DB2 Courses in New York
SYS-ED's DB2 courses are tough, but they're worth it. Our challenging "hands-on" DB2 training provides a foundation and framework for Fortune 1000 companies, government municipalities, healthcare providers, software houses, and consulting companies to meet their DB2 staffing requirements and acquire specialized DB2 skillsets.¹

Courseware
SYS-ED's DB2 courseware is highly respected. We draw upon our extensive library of courseware, sample programs, and case studies to explain, demonstrate, and teach the real-world DB2. Our DB2 curriculum include industry standard and consultancy derived content. We have the capability to provide tailored workshops and integrated training programs on z/OS, z/VSE, z/VM, and third party emulation workbench/platforms.

Teaching is Our Business
Most computer training companies are divisions of large software companies or consulting companies. Not SYS-ED. Our only goal is to provide world class DB2 training for highly motivated IT professionals - no more and no less. Because we're independent, we're free to concentrate on teaching - and since 1980 we have been doing it very well.

Our Teachers Know How to Teach
SYS-ED instructors combine teaching skills with broad practical experience as consultants. Our instructors average 25 years of experience with DB2 - operating systems, programming languages, third party utilities and development tools, and system software. And they know how to teach it. We teach not only "how to", but "why", building a solid foundation in fundamentals and insights into advanced materials. After a course, they are available to answer questions.

Enrollment - SYS-ED DB2 Courses are NOT for Everyone
No one is allowed to enroll in a SYS-ED mainframe course, without a consultation with our Director of Education. We review the operational objectives and project specifications fo for the organization evaluating whether to send its employee for the training. The employee is only allowed to register if they have the background corresponding to the appropriate learning path.

DB2 Training in New York, at Your Office, or via the Web
SYS-ED DB2 courses are held at our training center in Manhattan and in conjunction with CETi Technology Partners in North America and Europe. If you prefer, we'll arrange tailored mainframe training on-site at your organization’s facilities inclusive of mobile computer classroom set-up. On-site mainframe courses can include the identical workshops, case studies, and hands-on approach as the mainframe training we offer in New York.

For additional information including outlines, availability of private courses, references, and course customization, contact David Shapiro at our New York office at 212-564-9147 or register online.

Footnote 1:

SYS-ED’s core DB2 and mainframe curriculum have been submitted to the New York State Department of Education - Bureau of Proprietary School Supervision for review and licensing.