Learn about PostgreSQL, from simple queries to advanced functions like transaction control, security, replication, and performance tuning. Explore complex data types, backups, upgrades, and migration.

postgresql.tar.gz

storedProcedure

PostgreSQL is a popular relational database management system. This course offers many features—from fundamental commands to advanced functionalities within PostgreSQL. 

You will learn simple queries, data definition, and data manipulation through SQL. You’ll be taught how to work with complex data types, regular expressions, views, indexing, and stored procedures. You’ll also learn about transaction control, administration, security, replication, and performance tuning. Following that, you’ll gain insight into the methods for backup, restore, and recovery. You’ll then learn about upgrading and migration from legacy systems. There’s also a mini project and a thorough assessment to enhance your learning experience and confidence.

This course is an ideal choice for developers who want to upgrade their database management skills with hands-on experience. Starting from the basic concepts, this course is an excellent option for those who want to switch to the field of databases.

Mastering PostgreSQL Databases: From Basics to Advanced

Copies data from a single source to multiple destinations 

Acts as a backup of the database in case of failure 

What does database replication do?

What type of replication does PostgreSQL support?

What type of replication does PostgreSQL support?

How many copies of the data can be made in database replication?

How many copies of the data can be made in database replication?

What is the benefit of database replication?

What is the benefit of database replication?

Primary-secondary replication only has one primary server and multiple secondary servers, while bidirectional replication has multiple primary servers.

Primary-secondary replication provides high availability, while bidirectional replication provides high reliability.

Primary-secondary replication is only used for backups, while bidirectional replication is used for production systems.

Primary-secondary replication provides high performance, while bidirectional replication provides high scalability.

What is the main difference between primary-secondary replication and bidirectional replication in PostgreSQL?

What is the main difference between primary-secondary replication and bidirectional replication in PostgreSQL?

`CREATE USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD 'password';`


`CREATE REPLICA USER 'replicator' LOGIN ENCRYPTED PASSWORD 'password';`

`CREATE REPLICATION USER replicator LOGIN ENCRYPTED PASSWORD 'password';`

`CREATE REPLICA USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD 'password';`

Which SQL command is used to create a new replication user in PostgreSQL replication?

Which SQL command is used to create a new replication user in PostgreSQL replication?

What is the maximum number of WAL segments that can be retained in the WAL in PostgreSQL replication?

What is the maximum number of WAL segments that can be retained in the WAL in PostgreSQL replication?

It's used to store the database server configuration.

It's used to configure the replica server.

It's used to control database access permissions.

What is the purpose of the `recovery.conf` file in PostgreSQL replication?

What is the purpose of the <code>recovery.conf</code> file in PostgreSQL replication?

Test your knowledge about PostgreSQL replication.

Introduction to Database Management System

SQL Basics

Personal Expense Tracker Database

Advanced SQL

Administration

Security

Replication

Performance Tuning

Designing an Online Retail Store

Backup and Recovery

Upgrade and Migration

PostgreSQL Assessment

Appendix

Create a GUI Application for PostgreSQL Database

Quiz on PostgreSQL Replication