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

Understanding open source RDBMS systems is an important skill for a successful system administrator or engineer.


This course will help you gain a deep understanding of how to install and coonfigure PostgreSQL v9.4. Once you have the server itself, we will take a look at creating users that can access our RDBMS and setting up a basic schema, as well as how to create basic replication and do simple backup/restore.


Finally, we will show you how to build and work with that schema in order to understand data types, inserting, updating and deleting records.


Study Guides

Instructor Deck

Community

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