Database

In these expert videos, a breakdown of what constitutes performance in relation to Db2 applications is discussed. The presenter begins with a high-level view of performance, and the factors to be considered when coding, and managing Db2 applications.

These expert videos delve deeper into the relational aspect of Db2 databases, explaining how it impacts the way applications are coded. The presenter discusses traditional data processing techniques and describes how this process differs when coding for Db2 databases. A range of coding tips are presented that will improve the performance of your Db2 applications.

These expert videos focus on the benefits of using indexes when accessing data through SQL. It begins by looking at using SQL to obtain only the data required, and minimizing the passes through that data. You will see how indexes can improve SQL performance and also where indexes cannot be used. Finally, you will see how the way that Db2 data is stored can also impact performance when accessing it.

These expert videos look at concurrency, how it works, and the performance benefits it can provide. You will see how Db2 table spaces, tables, pages, and rows can be locked and when each of these types of locks should be considered for use. Details on isolation levels, how they are specified, and the impact they have on your SQL program is also presented. A section on common concurrency problems including lock suspensions, timeouts, and deadlocks is covered, and how they can be avoided. You will also see how parallelism is enabled and how it is used to improve processing efficiency.

These expert videos begin by reviewing the role of the Db2 Optimizer and how it is used to satisfy SQL requests. You will then explore the various options for accessing data in a single table, and then take a look at the methods that Db2 can use to combine data when more than one table is accessed in your SQL code. Focus will then turn to filter factors, describing what they are, how you can calculate them for your data and queries, and how Db2 uses them to estimate the amount of data that it needs to access. Finally, methods that you can use to examine the access paths chosen by Db2 for your SQL queries will be discussed.

These expert videos provide some tips and techniques for coding efficient SQL statements in your Db2 applications. You will discover several different ways to avoid writing code, for example by using existing Functions and Db2 Utilities, and see how reusable Db2 code in the form of stored procedures and triggers, can be created. You will also look at the use of dynamic and static SQL and when each should be used, and how to use set operations in Db2 to combine data from multiple queries in different ways and for different use cases. Finally, you will be introduced to general tips and techniques for writing SQL statements.

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.

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.

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.

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.

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.

The Db2 13 - 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.

The Db2 13 - Managing Db2 Operations on z/OS 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. You will be introduced to Db2 stored procedures on z/OS, and see how they are created and managed.

The Introducing Db2 course discusses the platforms on which Db2 can be implemented, and the core features that can be found with all Db2 versions. You will look at common Db2 components and see how they are used to store and manage Db2 data. An overview of IBM Data Studio is also presented, explaining how it is used to work with relational database management systems such as Db2.

The Create and Maintain Db2 Programs course describes how SQL can be invoked from an application program and the interaction that can occur between the application program and Db2. Measuring the success of the SQL is then discussed, and the use of SQLCA, and SQLSTATE to determine this. You will then see how cursors can be used to reference table data, and finally how Db2 data is saved and recovered using commits and rollbacks.

This course discusses the steps required to create Db2 COBOL programs.

The Db2 13 - 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 analyze their effectiveness.