MySQL Training Course

MySQL database administration and design training. Learn how to install MySQL, model and design a database, work with basic SQL, manage users and privileges, how to backup and restore MySQL databases, configure and maintain a MySQL server.

What must I know already to attend the course?

  • Excellent computer literacy
  • Technically inclined
  • SQL Course or Equivalent Knowledge
.

Who should attend attend the course?

  • MySQL Database administrator
  • Database Designers
.

What Will I Learn on this Course?
This course is a package consisting of the following courses:

SQL

This course will teach you all you need to know about SQL from basics to advanced joins.

MySQL Administration

The price for the package is a 10% discount on the sum of all its constituent courses. Booking and paying for the entire package in advance secures the discount.

Cost: R5090.9090909091 excl VAT Duration: 5 days

If you have a query relating to this course, please complete the form below.

Name
Email
Contact Number
Query
Security Code
Verify Code
 

Table of contents


  • Introducing SQL
  • Getting started with SQL
  • Creating a database table
  • Inserting data into tables
  • Retrieving data from tables
  • Sorting retrieved data
  • Simple data filtering
  • Complex data filtering
  • Generating calculated fields
  • Manipulating data
  • Grouping table data
  • Making complex queries
  • Joining database tables
  • Reference section

  1. Introduction to MySQL
  2. Installing MySQL
    • Installation Choices and Platforms
    • Using the Command-Line Interface
    • Downloading and Verifying Files from the MySQL AB Web Site
    • Installing Under Linux
    • Installing Under Windows
    • Configuring Access to the MySQL Server
  3. Using the MySQL Monitor
    • Starting the Monitor
    • Style, Case, and Semicolons
    • The Monitor Help
    • Running the Monitor in Batch Mode
    • Loading the Sample Databases
    • MySQL Monitor Program Options
    • Graphical Clients
  4. Modeling and Designing Databases
    • How Not to Develop a Database
    • The Database Design Process
    • The Entity Relationship Model
    • Using Tools for Database Design
  5. Doing More with MySQL
    • Loading Data from Comma-Delimited Files
    • Writing Data into Comma-Delimited Files
    • The EXPLAIN Statement
  6. Managing Users and Privileges
    • Understanding Users and Privileges
    • Creating and Using New Users
    • Privileges
    • The GRANT OPTION Privilege
    • How Privileges Interact
    • Users and Hosts
    • Checking Privileges
    • Revoking Privileges
    • Removing Users
    • Understanding and Changing Passwords
    • The Default Users
    • Devising a User Security Policy
    • Managing Privileges with SQL
    • Privileges and Performance
    • Resetting Forgotten MySQL Passwords
  7. Backups and Recovery
    • Dumping a Database as SQL Statements
    • Loading Data from an SQL Dump File
    • Scheduling Backups
    • The Binary Log
    • Checking and Repairing Corrupted Tables
    • Re-Creating Damaged Grant Tables
  8. Using an Options File
    • Configuring Options for the MySQL Monitor
    • Structure of the Options File
    • Scope of Options
    • Search Order for Options Files
    • Determining the Options in Effect
  9. Configuring and Tuning the Server
    • The MySQL Server Daemon
    • Server Variables
    • Checking Server Settings

Intoweb Branches Intoweb Services Marketing
Featured Marketing Clients
Affiliates
  • Intoweb Design
  • Intoweb Business
       -  Latest Projects
  • Instructor Led Training
       -  Latest Projects
  • Intoweb Australia
  • Intoweb UK
  • Intoweb Old Site

    Safari sites

  • African Sky
  • South Africa Tours
  • South Africa Safari
  • Kruger Park Safaris
  • Game Lodge
  • South Africa Vacation
  • South Africa Honeymoon
  • South Africa Travel
  • Cape Town Tours
  • African Sky Hunting
  • African Sky Golf
  • African Safaris
  • Africa Safari
  • Web Design
  • Programming
  • Flash Animation
  • Hosting
  • Mobile Website
  • CD Presentations
  • Intranets
  • Finances
  • Human Resources
  • E-learning
  • Sports
  • Intranet Modules
  • Website Development Training
  • Linux Training
  • Office Training
  • Management
       -  Viral Marketing
       -  Newsletter Marketing
  • Open Office Pro
  • PHP
  • Flash
  • Internet College
  • Gauteng
  • Intoweb
  • Mini MBA
  • Technical Training
  • Website Special
  • Microsoft Training
  • Press Desk
  • GO
  • Search ZA
  • IntoTravel
  • IntoJewellery
  • Construction Portal
  • Africa Safari
  • Articles
  • Sites
  • Info
  • Pretoria Property
  • Deluxe website marketing
  • Enterprise website marketing
  • Corporate website marketing
  • Google Pay Per Click (PPC)
  • Pagerank Optimisation
  • Portal seeding
  • Newsletters
  • Blogs
  • Forums
  • Articles
  • Advanced Statistics and Analytics
  • Search Engine Optimisation
  • African Sky
  • BandwidthBar
  • Trademarksearch
  • Med-Bay Medical Directory
  • Vision Conveying
  • Diamond Source
  • Colonial Stone
  • CrisisOnCall Emergency Services 
  • Selectech Water Analysis
  • Brivis
  • Colonial Stone
  • Lime Human Capital
  • Outdoor Power Solutions
  • Loutzavia Flight School
  • Infraset Precast Concrete
  • Bagley Lodge Guest Manor
  • CDT
  • Knysna Quays
  • Simple Insurance
  • Hudson and Knight
  • Stonehaven River Cruises
  • Jannie Cilliers Video Productions
  • Insurance
    Simple Insurance

    MiWay