Postgresql is rapidly replacing the traditional go-to databases in the enterprise space for workloads from the traditional back-end store for enterprise applications to big data workloads for machine learning and AI.
Postgresql implements and extends the SQL standard and has become a data platform with a rich feature set that allows developers and engineers to create solutions that simply are not possible on the traditional databases.
Replacing existing databases or using Postgresql as a foundation for your application requires resources with skills in
Postgresql database administration (dba) and,
Postgresql development with knowledge of APIs, unique data types and extensions
To get the most out of the rich Postgresql API, fetures and extensions developers need to know how to:
write optimised psql procedures,
install, use and create extensions,
write procedures in your preferred language,
define new data types,
define new functions,
leverage unique data types such as json, xml and hstore
See our Postgresql Developer training course outline for more details.
Testimonials
What our alumni have to say about our training
Training was very practical and I liked the troubleshooting skills demonstrated which will help me greatly at work
- Kaofela :: Botswana Revenue Services
Very pleasant training that covered a broad range of topics which exceeded expectation
- Jason :: SEDA
I loved the relevance of the training content towards my daily work and improved knowledge for making relevant recommendations
- Mayshiya :: Auditor General
Thanks for everything, experience was great and worth every cent.
- Leeto :: ABSA
The training was great and opened interesting channels that I never knew existed.
-Thato :: FNB
I loved the practical examples and channels explored plus the instructor created an engaging environment
- Saleha :: Bankserv Africa
Training was structured to be accommodative to everyone and the trainer went the extra mile for us as students
- Boiphelo :: FNB
More than enough to take with and implement, training was informative and practical which was the best part
- Thabiso :: Affinity Health
I would just like to say thank you for the incredible training experience. The professionalism and quality of training offered by Jumping Bean is first-class
Essential skills for a Postgresql administrator include the ability to optimise data storage, locations, improve query performance via index management and query plan analysis as well as setting up a robust backup policy and implementing replication. All of these skills are covered in our Postgresql database administrator course.
Whether you have database admin experience in another database or new to database administration this course will provide you with the skills you need to successfully manage your Postgresql cluster.
Anything missing in the course outline that you want to be covered? Let us know. We are happy to customise our courses to suit your needs. For pricing and details please see the Postgresql administrator training page on our main site.
Introduction to PostgreSQL
A Brief History of PostgreSQL
Installation
Architectural Fundamentals
Using the psql terminal-based client
Advanced SQL
Views
Sequences
Transactions
Window Functions
Inheritance
Indexes
Multicolumn Indexes
Indexes and ORDER BY
Combining Multiple Indexes
Unique Indexes
Indexes on Expressions
Partial Indexes
Setting up a Partial Index to Exclude Common Values
Setting up a Partial Index to Exclude Uninteresting Values
Setting up a Partial Unique Index
Operator Classes and Operator Families
Examining Index Usage
Full Text Search
Transaction Isolation and Concurrency
SQL Transaction Isolation Levels
Read Committed Isolation Level
Serializable Isolation Level
Serializable Isolation versus True Serializability
Postgresql can best be described as a database platform rather than a database server. For decades developers have been taught to create database-independent applications, programming to the most widley implemented SQL standard. With a commercial database this was a sound approach to avoid vendor lock-in event though many of the benefits of database-specific functionality were given up.
With Postgresql this is now no longer a constraint. Postgresql is feature-rich, offering many extension and integration points that afford developers the opportunity to create truly unique applications and solutions.
Anything missing in the course outline that you want to be covered? Let us know. We are happy to customise our courses to suit your needs. For pricing details on Postgresql developer training please see our main site.
Installing & managing PostgreSQL
Overview of PostgreSQL database
Using the psql client
Understanding PostgreSQL data types
Numeric data types
Integer data types
Floating point types
Serial types
Character types
Binary data types
Date & time values
Boolean values
Array types
Other data types
Understanding sequences
Creating & managing indexes
Understanding PostgreSQL indexes
Partial indexes
Indexes on expressions
Using COPY to load data
Working with Array Values
Advanced SQL Functions
Using Common Table Expressions (CTE)
Using Window Functions
Using Regular Expressions
Using Recursive Queries
Writing functions with PL/pgSQL
Writing triggers & stored procedures with PL/pgSQL
We build long relationships with our customers which helps us better understand their needs and offer customised solutions and training to meet their business requirements.
Our clients include large and small businesses in South Africa and across the globe. We offer both remote and on-site support.
Passion for Technology
We are passionate about open source and love living on the bleeding edge of technology innovation. Our customers lean our our practical experience with emerging technologies to ensure they get the benefits of early adopters and avoid the pitfalls.
