MySQL Fundamentals (D90871)

MySQL Fundamentals (D90871)

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
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
N/A
  • Basic computer literacy

Suggested Prerequisites:

  • Previous experience with any command-line program
  • Knowledge of database concepts
Course ID:
D90871


Show Schedule for: