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
Comments
Post a Comment
Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick