Overview
MySQL for Beginners Ed 3 training course enables you to learn about the world’s most popular open source database. ITShare certified instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases.
Course Prerequisites
- Basic knowledge of database
After completion of this course; you will learn following:-
- Explain MySQL storage engines
- Explain database transactions
- Obtain database metadata
- Describe MySQL GUI tools
- Monitor database performance
- Perform database backup and recovery
- Export and import database data
- Describe the features and benefits of MySQL
- Explain the basics of relational databases
- Design an effective database
- Build a database and tables by using SQL Modify or delete database entities
- Query data with the SELECT command
- Join data from multiple tables
- Perform nested subqueries
- Use built-in MySQL functions