PostgreSQL 9.4 Administration

Course Instructor
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

Course Syllabus

00:08:44

Introduction to Databases

00:07:26

Data Normalization

00:09:10

Indexes, Relationships and Keys

00:07:01

Introduction to RDBMS

00:06:57

Introduction to PostgreSQL 9.4

00:06:09

Installation and Configuration

Downloading PostgreSQL (Enterprise vs. Open Source)

00:05:51

Installation and Service Configuration

00:08:38

Using the Command Line Client

00:04:49

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

00:30:00

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

00:30:00

Administration and Security

Creating Databases

00:12:01

Creating Tables

00:09:42

Roles - Creating and Deleting Users

00:09:18

Roles - Assigning Permissions

00:08:39

Installing and Configuring myPgAdmin

00:12:24

Accepting External Connections

00:10:52

Inserting, Viewing and Deleting Data

00:07:51

Backing Up and Restoring Databases

00:11:20

Replication - Master Server Configuration

00:11:11

Replication - Slave Server Configuration

00:10:36

Discussion - Database Clustering

00:09:21

Exercise: Exercise: Creating and Deleting Databases and Adding Users

00:30:00

Exercise: Exercise: Create a Table and Inserting Data

00:30:00

Exercise: Exercise: Configure the Database for External Connections

00:30:00

Exercise: Exercise: Database Backup and Restore

00:30:00

Datatypes

Introduction to Datatypes

00:08:06

Character Datatype

00:11:53

Numeric Datatype

00:11:20

Serial Datatype

00:11:08

Boolean Datatype

00:06:59

Special Datatype - NULL

00:06:00

Date Datatype

00:08:24

Time Datatype

00:08:18

Timestamps

00:14:13

Conclusion

NoSQL and PostgreSQL

00:06:05

Big Data Processing

00:08:22

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