DB2 Technology Update

DB2 Training

Home

• Transitioning from older versions of DB2 UDB.

• Explanation of the protocols serving as the foundation of web services and utilizing XML and Java with DB2 UDB.

• Upgrading applications to utilize the emerging service oriented architecture standard.

• Demonstration of interoperability with DB2 and Java and identification of pitfalls.

• Introduction.
• The Relational Model.
• DB2 Utilities and Commands.
• Security and Integrity.
• Dynamic and Static SQL Embedded.
• DB2 Releases and Related Products.
• The Relational Model.
• Physical Design and Efficiency Techniques.
• Data Sharing and Locking Enhancements.
• OOPs Features in DB2.
• DB2 Tools.

• Fundamentals of DB2.
• Structured Query Language.
• Retrieval and Update Operations.
• SQL Functions.
• Table and View Design.
• Embedded Retrieval and Update Operations.
• DB2 Architecture.
• Locking.
• Performance.
• Explain Command.
• Query Management Facility.

• DB2 UDB and the Relational Model
• DB2 UDB Components and Concepts.
• DB2 UDB Installation.
• Creating Objects.
• Moving and Loading Data Backup, Logging, Recovery.
• SQL for Administrators (1).
• SQL for Administrators (2).
• Scaling the Database.
• Application Considerations.
• Connectivity Considerations.
• Security.
• Concurrency.
• Performance Measurement and Tuning.

• Advanced SQL Programming Techniques.
• Dynamic SQL Processing.
• Stored Procedures.
• Triggers.
• Planning For Concurrency and Locks.
• General Efficiency Techniques.
• Table and View Design.
• Performance and Tuning.
• Recovery and Security.
• Call Attachment Facility.

• Getting Started.
• Programming Environment.
• Developing Stored Procedures.
• COBOL Stored Procedures.
• Defining an SQL Procedure.
• WLM: Workload Manager.
• Accessing CICS.
• DB2 Stored Procedures.
• Create Procedure.
• Procedure Commands.
• Stored Procedure Catalog Information.
• Stored Procedure Performance.
• Commit in Stored Procedure.
• Special Registers.
• Linkage.

• Introduction.
• Monitoring and Reporting.
• Hardware and DB2.
• Processing DB2 Transactions / Queries.
• Thread Allocation and Workload Control.
• Buffer Pools, Memory, and I0.
• Locking and Concurrency.
• Utilities and System Considerations.
• Monitoring Strategy.
• Problem Investigation.
• Optimizer, Access Paths, Explain.

• Product Information and Facilities.
• Multisite Updates.
• Db2 Connect Connectivity.
• Programming DB2 Connect.
• Accessing DB2 Databases.

• Introduction.
• Coding a DB2 Application in Java.
• JDBC API.
• JDBC Programming.
• JDBC Programming: Advanced.
• Prepared and Stored Procedures.
• DB2 Application Techniques.
• DB2 UDB Visual Explain.

• DB2 Replication and Publishing Overview.
• SQL Replication Tasks.
• Using the Replication Center.
• Replication Control Tables.
• Replication Sources.
• Subscription Set.
• Capture and Apply Operations.
• Monitoring SQL Replication.

DB2 Training Portfolio

Mainframe Catalog

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.

Transition	Application Programming: z/OS
Programming: UNIX and Windows	Database Administration: z/OS

DB2 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 acclaimed in the IT field. We draw upon our extensive library of courseware, sample programs, and case studies to explain, demonstrate, and teach the real-world DB2. Our DB2 curricula 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 in the mainframe environment - operating systems, programming languages, 3rd party utilities/development aids, 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 for the organization evaluating whether to send its employee for the training. The employee is only allowed to register if they have the appropriate background corresponding to the correct learning path.

DB2 Training in New York or at Your Office
SYS-ED DB2 courses are held at our modern, fully equipped training center in New York City and in conjunction with training 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 city.

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, 48, 49 or register online.

Footnote 1:

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