Linux Academy – PostgreSQL 9.4 Administration (Professional Level)

Linux Academy – PostgreSQL 9.4 Administration (Professional Level)

English | Size: 1.26 GB (1,356,176,540 Bytes)
Category: CBTs

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
EXERCISE: Exercise: Install and Configure PostgreSQL 9.x: Debian/Ubuntu

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
EXERCISE: Exercise: Create a Table and Inserting Data
EXERCISE: Exercise: Configure the Database for External Connections
EXERCISE: Exercise: Database Backup and Restore

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

Buy Long-term Premium Accounts To Support Me & Max Speed

DOWNLOAD:

http://rapidgator.net/file/c0ae59a41705cee2ad88466ee1ac6c25/LinuxAcademy_-_PostgreSQL_9.4_Administration.part1.rar.html
http://rapidgator.net/file/7afad544ea1fd809fb9285e84ed0c648/LinuxAcademy_-_PostgreSQL_9.4_Administration.part2.rar.html
http://rapidgator.net/file/b3588d4e34e3900d0fc29d6b2ab7cf9e/LinuxAcademy_-_PostgreSQL_9.4_Administration.part3.rar.html

http://nitroflare.com/view/6D720336BF2439F/LinuxAcademy_-_PostgreSQL_9.4_Administration.part1.rar
http://nitroflare.com/view/CB441A9B10E34A0/LinuxAcademy_-_PostgreSQL_9.4_Administration.part2.rar
http://nitroflare.com/view/87F70CCD41DBFF0/LinuxAcademy_-_PostgreSQL_9.4_Administration.part3.rar

If any links die or problem unrar, send request to http://goo.gl/aUHSZc