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 International Group provides IT & business training courses for learners of all levels, and is also a top-rated, certified supplier of online IT courses, enabling 2KO students the opportunity to study courses online world-wide, to ensure 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

Introduction

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

Databases

Tables

Manipulating Table Data

Transactions

Joins

Subqueries

Views

Prepared Statements

Exporting and Importing Data

Stored Routines

Improving Performance with Indexes

Improving Searches of Date and Text Fields

Improving Inserts and Updates