Description

This training program teaches professionals to perform fundamental database managerial tasks utilizing Db2 11.1. These errands incorporate making database objects like tables, records and perspectives, and stacking information into the database with Db2 utilities like LOAD and INGEST. Different analytic strategies will be introduced, including utilizing db2pd order choices, and observing with SQL explanations that reference Db2 screen capacities. Understudies will figure out how to execute programmed chronicled for database logs and how to recuperate a database to a particular point in time utilizing the filed logs. The course covers utilizing EXPLAIN apparatuses to audit the entrance plans for SQL articulations and adding files to improve SQL execution. We will cover the locking performed by Db2 and the impact the application separation level has on locking and lock hold up conditions. Understudies will figure out how to execute database security, including a security chairman, SECADM client, and actualize database jobs to rearrange security the board. We will likewise portray actualizing Db2 local encryption for a database.
Radiant Techlearning offers Db2 11.1 Administration Workshop for Linux training program in Classroom & Virtual Instructor Led/Online Mode

 

Duration: 32 Hours

Prerequisites

to benefit from this course, professionals should have prior:

  • Perform basic database administration tasks on a relational database system
  • Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
  • State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
  • Discuss basic relational database concepts and objects such as tables, indexes, views, and joins

Professionals having prior knowledge in the following courses:

  • DB2 SQL Workshop
  • DB2 Fundamentals

Audience Profile

  • Database Administrators

Course Details

  • Overview of Db2 11.1
  • Db2 Command Line Processor (CLP) and GUI tools
  • The Db2 database manager instance
  • Creating Databases and Data Placement
  • Creating Database Objects
  • Moving Data
  • Backup and Recovery
  • Database Maintenance, Monitoring and Problem Determination
  • Locking and concurrency
  • Security

FAQs

Categories: ,

Unble To Find a Batch..?

Request a Batch