MySQL Class

MySQL Courses in Cape Town

2KO offers mySQL courses in Cape Town.  2KO presents MySQL courses in Cape Town by means of full time instructor-led training; as well as internet-accessible online training, which are aimed at International IT Certification exams. 2KO is an IT consulting and training company, offering both business services and multi-platform training. 2KO Africa's wide range of computer courses are available as full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.



Course Duration:

5 Days


Course Outline:

Course Objectives:

Understand the features and benefits of MySQL

Install and start the MySQL server

Understand the basics of relational databases

Understand the SQL and MySQL languages

Understand Data/Column types with regard to efficient database design

View a database design structure and content

Create a database design using an efficient structure

Extract basic database information using the SELECT command

Troubleshoot syntax and understand typical warnings and errors

Delete or modify a database, and table row data

Group query data with aggregation

Connect data from multiple table rows using JOIN

Perform nested sub-queries

Use simple functions (String, Date, Numerical)

Describe MySQL connectors, their major features and differences

Understand MySQL storage engines, transactions and features of the common engines


Course outline for: MySQL Developer


Improving Performance with Indexes

Improving Searches of Date and Text Fields

Improving Calculations

Improving Joins

Trees and Hierarchical Data

Utilizing Advanced Index Structures

Working with Locking Levels

Creating Reports

MySQL Client/Server Concepts

MySQL Clients

Querying for Table Data

Handling Errors and Warnings

SQL Expressions

Data Types

Obtaining Metadata



Manipulating Table Data





Prepared Statements

Exporting and Importing Data

Stored Routines

Improving Performance with Indexes

Improving Searches of Date and Text Fields

Improving Inserts and Updates