Class overview :

Class goals :

This course covers the installation and use of Navicat for administering PostgreSQL database. It will cover the administration, tuning, backup and recovery of PostgreSQL databases using the Navicat Database Administration Tool.

Content of PostgreSQL Administration using Navicat

INavicat for PostgreSQL – installation and configuration

Configuring connectivity

• SSL vs. non SSL
• Tunneling connections through SSH
• Understanding Connection keep-alives
• connection parameter storage

Navicat and Cluster Management

• Adding and dropping databases
• Configuring database defaults
• Carrying out database VACCUUM and ANALYZE operations
• Duplicating database objects

Using server monitor to modify and manage systems

Backup and Recovery

• creating backups
• Converting a backup files into an SQL Script
• Running recovery scripts
• Exporting data using Navicat Data export tools

Working with the Navicat Data Viewer/Editor

• Form and Grid Views
• BLOB and large text editing
• custom display formats
• Sorting & Searching
• Following Primary Key – Foreign key relationships
• more complex record filtering

Working with the Navicat Query Builder

• Overview and features – Syntax highlighting. SQL code completion
• SQL console
• Navicat Query logging

Importing and exporting data

• importing via ODBC
• importing data from MS-Excel, CSV, Text, DBF …
• exporting data to Excel, Access, PDF, HTML

Graphical exploration of database/table structure

Managing schemas, view and stored procedures

Managing privileges amd access control

• visual user manager
• cloning users and their permissions
• group membership management

Overview of the Navicat Report Management Tools

• Report Builder
• Report Viewer