Short courses

Advanced Database Design and Administration

  • Date: - -
  • Venue: Flomi Hotel, Morogoro
  • Cost: TZS 2,500,000
  • Contact: 0715677873 |
  • Register

Instructor will use PostgreSQL database commonly known as Postgress is often called the world's most advanced open-source database for demonstration and during practical sessions. This highly flexible and scalable relational database management system (RDBMS) supports everything from general purpose databases to machine learning applications and geospatial map servers. Databases provide a consistent, organized structure for storing and retrieving large amounts of data. They allow programmers to build more complex applications that can take orders, process payments, make recommendations, authenticate users, and more. SQL queries can be fast and highly efficient, but they can also be slow and demand excessive CPU and memory resources. In this course, Instructor will show you how to analyze query execution plans and use data modeling strategies to boost query performance, also highlights different types of indexes and how they factor in query tuning and discusses how to use partitioning and materialized views to improve performance.


  • Overview
  • Installation and Configurations
  • Explore Database Graphical User Interfaces
  • Database Architecture and Design

Database Foundations in Depth

  • Understand Data Structures
  • Understanding Relational Database
  • Tables Joining and Subqueries
  • Data Aggregating and Grouping
  • Operators and Functions
  • Working with Times, Dates, and Intervals
  • Using Interactive Terminal CLI
  • Table Inheritance and Partitions
  • Server Programming and Triggers
  • Database Transactions
  • Managing Database Security
  • Backup and Restore a Database
  • Database Maintenance and Monitoring

Query Tuning and Performance Optimization

  • Introduction
  • Understand Query Execution
  • Understand EXPLAIN Keyword
  • Working with INDEXES
  • JOIN Methods Tuning
  • Understanding Partitioning and Windowing
  • Working with Materialized Views
  • Statistics and Parallel Query Execution Techniques

High Availability and High Scalable

  • Comparison of Different Solutions
  • What are Scalability Requirements
  • Database Architecture and Relation Databases
  • Working with Data Ingestion
  • How streaming replication works
  • Different Replication Modes for Different Situations
  • Measuring the performance impact of each replication mode
  • Considerations for large datasets
  • Failover and Hot Standby
  • Building a Scalable Relational Databases


All payments should be made through Control Numbers.Register, then we will send an invoice with a Control Number to you.

Who should attend this course?

  • Database Administrator, Data engineers, and IT professional
  • Anyone who interesting in Database design and administration


  • Come with your own Laptop computer with minimum of 100GB HD free space and 8GB RAM
  • Should know how to use your own computer
  • Should be familiar with basic database syntax

Log in