The MySQL is most popular open source database in the world.
Learners will know how to manage and maintain a MySQL system, master complex features and functions.
In general DBA Actvities include :
rchestrating upgrades, backups, and provisioning of database instances.
work with cross functional teams, preparing documentations & specifications as required.
managing MySQL instances performance, availability
Managing MySQL User Accounts,Maintaining MySQL Log File, Tuning the MySQL Server
managining Multiple MySQL Servers, MySQL Database Maintenance and Repair.
To manage MySQL Workbench to perform various administrative tasks and many more
Course Takeaway:
Strong proficiency in MySQL database management
Manage Users, Roles, and Privileges
Manage upgrades, backups, and provisioning of database instances.
Proficient in writing and optimizing SQL statements
Ability to plan resource requirements from specifications
work on both clustered and non-clustered configurations
Manage storage engines, such as InnoDB and MyISAM
Performance analysis
ability to deliver reliability and performance
Requirements::
Sound knowledge with relational database concepts
comfortable using the mysql command-line client
knowledgeable with MySQL data types and writing procedures and functions
Who sholud learn this course:
Beginner Database Administrators
Beginner database designers
Beginner developers
Introduction,
Installation and Configuration,
Basic Select Statements,
Using Expressions in MySQL Statements,
Inserting, Updating and Deleting Records in MySQL,
Data Validation in MySQL,
Advanced Queries,
Aggregate Functions and Grouping,
Programming with MySQL,
Managing Transactions in MySQL,
Database METADATA,
Database Maintenance,
SQL Modes and Log Files,
CHARACTER SET SUPPORT,
TRANSACTIONS AND LOCKING,
Security and Access Management,
Stored Routines and Triggers,
Exporting and Importing Data in MySQL,
Backup and Recovery,
Partition and Replication,
Optimization and Performance,
Using Multiple Servers