MySQL Course

MySQL training course provided by Intoweb in Johannesburg and Pretoria, South Africa

What is MySQL?
MySQL is the world's most popular open-source database. Open source means that the source code, the programming code that makes up MySQL is available to anyone. MySQL is a relational database management system (RDBMS). It's a program capable of storing an enormous amount and a wide variety of data in a way that meets the needs of both large and small companies.

Pre-Requisites
Basic Computer Literacy

Course Details
Intoweb does not offer amateur lecture notes; rather each course member will be supplied with a quality, comprehensive textbook. Intoweb is ISETT SETA accredited.

3 day Course

Table of Contents

Quickstart to MySQL Understanding MySQL Basics Connecting to the MySQL server Creating and Using Your First Database	Data Types and Table Types Exploring the Various Column types MySQL Options Exploring the Various Table Types	Advanced SQL OperatorsAdvances Joins Adding Records to a Table from other    Tables with INSERT SELECT More About Adding Records More About Removing Records User Variables Running SQL Statements Stored in    Files Transactions and Locking
Indexes and Query Optimisation Understanding Indexes Creating an Index Using an Auto Increment Field Dropping or Changing and Index Understanding Table Types and    Indexes Using Indexes Effectively Analysing How MySQL Uses Indexes    with Explain Optimising Selects Optimising Updates, Deletes, and    Inserts	Programming with MsSQL Using Good Database Programming    Techniques The Stages of Application    Development	Database Design The Database Lifecycle Real-World Example: Creating and    Publishing Tracking System Concurrency Control
Understanding Relational Databases Exploring Early Database Models Understanding the Relational Database    Model	Database Normalization Understanding Normalization Understanding Demoralization	Extending MsSQL User-Defined Functions Troubleshooting
Basic Administration Meeting MySQL as an Administrator Starting and Shutting Down MySQL Configuring MySQL Logging Optimizing, Analysing, Checking and    Repairing Tables	Database Backups Backing Up MyISLAM Tables with    BACKUP Restoring MyISLAM with Tables with    RESTORE Backing Up MyISLAM Tables Backing Up with mysqldump Backing Up wihth SELECT INTO Using mysqlhotcopy to Back Up Using the Binary Update Log to Restore    a Database to the most Recent    Position Replication as a Means of Backup	Database Replication Understanding Replication Setting up Replication Replicating One Database Replicating with and Active Binary Log    on the Master Removing Old Binary Logs from the Master and Then Starting Avoiding Too Many Updates Avoiding Key Errors
Configuring and Optimizing MySQL Optimizing the mysqld Variables Changing Variable Values with the    Server Running Imporving Hardware to Speed Up Server Using Benchmarks Running MySQL in ANSI Mode Using Different Languages in MySQL	Database Security Security When Connecting Managing Users and Connnections SSL Connections Application Security System Security Security Issues with LOAD DATA              LOCAL	Installing MySQL Deciding Whether to Install a Source or Binary Distribution Installing MySQL on Windows Installin MySQL on Unix Installing Multiple MySQL Servers on    the Same Machine Avoiding Common Installation Problems Upgrading from MySQL3x to MySQL 4
Multiple Driver Understanding RAID Using Symbolic Links

For Similar courses go to www.courses.co.za

Blogged with the Flock Browser