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