Category: Databases

postgresql Order by & Group by

How to PostgreSQL- Order By & Group By

In this guide, we are going to learn how to use PostgreSQL ORDER BY & GROUP BY statements with Select. Before you continue its recommended to read previous PostgreSQL guides. PostgreSQL ORDER BY...

How to PostgreSQL- Update & Delete Query

How to PostgreSQL- Update & Delete Query

This PostgreSQL tutorial explains how to use the UPDATE & DELETE Query  Statements with syntax and examples. PostgreSQL UPDATE command will modify any field value of any PostgreSQL table. The DELETE statement is used to...

postgresql Insert & Select

How to PostgreSQL- Insert & Select Query

In this tutorial, you will learn how to use INSERT  & SELECT Query to insert & retrieve data respectively from a PostgreSQL table.   PostgreSQL INSERT The PostgreSQL INSERT statement is used to insert...

How to PostgreSQL- Create & Delete Tables

How to PostgreSQL- Create & Delete Tables

In this tutorial, you will learn how to use CREATE TABLE & DROP TABLE statements to create & delete tables respectively from the database.   PostgreSQL CREATE TABLE The PostgreSQL CREATE TABLE statement...

postgresql Installation

How to PostgreSQL- Installing PostgreSQL

This tutorial will show you how to install PostgreSQL Database on your local system to learn and practice PostgreSQL.   Download PostgreSQL Database You can start the download PostgreSQL from EnterpriseDB website. It leads...

postgresql -Getting started

How to PostgreSQL- Getting started

Getting Started In this guide, You will learn PostgreSQL through many practical examples. PostgreSQL is a fully featured object-relational database with many enterprise features. PostgreSQL is a general purpose and object-relational database management...

Scalar function

How to MySQL- Scalar functions

This SQL Tutorial provides you a summary of some of the most common MySQL Scalar Functions. Scalar functions act only on single data values.  MySQL provides many scalar functions that include. UCASE() –...

Aggregation Function

How to MySQL- Aggregate functions

MySQL has many built-in functions for performing calculations on data. There are two types of function, Aggregate, and scalar. An aggregate function performs a calculation on a set of values and returns...