2024 PostgreSQL Database Administration Essential Training: Master SQL & Performance

2024 PostgreSQL Database Administration Essential Training

PostgreSQL 16 Database Administration Essential Training

Created by : Rated :4.8 618 views

Last Updated: 2024-11-25 08:11:15 English Course Type: Self Learning

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

PostgreSQL Administration Course Overview

This course is targeted at beginners and 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, 15 an 16 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

Examine statistics and system tables

Manage tablespaces

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.

Laptop with 4GB RAM and at least 10GB hard disk free.

Database administrators
Junior Database Administrators

Section 1 : Introduction 2 Lectures 00:03:23
Lecture 1 :
Course Introduction Preview
Lecture 2 :
What is postgres
Section 2 : Install & Configure Postgres 7 Lectures 00:23:52
Lecture 1 :
Getting Stated
Lecture 2 :
Installing PG Admin
Lecture 3 :
Installing Oracle Virtual Box
Lecture 4 :
Installing Postgres On Linux
Lecture 5 :
How to install posgress on Windows- updated
Lecture 6 :
Postgres Config File
Lecture 7 :
Connecting To Your Postgres Database
Section 3 : Managing Databases 6 Lectures 00:15:28
Lecture 1 :
Creatiing Databases
Lecture 2 :
Altering Postgres Database
Lecture 3 :
Renaming Postgres Database
Lecture 4 :
Changing DB Owner
Lecture 5 :
Changing Tablespace
Lecture 6 :
Altering Database Demo a
Section 4 : Managing Tablespaces 4 Lectures 00:07:19
Lecture 1 :
Understanding Tablespaces in Postgres
Lecture 2 :
create Tablespaces in Postgres
Lecture 3 :
Altering Tablespaces in Postgres
Lecture 4 :
Drop Tablespaces in Postgres
Section 5 : Securing Your Server 5 Lectures 00:19:06
Lecture 1 :
Create Roles in Postgres Roles
Lecture 2 :
Granting Privileges in Postgres
Lecture 3 :
Revoking Privilleges in Postgres
Lecture 4 :
Altering Roles in Posgres
Lecture 5 :
Dropping Roles in Postgresql
Section 6 : Backup & Restore Databases 7 Lectures 00:20:53
Lecture 1 :
Backing up a Single Database
Lecture 2 :
Backing up all Databases
Lecture 3 :
Compressing Postgres Backups
Lecture 4 :
Splitting Backups into Multiple Files
Lecture 5 :
Backing Up Databases on Remote Host
Lecture 6 :
Optimizing Database Backups
Lecture 7 :
Restoring all Backup Types
Section 7 : Scheduling With pgAgent 5 Lectures 00:09:01
Lecture 1 :
What is PG Agent
Lecture 2 :
How to install pgagent
Lecture 3 :
Configuring your Database for pgAgent
Lecture 4 :
Setting up PgAgent as A Daemon
Lecture 5 :
Scheduling a task with pgAgent
Section 8 : Routine Database Maintenance Tasks 8 Lectures 00:12:37
Lecture 1 :
Maintenance in Postgres
Lecture 2 :
Vacuuming Basics
Lecture 3 :
Vacuuming Reclaiming Disk Space
Lecture 4 :
Vacuuming Updating Planner Statistics
Lecture 5 :
Vacuuming Visibility Map
Lecture 6 :
Vacuuming Transction Wrap arround ID
Lecture 7 :
The Auto vacuum Daemon
Lecture 8 :
Routine Reindexing

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Emar Morrison,

1054 Course Views

3 Courses

Emar J. Morrison is an experienced database administrator with almost a decade of expertise in the field. He has worked with various organizations, both big and small, and has played an instrumental role in the successful implementation and maintenance of their databases. Emar is well-versed in various cloud platforms, including Amazon Web Services (AWS) and Microsoft Azure. Apart from his work in database administration, Emar is also an avid investor with a keen interest in the stock market. He believes in the importance of investing as a means of building wealth and achieving financial freedom. Emar has spent years studying the strategies of successful investors and has honed his skills in identifying promising investment opportunities. He has a passion for sharing his knowledge with others and is dedicated to helping people achieve their financial goals. In addition to his work as a database administrator and investor, Emar is also a content creator. He is passionate about writing and creating informative and engaging content about database administration, cloud platforms like AWS and Azure, investing, and personal finance. Emar's content is designed to educate and empower his audience, providing them with the tools and knowledge they need to succeed.