Navicat with PostgreSQL

( Duration: 2 Days )

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

  • This Navicat with PostgreSQL workshop is designed for database administrators with experience administering the PostgreSQL database.



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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.