PostgreSQL Database Programming Course

4.8 (145 reviews)
  • 87 Lessons
  • 15 Students
  • Certificate of completion

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

  • Master SQL query optimization techniques for PostgreSQL to improve database performance and efficiency
  • Design and implement complex database schemas using PostgreSQL for scalable data management
  • Utilize PostgreSQL stored procedures, functions, and triggers to automate tasks and enforce data integrity
  • Apply advanced indexing strategies in PostgreSQL to enhance query speed and database responsiveness
  • Manage PostgreSQL user roles, permissions, and security settings to ensure data protection and compliance
  • Perform database backup, recovery, and replication in PostgreSQL for data durability and high availability
  • Analyze PostgreSQL logs and performance metrics to troubleshoot issues and optimize database operations
  • Develop and deploy PostgreSQL extensions and custom functions for enhanced database functionality
  • Implement data migration and integration techniques between PostgreSQL and other systems or applications
  • Configure PostgreSQL for high concurrency and workload management in enterprise environments
  • Use PostgreSQL’s JSON and XML data types for flexible, semi-structured data storage and querying
  • Optimize PostgreSQL database design for normalization, denormalization, and data consistency
  • Leverage PostgreSQL’s full-text search capabilities for efficient search and data retrieval
  • Apply best practices for securing PostgreSQL databases against vulnerabilities and unauthorized access

Course Content

87 Lessons • 48 h 29 m total

Migrating from MSSQL to PostgreSQL Percona Tech Days PostgreSQL Tutorial

27:09

An Introduction To pgcrypto Percona Tech Days Robert Bernier PostgreSQL Tutorial

26:23

Joining Heterogeneous Databases is a reality not a Myth Percona Tech Days PostgreSQL Tutorial

34:00

Elephant by the pool PostgreSQL connection poolers overview Percona Tech Days

20:19

Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL Percona Tech Days

28:37

Designing your SaaS Database for Scale with Postgres PostgreSQL Database Design Tutorial

45:53

NoSQL to PostgreSQL Adventures in Migrations PostgreSQL Tutorial

47:52

Aurora PostgreSQL Deep Dive PostgreSQL Tutorial

52:28

A Deep Dive Into PostgreSQL Indexing PostgreSQL Index Tutorial

50:37

Monitoring PostgreSQL with PMM Percona Monitoring and Management Monitoring Database Tutorial

34:39

High Performance PostgreSQL Tuning and Optimization Guide Ibrar Ahmed PostgreSQL Tutorial

1:12:12

Multi Primary Replication Solutions for PostgreSQL

59:57

Mostly mistaken and ignored parameters while optimizing a PostgreSQL database Percona Live 2020

33:10

Working With PostgreSQL As A JSON Document Store Robert Bernier Percona Live Online 2020

27:33

Parallelism in PostgreSQL Ibrar Ahmed Percona Live Online 2020

57:04

The Evolution of PostgreSQL Partitioning

59:22

Why PostgreSQL is Becoming a Migration Target in Large Enterprises 1

51:33

Percona Distribution for PostgreSQL

1:31

A Deep Dive Into PostgreSQL Indexing

1:02:23

Monitoring PostgreSQL with Percona Monitoring and Management PMM

30:47

High Availability and Automatic Failover in PostgreSQL on Kubernetes On premise and Cloud

43:26

HA PostgreSQL on Kubernetes by Demo

58:19

MySQL Group Replication vs PostgreSQL Bi Directional Replication MySQL vs PostgreSQL

26:40

Upgrade or Migrate Your PostgreSQL Database Through a Lowest Possible Downtime

25:02

Gonymizer A PostgreSQL Tool for Anonymizing Protected Health for HIPAA Compliant Test Infrastructur

45:02

Getting Started with PostgreSQL

47:15

Building PostgreSQL as an Enterprise Grade Setup Using Open Source Tools

49:49

New and Maturing Built in Features in PostgreSQL to Help Build Simple Shards

15:24

Upgrading Migrating your legacy PostgreSQL to newer PostgreSQL versions

1:02:52

Monitoring PostgreSQL with Percona Monitoring and Management PMM

39:46

Introduction to PostgreSQL Overview PostgreSQL Tutorial

8:10

PostgreSQL High Performance Tuning and Optimization PostgreSQL Tutorial

51:48

Lesson 1 Overview Deep Dive Into PostgreSQL Indexes Course Percona University Online

2:20

Monitoring PostgreSQL PostgreSQL Talk

38:27

Lesson 2 Heap vs Index Deep Dive Into PostgreSQL Indexes Course Percona University Online

9:22

Lesson 3 How to Create Indexes Deep Dive Into PostgreSQL Indexes Course

4:29

Lesson 4 How to create an Expression Index Deep Dive Into PostgreSQL Indexes Course

3:21

Lesson 5 Advantages of a Partial Index Deep Dive Into PostgreSQL Indexes Course

3:55

Lesson 6 Index Types B Tree Deep Dive Into PostgreSQL Indexes Course Percona University

4:42

Lesson 7 What is HASH Index Index Types Deep Dive Into PostgreSQL Indexes Course

2:13

How to Get The Certificate

  • You must have an Account on the platform.
  • Complete all lessons.
  • Watch at least 50% of Lesson Duration.
  • Get your Certificate free 🎉 !

Certificate Example

Mind Luster Certificate Template

4.8 (145 reviews)

Overall rating

  • 5.0 0%
  • 4.0 0%
  • 3.0 0%
  • 2.0 0%
  • 1.0 0%

Reviews

Shaymaa Al Khozendar

· 1yr ago

Thx, this is so helpful.

PostgreSQL Database Programming Course Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime

Course Intro