D90871 - MySQL Fundamentals

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.

Code: d90871

Duration: 4.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals


Enquire Now
 
 
 
 
QTpLxv
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy