Database Design, Tools & Techniques with PostgreSQL

Date Format Fees  
04 Jul - 07 Jul, 2023 Classroom ₦285,000 Register
19 Dec - 22 Dec, 2023 Classroom ₦285,000 Register
04 Jul - 07 Jul, 2023 Classroom ₦285,000 Register

Event Details

Database Design, Tools & Techniques with PostgreSQL provides fundamental skills necessary to maintain and manage a PostgreSQL server open source databases and related applications in a production environment. It covers foundation of PostgreSQL, system architecture, creating and managing databases, fundamental SQL, operations and maintenance of PostgreSQL database systems, using basic tools, and backup/restore.


Introduction to Structured Query Language (SQL) & PostgreSQL

  • PostgreSQL System Architecture
  • Installation
  • Configuration
  • The PostgreSQL Documentation

Managing Data

  • Moving Data
  • Postgres Data Dictionary

Working with Databases

  • Creating and Managing Databases
  • User Tools: Command Line Interface
  • GUI Tools


  • Security
  • SQL Primer

Backup and Recovery

  • Backup and Recovery
  • Point-in Time Recovery
  • Routine Maintenance Tasks



CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.



The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.



1ST BATCH:               4th - 7th July, 2023   

2ND BATCH:             19th - 22nd Dec, 2023


  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course