MySQL Database Administration Training Course
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Course Outline
MySQL Server Files and Scripts
- MySQL Programs
- MySQL Server
- MySQL Client
- GUI Tools
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 Accounts
- 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
- 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 File 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-Server Environment
Requirements
Fundamental knowledge of any database and SQL language.
Open Training Courses require 5+ participants.
MySQL Database Administration Training Course - Booking
MySQL Database Administration Training Course - Enquiry
MySQL Database Administration - Consultancy Enquiry
Consultancy Enquiry
Testimonials (7)
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database Administration
practical examples.
Kesh Mulloo - Vodacom
Course - MySQL Database Administration
Engagement of the Instructor
Mateusz Loszewski - Panstwowa Wyzsza Szkola Informatyki i Przedsiebiorczosci w Lomzy
Course - MySQL Database Administration
Machine Translated
A pleasant and friendly atmosphere, understandable teaching content, and the instructor's approach during the courses.
Pawel Lipski - Panstwowa Wyzsza Szkola Informatyki i Przedsiebiorczosci w Lomzy
Course - MySQL Database Administration
Machine Translated
positive attitude towards participants
Damian Luba - Panstwowa Wyzsza Szkola Informatyki i Przedsiebiorczosci w Lomzy
Course - MySQL Database Administration
Machine Translated
Course Conduct Style
Grzegorz Lendo - Panstwowa Wyzsza Szkola Informatyki i Przedsiebiorczosci w Lomzy
Course - MySQL Database Administration
Machine Translated
Precise explanation of all topics
Radoslaw Zielinski - Panstwowa Wyzsza Szkola Informatyki i Przedsiebiorczosci w Lomzy
Course - MySQL Database Administration
Machine Translated
Provisional Courses
Related Courses
MySQL Administration
28 HoursAudience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms.
Format: 40% theoretical/lectures, 60%Practical/hands on lab
MariaDB Database Administration
14 HoursMariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.
The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Advanced MariaDB for High Availability and Performance
28 HoursIn this instructor-led, live training in Poland, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
MariaDB Galera Cluster Administration
21 HoursThis course is intended for database administrators.
The course presents options for High-Availability solutions using Galera Cluster.
You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
MySQL Developer
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.
By the end of this training, participants will be able to:
- Write SQL queries to retrieve, filter, sort, and aggregate data.
- Perform data manipulation operations such as inserting, updating, and deleting data.
- Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
- Integrate MySQL with popular programming languages and execute queries from application code.
MySQL / Galera
21 HoursThis bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Percona Server dla MySQL
14 HoursThe "Percona Server for MySQL" training focuses on optimizing the use of Percona Server for MySQL, optimized for cloud computing, NoSQL access, containers, and modern hardware such as SSDs and Flash storage. The course covers the installation, configuration and optimization of Percona Server, focusing on features related to security, scalability, monitoring and data management. Participants will acquire practical skills enabling effective use of the advanced capabilities of Percona Server for MySQL.
Python in Data Science
35 HoursThe training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
SQL Fundamentals
14 HoursThis 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 any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
SQL in MySQL
14 Hours- How to build a query?
- What is a relational database?
- What is the structure and SQL commands?
SQL Advanced in MySQL
7 HoursThis course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
Zaawansowana administracja MySQL
14 HoursMySQL is a popular relational database management system (RDBMS) that allows you to create, manage, and operate databases. Jest is open-source software, which means it is available for free to users and the source code is open and publicly available. MySQL is one of the most popular database management systems in the world, especially in online environments. Thanks to its reliability, efficiency and ability to access open sources, it is widely used by companies, from small startups to large corporations, as a basis for storing and managing data.