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.

Introduction

Installation and Configuration

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

00:30:00

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

00:30:00

Administration and Security

Exercise: Creating and Deleting Databases and Adding Users

00:30:00

Exercise: Create a Table and Inserting Data

00:30:00

Exercise: Configure the Database for External Connections

00:30:00

Exercise: Database Backup and Restore

00:30:00

Datatypes

Conclusion

Details

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

Community

Looking For Team Training?

Learn More