Course outline for PostgreSQL
About PostgreSQL
Pre-requisites for learning PostgreSQL
- 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
Duration
- 2-5 days
Training Mode
Online training for PostgreSQL
We provide:
- Instructor led live training
- Self-paced learning with access to expert coaches
- 24x7 access to cloud labs with end to end working examples
All jnaapti sessions are 100% hands-on. All our instructors are engineers by heart. Activities are derived from real-life problems faced by our expert faculty. Self-paced hands-on sessions are delivered via Virtual Coach.
Classroom training for PostgreSQL
Classroom sessions are conducted in client locations in:
- Bengaluru
- Chennai
- Hyderabad
- Mumbai
- Delhi/Gurgaon/NCR
Note: Classroom training is for corporate clients only
Detailed Course Outline for PostgreSQL
Basics 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