Intro to PostgreSQL
for Non-PostgreSQL DBAs
Future-Proof Your Database Skills and Discover PostgreSQL
April 29 - 30, 2025
8:00-10:00AM Pacific
$300.00 USD (discounts for paid members)
Why should I attend this class?
PostgreSQL popularity is gaining ground
This class goes beyond introducing you to PostgreSQL—it equips you to use it effectively. You will learn how to harness its power to build faster, more reliable, and scalable applications. You won’t just learn why it’s popular—you’ll leave knowing how to apply its strengths to your own projects.
Get step-by-step guidance on Clusters
Get step-by-step guidance on installing, configuring and running PostgreSQL Clusters to meet your application’s needs. You’ll learn how to keep your PostgreSQL Cluster running optimally with index and statistics maintenance, monitoring your cluster, and creating effective backup solutions.
To stay relevant in the database world
Learning about this open-source and cost-effective database will keep you relevant and prepare you as companies continue to look for cost-savings while still enjoying enterprise-grade performance and scalability.
Gain practical knowledge of how PostgreSQL works
Master table design and server-side programming, with easy-to-follow examples, designed to build confidence in writing queries, designing schemas, and managing databases. Learn about indexing, query optimization, and performance tuning to work efficiently with large datasets.
You will be able to:
Class Pricing:
Class Outline:
Session 1
History and Installation
Postgresql History
Ubuntu Installation
Upgrade Information
Cluster Details and Basic Management
Disk Layout
Basic Administration Tasks Using PSQL and Various Binaries
Overview of PSQL and PGAdmin
Overview of PostgreSQL Cluster Components
Useful Binaries for Basic Administration
Session 2
Details:
Class Hours: There are 4 hours of live, interactive class training divided into two 2-hour sessions.
Skill Level: Knowledge of basic Linux navigation, basic SQL concepts, and general database design is beneficial.
Class Structure: OraPub believes you learn more when you freely and actively engage during the training. This is why each session is full of live demonstrations, lots of Q&A time and hands-on action! If you miss a session, you are free to attend that session when the class is offered again.
Watching Recorded Sessions: Each session is recorded and used to create a unique web page just for your class. The recordings can be streamed using any device, but not downloaded. You can re-watch the videos as many times as you wish. The videos and your unique class web page will be available for three years!
Class Requirements:
You will need:
Welcome OraPub Members!
Enter the member portal and be ready to be transformed in your Oracle DBA work.
© Copyrights by OraPub. All Rights Reserved.