Course outline for PostgreSQL
TechnologyPostgreSQLDuration
* 2-5 days
LevelPrerequisites listed
About PostgreSQL
Pre-requisites
- Participants must have good knowledge of relational databases and database administration
- Participants must be comfortable in a Linux environment
Lab Setup
- 2GB of free RAM, 20GB of free disk space and full network connectivity
How we train
Online training for PostgreSQL
- Instructor-led live cohorts
- Self-paced learning with expert coaches
- 24x7 cloud labs with end-to-end examples
All sessions are 100% hands-on. Labs and activities are derived from real-world work our engineers deliver.
Classroom training
Available for corporate teams in:
- Bengaluru
- Chennai
- Hyderabad
- Mumbai
- Delhi/Gurgaon/NCR
- Pune
Note: Classroom training is for corporate clients only.
Self-paced hands-on sessions are delivered via VirtualCoach.
Detailed Course Outline
Hands-onBasics of PostgreSQL
- Introduction to PostgreSQL
- Basic Syntax – Identifiers, Constants, Operators and Expressions
- PostgreSQL Queries – Simple and Complex
Data Types in PostgreSQL
- Numeric, Character and Boolean Types
- Date/Time Types
- Range Types
- Arrays
- Composite Types
Functions and Operators in PostgreSQL
- Logical, Comparison, Mathematical and String Functions and Operators
- Aggregate, Range Functions and Operators
- Pattern Matching
- Trigger and Event Trigger Functions
Indexes in PostgreSQL
- Introduction to Indexing
- Index Types
- Multicolumn, Partial and Unique Indexes
Concurrency Control in PostgreSQL
- Transaction Isolation
- Explicit Locking
- Data Consistency
Introduction to PL/pgSQL
- Basics of PL/pgSQL
- Functions in PL/pgSQL
- Cursors in PL/pgSQL
- Triggers in PL/pgSQL