Advanced Database Management Systems

HRODC Postgraduate Training Institute
In Dubai (United Arab Emirates), Kuala Lumpur (Malaysia), Manila (Philippines) and 3 other venues

£ 15,000 - (Rs 12,22,995)
VAT incl.
Compare this course with other similar courses
See all

Important information


Suitable for: Systems Manager. Database Administrators. Computer and Information Systems Administrator. Help Desk Technician. Information Technology Director. IT Manager. Web Administrator. Software Engineer. System Administrators. All others interested in Database Management System

Important information

Where and when

Starts Location
Brussels Hoofdstedelijk Gewest, Belgium
See map
Champolion, 12421, Egypt, Egypt
See map
Coral Deira Hotel, Muraqabat Street, Deria, Dubai, 82999,, 82999, Dubai, United Arab Emirates
See map
Kuala Lumpur
Jalan Ampang Hilir, 68, Malaysia, Malaysia
See map
Makati, 1200, Philippines, Philippines
See map
See all (6)

Course programme

Course Contents, Concepts and Issues

Module 6

Essentials of Databases:

Relational Database Model and Languages, Database Analysis and Design

I. Background

  • Introduction to Databases
  • Database Environment
  • Database Architectures and the Web

II. The Relational Model and Languages

  • The Relational model
  • Relational Algebra and Relational Calculus
  • SQL: Data Manipulation
  • SQL: Data Definition
  • Query-By-Example (QBE)

III. Database Analysis and Design

  • Database System Lifecycle
  • Database Analysis and the DreamHome Case Study
  • Entity–Relationship Modeling
  • Enhanced Entity–Relationship Modeling
  • Normalization
  • Advanced Normalization

Module 7

Database Methodology, Selected Database Issues, Distributed Database management Systems (DBMSs) and Replication

IV. Methodology

  • Methodology—Conceptual Database Design
  • Methodology—Logical Database Design for Relational Model
  • Methodology—Physical Database Design for Relational Databases
  • Methodology—Monitoring and Tuning the Operational System

V. Selected Database Issues

  • Security and Administration
  • Professional, Legal, and Ethical Issues
  • Transaction Management
  • Query Processing

VI. Distributed DBMSs and Replication

  • Distributed DBMSs—Concepts and Design
  • Distributed DBMSs—Advanced Concepts
  • Replication and Mobile Databases

Module 8.

Object Database Management Systems (DBMSs), Web and DBMSs, Business Intelligence Technologies

VII. Object DBMSs

  • Object-Oriented DBMSs—Concepts and Design
  • Object-Oriented DBMSs—Standards and Languages
  • Object-Relational DBMSs

VIII. Web and DBMSs

  • Web Technology and DBMSs
  • Semistructured Data and XML

IX. Business Intelligence Technologies

  • Data Warehousing Concepts
  • Data Warehousing Design
  • OLAP
  • Data Mining

Compare this course with other similar courses
See all