This is the last week of the year and most places it is a holiday. While we learn about SQL Server entire year, let us get out of the comfort zone and learn about different technology every day of the week. Today we will discuss where we can learn PostgreSQL.
PostgreSQL is considered to be one of the most advanced open-source databases. 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.
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 PostgreSQL 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.
Reference: Pinal Dave (https://blog.sqlauthority.com)