MySQL

by Greater Insights Claim Listing

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Greater Insights Logo

img Duration

5 Days

Course Details

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service.

Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability.

Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.

 

At the end of the training, participants will be able to:

  • Define and implement a backup strategy
  • Perform physical and logical backups of your data
  • Describe MySQL replication and its role in high availability and scalability
  • Configure simple and complex replication topologies
  • Administer a replication topology
  • Install the MySQL server and client programs
  • Upgrade MySQL on a running server
  • Describe MySQL architecture
  • Explain how MySQL processes, stores, and transmits data
  • Configure MySQL server and client programs
  • Use server logs and other tools to monitor database activity
  • Create and manage users
  • Protect your data from common security risks
  • Identify and optimize poorly-performing queries
  • Troubleshoot server slowdowns and other common problems
  • Gain an understanding of MySQL Cloud

 

Pre-requisite:

  • Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL
  • Should be knowlegeable with relational database concepts and using the mysql command-line client
  • Should be knowlegeable with Joining
  • MySQL Fundamentals Ed 1
  • MySQL for Developers

 

Course Outline:

  • Introduction to MySQL
  • Installing MySQL
  • MySQL Architecture
  • Configuring MySQL
  • Monitoring MySQL
  • User Management
  • MySQL Security
  • Maintaining a Stable System
  • Optimizing Query Performance
  • Backup Strategies
  • Performing Backups
  • Configuring a Replication Topology
  • Administering a Replication Topology
  • Group Replication
  • Conclusion
  • Kumaraswamy Layout Branch

    768, 14th Cross Rd, 2nd Stage, Kumaraswamy Layout, Bangalore

Check out more MySQL courses in India

Baroda Institute Of Technology Logo

Oracle PL-SQL Course

SQL/PLSQL Accelerated Training course will teach you SQL and PL/SQL programming language concepts. Learn how to write SQL commands, develop stored PL/SQL procedures, functions, packages and database triggers.

by Baroda Institute Of Technology [Claim Listing ]
ITCC Logo

Oracle Course

Oracle course is offered by ITCC. We started from a home office and growing ever since with support of our trainers, students and associates. We are thankful to everyone who has been a part of academy.

by ITCC [Claim Listing ]
Accord Info Matrix Logo

Database Management System (MySQL)

Database Management System (MySQL) Course is offered by Accord Info Matrix for all skill level. Accord Info Matrix is a Chennai based IT Software Training Institutes. Our main focus areas are IT and Computer Software, Hardware & Network Training and also Development.

by Accord Info Matrix [Claim Listing ]
SICS (Shah Institute Of Computer Science) Logo

MySQL

MySQL course is offered by SICS ((Shah Institute Of Computer Science). SICS offers courses in diverse domains to college students, graduates and experienced working professionals. These courses enable individuals to get an unrivalled boost in their career graph.

by SICS (Shah Institute Of Computer Science) [Claim Listing ]
Perfect Computer Education Logo

PHP & MySQL

PHP & MySQL Course is offered by Perfect Computer Education for all skill level. Our team of experienced faculty strives to provide good quality training with effective teaching methodologies.

by Perfect Computer Education [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy