EncartaLabs

Navicat with MySQL

( Duration: 2 Days )

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

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

COURSE AGENDA

1

Installing Navicat for MySQL

2

Connecting to the database (SSL and non-SSL)

  • Tunneling connections through SSH
  • Connection keep-alive
  • Storing connection parameters
3

Database Management with Navicat

  • Adding and dropping databases
  • Managing database defaults
  • Performing database repair operations
  • Duplicating database objects
  • Modifying & Managing system variables (server monitor)
4

Backup & Recovery

  • Generating backups
  • Converting backup files into SQL Scripts
  • Executing recovery scripts
  • Data export tools
5

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
6

Using the Query Builder

  • Generating basic queries
  • Syntax highlighting/SQL Editor
  • SQL Code completion
  • Using the SQL console
  • Logging Navicat Queries
7

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
8

Viewing and printing database/table structure

9

Managing Stored Procedures

10

Managing Views

11

Managing Users & Database privileges

  • Understanding the visual user manager
  • Duplicating existing users & their permissions
12

Job scheduling & execution

  • Establishing new jobs
  • Choosing output formats/options
  • Sending completion notifications
13

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.

Top