Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Introduction to Navicat with PostgreSQL (2 days)


This Navicat training course teaches you how to make the most of the Navicat Database Administration tool. Using Navicat for PostgreSQL, students attending this course will learn how to administer, tune, backup, and recover PostgreSQL.

Introduction to Navicat with PostgreSQL Course Calendar (2 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
spacer
For government and education pricing, please contact us.

Recommended Pre-requisites

This course is designed for database administrators with experience administering the PostgreSQL database.

Course Outline/Agenda

This Navicat training covers the following topics:
  • Installing Navicat for PostgreSQL
  • Connecting to the database (SSL and non-SSL)
    • Tunneling connections through SSH
    • Connection keep-alive
    • Storing connection parameters
  • Cluster Management with Navicat
    • Adding and dropping databases
    • Managing database defaults
    • Performing database VACCUUM and ANALYZE operations
    • Duplicating database objects
    • Modifying & Managing system variables (server monitor)
  • Backup & Recovery
    • Generating backups
    • Converting backup files into SQL Scripts
    • Executing recovery scripts
    • Data export tools
  • Navicat Data Viewer/Editor
    • Form & Grid Views
    • BLOB and large text editing
    • Choosing custom display formats
    • Performing Sorting & Searching
    • Following keys (PK/FK relationships)
    • Advanced record filtering
  • Using the Query Builder
    • Generating basic queries
    • Syntax highlighting/SQL Editor
    • SQL Code completion
    • Using the SQL console
    • Logging Navicat Queries
  • Data import and export
    • Importing data via ODBC
    • Importing data from MS-Excel, CSV, Text, DBF, and other files
    • Exporting data to Excel and Access
    • Exporting data to PDF and HTML
  • Viewing and printing database/table structure
  • Managing schemas
  • Managing Stored Procedures
  • Managing Views
  • Managing User & Group Database privilege
    • Understanding the visual user manager
    • Duplicating existing users & their permissions
    • Managing group membership and permissions
  • Using the Navicat Report Management Tools
    • Using the Report Builder
    • Using the Report Viewer

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details
Students may choose the version of the tool they wish to use for this course (Windows, Linux, OSX). Students wishing to use the OSX version of Navicat must bring their own laptop/mac.

Enroll in this course

View upcoming course calendar

info@otg-nc.com
877-258-8987