MySQL Database Administration Training Course

By: NobleProg (UK) Limited  24/03/2011
Keywords: computer training, IT consultancy, computer education

MySQL Programs

MySQL Server

MySQL Client

GUI Tools 

mysqld Options

The Server SQL Mode

Server System Variables

Dynamic System Variables

Server Status Variables

Shutdown Process

Securing MySQL Against Attacks

Security-Related mysqld Options

Security Issues with LOAD DATA LOCAL

MySQL Privilege System Overview

Privileges Provided by MySQL

Connecting to the MySQL Server - Stages

Access Control, Stage 1: Connection Verification

Access Control, Stage 2: Request Verification

Access Denied Errors

Users and Passwords

Creating New Users

Deleting User Accounts

Limiting User Resources

Changing Passwords

Backup and Recovery

Point-in-Time Recovery

Maintenance and Crash Recovery

myisamchk Syntax and Options

Getting Table Information

MySQL Local Setting

National Characters and Sorting

MySQL Server Time Zone

Error Log

General Query Log

Update Log

Binary Log

Slow Query Log

Log File Maintenance and Rotation

Running Multiple Servers in Windows

Running Multiple Servers in Windows as Services

Running Multiple Servers in Unix and Linux

Using Client Tools in a Multi-Server Environment

The Concept of Query Cache

Testing Query Cache with SELECT

Configuring Query Cache

Checking Query Cache Status and Maintenance

Keywords: computer education, computer training, IT consultancy, it consultants, it training

Contact NobleProg (UK) Limited


Print this page

Other products and services from NobleProg (UK) Limited


JMeter Fundamentals Training Course

This course covers the creation and implementation of functional and unit testing with Apache JMeter, the free application testing software from The Apache Software Foundation. The purpose of the course is to allow organisations to completely automate their various testing requirements, saving time, money and helping to minimise the risk of human error in testing. The programme explores the concepts of designing and creating test plans for real-world web applications using Apache J


Strategic Planning in Practice Training Course

This training course has been created for investors, business owners, directors, managers, executives and analysts who need to develop strategic planning skills. It is not designed for academic purposes, but to start realizing your dreams today. This course focuses on strategic planning for technology-based businesses in which flexibility and constant learning is the most important thing. The main emphasis is corporate and investment strategy using current real-world examples. Each c


SQL Programming Training Course

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can use them what are relations and how to create them the structure of data differences between SQL dialects (Oracle, T-SQL, ANSI) practical skills for writing queries This SQL course deals with generic ANSI SQL. It can be used in a


Excel VBA Introduction Training Course

This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.


Java Fundamentals Training Course

The course covers the basics of Java development. It introduces students to Java technology and teaches them basic Java syntax and concepts, leading to the creation of a simple program. Training goes through the essential concepts and features of the Java Programming Language, focusing on exceptions, basic input/output, concurrency, regular expressions, Java collections framework and the platform environment. The course finishes when all basic Java features have been explained and