تبلیغات

آشنایی با مدیریت PostgreSQL 9.4

دسته بندی ها: آموزش پستگرس‌کیوال (PostgreSQL) ، پایگاه داده ، آموزش های LinuxAcademy ، آموزش لینوکس (Linux)

linuxacademy-postgresql-9-4-administration

آیا این نوشته را دوست داشتید؟
PostgreSQL 9.4 Administration Publisher:LinuxAcademy Author:Terrence Cox Duration:04:39:05

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
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.
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

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 976.0MB LinuxAcademy PostgreSQL 9.4 Administration_git.ir.rar