ExitCertified - Canada
Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg, Canada
http://www.exitcertified.com/

DB2 UDB Advanced Programming

This course replaces CF113. Learn how to take advantage of advanced programming techniques to access DB2 databases in the workstation environment. You can use these techniques in addition to the standard embedded SQL calls that you learned in the prerequisite course: DB2 UDB Programming Fundamentals (CF104) ...
 

Address the use of the data quality assurance methodology and the AuditStage software in a DataStage XE warehouse application. Get a conceptual overview of data quality assurance in a warehouse, followed by detailed instruction in the use of the AuditStage manager software. Learn to organize a data quality analysis project and to build and package data filters to perform quality analysis. Concl......
 

Learn how to plan for, install, configure, manage, and perform problem isolation on an IBM TotalStorage DS4000 (formerly Fibre Array Storage Technology (FAStT)) Storage Area Network (SAN) in this hands-on course. Emphasize using Storage Manager and TotalStorage Productivity Center (TPC) to manage and monitor all aspects of the SAN....
 

Using the DataStage Mainframe edition, learn to build Extraction, Transformation, Load (ETL) jobs that run on the mainframe. These jobs extract data from a variety of native mainframe sources, including Common Business Oriented Language (COBOL) files, DB2 tables, Information Management System (IMS) databases, and Teradata databases. After transforming the data, these jobs can load the data into......
 

Gain knowledge on WebSphere Information Integrator Queue (Q) Replication’s use of WebSphere MQ to perform queue based data replication activities between IBM relational database systems and between IBM and non-IBM relational database systems. Learn to use Q Replication’s highly parallel, transaction based, asynchronous message based transmission capability. Compare Q Replication’......
 

In this course, updated to IBM Query Management Facility (QMF) Version 8, build on your previously acquired knowledge of SQL and DB2. Learn how to use QMF to access data and how to use QMF’s very powerful report formatting capabilities to produce tailored reports. Learn to direct QMF’s activities using the QMF command language and the ins and outs of writing QMF Procedures (PROCs)......
 

Learn about the features of DB2 UDB Data Warehouse Edition (DWE) Version 8.2. Create user / system profiles and management classes in Query Patroller in order to maximize the throughput of your DB2 UDB for Linux, UNIX, and Windows system. Use DB2 Alphablox to access DB2 tables defined as a star schema as though they were a multidimensional database.Through extensive hands-on exercises, use the ......
 

After an overview of relational concepts that are important for designing relational databases, learn about the different views of the data of the application domain and the steps included in this comprehensive relational database design methodology. These steps include: Analyzing a problem statement for an application domain Establishing an Entity Resolution (ER) model to visualize a......
 

Learn how to retrieve data from a relational database and how to use QMF’s very powerful report formatting capabilities to display the data in various types of reports. Use hands-on lab exercises to help build your QMF and SQL skills. Learn how to write queries in two query languages: SQL and Prompted Query. Also, learn the QMF command language and how to write QMF procedures, which ar......
 

WebSphere Federated Database Technology, as implemented by DB2 UDB and WebSphere Information Integrator (formerly known as DB2 Information Integrator), provides unparalleled capabilities to access and manage both relational and non-relational data spanning multiple data sources, including multivendor, from a single query, all of this with superior performance. This is true cross platform multid......
 

Continue developing your management skills by monitoring, tuning, and troubleshooting a Federated Database environment. Learn the configuration options for all supported DB2 UDB and DB2 Information Integrator data sources and how to tune the Federated Server for maximum Federated Database performance. Complete hands-on exercises between DB2 UDB for Windows, DB2 UDB for z/OS and OS/390, DB2 UDB ......
 

Learn practical methods and techniques for designing and constructing a Data Warehouse (DW) and to provide a comprehensive Business Intelligence (BI) solution architecture. Apply the techniques in the context of an incremental process, suitable for constructing a DW and BI solution from a departmental or functional workgroup perspective. Also, learn how the process can be extended further for t......
 

Are you new to the CICS system programming job and ready to install and tailor CICS Transaction Server (TS) for z/OS? Learn how to tailor the system to support a basic online application. Practice these skills on an IBM system in this lab-intensive course. Define transactions, programs, files, and other resources used by online applications. Lectures include problem determination tools, intersy......
 

Develop the practical skills you need to use the CICS Web Support (CWS) Application Programming Interface (API) and the 3270 Web Bridge supplied with CICS Transaction Server (CICS TS) 1.3. Through lectures and hands-on labs learn the various components of CWS, Hypertext Markup Language (HTML), JavaScript, Hypertext Transfer Protocol (HTTP), Hypertext Transfer Protocol Secure (HTTPS), and form d......
 

This course replaces U3924. Learn how to implement the CICS-DB2 attachment facility. Learn how to configure CICS-DB2 system, monitor the attachment facility, and establish attachment facility security and recovery procedures. In addition, learn about the new attachment supplied with CICS Transaction Server (TS) for z/OS Version 2....
 

Learn the basics of designing, coding, and debugging CICS application programs for e-business or traditional IT environments in this lab intensive workshop. Practice these programming techniques in either COBOL or Programming Language One (PL/I) computer exercises. ...
 

Learn how to analyze problem related information provided by CICS Transaction Server (TS) for z/OS Version 3 Release 1. Complete extensive online lab exercises that develop your skills as a system programmer new to problem analysis. If you are already experienced with CICS TS V1 or V2 problem analysis, you should attend: CICS Transaction Server for z/OS Transition from V2 to V3.1 (CI981) ......
 

Are you new to the CICS or just want to uncover the mystery of CICS transaction processing? Learn about major CICS concepts and facilities that are applicable to the CICS family of products. Focus on transaction processing and online system management. Learn about the CICS Application Programming Interface (API) along with general guidelines and programming aids that support application develop......
 

The Unix Fundamentals course teaches you how to use basic Unix Operating System Commands. The course is for new users of the Unix environment. You will learn fundamental command-line features including file system navigation, file permissions, the vi text editor, command shells, and basic network use....
 

This highly technical course focuses on properly securing machines running the Linux operating systems. A broad range of general security techniques such as packet filtering, password policies, and file integrity checking are covered. Advanced security technologies such as Kerberos and SELinux are taught. Special attention is given to securing commonly deployed network services. At the end of t......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z