trainocate-oracle-training-b
Home > Vendors > Oracle > D90871

D90871 - MySQL Fundamentals

Overview

Duration: 4 days

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.

Learn To:

  • Explain the relational database model.
  • Describe the features and benefits of MySQL.
  • Install and configure the MySQL server and clients.
  • Design efficient databases.
  • Use Structured Query Language (SQL) to build your database and query data.
  • Employ appropriate MySQL tools.
  • Gain an understanding on the MySQL Cloud Service.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • 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
  • Export and import database data
  • Explain database transactions
  • Gain an understanding on the MySQL Cloud Service

Content

Module 1: Introduction to MySQL
Module 2: MySQL Server and Client
Module 3: Database Basics
Module 4: Designing Your Database
Module 5: Data Types
Module 6: Creating Databases and Tables
Module 7: Modifying Databases and Tables
Module 8: Querying Table Data
Module 9: Modifying Table Data
Module 10: Functions
Module 11: Joining Tables
Module 12: Conclusion

Audience

  • Application Developers
  • Database Administrators
  • Database Designers
  • Developer

Prerequisites

  • Basic computer literacy

Suggested Prerequisites:

  • Previous experience with any command-line program
  • Knowledge of database concepts

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: