EQUNIX BUSINESS SOLUTIONS
Postgre SQL Advance
Tentang Pelatihan
"Don't Forget" to visit our site and fill the form to register at : https://equnix.asia/training
Day 1
- ORDBMS Concept in General (ACID Concept;OLTP and OLAP Concept; Benchmarking Result Oracle vs PostgreSQL;)
- Architecture (Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc.); Journaling Concept; Replication Concept; HA Concept; Archiving Concept;)
- Installation & Administration (Compilation concept on Linux; How to install PostgreSQL from Source Code;Source Code structure of PostgreSQL; How to initialize data directory; How to manage PostgreSQL Instance (control scripts); Data directory Structure;)
Day 2
- Monitoring (Pgadmin 4; Monitoring Views; PostgreSQL System Catalogs (stats); Art of Logging; How to analyze slow queries (Introduction);)
- Administration & Advance Security (Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters);Plugins Installation;)
- Syntaxes, Query, & Data Types (Keywords on PostgreSQL; Database structures on PostgreSQL; Data Types Explained; Stored Procedure, Trigger, View, Sequence Explained;)
Day 3
- Multitier Backup & Restore (Cold Backup; Hot Backup; Incremental Backup; Point in Time Recovery; Backup tools;)
- Replication (Synchronous Replication; Asynchronous Replication; Cascading Replication; Multi-slave Replication; Logical Decoding Explained;)
- High Availability Implementation (Linux-HA Concept & Hands-on; Failover & Recovery Mechanism; Combining Replication & Linux-HA on HA Implementation;)
Day 4
- Partition & Tablespace (How to configure Tablespace; How to configure Partition; Best practices on Performance Tuning using Tablespace & Partition;)
- Load-balancing (Bi-directional Replication Explained; Data sharding Concept; FDW for Loadbalancing, pg_shard, PostgresXL;)
- Benchmarking & Server-side Tuning (How to tune Server-side Configuration; Best Practices on High Performance System; pgBench Tools Explained; Hand-on tuning & benchmarking;)
Day 5
- Exotic Features (JSONB; FDW; UPSERT Query; Row Level Security; Paralel Worker;)
- Spesial Topic (SQL Query Tuning; Art of Indexing; pg_upgrade;)
- Free Discussion & Test (Free Discussion;Post-training Test;)
Tentang Penyedia Pelatihan
Informasi Perusahaan :
We are #1 Open Source based Solution for Enterprises in Indonesia, having strong reputation in giving Open Source based Solution to Banking, Retails, Telco, and Manufacturing Industries.
We are also definitely #1 PostgreSQL Expert in South East Asian Countries, and we open opportunity to work throughout the Regions in ASEAN Countries.
Our main expertise: High Performance System and Open Source (PostgreSQL). We also had Research and Development as part of our professional responsibility in giving the best solutions to our valuable clients.
Our Visions : To be The One and The Greatest open Source-based IT Business Solutions Provider for Indonesia and ASEAN Countries.
In services, we have Managed Services Colocations, Managed Services Databases, and Operating System Security and Scalability. Our software development has proven prevail in industry, serving hundreds transactions per second beyond our customer’s expectations, and aggregates thousands systems running altogether in harmony.
If you have a dream to see Indonesia’s software solution advancing toward others in the world, then this is the right place you would have to apply.
We highly value your capability, morality, responsibility, and merit. Growing up and onward together as a team is our most premier spirits. Moreover we highly value people with PASSCODE: PASSion, COurage, and DEtermination.
We are also provide Trainings such as :
- Basic PostgreSQL
- Advance PostgreSQL
- High Performance Software Development
- Basic OS Linux and Network Administration
- Advanced OS Linux and Network Administration
- SYSAdmin/DBAdmin
- System/Network Administration
- Technical description PRISMA Application System