SIlabus training MySQL DBA

Silabus/ Syllabuss Training MySQL DBA

MySQL 5.0 Database Administration

 

 

 

Deskripsi

:

MySQL adalah sistem manajemen database SQL yang bersifat Open Source dan paling populer saat ini. Sistem Database MySQL mendukung beberapa fitur seperti multithreaded, multi-user, dan SQL database managemen sistem (DBMS). Database ini dibuat untuk keperluan sistem database yang cepat, handal dan mudah digunakan. Administrasi Database di MySQL cukup menunjang kebutuhan database kelas server

 

 

 

Tujuan Training

:

1.       Peserta memahami konsep dasar RDBMS untuk merancang sebuah database

2.       Memahami Administrasi database diantaranya (Instalasi, Konfigurasi, Security, Backup Recovery, Replikasi)

 

 

 

Target Peserta

:

          Database developer

          Database Administrator

          System Analyst

          Application Programmer

 

 

 

Prasyarat

:

Telah mengenal MySql Database

 

 

 

Materi Training

:

Part I First Steps with MySQL

>> Introduction to MySQL                                                 

>> Installing and Upgrading MySQL Server                    

>> Accessing MySQL                                                           

 

Part II Developing with MySQL

>> How MySQL Extends and Deviates from SQL           

>> MySQL Data Types                                                         

>> MySQL Index Types                                                       

>> Stored Routines, Triggers, and Events                       

>> MySQL Views                                                                  

>> Transactions in MySQL                                                  

 

Part III Core MySQL Administration

>> MySQL Server Tuning                                                    

>> Storage Engines                                                             

>> Caching with MySQL                                                     

>> Backups and Recovery                                                  

>> User Management                                                         

>> Partitioning                                                                      

>> Logging and Replication                                               

>> Measuring Performance                                               

 

 

Part IV Extending Your Skills

>> Query Analysis and Index Tuning                                

>> Monitoring Your Systems                                             

>> Securing MySQL                                                             

>> The MySQL Data Dictionary                                          

>> Scaling and High Availability Architectures                                                             

 

 

 

 

Training Lanjutan yang Disarankan

:

Building Web Application with PHP MySQL

 

 

HERY PURNAMA – 081.223344.506 Freelance trainer untuk traning MYSQL DBA . Aktif di beberapa training center di Jakarta ,Bandung ,Surabaya ataupun diundang sebagai Inhouse Trainer di beberapa perusahaan baik bidang industri, pertambangan, finansial, asuransi, perbankan di seluruh indonesia

Hery adalah Inhouse trainer MYSQL DBA  di bandung, Jakarta, bekasi, bogor, sukabumi, semarang, yogya, Surabaya, bali, Lombok, ntb, ambon, jayapura, makasar, menado, Banjarmasin, Pontianak, palangkaraya, Balikpapan, samarinda, batam, lampung, Palembang, Riau, Padang, Medan, Aceh, Malaysia, Singapore , sisindotek training center dan wilayah Indonesia , Undangan Inhouse training bisa menghubungi  Hery – 081.223344.506 atau inhousetrainer@yahoo.com

Topik training lain yang diberikan Hery : sencha-extjs, excel-vba-macro, itil-cobit-cisa-uml, codigniter-yii,oracle-dba, sqlserver-dba, asp-net, vb-net, google-map-api, google-sketchup-3d, excel-advance-accounting, project-management, ms-project-MYSQL DBA, SEO-Internet-Marketing, php-mysql-jquery, android-phonegap-jquery-mobile, ms-access-vba, visual-foxpro, Ubuntu-server, facebook-api-developer, python-programming, adobe-photoshop, corel-draw, adobe-indesign, adobe-flash, cms-wordpress, 3d-studio, autocad, mobile-apps-development, sms-gateway, spss-matlab, dan lainnya silahkan konsultasikan

Untuk informasi/konsultasi atau undangan sebagai inhouse trainer silahkan menghubungi :

HERY PURNAMA
OCA., CIW., ITILF.

Hometown  : Bandung – Indonesia
Call/SMS/WA : 081.223344.506
EM :
inhousetrainer@yahoo.com
BB : 7DC633AA
FB : inhousetrainer , TW : @inhousetrainer , INS : inhousetrainer

Blog : http://freelance-it-trainer.blogspot.com

 

[tags  trainer freelance MYSQL DBA , pengajar lepas MYSQL DBA , trainer bersertifikasi MYSQL DBA, cari trainer MYSQL DBA, butuh trainer MYSQL DBA, trainer MYSQL DBA di bandung , trainer MYSQL DBA di jakarta, trainer MYSQL DBA di bogor, trainer MYSQL DBA di bekasi, trainer MYSQL DBA di semarang, trainer MYSQL DBA di yogya, cari freelance trainer MYSQL DBA, butuh freelance trainer MYSQL DBA , trainer MYSQL DBA di Surabaya, lowongan trainer MYSQL DBA , kursus MYSQL DBA , trainer MYSQL DBA di bali, trainer MYSQL DBA di lombok, trainer MYSQL DBA di ambon, trainer MYSQL DBA di makasar, trainer MYSQL DBA di menado, trainer MYSQL DBA di Banjarmasin, trainer MYSQL DBA di samarinda , trainer MYSQL DBA di Pontianak, trainer MYSQL DBA dipalangkaraya, trainer MYSQL DBA di batam, trainer MYSQL DBA di Palembang, trainer MYSQL DBA di lampung, trainer MYSQL DBA di tangerang, trainer MYSQL DBA di padang, trainer MYSQL DBA di medan, trainer MYSQL DBA di aceh, trainer MYSQL DBA di Malaysia, trainer MYSQL DBA di Singapore, certified trainer MYSQL DBA , download MYSQL DBA , tutorial MYSQL DBA, ebook MYSQL DBA, tips trik MYSQL DBA, belajar MYSQL DBA, tempat training MYSQL DBA, inhouse training MYSQL DBA , sertifikasi MYSQL DBA, training MYSQL DBA di tambang , training MYSQL DBA di bank , training MYSQL DBA di universitas, training MYSQL DBA di hotel, training MYSQL DBA di perusahaan asuransi , sertifikasi MYSQL DBA, ujian MYSQL DBA, hery trainer MYSQL DBA , syllabuss MYSQL DBA , sisindotek training MySQL DBA, hubungi trainer MYSQL DBA , profesi trainer MYSQL DBA  , profile trainer MYSQL DBA , solusi MYSQL DBA, konsultasi MYSQL DBA, download ebook  MYSQL DBA gratis, download  gratis software MYSQL DBA ]

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Author: Inhouse Trainer freelance

Hery Purnama 081.223344.506 - Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle , MySQL DBA, MS. Access VBA, Primavera P6, MS Project ,Jquery, Yii, CodeIgniter. laravel, CATIA 3D, Unity 5 , PMBOK, PMO, TOGAF, PRINCE2 - Call : 081.223344.506 | PinBB : 7DC633AA| Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer

Leave a Reply

Your email address will not be published. Required fields are marked *