OVERVIEW

Advances in our capability to generate and collect information coupled with  decreasing disk‐space prices are pushing us toward a world centered around data  management. Databases are at the heart of modern commercial application  development. Their use extends beyond this to many other environments and  domains where large amounts of data must be stored for efficient update and  retrieval. The purpose of this course is to provide a comprehensive introduction to  the use of database management systems for applications.

OBJECTIVE

To be able to use Database Management Systems (DBMSs) successfully, one has to understand the concepts on which they are based.

The aims of this course are to :

  • familiarise you with the basic concepts underlying a DBMS;
  • show how they are realized in specific systems such as the PostgreSQL DBMS;
  • give you some hands-on experience in using a DBMS.

COURSE CONTENT

Day 1

  • Fundamental Database Concepts
  • The Entity Relationship (= ER) Model (the most common approach to conceptual database design)
  • The Relational Data Model – Relations – Integrity Constraints (keys, foreign keys, etc.)

Day 2

  • Logical Database Design (ER to relational schemas)
  • Relational Algebra (an algebraic query language for the relational model)
  • SQL: Querying and Manipulating Data :
  • SQL Data Definition Language
  • Single Block Queries
  • Aggregation
  • baseJoins and Outer Joins
  • Nesting
  • Negation

Day 3

 

  • Transaction Management and Concurrency Control
  • Database Access from a Programming Language: JDBC
  • Data Storage and Indexing :
  • File Organisation and Indexes
  • Tree-structured Indexing: B+-trees
  • Hash-based Indexing

Day 4

Outbound Activities Aimed At Improving:

  • Communication
  • Teamwork
  • Confidence
  • Motivation

Day 5

Query Evaluation :

  • Sorting
  • Evaluation of Relational Operators
  • Query Optimisation
  • Physical Database Design
  • Post training program
  • Certificates

WHO SHOULD ATTEND

Audience for the Training

  • Business managers and their staff who need to understand the concepts of data modeling, so they can participate actively in partnership with IT staff in data modeling sessions that draw on their business expertise.
  • IT managers, data administrators and systems development staff who also need to understand the concepts of data modeling to participate with business managers and staff in data modeling sessions, and so enable the IT staff to draw on their systems development expertise in a design partnership with the business experts.
  • Others interested

METHODOLOGY

  • Face To Face
  • Role playing
  • Post session assessment
  • Video presentation
  • Case study

PERIOD

5 working days

LANGUAGE

  • English
  • Indonesia
  • Tetun