Today I want to share PostgreSQL Learning Path at Pluralsight where you can learn this technology systematically. PostgreSQL is known as Postgres as well.
Pluralsight – Storing and Managing Data with Postgres on Heroku
I have recently released a new course at Pluralsight on Storing and Managing Data with Postgres on Heroku. Let us learn more about it today.
Heroku – How to Deploy Postgres Add-Ons?
Recently I was helping one of my clients on Performance Health Check, they asked me if I know how to Deploy Postgres Add-Ons on Heroku.
Learn PostgreSQL – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss where we can learn PostgreSQL. PostgreSQL Learning Path
Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
PostgreSQL – Storing Unicode Characters is Easy
One of the interesting features of PostgreSQL database is the ability to handle Unicode characters. In SQL Server, to store non-English characters, we need to use NVARCHAR or NCAHR data type. In PostgreSQL, the varchar data type itself will store both English and non-English characters.
PostgreSQL – Learn Online in a Single Day – PostgreSQL Learning Path
PostgreSQL is considered to be one of the most advanced open source database.In this blog post we will discuss about the PostgreSQL Learning Path.