PostgreSQL Training in Australia

We can host this training at your preferred location. Contact us!

With in-depth tutorials and a practical, hands on workshop, you will learn about the basics and advanced features of PostgreSQL and how to develop applications with PostgreSQL as the back-end.

You will be led by our team of expert trainers who will hand hold you through the concepts of database installation and connection, writing queries to manage the database, and SQL statements to operate PostgreSQL. You will also get the PostgreSQL certification on successful completion of the course..

Participants are required to have basic knowledge of DATABASE and RDBMS.

How relational databases work and how are they relevant in today’s times
What sort of a database management system is PostgreSQL
How to install and setup PostgreSQL and run queries on it
How to create applications with PostgreSQL as a back end database management system

Module 1: Introduction

History of PostgreSQL
Major Features
New Features of PostgreSQL
Multi Version Concurrency Control
Write-Ahead Logging
Architectural Overview
Limits

Module 2: PostgreSQL System Architecture

Architectural Summary
Shared Memory
Statement Processing
Utility Processes
Disk Read Buffering
Write Buffering
Background Writer Cleaning Scan
Commit & Checkpoint
Physical Database Architecture
Data Directory Layout
Installation Directory Layout
Page Layout

Module 3: Creating and Managing Databases

Object Hierarchy
Creating Databases
Creating Schemas
Schema Search Path
Roles, Users & Groups
Access Control

Module 4: Postgres Data Dictionary

The System Catalog Schema
System Information views/tables
System Information Functions

Module 5: Configuration

Setting PostgreSQL Parameters
Access Control
Connection Settings
Security and Authentication
Settings
Memory Settings
Query Planner Settings
WAL Settings
Log Management
Background Writer Settings
Statement Behavior

Module 6: Security

Authentication
Authorization
Levels of security
pg_hba.conf file
Users
Object ownership
Access control
Application access parameters

Module 7: Backup and Recovery & Point-in Time Recovery

Backup Types
SQL Dump
Cluster Dump
Offline Copy Backup
Continuous Archiving
pg_basebackup
Point-In Time Recovery
pg_upgrade

Module 8: Routine Maintenance

Explain and Explain Analyze
Table Statistics
Updating Planner Statistics
Vacuuming
Scheduling Auto Vacuum
Preventing Transaction ID Wraparound Failures
The Visibility Map
Routine Reindexing

Module 9: Table Partitioning

Partitioning
Partitioning Methods
When to Partition
Partitioning Setup
Partitioning Example
Partitioning and Constraint
Exclusion
Caveats

Module 10: Database Monitoring

Database Statistics
The Statistics Collector
Database Statistic Tables
Operating System Process Monitoring
Current Sessions and Locks
Log Slow Running Queries
Disk Usage

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Upcoming Trainings

Join our public courses in our Australia facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

23 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

26 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

27 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

23 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

26 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

27 November 2024

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

14 March 2025

Melbourne, Sydney, Brisbane

4 Days

Classroom / Virtual Classroom

25 March 2025

Melbourne, Sydney, Brisbane

4 Days

PostgreSQL Training Course in Australia

Australia is the smallest continent yet it's also one of the largest countries in the World. As the oldest and flattest continent, Australia is a mega-diverse country with a vast variety of landscapes, climates and animals. Canberra is the capital city while Sydney, Brisbane and Melbourne are the more popular ones. Australia is a developed country with a high-income economy and a member of the United Nations, G20 and the Commonwealth of Nations.

While cricket and football are the most popular sports in Australia, the Australian Open tennis grand slam tournament is a major international event that takes place in this country. The island of Tasmania has the cleanest air in the world. Uluru-Kata Tjuta National Park, Great Barrier Reef, Kangaroo Island, Kakadu National Park, Whitsunday Islands and The Pinnacles are some of the jaw-dropping places in Australia.

We offer a wide range of IT courses, from cybersecurity, data science and software development to business skills and project management, and we can host training at your preferred location in Australia. Let our experienced instructors provide you with hands-on training and practical insights.

Prerequisites

What You Will Learn

Outline

Module 1: Introduction

Module 2: PostgreSQL System Architecture

Module 3: Creating and Managing Databases

Module 4: Postgres Data Dictionary

Module 5: Configuration

Module 6: Security

Module 7: Backup and Recovery & Point-in Time Recovery

Module 8: Routine Maintenance

Module 9: Table Partitioning

Module 10: Database Monitoring

WHAT IS A BACKEND DEVELOPER?

Upcoming Trainings