PostGreSQL/Querying PostgreSQL Databases

Querying PostgreSQL Databases Certification Training Course Overview

The Querying PostGreSQL Databases course from Koenig offers insightful training on intermediate level querying of SQL using PostGreSQL. PostgreSQL or just Postgres, is a relational database that is open source. This ACID-compliant RDBMS is available for various platforms. It is completely transactional in nature and chiefly employs the SQL:2008 standard. PostgreSQL has extensible data types, functions, operators, aggregates, index methods, procedural languages, and a lot of extensions by third parties.

Querying PostgreSQL Databases (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1100
02 - 04 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1300
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction to PostgreSQL Server
  • Overview
  • History
  • PostgreSQL Internals
Module 1: Introduction to PostgreSQL Server
  • Overview
  • History
  • PostgreSQL Internals
Module 2: Introduction to SQL Language
  • Writing SQL Queries
  • Structure of SQL Queries
Module 2: Introduction to SQL Language
  • Writing SQL Queries
  • Structure of SQL Queries
Module 3: Working with Data Types
  • Topic details are not available.
Module 3: Working with Data Types
  • Topic details are not available.
Module 4: Working with Built-In-Functions
  • Topic details are not available.
Module 4: Working with Built-In-Functions
  • Topic details are not available.
Module 5: Querying and Filtering Data
  • Where Clause
  • NULL Values
  • ORDER BY
  • DISTINCT
Module 5: Querying and Filtering Data
  • Where Clause
  • NULL Values
  • ORDER BY
  • DISTINCT
Module 6: Working with Type Conversions and Operators
  • Logical, Mathematical, Comparison, Bit String Operators
  • UNION and UNION All
Module 6: Working with Type Conversions and Operators
  • Logical, Mathematical, Comparison, Bit String Operators
  • UNION and UNION All
Module 7: Working with Joins
  • Topic details are not available.
Module 7: Working with Joins
  • Topic details are not available.
Module 8: Working with Group and Aggregation
  • Topic details are not available.
Module 8: Working with Group and Aggregation
  • Topic details are not available.
Module 9: Working with Windows Function
  • Topic details are not available.
Module 9: Working with Windows Function
  • Topic details are not available.
Module 11: Working with Functions
  • Topic details are not available.
Module 11: Working with Functions
  • Topic details are not available.
Module 12: Querying Metadata of PostgreSQL
  • System Information Functions
  • System Administration Functions
Module 12: Querying Metadata of PostgreSQL
  • System Information Functions
  • System Administration Functions
Module 13: Introduction to DML
  • Topic details are not available.
Module 13: Introduction to DML
  • Topic details are not available.
Module 15: Introduction of PGADMIN III
  • Topic details are not available.
Module 15: Introduction of PGADMIN III
  • Topic details are not available.
Download Course Contents

Request More Information

Course Prerequisites
  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows/Linux operating system and its core functionality.

Upon Completion of this Course, you will accomplish following:

  • An Introduction to concepts of database and RDBMS
  • Introduction to SQL and PostgreSQL
  • Querying, Filtering and Retrieving Data
  • Creating Tables and Ensuring Data Integrity
  • Manipulating Data in Tables
  • Working with Views, Subqueries and Functions

Give an edge to your career with Other Technologies certification training courses. Students can join the classes for Querying PostgreSQL Databases at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.