Introduction to PostgreSQL for Developers and Administrators

Introduction to PostgreSQL for Developers and Administrators

Bascom Bridge’s Introduction to PostgreSQL for Developers and Administrators training teaches attendees how to build, query, program stored procedures in PL/pgSQL, and administer the popular, open source PostgreSQL database platform.

 

POSTGRESQL TRAINING OBJECTIVES

All students will learn how to:

  • Find PostgreSQL documentation and resources
  • Work with PostgreSQL functions
  • Create your own functions
  • Program with PL/pgSQL
  • Install and setup PostgreSQL securely
  • Work with basic administration tasks such as user creation, cataloging, and backing up
  • Use SLONY and PGPOOL
  • Work with inheritance in PostgreSQL
  • Partition tables
  • Use Tablespaces
  • Monitor the database
  • Use the EXPLAIN Statement
  • Use PITR
  • Tune the PostgreSQL Server

POSTGRESQL TRAINING PREREQUISITES

All PostgreSQL training students must have a solid understanding of basic relational database principles and SQL SELECT statements prior to this training.

POSTGRESQL TRAINING MATERIALS

All students receive comprehensive courseware.

SOFTWARE NEEDED FOR EACH PC:

  • Operating system of your choice
  • A full installation of the PostgreSQL Core Distribution (your choice of version; please just make us aware of the version you choose)
  • Sample databases and lab files that Accelebrate provides
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

POSTGRESQL TRAINING OUTLINE

  • Introduction and Architecture
    • History and Overview
    • PostgreSQL Major Features
    • PostgreSQL Limits
    • PostgreSQL Architecture
    • MVCC
    • Write Ahead Logs
    • The Background Writer
    • PostgreSQL Data Types
  • Installation
    • Overview
    • Binary Installation
    • Source Installation
    • Initializing a PostgreSQL cluster
    • Starting and stopping a PostgreSQL cluster
    • Automatic startup/shutdown
  • Configuration
    • Access Control
    • Connection settings
    • Security and Authentication settings
    • Memory settings
    • Kernel resource settings
    • Log management
    • Background writer settings
    • Vacuum cost settings
    • Autovacuum settings
  • Intro to psql
    • Command line parameters
    • Meta commands
    • Security
  • Managing PostgreSQL Databases
    • PostgreSQL Clusters
    • PostgreSQL Databases
    • Tables, Joins and Aggregates
    • PostgreSQL Indexes and Foreign Keys
  • Roles and Security
    • Schemas
    • Tables, Views and Rules
    • Users, Groups and Roles
    • Tables and Sequences
    • Object Security
  • Tablespaces, Partitioning and Advanced Features
    • Vacuum
    • Tablespaces
    • Inheritance
    • Table Partitioning
    • Windowing Functions
    • Transactions
    • Concurrency Control
    • Functions and Operators
    • Type conversion
    • Full text search
  • Moving Data with PostgeSQL
    • Basic DML
    • COPY
    • Other Tools
  • Routine DBA Tasks and Best Practices
    • Log Management
    • Query analysis
    • Routine Vacuuming
    • Recovering disk space
    • Managing Planner statistics
    • REINDEX
  • Monitoring and Statistics
    • Database Logs
    • OS Process monitoring
    • The PostgreSQL Statistics Collector
    • Statistics Views
    • Statistics Functions
  • Performance Tuning
    • OS Tuning
    • Hardware configuration
    • Transaction logs
    • Tablespaces and Partitioning
    • Checkpoint tuning
    • Query tuning
  • Backup and Recovery
    • The pg_dump utility
    • The pg_dumpall utility
    • Recovery options
    • Point In Time Revovery
  • PostgreSQL Upgrades
    • The pg_upgrade utility
    • RPM based upgrades
    • Source based upgrades
    • Replication based upgrades
    • Rolling back
  • Replication and HA
    • Streaming Replication
    • Synchronous Replication
    • Replication Slots
    • Failover management
    • Connection Poolers
    • HA configurations
  • Triggers
    • Overview
    • Triggers
  • Event Triggers
    • Overview
    • Event Triggers
  • RULEs
    • Overview
    • SELECT Views
    • Updating a View
    • Materialized Views
    • Rules and privileges
  • The PL/pgSQL Language
    • Structure
    • Declarations
    • Expressions
    • Statements
    • Control Structures
    • Cursors
    • Errors and Messages
    • Trigger Procedures
  • Other Procedural Languages
    • PL/Perl
    • PL/Python
    • More…
  • PostgreSQL Contribs
    • Overview of additionally supplied modules
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


Introduction to PostgreSQL for Developers and Administrators

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : PSQL-100
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 30 hours
Scroll Up
Skip to toolbar