fbpx

Course MySQL Administration

Region:
  • Content
  • Training
  • Modules
  • General
    General
  • Reviews
  • Certificate
  • Course MySQL Administration : Content

    In the course MySQL Administration participants learn to configure and manage a MySQL database. MySQL is an open source relational database management system (RDBMS) from Oracle. Originally MySQL was mainly used for web applications with PHP, but other programming languages ​​such as Java are also possible. The course uses the latest version of the MySQL database and the MySQL Workbench.

    MySQL Intro

    The MySQL Administration course starts with a discussion of the mysqld daemon that runs on the server and a series of client programs such as mysql and mysqldump that can interact with the server. Also the SHOW and DESCRIBE commands and MySQL server variables are covered.

    Configuring MySQL

    Next installing, starting up and shutting down a MySQL server is covered. Configuring MySQL components and the various storage engines is also treated.

    MySQL Architecture

    Attention is then paid to the internal architecture of the MySQL server, in which Communication Protocols and Storage Engine Tiers are reviewed. And the data types in MySQL are covered.

    Storage and Locking

    The course MySQL Administration also discusses storage and locking. The difference between table-level locking and row-level locking is explained. InnoDB is the only storage engine that supports row-level locking and thus ACID transactions.

    Backup and Recovery

    Attention is also paid to the maintenance of MySQL server including backup, recovery and optimization. Export of data with mysqldump and import with mysqlimport state is treated.

    Security

    Then it is time for the security of a MySQL installation. The assignment and maintenance of GRANTS and PRIVILEGES as well as the management of users and access rights are discussed. Attention is also paid to operating, file system and network security.

    Optimization and Scaling

    Finally optimization of a MySQL database is on the agenda. This includes explain to analyze Queries, the use of indexes, the Query Cache as well as the use of multiple servers and replication.

  • Course MySQL Administration : Training

     

    Audience MySQL Administration Course

    The course MySQL Database Administration is designed for database Administrators who need to administer, monitor and support MySQL databases and servers.

    Prerequisites Course MySQL Administration

    To join the course MySQL Administration knowledge of the SQL query language and databases is needed.

    Realization Training MySQL Administration

    The subject matter is treated on the basis of presentation slides. Demos are used to clarify the theory and exercises are used to bring the theory into practice. The course material is in English. This course fulfills the requirements for the Oracle MySQL Database Administrator certification. The course times are from 9.30 up and to 16.30.

    Certification Course MySQL Administration

    Participants receive an official certificate MySQL Administration after successful completion of the course.

    Course MySQL Administration
  • Course MySQL Administration : Modules

    Module 1 : Intro MySQL

    Module 2 : Configuring MySQL

    Module 3 : MySQL Architecture

    Client Program Limitations
    mysql en mysqld
    MySQL Admin
    What is Metadata?
    mysqlshow Utility
    SHOW Command
    DESCRIBE Command
    Information_Schema Database
    MySQL Server Options
    MySQL Server Variables
    MySQL Status Variables
    MySQL Distributions
    SQL Parser
    Client/Server Overview
    Installing on Windows
    Installing on Linux
    Starting and Stopping
    Log and Status Files
    The Default SQL Mode
    Time Zone Tables
    Some Security Issues
    MySQL Error Messages
    The SHOW Statement
    SQL Modes
    The PERROR Utility
    The Log
    The Error Log
    The Slow Query Log
    Communication Protocols
    Storage Engine Tiers
    Disk Space and Memory Usage
    Table Properties
    Obtaining Table Metadata
    Column Attributes
    Bit and Numeric Data Types
    Character String Data Types
    Binary String Data Types
    Enum and Set Data Types
    Temporal Data Types
    Auto_Increment
    Missing or Invalid Data Values
    Performance Issues Character sets

    Module 4 : Storage and Locking

    Module 5 : Table Maintenance

    Module 6 : Backup and Recovery

    Locking Concepts
    Explicit Table Locking
    Advisory Locking
    Preventing Locking Problems
    Innodb Status
    The MYISAM Engine
    Locking with MYISAM Tables
    The Merge Engine
    Other Engines: Archive,
    Memory, Federated
    Blackhole, NDBCluster
    Transactions
    Referential Integrity
    Physical Characteristics of Innodb Tables
    Tablespace Configuration
    Log File and Buffer Configuration
    Table Maintenance Operations
    Check, Repair, Analyze, Optimize
    MySQL Check
    MYISAMCHK
    Repairing Innodb Tables
    Enabling MYISAM AutoRepair
    Backup and Recovery Strategy
    Disaster Recovery Plan
    Backup and Recovery Plan
    Binary Backups of MYISAM Tables
    Binary Backups of Innodb Tables
    Recovery
    Import and Export Operations
    Exporting Using SQL
    Importing Using SQL
    Exporting using mysqldump
    Importing using mysqlimport

    Module 7 : Security

    Module 8 : Stored Procedures

    Module 9 : Optimization

    User Accounts
    Creating Users
    Changing Passwords
    Dropping Users
    Granting Privileges
    Revoking Privileges
    Resource Limits
    Show Grants Command
    Operating System Security
    File System Security
    Network Security
    User Variables
    Prepared Statements
    Types of Stored Routines
    Benefits of Stored Routines
    Stored Routines Features
    Stored Routine Maintenance
    Stored Routine Privileges
    Stored Routine Execution Security
    DML Triggers
    The Create Trigger Statement
    Managing Triggers
    Optimization Process
    Using Explain to Analyze Queries
    Indexes for Performance
    Creating and Dropping Indexes
    Indexing and Joins
    Normalisation
    General Table Optimizations
    Measuring Server Load
    Server Parameters
    Query Optimizer Performance
    The Query Cache

    Module 10 : Environment Optimization

    Module 11 : Scaling MYSQL

    Module 12 : MySQL Workbench

    Choosing the Platform
    Hardware Configurations
    Disk Issues on Linux
    Symbolic Links
    Optimizing the Operating System
    Event Scheduler Configuration
    Creating and Altering Events
    Event scheduler monitoring
    Events and privileges
    Partitioned tables Concepts
    Range partitioning
    Hash partitioning
    Key partitioning
    List partitioning
    Composite Partitioning
    Maintenance of partitioned tables
    Using Multiple Servers
    Replication
    Installation
    Connecting
    Server Information
    Service Control
    User Administration
    Privileges
    Health
    Backup and Restore
    Catalogs
  • Course MySQL Administration : General

    Course Forms

    All our courses are classroom courses in which the students are guided through the material on the basis of an experienced trainer with in-depth material knowledge. Theory is always interspersed with exercises.

    Customization

    We also do custom classes and then adjust the course content to your wishes. On request we will also discuss your practical cases.

    Course times

    The course times are from 9.30 to 16.30. But we are flexible in this. Sometimes people have to bring children to the daycare and other times are more convenient for them. In good consultation we can then agree on different course times.

    Hardware

    We take care of the computers on which the course can be held. The software required for the course has already been installed on these computers. You do not have to bring a laptop to participate in the course. If you prefer to work on your own laptop, you can take it with you if you wish. The required software is then installed at the start of the course.

    Software

    Our courses are generally given with Open Source software such as Eclipse, IntelliJ, Tomcat, Pycharm, Anaconda and Netbeans. You will receive the digital course material to take home after the course.

    Lunch

    The course includes lunch that we use in a restaurant within walking distance of the course room.

    Locations

    The courses are planned at various places in the country. A course takes place at a location if at least 3 people register for that location. If there are registrations for different locations, the course will take place at our main location, Houten which is just below Utrecht. A course at our main location also takes place with 2 registrations and regularly with 1 registration. And we also do courses at the customer’s location if they appreciate that.

    Evaluations

    At the end of each course, participants are requested to evaluate the course in terms of course content, course material, trainer and location. The evaluation form can be found at https://www.klantenvertellen.nl/reviews/1039545/spiraltrain?lang=en. The evaluations of previous participants and previous courses can also be found there.

    Copyright

    The intellectual property rights of the published course content, also referred to as an information sheet, belong to SpiralTrain. It is not allowed to publish the course information, the information sheet, in written or digital form without the explicit permission of SpiralTrain. The course content is to be understood as the description of the course content in sentences as well as the division of the course into modules and topics in the modules.

  • Course MySQL Administration : Reviews

  • Course MySQL Administration : Certificate