Overview
Elephas Inc provides Postgres and Open Source technologies support for the Enterprises for over decade. Our engineers have decades of Postgres and many Open Source technologies experience. Additionally, Elephas provides onsite and offsite training on the subjects like “Postgres for Developers” and “Data Science of using Python”.
Key features
- Interactive hands-on learning classes
- Understand the fundamental and advanced concepts of Postgres
- Grasp the advanced concepts of Installation, Postgres setup, and running queries on it.
- Learn to create applications with Postgres as a back end database management system
- Our Postgres mentors will guide students in implementing the technology for future projects
Postgres DBA
The Postgres DBA training covers following topics:
Day 1
- Introduction to Postgres for Oracle or MySQL or SQL Server DBAs
- Postgres installation and configuration
- Postgres internals
- Server and Client Authentication – Roles
- Localization
- Storage
- Vacuum
- WAL
Day 2
- Backups and Recovery
- Types of backups
- Restore
- Failover configuration
- Replication
- Sync vs Async replication
- Log shipping
- Streaming Replication
- Physical vs Logical Replication
Postgres Developers
This Postgres developer training course is ideal for those looking to migrate to Postgres or use Postgres in their applications. This Postgres training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to Postgres. Attendees will learn how to apply their SQL knowledge and experience to the Postgres platform
This Postgres course does cover the following topics:
- Installing & managing Postgres
- Overview of Postgres database
- Using the psql client
- Understanding Postgres 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
- Numeric data types
- Understanding sequences
- Creating & managing indexes
- Understanding Postgres 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
- Variables in procedures
- Performing loop operations
- The PERFORM and EXECUTE statements
- Triggers in Postgres
- Using the Postgres query optimiser
- Analyzing & optimizing queries
- Viewing execution plans with EXPLAIN
- Understanding Postgres query operators
- Improving query performance
- Foreign Data Wrappers
FAQ
-
Why should I pursue Postgres Course
Postgres has several advantages over other database systems in terms of reliability, speed, scalability, and other features. It is also maintained by a solid community and offers quick solutions to users. Elephas, therefore brings you a Postgres online course that will help you understand the basics of this database and use it to build applications.
-
What will I accomplish after completing online Postgres Training from Elephas
On completing the course, you will learn about:
- Postgres and relational databases
- Installation, configuration
- Best practices
- How to create databases
- Writing queries and managing the database
- How to insert and manipulate data
- How to write SQL statements for Postgres
-
Why elephas?
Elephas provides you not only professionals gain and theoretical expertise but also the practical experience in a wide variety of courses. Our online course is delivered by seasoned professionals of the industry who provide hands on training and easy methods of learning.