Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

PostgreSQL 9.4 Administration


Introduction:
Course Syllabus
Introduction to Databases
Data Normalization
Indexes, Relationships and Keys
Introduction to RDBMS
Introduction to PostgreSQL 9.4

Installation and Configuration:
Downloading PostgreSQL (Enterprise vs. Open Source)
Installation and Service Configuration
Using the Command Line Client

Administration and Security:
Creating Databases
Creating Tables
Roles - Creating and Deleting Users
Roles - Assigning Permissions
Installing and Configuring myPgAdmin
Accepting External Connections
Inserting, Viewing and Deleting Data
Backing Up and Restoring Databases
Replication - Master Server Configuration
Replication - Slave Server Configuration
Discussion - Database Clustering

Datatypes:
Introduction to Datatypes
Character Datatype
Numeric Datatype
Serial Datatype
Boolean Datatype
Special Datatype - NULL
Date Datatype
Time Datatype
Timestamps

Conclusion:
NoSQL and PostgreSQL
Big Data Processing