Course Description

THE RATIONALE

Management and protection of information assets is crucial to organizational survival. Database management is changing with the dynamics in the ICT and as a result, database administrators need to be upgraded with recent knowledge on database peculiarities.

THE COURSE OBJECTIVES:

The course aims at achieving the following learning outcomes:

• An appreciation of pervasive use of Knowledgebase and DBMS in different application domains
• Skill for developing database applications
• Learning transaction processing and database recovery
• Skills for devising data models and query languages
• Learning knowledge representation and semantic web technologies
• Skills for developing web database applications
• Learning storage and indexing of data
• Skills to integrate knowledge to databases

 THE COURSE OUTLINE

The course will cover the following:

MODULE 1: DATABASE CONCEPTS

• Database concepts
• Relational model
• Relational query languages
  • Relational Algebra and Calculus
  • Datalog
  • SQL
  • QBE

MODULE 2: TRIGGERS

• Triggers
• Embedded SQL
• Recursion
• Web database programming

MODULE 3: CONCEPTUAL DATA MODELING

• Conceptual data modeling
• E/R data model
• OO data model
• Relational database design
  • Normal Forms (NF)
  • 1-4NF
  • Lossless join decomposition
• XML, XPath and XQuery
• Ontology and Data Model

MODULE 4: SEMANTIC WEB

• Semantic Web
• RDF, RDF Schema, and OWL
• Storage and indexing
• Query processing and optimization
• Parallel and distributed databases

MODULE 5: DATABASE SECURITY

• NoSQL databases
• Transaction processing and database recovery
• Database security
• Current developments in knowledgebase
• Big data and Hadoop

TARGET AUDIENCE

• Database Officers and Managers
• Heads of Computer Departments
• Team Members of Computer or ICT Departments among others

Delivery Method: Combines lectures, discussions, group exercises and illustrations

Venue:

Fee:

Duration: 1 week

Course Date: July 17th -21st 2023