Duration
3 days
Outline
- Introduction to PostgreSQL Server
Overview
- History
- PostgreSQL Internals
- Introduction to SQL Language
- Writing SQL Queries
- Structure of SQL Queries
- Working with Data Types
- Working with Built-In-Functions
- Querying and Filtering Data
- Where Clause
- NULL Values
- ORDER BY
- DISTINCT
- Working with Type Conversions and Operators
- Logical, Mathematical, Comparison, Bit String Operators
- UNION and UNION All
- 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
- System Information Functions
- System Administration Functions
- Introduction to DML
- Introduction to Indexes and Collations
- Introduction of PGADMIN III
Programme scope, delivery arrangements and suitability are confirmed during enquiry.