MySQL Introduction Training Course

Training Course Outline: 

MySQL Database Licensing

MySQL's dual license policy

Commercial License

Open Source License

MySQL Server Installation

Binary MySQL installation

Testing and configuring MySQL server

Upgrading MySQL server

Connecting to MySQL Server

Executing a Query

Creating and Using Databases

Creating and selecting databases

Creating tables

Importing external data into tables

Getting Information about MySQL Databases and Tables

Executing MySQL Commands in Batch Mode

MySQL Database Tools and Utilities

Invoking MySQL programs

Standard MySQL program options

Command line options

Configuration files

Environmental variables

Setting MySQL variables through command line

MySQL and Third Part GUI Tools

MySQL Administrator

MySQL Query Browser

Toad for MySQL

Oracle SQL Developer 

Code: 
mysql01
Prerequisites: 

Completion of SQL Language course recommended but not necessary.

Overview: 

After completing this course, participants will know how to use and manage MySQL server. This course is for web developers or anyone using MySQL server. During this course students will learn:

  • Is MySQL really free
  • What are terms and conditions of MySQL Licenses
  • How to install MySQL Server
  • What MySQL AB or third party MySQL tools are available and how to use them

 

Certification: 

NobleProg Certificate

Duration: 
16 teaching hours
Prices
Public: 
900 GBP per delegate

Public Course Dates

Datesort iconTraining OutlineVenueDetails/Book
2008-07-10 09:00 - 2008-07-11 17:00MySQL Introduction112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-09-18 09:00 - 2008-09-19 17:00MySQL Introduction112/114 North Acton Road, NW10 6QH, LondonDetails/Book
2008-11-27 09:00 - 2008-11-28 17:00MySQL Introduction112/114 North Acton Road, NW10 6QH, LondonDetails/Book