| Course Title |
Duration |
Description |
Databases Series
|
Databases – Introduction to Databases and Database Managers
|
4 |
This course provides you with a core understanding of the need for databases, the way they are structured, and the type of information they can hold. It describes the types of database models that you are likely to encounter and describes their pros and cons. The use of a Database Management System (DBMS) is discussed, providing examples of functionality and features that are often employed by users of it. Finally, you will see how a database is defined and configured, along with the types of tasks that need to be performed as part of this process. |
Databases Introduction to SQL
|
4 |
This course begins by providing you with an overview of SQL functionality, and describes how SQL is used to obtain data from a database table. Once data has been obtained there are many scalar and aggregate functions that can be used for purposes such as creating a subset of that data, or manipulating the data itself into another format. This is discussed in detail. Finally, you will see how data can be added to a database, and how it can be modified, and deleted. |
Databases – Advanced SQL
|
4 |
This course provides you with more in-depth uses of SQL. It begins by examining how data from multiple tables can be joined together, and how different types of JOIN statements can be used to achieve your goal. You will also see how specific data can be selected from tables and how conditional operations can be invoked based on data values. The merging of results from multiple SELECT statements is also presented. Finally, you will see how a SELECT query can exist within another SELECT statement. These are called subqueries. |
Databases – Database Manager Resources
|
4 |
This course starts by providing you with the methods used to create a database and its components. It then introduces you to the commands used to alter database component attributes and shows you how to remove data. You will see how commonly used instructions can be saved as a stored procedure, and the benefits they provide. You will then look at user-defined functions (UDFs), how they are created, and how they differ from stored procedures. Finally, you will be presented with various methods for securing your database. |
Databases – Database Communication
|
4 |
This course describes how local and remote clients can connect to a DBMS server. It discusses connection options including the use of APIs. You will also see how an administrator can view existing client connections and configure the DBMS to place restrictions on client activity. Finally, you will see how replication provide copies of database systems on alternate DBMS servers. This is useful for redundancy purposes. |
Db2 v12 Operations Series
|
Db2 - Db2 Fundamentals V12
|
5 |
The Db2 Fundamentals course describes what Db2 is, how it is used and the components that comprise its structure. An overview of the SQL language, which is used to communicate with Db2, is provided along with details on how it is used with SPUFI. |
Db2 - Managing Db2 Operations V12
|
4 |
The Managing Db2 Operations course looks at Db2 from an Operations viewpoint, describing Db2 startup and shutdown, common operator tasks, message interpretation and restart and recovery considerations. A number of commands used to analyze the status of Db2 components are discussed as well as the facilities associated with backup, recovery and restart. |
Db2 v12 Database Management System Series |
Db2 - Introduction to RDBMSs and Db2 V12
|
4 |
The Introduction to RDBMSs and Db2 course describes from a Database Administrator's (DBA) viewpoint how Db2 is used and the types of Db2-related tasks that the DBA performs. The course also looks at Db2's system configuration requirements and how it is implemented in a z/OS environment.
|
Db2 - Manage Data Definitions with Db2 V12
|
6 |
The Manage Data Definitions with Db2 course describes how SQL is used to define a Db2 database and its associated objects. It looks at SQL statement syntax and the methods used to invoke SQL statements. |
Db2 - Db2 SQL Fundamentals V12
|
4 |
The Db2 SQL Fundamentals course looks at some of the more common SQL statements used by programmers when starting out. It addresses the code used to obtain Db2 table data, sort it, as well as methods used for inserting, deleting, updating and merging table data.
|
Db2 - Advanced Db2 SQL V12
|
4 |
The Advanced Db2 SQL course discusses some of the more advanced SQL code used to manipulate table data. Various methods used for joining tables is presented, along with examples of SQL statements and subqueries used to filter data results. |
Db2 - Create and Maintain Db2 Programs V12
|
6 |
The Create and Maintain Db2 Programs course describes how SQL is invoked from an application program and the interaction that can occur between the application program and Db2. This course also discusses how a Db2 COBOL Program is created. |
Db2 - Db2 Stored Procedures V12
|
3 |
The Db2 Stored Procedures course describes how stored procedures are used and the platforms on which they can be implemented. The benefits derived from using stored procedures are discussed as well as security implications associated with them.
|
Db2 - Optimize Db2 Application Performance V12
|
5 |
The Optimize Db2 Application Performance course describes the methods used by Db2 when processing application programs containing SQL, and provides details of the tools and utilities that can be used to measure and analyse their effectiveness.
|
