Learning should never stop and particularly new technology, every year, I focus on learning new technology. Today I am sharing the PostgreSQL Learning Path.
Learn PostgreSQL – Learning Path
- Course 1: PostgreSQL: Getting Started
PostgreSQL is commonly known as Postgres and is often referred to as the world’s most advanced open source database. In this course, we will go over the basics of PostgreSQL. We will cover topics ranging from installations to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.
- Course 2: PostgreSQL: Introduction to SQL Queries
In this course, we will learn about various data types and their impact on performance and database designs. We will learn about various table operations, schemas, keys, and constraints. We will also learn how to efficiently retrieve data and make a modification to data with insert, update, and delete operations.
- Course 3: PostgreSQL: Advanced SQL Queries
In this course, we will discuss advanced queries for PostgreSQL. We will learn about functions and operators, type conversions, and transactions.
- Course 4: PostgreSQL: Advanced Server Programming
If you’re a database developer looking to expand your skills and understanding of triggers, rules, and procedural language in PostgreSQL, this course is for you.
- Course 5: PostgreSQL: Index Tuning and Performance Optimization
Data is critical to any application, and database performance goes hand-in-hand with it. In this course, you’ll get to see some ways to maximize database performance with PostgreSQL, covering indexes, best practices, and more.
I hope you find this MariaDB Learning Path helpful. If you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.