SQL Server vs Oracle vs PostgreSQL Comparison

Learn about the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and PostgreSQL.

This tip looks at the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, and the concepts of roles, schemas, and owners.

Learn how to schedule tasks in SQL Server, Oracle, and PostgreSQL along with the similarities and differences.

Learn similarities and differences of aggregate functions for Having, Order By, Distinct, Partition By and more in SQL Server, Oracle and PostgreSQL.

Learn about the similarities and differences of aggregate functions like sum, count, min, max, avg and more for SQL Server, Oracle and PostgreSQL.

In this article we look at the SQL functions COALESCE, ISNULL, NULLIF and do a comparison between SQL Server, Oracle and PostgreSQL.

Learn about the differences in SQL Server, Oracle and PostgreSQL on how to use variables for ad hoc queries and stored procedures.

Learn about the differences in SQL Server, Oracle and PostgreSQL on how to store large textual data.

Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.

Learn how to setup, configure and use identity columns in SQL Server, Oracle and PostgreSQL along with the similarities and differences.

Learn about different ways time zones are handled in SQL Server, Oracle and PostgreSQL along with examples to retrieve and update the settings.

In this article we look at how to use string functions to concatenate, replace, trim and get substrings in SQL Server, Oracle and PostgreSQL.

In this article we look at some of the differences and similarities with working with dates in SQL Server, Oracle and PostgreSQL.

Similarities and differences of views in SQL Server, Oracle and PostgreSQL including indexed views, materialized views and updatable views.

Learn how to query across database servers and database platforms for SQL Server, Oracle and PostgreSQL.

Learn about the similarities and differences of SQL Server, Oracle and PostgreSQL related to instances, databases, schemas and linked servers.

Learn about Window Functions in SQL Server, Oracle and PostgreSQL to see the differences and similarities.

Learn about the differences and similarities when deleting data from SQL Server, Oracle and PostgreSQL with the several examples in this article.

In this article we look at the different SQL syntax you need to use when inserting data into tables for SQL Server, Oracle and PostgreSQL.

In this article we look at the different SQL syntax you need to use when updating data for SQL Server, Oracle and PostgreSQL.