Database Administration and Development with PostgreSQL

Database Administration and Development with PostgreSQL

PostgreSQL( or simply postgres) is an extremely high quality database engine. As a slogan, the creators like to call it 'the most advance open source database in the world'. And really going by some of the features postgres provides out-of-the-box compared to its commercial counterparts like Oracle or Ms SQL Server, that description may not be far from truth.

Postgres is the only relational store that mimics the object orientation in programming platforms by default. It powers popular websites like Yahoo and Instagram. It can be also used as a NoSQL document store like MongoDB.

This is a complete course on learning the administration and development of this powerful database engine. No prior experience with postgres is required; we start from scratch.

Schedule and Fee

  • Training Starts May 20, 2019
  • Duration 2 Monoths (shorter fast-paced track available for busy candidates)
  • Program Type Weekdays (weekend program available too - Saturdays ONLY)
  • Fee N180,000.00

Course Outline

Database Administration and Development with PostgreSQL

  • Introduction to database systems
  • Installation and configuration
  • Installing pgAdmin
  • Creating a database
  • Creating a table
  • Writing queries - SELECT, INSERT, UPDATE, DELETE
  • Using wildcard
  • Indexes
  • Data types in details
  • Working with dates
  • Implicit data conversions
  • Exploring database design and development
  • Subqueries
  • Joins
  • Views
  • Aggregate functions
  • Stored procedure
  • Triggers
Database Administration and Development with PostgreSQL

WHAT YOU WILL BE ABLE TO DO AFTER THE TRAINING

  • Understand the role of a DBA in an enterprise environment.
  • Have a general understanding of the popular database systems, and a professional understanding of Postgres.
  • Have a solid understanding of how to design and manage databases for frontend applications and support programmers for subsequent changes as the applications evolve.
  • Be able to carry out common admin tasks such as installation of Postgres instance on windows and linux servers, create databases and db users with well defined limited roles and privileges, backup and restore, database recovery, database replication and more.