This course teaches students how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for individuals working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.
Click Here to Request It.
2L285G – Quick Basics of DB2 10.5 Administration for Windows
This course teaches students how to perform, basic database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating database objects like table, indexes and views and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using various db2pd command options and monitoring using SQL statements with DB2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The locking performed by DB2 and the effect the application isolation level has on locking and lock wait conditions are covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).
The lab exercises are performed using DB2 LUW 10.5 for Windows. For some exercise tasks students will have the option to complete the task using a DB2 command line processor or using the graphical interface provided by IBM Data Server Manager.
6X136G – IBM Cloud Pak for Data – Foundations (V2.1.x)
This course will tell a holistic story of Cloud Pak for Data including collaboration across an organization, which is key in this platform. Applicable to all personas. Multiple use cases will provide understanding of how organizations can benefit from Cloud Pak for Data. A variety of features will also be explored, providing students with the insight on how to use the platform.
6X137G – IBM Cognos Analytics on IBM Cloud Pak for Data (V2.1.x): Dashboarding and Reporting
This offering provides analysts with an introduction to create dashboards with Cloud Pak for Data, and create dashboards and reports using the Cognos Analytics add-on.
6X139G – IBM Decision Optimization on IBM Cloud Pak for Data (V2.1.x)
IBM Decision Optimization allows students to run optimization models in IBM Cloud Private for Data, with a user-friendly environment in which they can combine optimization with data science. IBM Decision Optimization gives students access to IBM’s industry-leading solution engines for mathematical programming and constraint programming.
6X140G – IBM SPSS Modeler Foundations on IBM Cloud Pak for Data (V2.1.X)
SPSS Modeler is one of the add-on modules on IBM Cloud Pak for Data. This course reviews the basics of how to import, explore, and prepare data, and introduces the student to machine learning models with SPSS Modeler on Cloud Pak for Data. This training also applies to IBM Cloud Pak for Data System and IBM Cloud Private for Data.
6X141G – IBM Cloud Pak for Data (V2.1.x): Data Virtualization
This course will focus on the Data Virtualization add-on to IBM Cloud Pak for Data. Students will learn about the Data Virtualization technology and be able to create connections to remote data sources. The course will also cover how to create and manage virtual assets, such as database tables or views, from the remote data sources. Finally, the students will use those assets within IBM Cloud Pak for Data without needing to move any data.
6X235G – IBM Cloud Pak for Data (V2.5.x): Data Virtualization
This course will focus on the Data Virtualization add-on to IBM Cloud Pak for Data. Students will learn about the Data Virtualization technology and be able to create connections to remote data sources. The offering will also cover how to create and manage virtual assets, such as database tables or views, from the remote data sources. Finally, the students will use those assets within IBM Cloud Pak for Data without needing to move any data.
6X240G – IBM Watson OpenScale on IBM Cloud Pak for Data (V2.5.x)
This offering teaches students how IBM Watson OpenScale on IBM Cloud Pak for Data lets business analysts, data scientists, and developers build monitors for artificial intelligence (AI) models to manage risks. Students will understand how to use Watson OpenScale to build monitors for quality, fairness, and drift, and how monitors impact business KPIs. Students will also learn how monitoring for unwanted biases and viewing explanations of predictions helps provide business stakeholders confidence in the AI being launched into production. Note: This course contains the same topics as W7069G Watson OpenScale Methodology WBT.
6X241G – IBM Watson Knowledge Catalog on IBM Cloud Pak for Data (V2.5.x)
This offering provides analysts an introduction to the basics of IBM Watson Knowledge Catalog on IBM Cloud Pak for Data. Learners will be introduced to the Cloud Pak for Data product layout and functionality and the role of services within the product. Students will learn to access the Watson Knowledge Catalog through the service, and gain skills in creating catalogs, populating them with assets, and then managing the assets in the catalog.