About This Guided Project

In this project, you will learn how to add keys to create relationships between the tables and how to use constraints to enforce rules on the data entry in the MySQL database service using the phpMyAdmin graphical user interface (GUI) tool.

Objectives

After completing this project, you will be able to:

Use MySQL phpMyAdmin to create primary and foreign keys
Add constraints to data columns

Requirements

To complete this project you will need the MySQL relational database service which will be available as part of the IBM Skills Network Labs (SN Labs) Cloud IDE. SN Labs is a virtual lab environment used in this project.

Frequently Asked Questions

Do I need to install any software to participate in this project?

Everything you need to complete this project will be provided to you via the Skills Network Labs and it will all be available via a standard web browser.

What web browser should I use?

The Skills Network Labs platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari.

Keys and Constraints in MySQL

Language

Topic

Enrollment Count

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update