Learn Database Advanced SQL Queries Online

Course outline

Advanced SQL Queries :-

- Database Views using Postgres Database

- Named Queries & Sub-Queries using SQL in Postgres

- Create Table As Select (CTAS)

- Advanced DML Operations on Postgres Database Tables

- Merging or Upserting Data in Tables

- Analytic Functions using SQL in Postgres (Aggregations, Windowing, Filtering and Ranking)

Prerequisite knowledge

Database Operations -Postgresql

Database Fundamentals - SQL Queries, Tables & Indexes

Learning outcomes

This session will enable the learners to advance further in their SQL Queries journey, by helping them understand and write Advanced SQL Queries using Postgresql.

Software / Hardware requirements

Postgresql Database

Database Fundamentals - Predefined Functions (Postgresql)

2 hours session

Database Fundamentals - Tables & Indexes (Postgresql)

1.5 hours session

Database Fundamentals - Postgresql Database & SQL Queries

1.5 hours session

Want to upskill or acquire a new skill?

Start Learning!