Course not currently available

Using and managing the database in MySQL Training Course

Course

In Manchester ()

£ 2,050 VAT inc.

Description

  • Type

    Course

Participant will learn:
Can I use MySQL for free?
What do I offer a commercial license?
How to install a MySQL database?
How to perform basic operations on the installation?
What are the available tools for managing and programming in a MySQL database?

About this course

Computer literacy
Knowledge of any operating system
It is recommended that completion of the course: Language SQL in MySQL database

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Testing
  • Server
  • MySQL
  • Database
  • Database training
  • Installation
  • GNU
  • FreeBSD
  • Programming
  • Install

Course programme

Legal aspect MySQL
  • MySQL's dual license policies
  • Commercial License
  • Open Source License
Installing MySQL
  • Standard installation of MySQL (binary files)
  • Installing MySQL on Windows or Unix-like (GNU / Linux, FreeBSD)
  • Tuning the server after installation, testing
  • Upgrading MySQL
Connecting to the server Making queries Creating and using databases
  • Creating and selecting a database
  • Creating tables
  • Importing data into the table
Obtaining information about the database and tables Using the mysql command in batch (Batch Mode) Discussion of the utilities
  • Ways to call the program
  • Setting program options (command line, the configuration file, environment variables)
  • Setting the program variables via command line
GUI tools for managing and programming the database
  • MySQL Administrator
  • MySQL Query Browser
  • Toad for MySQL

Additional information

14 hours (usually 2 days including breaks)

Using and managing the database in MySQL Training Course

£ 2,050 VAT inc.