+91 88606 33966 edu_sales@siriam.in Job Opening : On-site Functional Trainer/Instructor | Supply Chain Management (SCM)

PostgreSQL

Querying PostgreSQL Databases

0 (0)

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.

Curriculum

1 Section
15 Lessons
24h Duration

Expand All

LESSONS

15 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

0 out of 5

0 user ratings

Querying PostgreSQL Databases

Course Prerequisites

Curriculum

LESSONS

Deleting Course Review

Course Access