Description

Navicat is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL.

1. Installing Navicat for MySQL

2. Connecting to the database (SSL and non-SSL)

a). Tunneling connections through SSH

b). Connection keep-alive

c). Storing connection parameters

3. Database Management with Navicat

a). Adding and dropping databases

b). Managing database defaults

c). Performing database repair operations

d). Duplicating database objects

e). Modifying & Managing system variables (server monitor)

4. Backup & Recovery

a). Generating backups

b). Converting backup files into SQL Scripts

c). Executing recovery scripts

d). Data export tools

5. Navicat Data Viewer/Editor

a). Form & Grid Views

b). BLOB and large text editing

c). Choosing custom display formats

d). Performing Sorting & Searching

e). Following keys (PK/FK relationships)

f). Advanced record filtering

6. Using the Query Builder

a). Generating basic queries

b). Syntax highlighting/SQL Editor

c). SQL Code completion

d). Using the SQL console

e). Logging Queries

7. Data import and export

a). Importing data via ODBC

b). Importing data from MS-Excel, CSV, Text, DBF, and other files

c). Exporting data to Excel and Access

d). Exporting data to PDF and HTML

8. Viewing and printing database/table structure

9. Managing Stored Procedures

10. Managing Views

11. Managing Users & Database privileges

a). Understanding the visual user manager

b). Duplicating existing users & their permissions

12. Job scheduling & execution

a). Establishing new jobs

b). Choosing output formats/options

c). Sending completion notifications

13. Using the Navicat Report Management Tools

a). Using the Report Builder

b). Using the Report Viewer

For more inputs on Navicat you can connect here.
Contact the L&D Specialist at Locus IT.

Locus Academy has more than a decade experience in delivering the training/staffing on Navicat with MySQL for corporates across the globe. The participants for the training/staffing on Navicat with MySQL  are extremely satisfied and are able to implement the learnings in their on going projects.