Advanced Mysql Database
Overview
The Advanced MySQL Database training course take you through more complex queries in MySQL and cover some of your backup/recovery options. Some of the topics you will learn in advance MySQL Database topics such as MySQL sys Schema, Logical operators, comparison operator, commit, save point and rollback, views and subqueries, stored procedure and triggers, MySQL Shell, replication, back up in MySQL, and so many other important topics of MySQL.
Objectives
- Discover critical concepts for designing a database
- Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring.
- Overview of MySQL and PhpMyAdmin.
- Understand basic concepts of how a database stores information via tables.
- Understanding of SQL syntax used with MySQL.
- Learn how to retrieve and manipulate data from one or more tables.
- Know how to filter data based upon multiple conditions.
Audience
- Web applications developers
- Database Designers
Requirements
- MySQL Beginner Course
- Computer skills
Course Outline
- MySQL Server Administration
- Security
- Backup and Recovery
- Optimization
- Language Structure
- Character Sets, Collations, Unicode
- Functions and Operators
- SQL Statements
- MySQL Data Dictionary
- The InnoDB Storage Engine
- Alternative Storage Engines
- Replication
- Group Replication
- MySQL Shell
- Using MySQL as a Document Store
- InnoDB Cluster
- MySQL NDB Cluster 8.0
- Partitioning
- Stored Objects
- INFORMATION_SCHEMA Tables
- MySQL Performance Schema
- MySQL sys Schema
- Connectors and APIs
- Extending MySQL
- MySQL Enterprise Edition
- MySQL Workbench
- How to specify multiple values
- How to use MySQL Workbench