Thx, this is so helpful.
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
An Introduction To pgcrypto Percona Tech Days Robert Bernier PostgreSQL Tutorial
Joining Heterogeneous Databases is a reality not a Myth Percona Tech Days PostgreSQL Tutorial
Elephant by the pool PostgreSQL connection poolers overview Percona Tech Days
Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL Percona Tech Days
Designing your SaaS Database for Scale with Postgres PostgreSQL Database Design Tutorial
NoSQL to PostgreSQL Adventures in Migrations PostgreSQL Tutorial
Aurora PostgreSQL Deep Dive PostgreSQL Tutorial
A Deep Dive Into PostgreSQL Indexing PostgreSQL Index Tutorial
Monitoring PostgreSQL with PMM Percona Monitoring and Management Monitoring Database Tutorial
High Performance PostgreSQL Tuning and Optimization Guide Ibrar Ahmed PostgreSQL Tutorial
Multi Primary Replication Solutions for PostgreSQL
Mostly mistaken and ignored parameters while optimizing a PostgreSQL database Percona Live 2020
Working With PostgreSQL As A JSON Document Store Robert Bernier Percona Live Online 2020
Parallelism in PostgreSQL Ibrar Ahmed Percona Live Online 2020
The Evolution of PostgreSQL Partitioning
Why PostgreSQL is Becoming a Migration Target in Large Enterprises 1
Percona Distribution for PostgreSQL
A Deep Dive Into PostgreSQL Indexing
Monitoring PostgreSQL with Percona Monitoring and Management PMM
High Availability and Automatic Failover in PostgreSQL on Kubernetes On premise and Cloud
HA PostgreSQL on Kubernetes by Demo
MySQL Group Replication vs PostgreSQL Bi Directional Replication MySQL vs PostgreSQL
Upgrade or Migrate Your PostgreSQL Database Through a Lowest Possible Downtime
Gonymizer A PostgreSQL Tool for Anonymizing Protected Health for HIPAA Compliant Test Infrastructur
Getting Started with PostgreSQL
Building PostgreSQL as an Enterprise Grade Setup Using Open Source Tools
New and Maturing Built in Features in PostgreSQL to Help Build Simple Shards
Upgrading Migrating your legacy PostgreSQL to newer PostgreSQL versions
Monitoring PostgreSQL with Percona Monitoring and Management PMM
Introduction to PostgreSQL Overview PostgreSQL Tutorial
PostgreSQL High Performance Tuning and Optimization PostgreSQL Tutorial
Lesson 1 Overview Deep Dive Into PostgreSQL Indexes Course Percona University Online
Monitoring PostgreSQL PostgreSQL Talk
Lesson 2 Heap vs Index Deep Dive Into PostgreSQL Indexes Course Percona University Online
Lesson 3 How to Create Indexes Deep Dive Into PostgreSQL Indexes Course
Lesson 4 How to create an Expression Index Deep Dive Into PostgreSQL Indexes Course
Lesson 5 Advantages of a Partial Index Deep Dive Into PostgreSQL Indexes Course
Lesson 6 Index Types B Tree Deep Dive Into PostgreSQL Indexes Course Percona University
Lesson 7 What is HASH Index Index Types Deep Dive Into PostgreSQL Indexes Course
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 🎉 !
4.8
(145 reviews)
Overall rating
Reviews
Be the First One Review This Course
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.
Cancel your subscription anytime