Skill

Creating Tables with Constraints in MySQL

September 2021 with Trevor Sullivan

Join Trevor Sullivan as he explains how to create MySQL tables using primary and foreign key constraints!

Recommended Experience

Six months of hands-on experience using MySQL is recommended.

Related Job Functions

IT Professional
Database Administrator
Database Developer

Trevor Sullivan has been a CBT Nuggets trainer since 2020 and has received a variety of AWS certifications. His areas of expertise include Amazon Web Services, Docker, Microsoft Azure, and PowerShell automation.

Get started

Videos in this skill

1. Intro to MySQL Table Constraints (14:04)
2. Using PRIMARY KEY Constraints in MySQL (9:13)
3. Create FOREIGN KEY References in MySQL (11:09)
4. Query Data Across FOREIGN KEY References (4:38)
5. Define Table CHECK Constraints in MySQL (9:18)
6. Define Column CHECK Constraints in MySQL (4:38)

Quizzes & Practice Exams

Reinforce core concepts and new skills with built-in quiz questions, and exams.

Virtual Labs

Explore new technology and apply your expertise in customized virtual labs.

Accountability Coaching

Define your goals and stick to a training plan with help from our coaches.

Learn this skill and so much more!

Get started

Gain instant access to our entire IT training library, free for your first week. Train anytime on your desktop, tablet, or mobile devices.

Not sure where to start?
Call 541-284-5522 or try our .

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews