loader
PostgreSQL

Learn PostgreSQL with our comprehensive and user-friendly course!

Basic to Advanced Course

Intuitive & Practical Learning

Getting started with PostgreSQL

Let us install PostgreSQL and understand the basics of PostgreSQL.

Installation of PostgreSQL

+0 XP

Introduction of PostgreSQL

+0 XP

Schema-database for queries

+0 XP

Creating and Inserting Tables

Let us write query in PostgreSQL and learn the building blocks to create , insert, select data from database tables.

Creating-Inserting Tables

+9 XP

Querying Table.

+12 XP

AND-OR Operators

+21 XP

NOT Operator.

+11 XP

Aggregate Functions and Operators

Let us write query in PostgreSQL and learn the building blocks of various Aggregate Functions and Operators.

List of Aggregate Functions

+9 XP

LIKE Operator.

+10 XP

IN,BETWEEN Operator

+20 XP

ALIAS.

+10 XP

Data Manipulation

Let us write query in PostgreSQL and learn the building blocks of various Data Manipulation.

Update Statement

+8 XP

Delete Statement

+7 XP

LIMIT Clause

+8 XP

Joins

Let us write query in PostgreSQL and learn the building blocks of various Joins statement.

Pre-Requisites

+0 XP

Inner Join

+10 XP

Left Join

+9 XP

Right Join

+9 XP

FULL OUTER Join

+10 XP

Statement, Clause & Operators

Let us write query in PostgreSQL and learn the building blocks of statement, clause and operators.

UNION Operator

+9 XP

GROUP BY

+9 XP

HAVING Clause

+10 XP

Comments

+9 XP

Subqueries

Let us write query in PostgreSQL and learn the building blocks of Subqueries.

Subqueries Explanation

+9 XP

ANY Keyword

+8 XP

ALL Keyword

+8 XP
Trophy
100 XP
Trophy
225 XP
Trophy
0 XP
S M T W T F S
Practice Daily to Unlock Badges. Keep the Streaks and Fire Burning!
Shopping Cart
5 new
Sub Total
$2530
Total
$6830
Go to shopping cart