Short course

PostgreSQL Database Design and Administration

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.

Introduction

  • 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

Payments

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

Prerequisites

  • 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
Event Date & Details
30 Jan 2023 - 10 Feb 2023
Flomi Hotel, Morogoro
TZS 1,950,000
oscar.mashauri@udsm.ac.tz
0715677873

Frequently Asked Questions

Centre for Virtual Learning (CVL) offers students a full range of learning opportunities powered by the latest online technologies available. We are committed to setting very high standards for distance learning and know that the student-teacher interaction is key to student success.

Applications are now open to qualified candidates from Tanzania, the Eastern and Southern African region and beyond, who wish to pursue Undergraduate Degree and Non-Degree Programmes at the University of Dar es Salaam for the academic year 2022/2023.

Centre for Virtual Learning (CVL) offers students a full range of learning opportunities powered by the latest online technologies available. We are committed to setting very high standards for distance learning and know that the student-teacher interaction is key to student success.

Applications are now open to qualified candidates from Tanzania, the Eastern and Southern African region and beyond, who wish to pursue Undergraduate Degree and Non-Degree Programmes at the University of Dar es Salaam for the academic year 2022/2023.

Centre for Virtual Learning (CVL) offers students a full range of learning opportunities powered by the latest online technologies available. We are committed to setting very high standards for distance learning and know that the student-teacher interaction is key to student success.

Applications are now open to qualified candidates from Tanzania, the Eastern and Southern African region and beyond, who wish to pursue Undergraduate Degree and Non-Degree Programmes at the University of Dar es Salaam for the academic year 2022/2023.