PostgreSQL 9.4 Administration

Training Architect
course instructor image
Terrence Cox
A veteran of twenty years in Information Technology in a variety of roles. He has worked in development, security and infrastructure well before they merged into what we now call DevOps. He provides training in Linux, VMWare, DevOps (Ansible, Jenkins, etc) as well as containers and AWS topics.


Installation and Configuration

Exercise: Install and Configure PostgreSQL 9.x: RHEL/CentOS


Exercise: Install and Configure PostgreSQL 9.x: Debian/Ubuntu


Administration and Security

Exercise: Creating and Deleting Databases and Adding Users


Exercise: Create a Table and Inserting Data


Exercise: Configure the Database for External Connections


Exercise: Database Backup and Restore





This course will introduce the student to each of the key areas of PostgreSQL administration: installation, configuration and setup, security, database creation and common SQL statements for manipulating data. We will also walk through setting up basic data structures (tables) and demonstrate different methods of importing, exporting and backing up their data. Once we have the basics down, we will talk about replication as well as how to read the logs to determine areas we can optimize our table structures in and finish by discussing how PostgreSQL can be used for NoSQL queries and big data reporting.

Study Guides

Instructor Deck


certificate ribbon icon

Earn a Certificate of Completion

When you complete this course, you’ll receive a certificate of completion as proof of your accomplishment.

Looking For Team Training?

Learn More