SYS-ED DB2 Technology Assessments DB2 UDB Training
The Computer Education Professionals

DB2 Training Sitemap

DB2 UDB Training by the DB2 Experts

Genre of DB2 Training
Better than IBM! Demonstrated Excellence with DB2
   
SYS-ED courses teach the
hardware driven enhancements to DB2:
  • Parallel Sysplex data sharing.
  • Clustering with the DBF: Database Partitioning Feature.
  • Base 64-bit processing requirements.
  • XML native support.
  • OLTP-related improvements for distributed platforms.
  • Business intelligence and data warehousing for z/OS.
  • Self-tuning and self-managing features.
  • Performance enhancements for stored procedures.

Information Technology in Transition

Information Technology in Transition


z/OS Courses Advanced search

IBM WebSphere and Rational Development

  

SYS-ED Training Service

DB2 for Data Mining and BI Application Development

Brought to market in 1983 by IBM for its MVS mainframe platform, contemporary DB2 is a multiplatform object-SQL Database Management System: z/OS, z/VSE, z/VM, UNIX, Linux, and MS Windows servers, iSeries, and IBM InfoSphere Warehouse editions. IBM has been promoting DB2 for its central role in its SOA: Service Oriented Architecture for updating and integrating existing investments in legacy programming languages and mainframe system software. To further advance this strategic agenda DB2 has been extended to accommodate open source software and third party databases. DB2 for z/OS has few direct competitors.

DB2 offers comprehensive API programming language support:

IBM Mainframe Client/Server Languages and Development Platforms 1 FOSS: Free Open Source Software 2
COBOL Fortran PL/1 REXX RPG C C++ Borland - Delphi Microsoft CLI and .NET Oracle - Java and WebLogic Java Perl PHP Python Ruby

Rational Developer for System z is the IBM development platform for modernizing existing assets and deploying new applications. Tools are providing which assist in the creation of relational databases: designing databases, managing schemas, and writing queries against local and remote data. Rational Developer for System z supports SQL: Structured Query Language, DB2 stored procedures, and integration of DB2 with XML.


Teaching DB2 and IBM's Smart Software

SYS-ED staff and CETi Technology Partners have been evaluating the IBM advertisements, DB2 UDB product announcements, trial software, and in-production code for developing courseware and teaching; 1- Standards-based capabilities for SOA: Service Oriented Architecture requirements. 2- SQLJ and JDBC support. 3- UNICODE support. and 4- WebSphere integration. Exercises and case studies have been added to our courseware library for provisioning and reconfiguring system resources and optimizing DB2 performance. Benchmarks and best practices are presented in conjunction with teaching planning and transitioning to extended infrastructures and a cloud computing delivery model.


DB2 Training - Performance Objectives and Content Delivery

A predictable professional information technology training outcome requires an accurate recognition of a client's performance and operational objectives and the appropriate extension of industry standard subject matter. It is SYS-ED policy to provide code snippets, examples, and exercises which highlight efficient performance design and coding techniques. We refer to it as educational consultancy, more specifically it is working with the prospective client to identify and differentiate between a course - DB2 UDB: Application Programming and MS Windows.NET ASP.NET and ASP/DB2 Workshops and DB2 UDB: Programming in Java with JDBC as compared to teaching and addressing operational requirements: DB2 UDB: System/Disaster Recovery and DB2 UDB: System Performance and Tuning with Data Warehousing.

Industry Standard Content Transition and Migration Educational Consultancy
Teach the topics and skillsets designated by the source software company and have case studies and workshops which provide experience to perform specific tasks. Apply the transitional releases of DB2 in relation to the client system software environment and other databases: Oracle, SQL Server, Sybase, and MySQL. Identify and teach subject matter which addresses client-specific operational objectives by incorporating client project specifications into the course lesson plan.


An underlying cause for an instructor-led DB2 course failing to meet its stated performance objectives occurs when the training vendor has not selected the subject matter and calibrated the examples, case studies, and exercises to the true underlying requirements of the client organization and the ability of its employees to learn. Pre course planning is used to apply the guidelines prescribed in classic adult learning theory and designate the training service to be used in addressing client-specific performance objectives.

This checklist provides a framework for executives, management, and project leaders to select the delivery medium and courseware specific to its operational requirements and budget.

Client Review Process:
1- How its Employees can Efficiently and Best Learn		 Component Training Service:
Industry Standard Courses, Educational Consultancy, and Training Programs
Learning Paths New York State
BPSS-30 Lesson Plan		 Courseware for Teaching Examples and
Code Snippets		 Exercises Completed
Assignments - Log
Demonstration of Prerequisite Knowledge - Required            
Provide Foundation for Deductive Reasoning            
Extrinsic Employee Motivation Required            
Review and Reinforcement of Subject Matter and Performance Objectives            
Subject Matter Expert Centered Content Delivery            
Require Traditional Classroom Instruction            
Require Availability of Optional Self-paced Learning            
Learning Support - Informal and Available Outside of Standard Business Hours            
2- Required Training Outcomes            
Post Course Evaluation - Client, Vendor, Third Party or Combination of All Three            
Meet Organization-specific Standards            
Generate Project Deliverables - Grade the Deliverable            
Meet Certification Standards - Source Software Company            
Meet International Standards - Demonstrate            

Courseware for Teaching

Computer Education Techniques courseware used in SYS-ED courses is designed for use in teaching and measuring mastery of DB2 UDB subject matter. It is highly valued in those areas of information technology where there is a scarcity of industry standard textbooks: IBM mainframe systems, open source software, and increasingly hybrid information technology.

At the client discretion, CETi courseware can be used in conjunction with an industry standard text book, NRV curriculum, and source vendor documentation.

Component Courseware Technology Updates Industry Standard
Text Book		 Software Technology
in Transition		 NRV: Nationally Recognized Vendor Curriculum CETi
Knowledge Base		 Source Vendor Documentation Validation Assessment


The CETi courseware library is being transitioned for use in multiple delivery medium and meeting the standards of the New York State Department of Education Bureau of Proprietary School Supervision:

DB2 IBM WebSphere and Open Source Software Java Development Platform and Language Information Technology Infrastructure
Mainframe Mainframe Legacy Programming Languages Mainframe Utilities and Development Tools
Open Source Software Web Development and Internet Programming Web Servers

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.

Why SYS-ED for DB2 Training

Since the late 1980s, SYS-ED staff and CETi Technology Partners have been providing DB2 UDB consultancy services for Fortune 1000 companies, government municipalities, and healthcare providers: DB2 application programming, administration, system performance, and web enablement. This hands-on experience has served as a foundation for the compilation of our knowledge base and independent assessment of DB2 documentation which explains the architecture and underlying design of IBM DB2 Enterprise Server Edition and the development languages that DB2 was written in: PL/S for the mainframe, C++ for the server, and Starburst Optimizer for SQL cross platform SQL optimization.3  In conjunction with teaching DB2, we have authored DB2 text books and developed DB2 training aids. The DB2 courseware incorporates information from the CETi knowledge base inclusive of an interpretation of IBM manuals and red books. The CETi courseware has been developed based upon the standards mandated by the New York State Department of Education and designed for helping information technology professionals learn DB2. 4

Equally as important, we are longstanding experts in hybrid operating environments: 1- mainframe - z/OS, z/VSE, and z/VM, 2- UNIX - Solaris, Linux, 3- MS Windows and 4- MS.NET, and 5- programming languages - COBOL, Java, and 6- middleware - WebSphere MQ. This expertise provides a privileged perspective from which we explain nuances, challenge IBM guidelines, and much to IBMs chagrin, point out the glitches in DB2 UDB which do not work as advertised. Once the DB2 training has been completed, we invite client's to submit DB2 questions. And by the way we do get requests from major software and consulting companies to train their clients and staff.

So when it comes to your DB2 UDB training needs, by all means contact IBM and review their course outlines, lesson plans, performance objectives, and courseware. Then e-mail us to schedule a complimentary consultation at dshapiro@sysed.com or dsilverberg@sysed.com or call 212-564-9147. 

SYS-ED/New York Schedules


DB2 Training Advanced search

DB2 Schedule

WebSphere MQ Schedule

Mainframe Schedule

SYS-ED DB2 courses are not open to the general public. Only employees sponsored by Fortune 1000 corporations, government municipalities, healthcare providers, and consulting companies are allowed to enroll in a SYS-ED course and only after a telephone consultation with our Director of Education. This is essential for ensuring that the individual be placed in the course which corresponds to the employers operational objectives, operating environment, version of DB2, and development platform. The search engine can be used for researching course titles and topics.

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. It will be updated quarterly.

Private Courses

SYS-ED teaches private courses in North America and Europe. With private courses, topics can be mixed and matched from multiple course outlines and the workshops tailored. Case in point; several of our fast-track clients have had us conduct accelerated 5-day courses consisting of what is regularly 8 days of subject matter.

Blended Learning Web-based Content Delivery
Technology Driven Classrooms Web-based Training Distance-learning M-learning


SYS-ED's distance-learning training service is 65% lecture with the remaining 35% of the service provided in the form of scheduled interactive question and answer sessions with a subject matter expert, hands-on exercises, optional validation assessment, and submission of questions through our technology exchange websites.

Enrollment is contingent upon the prospective trainee's having been qualified by our Director of Education to have the appropriate background for the training and review of a checklist of items required for transmission of the service to the client location: bandwidth, firewall, base operating system, software requirements, web browser, and set-up of hands-on machine exercises.

Alternative web-based and e-learning training is available: self-paced, presentation through the client's authoring system, or podcast.
DB2 Versions - Selecting the Subject Matter
DB2 Version 8 DB2 Version 9 DB2 Version 10


DB2 Distance-learning Curriculum
DB2 SQL Fundamentals DB2 QMF: Query Management Facility DB2 UDB: Application Programming
DB2 UDB: Application Programming - Advanced DB2 EXPLAIN DB2 UDB: Stored Procedures - Advanced
DB2: Debugging with Xpediter File-AID: DB2 File-AID/RDX (DB2)
DB2 UDB Stored Procedures DB2 UDB: Java Stored Procedures DB2 UDB: Programming in Java with JDBC
DB2 UDB: Relational Database Design DB2 UDB: Database Administration DB2 UDB: Database Administration - Windows
DB2 UDB: Database Administration - Advanced DB2 UDB: System Performance DB2 UDB: System Performance and Tuning

Contact our New York office for additional information on the selection of content delivery.

Right to Privacy
 SYS-ED does not send out unsolicited e-mail. You are receiving this e-mail because you are a past customer or have voluntarily provided an e-mail address through our web site.

Unsubscribe
 In order to remove your name from our e-mail list, reply to this message and type REMOVE in the subject line of your reply.

Technology Exchange Websites
SYS-ED's websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer: web-based training, classroom instruction, courseware, learning paths, and validation assessment.

http://www.db2trainingbysysed.us/commquests.htm

Footnote 1:
 Several of the leading software companies provide both financial and technical support for the development of open source software. They also will typically have their own specialized versions of open source software integrated with their proprietary software: 1- IBM Corporation with Linux, Java and Rational, and MySQL and DB2 2- Microsoft Corporation with C and Visual C++ 3- Oracle Corporation with Solaris, Java, and MySQL.

Footnote 2:
A shaded gray cell in a table indicates that the software is available free of charge through a GPL: General Public License. FOSS: Free Open Source Software is downloaded and courseware updated prior to use in order to teach the latest version in the public domain or the version in use by the client in its information technology infrastructure.

Footnote 3:
 PL/S: Programming Language/Systems, is a machine-oriented programming language based on PL/1. Developed by IBM in the late 1960s as a replacement for assembly language on internal software projects; it included support for inline assembly and explicit control over register usage.

Footnote 4:
 SYS-EDs 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.