Stats: 3,183,678 members, 7,921,455 topics. Date: Thursday, 15 August 2024 at 05:31 AM |
Nairaland Forum / Nairaland / General / Career / Certification And Training Adverts / Mysql Dba Realtime Online Training From India By Hands-on Professionals :::apex (384 Views)
Oracle Apps Dba Realtime Online Training By Hands-on Working Professionals @apex / Db2 Dba Realtime Online Training [ph: 8500122107],support And Corporate Training / Oracle Dba Realtime Online Training,job Support,corporate Training:8500122107 (2) (3) (4)
(1) (Reply)
Mysql Dba Realtime Online Training From India By Hands-on Professionals :::apex by apex01: 5:55pm On Feb 19, 2017 |
MYSQL DBA HANDS-ON LIVE TRAINING BY REALTIME WORKING FACULTY FROM INDIA | USA | UK | CANADA | AUS FOR FREE DEMO contact us: Email : raj@apex-online-it-training.com Phone/WhatsApp : +91-(850) 012-2107 MYSQL DBA Course Agenda (we can customize the course content as per your requirements) Course Curriculum 1. Introduction of MySQL database system, history, features and architecture of MySQL. • Introduction, History and describe the client/server model • Understand communication protocols • Understand how the server supports storage engines 2. MySQL Installation • RPM Installation • Generic Binaries Installation 3. MySQL installation start up programs • How to start, stop and restart the server • How to check the MySQL status • How to set/update the MySQL root/user password 4. MySQL user management. • How to maintain the user privileges using DDL & DCL Commands • How to maintain the user privileges using DML Commands 5. Storage engines • MYISAM • INNODB • MEMORY • CSV • ARCHIVE • MERGE • FEDERATED • BLACKHOLE 6. MySQL Server performance Optimization/Tuning. • Basic settings in configuration file • Tuning server parameters • Optimization techniques 7. MySQL Programs. • Server programs • Client programs • Utility programs 8. Locks • READ (Shared Locks) • WRITE(Exclusive Locks) 9. MySQL server logs • Error Log • General Log • Binary Logs • Slow Log 10. Backup • Physical backup • Logical backup • Using GUI/Backup Tools 11. Restore & Recovery. 12. General Security Issues. 13. Query Optimization. • EXPLAIN PLAN • Query optimization techniques 14. Partitioning • Range • List • Hash • key 15. Replication • Master-Slave Conjuration • Master-Master Configuration • Replication trouble shooting 16. Upgrading MySQL. 17. MySQL Trouble Shooting Techniques 18. NDB Cluster Over view • Management Node • SQL Node • Data Node 19. Managing multiple instances • Configure multiple instances in a single server • How to maintain multiple instances 20. Advanced Topics A. MySQL 5.6 Futures • GTID Replication • Multi-threaded slave • Crash-safe slave Configuration • Delay Replication • Multi-Source Replication • No-SQL with MySQL B. MySQL 5.7 Installation and futures FOR More Details contact : Email : raj@apex-online-it-training.com Phone/WhatsApp : +91-(850) 012-2107
|
(1) (Reply)
Microsoft Project 2016 Practical Training In Lagos -may 2017 - 08033146625 / 24th - 28th July Introduction To Big Data And Hadoop Course In Abuja / Please I Need guidance on Autocad/project Management Training
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |