Database Modernization / SQL DDL

Code: DBMDZ

Description

The course does not design a new database, but rather assumes that most companies have grown database concepts, physical logical files with lots of redundancies. Furthermore, it is shown how it is possible not only to convert the files in an existing application, but also to extend them ... and, last but not least, to redesign them.

Audience

RPG IV and SQL developers

Prerequisites

The participants should be familiar with database concepts, and at least know physical and logical files.

Topics

DDS # SQL

  • SQL/DDS Terminology
  • SQL versus System Naming Conventions
  • Architectural Differences (invalid numeric Values)

Schema

Tables

  • Definition
  • Data Types
  • Unique Identifier (Identiy Columns)
  • Other Auditing Columns
  • CREATE OR REPLACE ... convert from DDS to DDL
  • Row and Column Access Control (RCAC)

Constraints

  • Primary / Unique Key Constraints
  • Check Constraints
  • Referential Integrities
  • Trigger

Journaling and Commitment Control

Temporal Tables

Materialized Query Tables

Reverse Engineering

Views

  • Data Centric Thinking
  • Definition
  • Instead Of Triggers

Indices

  • Binary Radix Tree Indexes
  • Encoded Vector Indexes (incl. INCLUDE Clause)
  • Derived and Sparse Indexes

IBM i Access Client Solutions - Index Analysis

  • Index Advisor
  • Index Evaluator
  • Index Condenser

Price (ex. VAT)

€ 3.800,00 per person

Duration

3 to 5 days

Schedule

  •  virtual
  •  28-10-2024 - 30-10-2024
  • register

  •  virtual
  •  16-12-2024 - 18-12-2024
  • register

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us