|
|
|
|
|
EnterpriseDB’s PostgreSQL Training for Database Administrators (DBA) EnterpriseDB and OSSCube have announced India’s first official EnterpriseDB PostgreSQL Training for Database Administrators. The PostgreSQL DBA track targets candidates who will take the administrative role of tuning, planning, and optimizing data layout for one or many servers. This track is for enterprise production DBAs who administer highly scalable PostgreSQL infrastructures in the most demanding highly available environments. This Three-day hands on course is ideally suited for DBAs to become comfortable in managing a product PostgreSQL database. It covers the fundamental concepts and skills needed to install the database, configure it, and perform day-to-day maintenance and management. Duration: 3 Days Date: 19, 20 & 21 December 08 Venue:OSSCube Solutions (P) Ltd. Evoma Business Center, #14, Bhattarahalli, Near Garden City College,
Old Madras Road, K R Puram
560 049 Bangalore,
India Ph. +91 9958090987 Prerequisites: Some knowledge of database concepts Your Investment: INR 19500 + 12.36% Service Tax (Pay via Credit Card, Bank Transfer or Cheque, click here to register now Course Outline: Introduction & Architecture | PostgreSQL System Architecture | Installation | - History of PostgreSQL
- Major Features
- Limits
- Architectural Overview
- PostgreSQL Terminology
| - Architectural Summary
- Database Clusters
- Physical Database Architecture
- Data File Architecture
- Database File Layout
- Database Page Layout
- Process Architecture
- Connect Request
- Backend Spawning
- Multi-Version Concurrency Control (MVCC)
- Write-Ahead Logging
| - Installation
- Creating a database cluster
- Starting and Stopping the Server (Windows)
- Starting and Stopping the Server (Other)
- Lab Exercise - Installation
- Install PostgreSQL from source
- Create a database cluster
- Start the database server
- Connect to the server using psql
- Stop the database server
- Using PSQL Tool
| Introduction to PLPGSQL | Security | Routine Database Maintenance Tasks | - Procedural Languages
- Language Installation
- Using PLPGSQL
- Declarations, Assignments, Printing output.
- Functions
- Cursors
- Triggers
| - Levels of security: pg_conf,
schemas and users and table level. - USERS
- GROUPS
- ROLES
- Object Ownership
- Accesss control
- Application Access
- pg_hba.conf
- Schemas and Search Paths
- Lab to create USERS, SCHEMAS, ROLES, Alter SEARCH_PATH, GRANT and REVOKE privileges
| - Backup & Recovery
- Log Management
- Routine Vacuuming
- Recovering Disk Space
- Vacuum Full
- Updating Planner Statistics
- Preventing Transaction ID Wraparound Failures
- Routine Reindexing
| Backup & Recovery | High Availability & Replication | Monitoring & Statistics | - pg_dump
- pg_restore
- pg_dumpall
- File System Backup - copying DATA folder
- pg_start_backup and pg_stop_backup
- PITR - Point in Time Recovery
- Creating a base backup
- Archive command
- Recovery file parameters
- Lab to test PITR
| - Why Use Replication
- Replication
- Introduction to Slony
| - Database Logs
- OS Process Monitoring
- Statistics Collector
- Statistics Parameters
- Statistics Views and Functions
- Timing
| Performance Tuning | PostgreSQL Partitioning and Tablespaces | - Explain and Explain Analyze
- Forcing Query Plan Selection
- Helping the Optimizer
- Using Views
- Creating Rules with Views
- Indexing
- Constraints
- Clustering Rows
| - Partition Methods
- Partition Setup
- Table space Management
| About EnterpriseDB EnterpriseDB is the world's leading provider of enterprise-class products and services based on PostgreSQL, the world's most advanced open source database. The company's Postgres Plus products are lightning-fast, massively scalable, and extremely reliable, making them ideal for high-volume, mission-critical applications. EnterpriseDB has offices throughout North America, Europe, and Asia. The company was founded in March 2004 and is headquartered in Edison, New Jersey. For more information please visit EnterpriseDB WebSite About OSSCube
OSSCube is India’s leading Open Source software development & training company with expertise in outsourced product development. We are dedicated to providing solutions to businesses by leveraging the power of open source software, solutions and technologies. We have partnered with leading technology development companies such as Zend, MySQL, Ingres, EnterpriseDB, Moodlerooms and Continuent, to provide most current and effective solutions. With over a decade of experience and 100+ team members, we can deliver solutions cost-effectively and on time. |
|
|
|
1 919 791 5472 (USA)
