Training PostgreSQL Administration using Navicat – 2 days

Class overview :

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.

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
PostgreSQL Administration using Navicat
Training PostgreSQL Administration using Navicat

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s