Hakkında
The MySQL for Database Administrators empowers DBAs and other
database experts to augment their association's interest in MySQL. Figure out
how to arrange the MySQL Server, set up replication and security, perform
database reinforcements and recuperations, streamline inquiry execution, and
design for high accessibility.
- Install and arrange MySQL Server and
customer programs
- Recognize the key parts of the MySQL
engineering
- Manage client accounts and secure your
server
- Troubleshoot server log jams and
different issues
- Backup and recoup MySQL database
- Configure and regulate an assortment of
replication topologies
Önkoşullar
Involvement
in social database ideas; information on essential SQL articulations; see
how to execute Linux/Unix orders.
Kurs Süresi
- Instructor-led training: 5 days with hands-on lab practice
- Virtual instructor-led training: 5 days of web-based classes with hands-on lab practice
- E-learning: Equivalent of 5 days of instruction with hands-on lab practice
Kurs Hedefleri
- Install
the MySQL server and customer programs
- Upgrade MySQL on a running server
- Describe MySQL design
- Explain how MySQL procedures, stores,
and transmits information
- Configure MySQL server and customer
programs
- Use server logs and different
apparatuses to screen database action
- Create and oversee clients and jobs
- Protect your information from basic
security dangers
- Troubleshoot server stoppages and other
regular issues
- Identify and streamline inadequately
performing inquiries
- Define and execute a reinforcement
procedure
- Perform physical and sensible
reinforcements of your information
- Describe MySQL replication and its job
in high accessibility and versatility
- Configure basic and complex replication
topologies
- Administer a replication topology
- Configure and regulate InnoDB Cluster
Ders İçeriği
Introduction
to MySQL
Connectors
and APIs
Using Connectors
Prepared
Statements
Handling
Errors and Warnings
Creating
Database-Driven Web Applications
Tables and
Views
Working with
Strings
Working with
Numeric and Temporal Data
Subqueries
Modifying
Table Data
Transactions
Optimizing
Queries
Stored
Routines
Triggers and
Scheduled Events
Reporting
Building
NoSQL Applications
Spatial Data
Conclusion
