Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
.jpg)
Get Unlimited Learning Access
$29
7 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
7 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- 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
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.
Pre-requisites
- Laptop with 4GB RAM and at least 10GB hard disk free.
- Internet connection to download installation files.
Target Audience
- Database administrators
- DBAs
- Junior Database Administrators
- I.T Professionals
Curriculum 55 Lectures 02:56:27
-
Section 1 : Introduction
- Lecture 2 :
- DB storage classes
- Lecture 3 :
- Installing Oracle Virtual Box
- Lecture 4 :
- Installing PG Admin 4
- Lecture 5 :
- AWS Regions
- Lecture 6 :
- Setting AWS Up Free Teir
-
Section 2 : Install & Configure Postgres
- Lecture 1 :
- AWS cli
- Lecture 2 :
- AWS S3
- Lecture 3 :
- Creating RDS Instance
- Lecture 4 :
- create delete modify rds
- Lecture 5 :
- Install postgres on ec2
-
Section 3 : Section 3
- Lecture 1 :
- install pg admin
- Lecture 2 :
- Connecting to RDS instance
- Lecture 3 :
- azure data studio
- Lecture 4 :
- Enable Replicated Backups
- Lecture 5 :
- How To Copy Snapshot
-
Section 4 : Section 4
- Lecture 1 :
- How To Export Snapshot to S3
- Lecture 2 :
- Controlling access
- Lecture 3 :
- delegating passwords
- Lecture 4 :
- Using SCRAM for PostgreSQL password encryption
- Lecture 5 :
- Import Data From EC2
-
Section 5 : Section 5
- Lecture 1 :
- Exporting Data to EC2
- Lecture 2 :
- Multi az deployment
- Lecture 3 :
- Read Replica
- Lecture 4 :
- RDS Recomendations
- Lecture 5 :
- DB metrics Monitering
-
Section 6 : Section 6
- Lecture 1 :
- RDS logs
- Lecture 2 :
- RDS Events
- Lecture 3 :
- Allocating Memory For Autovacuum
- Lecture 4 :
- Recovering Disk Space
- Lecture 5 :
- Reducing Transaction ID Wrap Arround
-
Section 7 : Section 7
- Lecture 1 :
- Determing if if a database need vacuuming
- Lecture 2 :
- Vacuuming Updating Planner Statistics
- Lecture 3 :
- Vacuuming Visibility Map
- Lecture 4 :
- Scheduling With Cron
- Lecture 5 :
- AWS State Manager
-
Section 8 : Section 8
- Lecture 1 :
- AWS CLI Configuration
- Lecture 2 :
- Creating Snapshot
- Lecture 3 :
- Delete Multi AZ Deployment Cluster
- Lecture 4 :
- Deleting Snapshots
- Lecture 5 :
- Importaing data from $3
-
Section 9 : Section 9
- Lecture 1 :
- intro
- Lecture 2 :
- Multi AZ Deployment Cluster
- Lecture 3 :
- Postgres Automated backups
- Lecture 4 :
- Postgres Parameter Group
- Lecture 5 :
- RDS Cloud watch monitering
-
Section 10 : Section 10
- Lecture 1 :
- RDS Maintenance
- Lecture 2 :
- RDS Tranport database
- Lecture 3 :
- Restore Snapshot
- Lecture 4 :
- Restoring Automated backups
- Lecture 5 :
- Role and Permission
-
Section 11 : Section 11
- Lecture 1 :
- super user role
- Lecture 2 :
- Vacuuming Basics
- Lecture 3 :
- what is Multi-AZ
- Lecture 4 :
- Working With Backups
Our learners work at
Frequently Asked Questions
-
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?
Instructor
153 Course Views
1 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.
View More...
