Training Course:MySQL Database AdministrationSchool/Trainer:NobleProg - training courses, consulting and advisory
Krakow, Malopolska, Poland
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' It’s a comprehensive course on all administrator duties. It explains how MySQL Database works, how we can run multiple MySQL servers on the same machine, what tools are available and how we can use them, how we can secure MySQL Database server and configure it. During the training course you will learn to manage user accounts and you will understand how MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and crash recovery. The course also provides basic tuning for MySQL Server knowledge.
Training Course Outline :
MySQL Server Files and Scripts
MySQL Programs
Extended MySQL Server (mysqld-max)
mysqld_safe, mysql.server
mysqld_multi
MySQL Server Configuration
mysqld Options
The Server SQL Mode
Server System Variables
Dynamic System Variables
Server Status Variables
Shutdown Process
MySQL Security Issues
Securing MySQL Against Attacks
Security-Related mysqld Options
Security Issues with LOAD DATA LOCAL
MySQL Access Privilege System
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
MySQL User Account Management
Users and Passwords
Creating New Users
Deleting User Account
Limiting User Resources
Changing Passwords
MySQL Database Maintenance
Backup and Recovery
Point-in-Time Recovery
Maintenance and Crash Recovery
myisamchk Syntax and Options
Getting Table Information’s
MySQL Local Setting
National Characters and Sorting
MySQL Server Time Zone
MySQL Log Files
Error Log
General Query Log
Update Log
Binary Log
Slow Query Log
Log Files Maintenance and Rotation
Running Multiple MySQL Servers on the Same Machine
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-Servers Environment
MySQL Query Cache
Idea of Query Cache
Testing Query Cache with SELECT
Configuring Query Cache
Checking Query Cache Status and Maintenance
...''
Please go to the school's official website for training price and schedule:
http://www.nobleprog.com/en/
Phone:+48 12 429 91 67
School Address:
ul. Księcia Józefa 355/8
Jobs & Resumes: Krakow
Houses & Roommates: Krakow
Other training courses offered by NobleProg - training courses, consulting and advisory:
Linux Network Security
Linux System Administration
Microsoft Access Introduction
Microsoft Access Advanced
Visual Basic .NET for Advanced Programmers
Microsoft Excel Advanced with VBA Introduction
SQL Language
MySQL Introduction
Microsoft Excel VBA Introduction
C# Language in Visual Studio .NET
Visual Basic .NET for Beginners
Introduction to Microsft ASP.NET
Macromedia Dreamweaver 2004 MX Introduction
Linux Installation and Configuration
Linux Networking
Linux System Administration
Linux Network Security
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback. |
|
|
