MySQL Administration 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.

Course Details

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Kyalami, Midrand - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.

Audience

• MySQL Database administrator
• Database Designers

Pre-Requisites

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

Course Duration

2 Days

Cost using our PC's as from 1st of March 2012

R 3,013.60 excl vat
R 3,435.50 incl vat

Cost using your own PC's as from 1st of March 2012

R 2,613.60 excl vat
R 2,979.50 incl vat

Note: information may change without notice.

Course Outline

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

Scheduled Dates

To apply for a booking, click on the relevant "Book" link below.
Note: places are only fully secured once payment has been made.

From Date	To Date	Duration	Venue
Thu 23 Feb 2012	Fri 24 Feb 2012	2 days	Kyalami	Closed Please call
Thu 22 Mar 2012	Fri 23 Mar 2012	2 days	Kyalami	Book
Thu 19 Apr 2012	Fri 20 Apr 2012	2 days	Kyalami	Book
Thu 17 May 2012	Fri 18 May 2012	2 days	Kyalami	Book
Thu 21 Jun 2012	Fri 22 Jun 2012	2 days	Kyalami	Book

Course Enquiry

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

Name
Email
Contact Number
Query
Security Code
Verify Code

Advanced Project Management   Advanced Skills for the Practical Trainer   Advanced Writing Skills   Building Better Teams   Building Relationships for Success in Sales   Building Your Self Esteem and Assertiveness Skills   Business Etiquette: Gaining That Extra Edge   Business Leadership: Improving Management Performance   Business Succession Planning: Developing and Maintaining a Su   Business Writing that Works   Call Center Training: Sales and Customer Service Training for   Change and How to Deal with It   Communication Strategies   Conflict Resolution: Dealing with Difficult People   Conflict Resolution: Getting Along in the Workplace   Conquering Your Fear of Speaking in Public   Creating a Dynamite Job Portfolio   Creating and Managing Your Corporate Brand   Critical Thinking   CRM: An Introduction to Customer Relationship Management   Customer Service Training: Critical Elements of Customer Serv   Customer Service Training: Managing Customer Service   Delegation - The Art of Delegating Effectively   Dynamite Sales Presentations   Effective Planning and Scheduling   Employee Dispute Resolution: Mediation through Peer Review   Facilitation Skills   Generation Gap: Closing the Generation Gap in the Workplace   Getting Your Job Search Started   Hiring for Success: Behavioral Interviewing Techniques   Human Resources Training: HR for the Non-HR Manager   Intermediate Project Management   Introduction to Neuro Linguistic Programming   Inventory Management - The Nuts and Bolts   Leadership Skills for Supervisors:Communication, Coaching, an   Marketing and Sales   Mastering the Interview   Meeting Management - The Art of Making Meetings Work   Motivation Training: Motivating Your Workforce   Negotiating For Results   NLP Tools for Real Life   Onboarding: The Essential Rules for Successful Onboarding   Orientation Handbook: Getting Employees Off to a Good Start   Overcoming Objections to Nail the Sale   Performance Management: Managing Employee Performance   Problem Solving & Decision Making   Project Management Fundamentals   Prospecting for Leads Like a Pro   Public Speaking: Presentation Survival School   Public Speaking: Speaking Under Pressure   Risk Management   Skills for the Administrative Assistant   Stress Management   Survival Skills for the New Trainer   Team Building:Developing High Performance Teams   Telemarketing - Using the Telephone as a Sales Tool   The ABCs of Supervising Others   The Minute-Taker's Workshop   The Practical Trainer   The Professional Supervisor   Tough Topics: Talking to Employees about Personal Hygiene   Using Activities to Make Training Fun   Working Smarter:Using Technology to Your Advantage   Writing Reports and Proposals   Accounting Skills for New Supervisors   Administrator Bootcamp   Adobe Captivate   Advanced PHP   Anger Management: Understanding Anger   Assertiveness as a Business Tool   Basic Computer Skills   Budgets and Managing Money   Business and Report Writing   Change Management   Coaching for Growth and Performance   Coaching In The Call Centre Environment   Coaching: A Leadership Skill   Communicating Across Cultures   Concepts of Information Technology   Conducting Effective Performance Reviews   Conflict Resolution   Creating a Top Notch Talent Management Program   Customer Service   Developing Your Training Program   Dreamweaver CS5   Drupal Administration   Effective Business Writing   Emotional Intelligence: Its Not What You Think   Finance for Non Financial Managers   Flash CS5   Fundamentals of Selling   Getting Stuff Done: Personal Development Boot Camp   Graphic Design Practicals   High Performance PA and Management Skills for the Administrator   HTML and CSS   HTML5 upgrade   Human Resources Training for the Non HR Manager   Illustrator CS4   Illustrator CS5   InDesign CS5   Interpersonal Skills   Introduction to PC   Introduction to Programming   Java   Javascript   Joomla Basic   Joomla Intermediate   jQuery   Linux Essentials   Linux Master Bundle   Linux Networking   Linux Point&Click Admin   Linux Security   Linux Single Sign On   Linux System Administration 1   Linux System Administration 2   Linux Ubuntu 199   Management and Supervisory Skills   Microsoft Access 2007   Microsoft Excel 2007: Advanced   Microsoft Excel 2007: Basic   Microsoft Excel 2007: Intermediate   Microsoft Outlook 2007   Microsoft PowerPoint 2007   Microsoft Project 2007   Microsoft Visio   Microsoft Word 2007   Motivating Your Employees   MySQL   MySQL Administration   Negotiation Skills   Office Administration   Open ICDL Module 1   OpenOffice   PC Networking   Perl Fundamentals   Photoshop CS5   PHP   PostgreSQL Administration   Practical Leadership   Presentation Skills (US 13925)   Presentations Skills   Project Management   Project Management   Protecting Intellectual Property   Python   Search Engine Optimization   Selling Smarter   Sexual Harassment Awareness for Employees   Sexual Harassment Awareness for Supervisors   SQL (Database)   TCP/IP Networking   Team Leadership   Telephone Etiquette   Telephone Skills for Call Centres   Time, Performance and People Management   Train the Trainer   Web Design Practicals   Web Developer   Webmaster   Windows 7   WordPress   Writer   XML