← Back to Training Catalog
UPSKILLING PROGRAM

Querying PostgreSQL Databases

Duration: Self-Paced | Status: Active
Querying PostgreSQL Databases

Course Description

The Querying PostgreSQL Databases course from SIRIAM 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.

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

Training Curriculum

LESSONS
  • Introduction to PostgreSQL Server
  • Introduction to SQL Language
  • Working with Data Types
  • Working with Built-In-Functions
  • Querying and Filtering Data
  • Working with Type Conversions and Operators
  • Working with Joins
  • Working with Group and Aggregation
  • Working with Windows Function
  • Working with Views, Sub Query Expressions and Common Table Expressions
  • Working with Functions
  • Querying Metadata of PostgreSQL
  • Introduction to DML
  • Introduction to Indexes and Collations
  • Introduction of PGADMIN III

Program Details

Duration
Self-Paced
Delivery Mode
Instructor-Led Online & Classroom
Enroll / Enquire Now →