Skip to main content

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



Comments

Post a Comment

Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick

Popular posts from this blog

Laravel Training Purnama Academy

Nov 2018 Purnama Academy 0838-0838-0001 Kursus Laravel Training Center INdonesia, jakarta, Bandung, Bogor, Semarang, Yogya, Palembang kalimantan, surabaya visit www.purnamaacademy.com , Laravel - Online Courses, Classes, Training, Tutorials on Lynda https://www.lynda.com/Laravel-training-tutorials/2779-0.html Learn how to use Laravel, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Top Laravel Courses Online - Updated November 2018 | Udemy https://www.udemy.com/topic/laravel/ Whether you're interested in developing web apps in the Laravel PHP framework, or building a RESTful API with Laravel, Udemy has a course to help you ... PHP Laravel Framework | Brainmatics.Com brainmatics.com/php-laravel-framework/ Translate this page Laravel merupakan framework PHP yang dirancang untuk membangun situs web ... Pada training ini diharapkan mampu membantu meningkatkan kemampuan ... Dec 3 - Dec 6 Brainmatics Laravel training - Laracasts htt...
10 comments
Detail Alamat »

Bisnis Paling Populer 2012

TEMPO.CO, Jakarta - Sektor industri pangan, industri jasa dan perhotelan, serta pertambangan dan energi diperkirakan bakal mengalami booming pada 2012. Permintaan di dalam negeri terhadap industri jasa, perhotelan, serta makanan di dalam negeri akan meningkat. »Adapun pertambangan dan energi karena permintaan di beberapa negara yang tidak terkena krisis juga cukup besar,” tutur Didik J. Rachbini, Kepala Lembaga Pengkajian, Penelitian, dan Pengembangan Ekonomi (LP3E) Kadin Indonesia, di Jakarta, Rabu, 28 Desember 2011. Menurutnya, pertumbuhan kelompok masyarakat yang memiliki daya beli tinggi saat ini cukup besar. Sehingga, permintaan terhadap sektor jasa dan produk makanan maupun perhotelan akan terus bertumbuh. Dia menyebut, sektor konsumsi masih akan menyumbang sekitar 60 persen dari pertumbuhan ekonomi. »Namun, bila pemerintah tidak bisa menjaga kondisi yang nyaman bagi kalangan usaha, maka pertumbuhan industri di dalam negeri akan di bawah target pemerintah,” kata Didik. Dia menyeb...
Post a Comment
Detail Alamat »

tempat training komputer di bandung

Jadwal training, kursus komputer sisindotek Bandung GRA-03 - Google Sketchup 3D for Building Interior 3 Hari , Start : 6,20 Oct , 3 Nov, 8 Dec 2014 GUI-02 - Building ASP.Net Application with IronSpeed Designer 4 Hari , Start : 13, 27 Oct, 10, 24 Nov , 1,15 Dec 2014 API-02 - Building Integrated Map Website with PHP MySQL and Google Map API V.3 3 Hari , Start : 6,20 Oct , 3 Nov, 8 Dec 2014 NTW-04 - Installing and Configuring Exchange Server 2008 4 Hari , Start : 13, 27 Oct, 10, 24 Nov , 1,15 Dec 2014 CMS-03 - Web Development with PHP CodeIgniter 3 Hari , Start : 6,20 Oct , 3 Nov, 8 Dec 2014 PRO-01 - Computer for Secretary and Admin Staff (Networking Essential, MS. Outlook, Document Security and sharing, MS. Office Integration, File Archive and data backup - Recovery, etc.) 3 Hari , Start : on demand PRG-06 - Building Event Scheduler System with PHP AJAX and SMS Gateway 4 Hari , Start : 13, 27 Oct, 10, 24 Nov , 1,15 Dec 2014 NTW-03 - Installing, Configuring and Administering UBUNT...
Post a Comment
Detail Alamat »