mySQL Training

mySQL Training in Cape Town

Microsoft House offers MySQL services in Cape Town. MySQL and PHP services are offered according to International Certification Standards. 2KO International has been a Microsoft Partner since 1999, and offers IT training and consulting in Cape Town and the rest of South Africa. 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.


For the most up to date version of this course consult



MySQL Services Cover

  • 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

MySQL Developer Services Cover

  • 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