Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Online MySQL DBA Training - Basic Level

No Reviews Yet

Course type: Online Instructor led Course

Platform: Online

Course ID: 37333

Course type: Online Instructor led Course

Platform: Online

Students Interested 0 (Seats Left 0)

₹ 12,000

No Reviews Yet

Date and Time

Not decided yet.

Sarath

MCA

About Sarath

I did Microsoft Certifications and Oracle Certifications.I had around 12+ years of industry experience working on Oracle,MS SQL Server,MySQL database platforms as Sr Database Administrator. He has worked with Oxford Groups, EDS – Mphasis Company, Cognizant Technology Solutions.

I worked in United States and worked on large scale projects like EDS – General Motors, Rodale Inc., Houghton Mifflin Harcourt Inc. Pfizer Pharmaceuticals, AstraZeneca Pharmaceuticals, Blue Shield of California ,Cognizant etc..

Post graduated from Mahindra Engineering College, Tamilnadu.

I had a passion for providing SQL Server trainings and knowledge sharing sessions. I am conducting Online training and Corporate training as well. His main areas of focus include Performance Tuning, Clustering Issues, and Troubleshooting Principles in all rdbms as well Cloud Computing administration.

I am good at MSSQL Clustering, Oracle RAC and Performance Tuning.
No reviews currently Be the First to Review

About the Course

 



  • Real Time Scenarios and solutions

  • DBA Real time tools

  • ITIL Infrastructure Methods

  • Real Time Project with live demo

  • Interview Questions

  • Interview Preparation Sessions

  • Resume preparation

  • Mock Interviews

  • 6 Months Free Email Support,Call Support & Chat Support


Open Source Introduction
• Overview of MySQL
• History of MySQL
• The Main Features of MySQL
MySQL Installation

How to start, stop and restart the server
1.How to check the MySQL status
2.How to set /update the MySQL root/user password
• Mysql_install_db
• Mysql_secure_installation
• Mysql_tzinfo_to_sql

MySQL user management.
•How to maintain the user privileges using DDL & DCL Commands
•How to maintain the user privileges using DML Commands

MySQL Programs.
MySQL Client Programs.
• Mysql — the MySQL Command-Line Tool.
• Mysqladmin — Client for Administering MySQL Server
• Mysqlcheck — A Table Maintenance Program.
• Mysqldump — A Database Backup Program.
• Mysqlimport — A Data Import Program.
• Mysqlshow — Display Database, Table and Column Information
• Mysqlslap — Load Emulation Client

Storage Engines with Simple Examples
•MYISAM
•INNODB
•MEMORY
•CSV
•ARCHIVE
•MERGE
•FEDERATED
•BLACKHOLE

Configuring InnoDB
• InnoDB Table and Index Structures.
• Managing InnoDB Data and Log Files.
• InnoDB Startup Options.
• InnoDB Multi-Versioning.
• Restrictions on InnoDB Tables
• Memory allocation for Innodb
• Turnoff Innodb
• Innodb startup options

8.MySQL server logs
• Error Log
• General
• Slow Log
• Binary Log

Database Backup Methods
• Using mysqldump for Backups
• Dumping Data in SQL Format.
• Backup Tools ( Oracle Enterprise Backup (or) Percona XtraBackup )
• Restore & Recovery.

Replication
• Overview Replication
• Master-Slave Configuration
• Master-Master Configuration
• Replication trouble shooting / errors

Managing Multiple instances
• Setting Up Multiple Data Directories
• Running Multiple MySQL Instances on UNIX
• Running Multiple MySQL Instances on Windows
• Using mysqld_multi for Managing Multiple MySQL Servers

Performance Tuning
• InnoDB
• Performance Tuning
• Isolation Levels
• Error Handling

INFORMATION_SCHEMA Tables
• Buffering and Caching
• The MyISAM Key Cache
• The InnoDB Buffer Pool

Locking Issues
• Internal Locking Methods
• Table Locking Issues
• Concurrent Inserts
• External Locking

Upgrading MySQL and Features.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 12,000

Post your requirement and let us connect you with best possible matches for MySQL DBA Training Post your requirement now
₹ 12,000 Enquire

Enquire

Submit your enquiry for Online MySQL DBA Training - Basic Level

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With DBA Centre

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer