SYLLABUS TRAINING MY SQL DATABASE ADMINISTRATOR (DBA)

SYLLABUS TRAINING MY SQL DATABASE ADMINISTRATOR (DBA)

MYSQL DATABASE ADMINISTRATOR (DBA)

www.purnamaacademy.com , Hotline (Call/SMS/WA) :  0838-0838-0001

Syllabus Overview

Melalui training ini peserta mampu memahami tugas tugas seorang Database Administrator dalam mengelola Database Server MySQL terkait storage management, user management, keamanan , performance dan juga cara pemantauan kinerja server database

Class Type : Training

Duration : 3 Days (09.00 – 17.00)

Venue / Price : www.purnamaacademy.com 

Registration : www.purnamaacademy.com   (Save up to 20% for Early Bird Registration !)

Description :

MySQL adalah sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh dunia. MySQL AB membuat MySQL tersedia sebagai perangkat lunak gratis dibawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus di mana penggunaannya tidak cocok dengan penggunaan GPL.

Topics include:

Installing MySQL

    Installing MySQL

    Installed Files and Directories

    Initial Configuration

    Starting and Stopping MySQL

    Upgrading MySQL

MySQL Architecture

    Architectural Overview

    How MySQL Transmits Data

    How MySQL Processes Requests

    How MySQL Stores Data

    Tablespaces

    Redo and Undo Logs

    How MySQL Uses Memory

    Plug-in Interface

Configuring MySQL

    Server Options, Variables, and the Command Line

    Option Files

    System Variables

    Launching Multiple Servers on the Same Host

Monitoring MySQL

    Monitoring MySQL with Log Files

    Monitoring MySQL with Status Variables

    Monitoring MySQL with Performance Schema

    Monitoring User Activity

User Management

    MySQL Privilege System

    Creating and Modifying User Accounts

    Configuring Passwords and Account Expiration

    Authentication Plug-Ins

    Granting Permissions

    Grant Tables

    Resetting a Forgotten Root Password

MySQL Security

    Security Risks

    Network Security

    Secure Connections

    Password Security

    Operating System Security

    Protecting Against SQL Injections

    MySQL Enterprise Firewall

Optimizing Query Performance

    Identifying Slow Queries

    The EXPLAIN statement

    Working with Indexes

    Index Statistics

Backup Strategies

    Understanding Backups

    Backup Techniques

    Creating a Backup Strategy

Performing Backups

    MySQL Backup Tools

    Raw Backup Methods

    Techniques that Use the Binary Log

Configuring a Replication Topology

    Overview of Replication

    Replication Conflicts

    When to Use Replication

    Configuring Replication

Administering a Replication Topology

    Failover

    MySQL Utilities

    Replication Threads

    Monitoring Replication

    Troubleshooting Replication

Participants :  (Database Administrator, IT Manager, IT Staff, Public)

Speaker  : Certified Trainer from PurnamaAcademy.com

#MYSQLtraining  #mysqldba #belajartutorial  #silabustraining #tempattraining  #pelatihan #jakarta  #bandung  #bali  #surabaya #makasar #jadwaltraining