DASVM brings you a comprehensive MySQL DBA training, designed to give you basic knowledge and skills to become a successful MariaDB Administrator. In this course, you will get a walk through on how the Database works, availability of tools, how to use these tools, how to configure MySQL Database server and configuration. The course also covers database maintenance, backup and recovery. MySQL Server is one of the most popular database servers and it has been developed by the original developers of MySQL. MySQL is open source and as a relational database it provides SQL interface for data access.
Course content
Open Source Introduction
- Overview of MySQL
- History of MySQL
- The Main Features of MySQL
MySQL Installation
- Linux Operating System Installation
- Linux Commands
- Installing MySQL on Linux
- How to start, stop and restart the server
- How to check the MySQL status and Configuration file
- INFORMATION_SCHEMA Tables
- System Catalog Views
Storage Engines with Simple Examples
- Setting the Storage Engine
- The MyISAM Storage Engine
- The InnoDB Storage Engine
- The MEMORY Storage Engine
- The CSV Storage Engine
- The ARCHIVE Storage Engine
- The BLACKHOLE Storage Engine
- The MERGE Storage Engine
- The FEDERATED Storage Engine
Tablespace Management
- Storage Architecture
- Create Tablespace
- Alter Tablespace
- Drop Tablespace
MySQL User management.
- Creating Users
- Renaming Users
- Changing Passwords
- Dropping Users
- Granting Privileges
- The User Table
- Create SSL Users
Installation on Windows on MySQL
- Installation of Workbench
- Installation of HeidiSQL
- MySQL Architecture
MySQL Server logs
- Error Log
- General Log
- Slow Log
- Binary Log
- Relay Log
Configuring InnoDB
- InnoDB Table and Index
- Managing InnoDB Data and Redo Log
- Change the location of the ibdata file
- Adding 2 ibdata files
- Change the position of log files
- increase the redo log files with 4 or 6
- Memory allocation for Innodb
- Turnoff Innodb
Database Backup Methods
- Using mysqldump for Backups
- Dumping Data in SQL Format.
- Backups
- Restore
- Point in Time Recovery (Binlog)
- Percona XtraBackup Installation on MySQL Server
Percona Server
- Percona Overview
- Percona Server Installation
- Percona XtraBackup Installation
- Percona Features
- Configuration of XtraBackup
- Taking Full Backup
- Taking Incremental Backups
- Restoring / Recovering Full Backups and Incremental
- Partial Backups
- XtraBackup Installation on MySQL Server
Performance Tuning – Partitioning
- Overview of Partitioning in MySQL
- Partitioning Types
- RANGE Partitioning
- LIST Partitioning
- HASH Partitioning
- KEY Partitioning
- Obtaining partitioned information
- Modifying and removing partitions
- Partition pruning
Managing Multiple instances
- Installing MySQL Server from Generic Binaries
- Setting Up Multiple Data Directories
- Running Multiple MySQL Instances on Linux
- Managing Multiple MySQL Servers
Upgrading MySQL
- MySQL Server 5.7 to MySQL Server 8
Uninstalling MySQL Server 5.7
Installing MySQL Server 8.0 on Linux
- New Features
Advanced DBA Concepts
Scaling and High Availability
- Types of Replication
- Master-Slave Configuration
- Master-Master Configuration
- Adding Slave to Master – Master Setup
- Overview of GTID Replication
- GTID Setup & Configuration
- Overview of Multi Source Replication
- Multi Source Replication Setup & Configuration
- Replication Troubleshooting
Performance Tuning
- DBA Checklist
- What is running slow on my server?
- Why are my queries running slow?
- How to fix slow running queries?
- MyISAM Key Cache
- About Locking & Issues
- Locking Methods
- Table Locks
- Deadlock
- InnoDB PT Parameters
- The InnoDB Buffer Pool
- Performance_schema Database
- Monitors Server Events
- Current & History
- Performance reports
- InnoDB Statistics
- Optimization [ About Constraints ]
- Index Management
- Types of Indexes
- Explan Plan Quering
- Indexing Strategies for High Performance
- Index Maintaince
- Indexing Check List
- Analyze table
- Optimize table
To see the full course content Download now
Course Prerequisites
- Basic SQL knowledge
- Basic Linux knowledge is recommended, but not needed
Who can attend
- Database administrators who have experience in alternate relational database management systems and those who want to learn to administer, monitor and support MySQL databases and servers will find this course useful.
Number of Hours: 40hrs
Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com