Seminare
Seminare

MySQL/MariaDB Administration

Webinar - GFU Cyrus AG

Participants will gain a comprehensive understanding of MySQL and MariaDB administration, including installation, configuration, and management of database servers. They will learn how to design efficient database schemas, implement indexing strategies, and optimize queries for enhanced performance. The seminar will cover essential tasks such as user and permission management, backup and restoration procedures, and monitoring database health. Additionally, attendees will explore replication and high availability configurations to ensure data availability and disaster recovery. By the end of the seminar, participants will be capable of handling routine database administration tasks, optimizing database performance, and ensuring the security and reliability of the database systems.
Termin Ort Preis*
16.03.2026- 18.03.2026 online 2.296,70 €
16.03.2026- 18.03.2026 Köln 2.296,70 €
*Alle Preise verstehen sich inkl. MwSt.

Detaillierte Informationen zum Seminar

Inhalte:
  • Introduction to MySQL/MariaDB
    • Overview of MySQL vs. MariaDB
    • Key features and differences
    • Installation and initial setup

  • Database Design and Architecture
    • Principles of database design
    • Normalization and denormalization
    • Indexing strategies for performance

  • User and Permission Management
    • Creating and managing users
    • Assigning roles and privileges
    • Securing database access

  • Data Manipulation and Query Optimization
    • Writing efficient SQL queries
    • Understanding query execution plans
    • Optimizing queries for performance

  • Backup and Recovery
    • Backup strategies and tools
    • Performing backups and restorations
    • Automating backup processes

  • Replication and High Availability
    • Setting up master-slave replication
    • Configuring master-master replication
    • Implementing high availability solutions

  • Performance Monitoring and Tuning
    • Monitoring database performance
    • Identifying and resolving bottlenecks
    • Tuning server and query performance

  • Security Best Practices
    • Securing MySQL/MariaDB servers
    • Implementing encryption and SSL
    • Auditing and compliance

  • Advanced Administration Tasks
    • Managing stored procedures and triggers
    • Using scripting for automation
    • Data migration techniques

  • Troubleshooting and Maintenance
    • Common issues and solutions
    • Maintenance tasks and scheduling
    • Using tools for troubleshooting

  • Integration with Applications
    • Connecting databases to applications
    • Using connectors and APIs
    • Managing data access in web applications

  • Exercises
    • Exercise 1: Setting Up Replication
      • Description: Configure master-slave replication between two MySQL/MariaDB servers, ensuring data consistency and replication lag monitoring.
      • Result: Participants will have a functional replication setup, demonstrating their ability to implement data replication for high availability and redundancy.

    • Exercise 2: Query Optimization
      • Description: Analyze and optimize a set of slow-performing queries using indexing and query restructuring techniques.
      • Result: Attendees will improve the performance of the given queries, showcasing their ability to enhance database performance through optimization strategies.


Dauer/zeitlicher Ablauf:
3 Tage
Zielgruppe:
This seminar is ideal for Database Administrators, System Administrators, IT Professionals, Developers, and Technical Support Staff who are responsible for managing and maintaining MySQL or MariaDB databases within their organizations. It is perfect for individuals seeking to implement, upgrade, or optimize their database environments to ensure efficient, secure, and reliable data management.
Seminarkennung:
R91456
Nach unten
Nach oben
Wir setzen Analyse-Cookies ein, um Ihre Zufriedenheit bei der Nutzung unserer Webseite zu verbessern. Diese Cookies werden nicht automatisiert gesetzt. Wenn Sie mit dem Einsatz dieser Cookies einverstanden sind, klicken Sie bitte auf Akzeptieren. Weitere Informationen finden Sie hier.
Akzeptieren Nicht akzeptieren









Um Spam abzuwehren, geben Sie bitte die Buchstaben auf dem Bild in das Textfeld ein:

captcha



Bei der Verarbeitung Ihrer personenbezogenen Daten im Zusammenhang mit der Kontaktfunktion beachten wir die gesetzlichen Bestimmungen. Unsere ausführlichen Datenschutzinformationen finden Sie hier. Bei der Kontakt-Funktion erhobene Daten werden nur an den jeweiligen Anbieter weitergeleitet und sind nötig, damit der Anbieter auf Ihr Anliegen reagieren kann.







Um Spam abzuwehren, geben Sie bitte die Buchstaben auf dem Bild in das Textfeld ein:

captcha