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 Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification.

 

For the most up to date version of this course consult www.2ko.co.za


 

 

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