PostgreSQL – Learn Online in a Single Day – PostgreSQL Learning Path

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.

PostgreSQL - Learn Online in a Single Day - PostgreSQL Learning Path postgresql

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.

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.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Pluralsight, PostgreSQL
Previous Post
Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081
Next Post
Restore or Attach Database Without Log File – SQL in Sixty Seconds #082

Related Posts

1 Comment. Leave new

  • Irfan Charania
    October 28, 2016 7:57 pm

    Hi Pinal,

    Have you come across a GUI tool for Postgres that’s better than pg admin?
    I’ve yet to find something that’s as nice to work with as MS SQL Server Management Studio…

    Reply

Leave a Reply