Call Now+234 803 304 5484, +234 906 000 2299

Send Message[email protected]

Start Date: 23 Jun, 2025

End Date: 27 Jun, 2025

WiFiFree WiFi available

$3,000

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.

CONTENT

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

  • Security
  • SQL Primer

Backup and Recovery

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

 

FOR WHOM:

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

 

TRAINING METHODOLOGY

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.

 

This course is available in the following locations:
Nigeria - $3000
Ghana    - $6500
Rwanda - $7500
UK - $8500
USA - $8500

Venue

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

Other Dates

Start Date End Date
01 Dec, 2025 05 Dec, 2025
Start Date End Date
23 Jun, 2025 27 Jun, 2025