Making Intellectuals Meet Excellence!
Querying PostgreSQL Databases
Intermediate
Querying PostgreSQL Databases
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
- 0 Quizzes
- 24h Duration
LESSONS
15 Lessons0 Quizzes
- 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