Learn how MySQL, a powerful relational database management system can make your life easier and fun! This class covers all the basics and will get you on your way to database mastery, with a solid foundation in MySQL. Manage and maintain large amounts of data using the MySQL database. This instructor led, hands-on class on MySQL covers the fundamentals of SQL and relational databases using MySQL. Discover how to use MySQL, a popular choice of database for use in powerful web applications! ONE Week of MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics. Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.
2 Weeks
- MySQL Beginner Course
- Computer skills
- 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
What to learn next?
