Database

ATC-PSQL-ADM-DEV : PostgreSQL Administration & Development

Course Duration

4 Days

Delivery

ILT VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

PostgreSQL is the most advanced open source database; it is globally accepted as an incredibly powerful tool for database management. PostgreSQL Administration & Development course offers you the information required to manage your live production database. It handles the administration and performance tuning of PostgreSQL databases. The candidates of PSQL training program are likely to learn the use of specialized PostgreSQL (AKA Postgres) modules such as replication, connection pooling, and full-text searching.

What You'll Learn

Install, configure, and upgrade PostgreSQL Server
Replicate data between PostgreSQL Server instances
Deal with data access mechanisms and custom components
Detail the data access mechanisms

Who Should Attend

Anyone who wants to learn PostgreSQL skills.
Professionals getting started on PostgreSQL projects.

Prerequisites

A participant is expected to have basic knowledge of SQL and C. He/she also needs to know basic system administration (Windows or Unix/Linux).

Learning Journey

Coming Soon...

UNIT 1: What is PostgreSQL?

A Brief History of PostgreSQL
Conventions
Further Information
Bug Reporting Guidelines

UNIT 2: Introduction to PostgreSQL

Installation and Creating Database
The SQL Language
Advanced Features

UNIT 3: The SQL Language

SQL Syntax
Data Definition
Data Manipulation
Queries
Data Types
Functions and Operators
Type Conversion
Indexes
Full Text Search
Concurrency Control
•Performance Tips

UNIT 4: Server Administration

Installation from Source Code
Installation from Source Code on Windows
Server Setup and Operation
Server Configuration
Client Authentication
Database Roles
Managing Databases
Localization
Routine Database Maintenance Tasks
Backup and Restore
High Availability, Load Balancing, and Replication
Recovery Configuration
Monitoring Database Activity
Monitoring Disk Usage
Reliability and the Write-Ahead Log
Regression Tests

UNIT 5: Client Interfaces

libpq - C Library
Large Objects
ECPG - Embedded SQL in C
The Information Schema

UNIT 6: Server Programming

Extending SQL
Triggers
The Rule System
Procedural Languages
PL/pgSQL - SQL Procedural Language
PL/Tcl - Tcl Procedural Language
PL/Perl - Perl Procedural Language
PL/Python - Python Procedural Language
Server Programming Interface

UNIT 7: Internals

Overview of PostgreSQL Internals
System Catalogs
Frontend/Backend Protocol
PostgreSQL Coding Conventions
Native Language Support
Writing A Procedural Language Handler
Writing A Foreign Data Wrapper
Genetic Query Optimizer
Index Access Method Interface Definition
GiST Indexes
GIN Indexes
Database Physical Storage
BKI Backend Interface
How the Planner Uses Statistics

Trainocate Certificate of Attendance

Frequently Asked Questions (FAQs)

Why should I pick up this course and get certified?

Career Advancement: Boost your earning potential and unlock new job opportunities.
Stay Relevant: Keep your skills current in the ever-changing tech landscape.
Problem-Solving Prowess: Hone your critical thinking and problem-solving abilities.
Hands-On Experience: Apply your knowledge through practical labs and projects.
Expand Your Network: Connect with industry experts and like-minded professionals.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By Advanced Technology Courses

Browse All Courses

Blockchain

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself
Company

Inquiry Details

By providing your contact details, you agree to our Privacy Policy.