Database Design, Tools & Techniques with PostgreSQL

Database Design, Tools & Techniques with PostgreSQL provides fundamental skills necessary to maintain and manage a PostgreSQL server open source databases and related applications in a production environment. It covers foundation of PostgreSQL, system architecture, creating and managing databases, fundamental SQL, operations and maintenance of PostgreSQL database systems, using basic tools, and backup/restore.

CONTENT

Introduction to Structured Query Language (SQL) & PostgreSQL

• PostgreSQL System Architecture
• Installation
• Configuration
• The PostgreSQL Documentation

Managing Data

• Moving Data
• Postgres Data Dictionary

Working with Databases

• Creating and Managing Databases
• User Tools: Command Line Interface
• GUI Tools

Security

• Security
• SQL Primer

Backup and Recovery

• Backup and Recovery
• Point-in Time Recovery
• Routine Maintenance Tasks

FOR WHOM:

CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.