PostgreSQL management, tutorials, scripts, coding, programming and tips for database administrators

PostgreSQL

How Many Databases Can You Name? 05/11/2020

There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!

Understanding Views in SQL 04/27/2020

Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.

Working with SQL Cursors 03/23/2020

In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.

How do OODBMS and ORDBMS Differ from RDBMS? 02/10/2020

Get a high-level understanding of how object-relational and object-oriented database management systems differ from traditional relational database management systems.

A Quick Look at SQL Server Numeric Functions 12/19/2019

If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions

Hands-on SQL in PostgreSQL 12/16/2019

Learn how SQL commands are typically entered using the PostgreSQL interactive terminal - psql. Get hands-on information for using SQL to deal with CRUD, viewing data, and more by using some of the basic SQL commands in PostgreSQL.

A Beginner’s Guide to SQL String Functions 11/21/2019

Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!