Intermediate
Querying PostgreSQL Databases
- 1 Section
- 15 Lessons
- 24h Duration
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
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.
Want to submit a review? Login