PostgreSQL Database Administration

Focused View

Emar Morrison

1:29:13

271 View

1 - Introduction

1 - Introduction.mp4

00:57

2 - What is postgres.mp4

02:24

2 - Install & Configure Postgres

3 - Install PortgreSQL on Linux.mp4

08:49

4 - Install PortgreSQL on Windows.mp4

02:40

5 - Understanding PostgreSQL Configuration files.mp4

03:29

6 - Connecting to PostgreSQL Database.mp4

04:09

3 - Managing Databases

7 - Creating your first database.mp4

05:50

8 - Altering PostgreSQL database.mp4

01:26

9 - Renaming PostgreSQL Database.mp4

01:05

10 - Changing Database Owner.mp4

00:36

11 - Changing The Tablespace of Database.mp4

00:51

12 - Demo Altering Databases.mp4

05:29

4 - Managing Tablespaces

13 - Understanding tablespaces in PostgreSQL.mp4

03:17

14 - Creating a Tablespace in Postgres.mp4

04:41

15 - Altering Tablespaces in Postgres.mp4

02:01

16 - Dropping Tablespaces in Postgres.mp4

01:56

5 - Securing Your Server

17 - Creating users in Postgres.mp4

06:56

18 - Granting privileges in Postgres.mp4

04:42

19 - Revoking Privileges in Postgres.mp4

02:09

20 - Altering Roles in Postgres.mp4

01:59

21 - Dropping Roles in Postgres.mp4

03:06

6 - Backup & Restore Databases

22 - Backing up a Single Database.mp4

02:47

23 - Backing up all Databases.mp4

03:19

24 - Compressing Postgres Backups.mp4

01:42

25 - Splitting Backups into Multiple Files.mp4

00:53

26 - Backing up Remote Databases.mp4

01:24

27 - Optimizing Postgres Backups.mp4

02:45

28 - Restoring all Backup Types Database.mp4

07:51

Description

Postgres 14 Database Administration for Database Administrators

What You'll Learn?

Install and Configure Postgres
Perform backups and restores
Create Roles and Grant Permissions
How To Manage Tablespaces
How To Optimize Database Backups
How To Migrate Databases

Who is this for?

Database administrators

DBAs

More details

Description
PostgreSQL Administration Course Overview
This course is targeted towards beginners, DBAs with experience using another DBMS such as Microsoft SQL Server, MySQL or Oracle.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Course Objectives
This course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover and tune a PostgreSQL database.
Who will the Course Benefit?
This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL 10, 11, 12, 13, 14 and 15 databases. This course is also suitable for users of PostgreSQL 9 databases.
Skills Gained
The delegate will learn and acquire skills as follows:
Install PostgreSQL
Create a database
Manage roles and privileges
Manage schemas
Examine statistics and system tables
Manage tablespaces
Understand error reporting and logging
Carry out periodic maintenance with VACUUM autovacuum
Backup and restore databases
Configure settings for increased performance
PostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source community that is dedicated to improving the platform to keep it relevant to today's time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.
Who this course is for:
Database administrators
DBAs

User Reviews

Rating

average 0

Total votes0

Focused display

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.