TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

MySQL Fundamentals Ed 2

Schedule

Start End Duration Location Details

Course Details

MySQL Fundamentals Ed 2

Course code: MSQLF2

Duration: 4 Days

Prerequisite:

Before you start doing practice with various types of examples given in this tutorial, it is being assumed that you are already aware about what a database is, especially an RDBMS and what is a computer programming language.

Course Description:

The MySQL Fundamentals training is the first step in mastering MySQL, the world's most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.

Course Objectives:

After taking this course, you should be able to:

• Describe the features and benefits of MySQL
• Explain the basics of relational databases
• Issue MySQL statements from the mysql command-line client
• Perform database operations by using MySQL Workbench
• Select appropriate data types for your database
• Build a database and tables by using SQL
• Modify the structure of your database
• Create indexes and keys
• Add or update database data
• Query data with SELECT statements
• Join data from multiple tables
• Use built-in MySQL functions
• Retrieve JSON data
• Backup and restore database data
• Explain database transactions

Intended Audience:

• Architects
• Database Administrators
• Developers
• End Users

Course Outlines:

  • Introduction to MySQL
  • MySQL Server and Client
  • Querying Table Data
  • Querying Table Data
  • Querying Table Data
  • Functions
  • Joins and Unions
  • Subqueries
  • Creating Databases and Tables
  • Modifying Databases and Tables
  • Modifying Table Data
  • Securing Your Database
  • Backing Up Your Database
  • JSON
  • Conclusion