DB2 for LUW: Introduction & Fundamentals

Learn via : Virtual Classroom / Online
Duration : 2 Days
Download PDF
  1. Home
  3. DB2 for LUW: Introduction & Fundamentals

Description

    This course introduces and explains the fundamental principles of the Db2 for Linux, UNIX and Windows family of products. The course focuses on the relational theory and concepts, and how Db2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, Db2 utilities, and the use of Db2 Interactive (Db2i) and the relevant centres.

     

    Delegates will learn how to 

    • describe the relational theory and concepts
    • list the objects used to store Db2 data
    • understand the use of Structured Query Language
    • describe the functions available with Db2 Interactive (Db2i)
    • list the utility jobs available for Db2.

     

    Audience

    All IT professionals who need to understand the full range of the Db2 for LUW family of products.

Outline

Overview of DB2 for Linux, UNIX and Windows

Command Line Processor (CLP) and GUI Usage

The DB2 Environment

Creating Databases and Data Placement

Creating Database Objects

Moving Data

Backup and Recovery

Locks and Concurrency

Database Maintenance, Monitoring and Problem Determination

Security

Database Rebuild Support

DB2 Database and Table Space Relocation

Using Explain Tools

Using Indexes for Performance

Advanced Monitoring

Prerequisites

A basic understanding of IT, with some exposure to database technology as a user.