PostgreSQL Administration using Navicat

INavicat for PostgreSQL - installation and configurationConfiguring 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 systemsBackup 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 structureManaging schemas, view and stored proceduresManaging 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