PostgreSQL is considered to be one of the most advanced open source database. PostgreSQL is very easy to learn as well as it is very implemented and easy to implement. Along with SQL Server I have been recently focusing on MySQL and PostgreSQL. While working with three well proven Relational Databases, I have figured out that once you know one relational language, it is really easy to master another relational language, we just have to know the basics and the rest of the advanced concepts we can build over our founding concepts. In this blog post we will discuss about the PostgreSQL Learning Path.
Earlier this year, I have completed a series of five courses on Pluralsight about PostgreSQL. While I build these courses I have kept following details in my mind:
- Each concept should be easy to understand
- Each example, should feel very close to real world scenarios
- Each demonstration should be easy to execute
Well, that’s it. I kept above three rules in my mind when I built the courses and each course is extremely well received. Here is the link five courses. I strongly suggest that you follow this learning path to learn PostgreSQL. However, you can select any course and any module and learn from that point. I have made sure that each topic can be learnt independent from each other.
Please note that you will need valid access to Pluralsight to watch this courses. Pluralsight offers free trials.
Course 1: PostgreSQL: Getting Started
PostgreSQL is commonly known as Postgres and is is often referred to as a the world’s most advanced open source database. In this course, we will go over the basics of the 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 datatypes 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 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.
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.
Reference: Pinal Dave (https://blog.sqlauthority.com)