A database is a structured series of data. It may be whatever from a easy purchasing listing to a image gallery or the sizable quantities of information in a company network. To add, access, and manner facts saved in a laptop database, you need a database administration gadget such as MySQL Server. Since computer systems are very good at managing massive amounts of data, database administration structures play a central function in computing, as standalone utilities, or as parts of different applications.

Course covers:

• Installing and Upgrading MySQL
• MySQL Server Administration
• Security
• Backup and Recovery
• Optimization
• Character Sets, Collations, Unicode
• Data Types
• Functions and Operators
• MySQL Data Dictionary
• The InnoDB Storage Engine
• Alternative Storage Engines
• Replication
• MySQL Shell
• Using MySQL as a Document Store
• InnoDB Cluster
• InnoDB ReplicaSet
• MySQL NDB Cluster 8.0
• Partitioning
• Stored Objects
• INFORMATION_SCHEMA Tables
• MySQL Performance Schema
• MySQL sys Schema
• Connectors and APIs
• MySQL Enterprise Edition
• MySQL Workbench
• MySQL on the OCI Marketplace
• Error Messages and Common Problems