MySQL Concepts

MySQL Concepts Matching

Introduction

MySQL Concepts Matching will review your understanding of the various keywords in the MySQL lanaguage through matching exercises where you will pair a keyword with the best category for that keyword.

• Drag each keyword to the correct box
• When you've finished matching, click the "Solution" button to review your work.
• Move on to the next page using the arrows until you reach the end of the game.

Objectives

Through this game, you will be able to properly classify MySQL keywords

MySQL Keywords

Solution

Drag each keyword to the correct group

COUNT

Verbs

Aggregates

SELECT

INSERT

AVG

UPDATE

SUM

MySQL Keywords

Solution

Drag each keyword to the correct group

DELETE

Verbs

Aggregates

MAX

GROUP_CONCAT

ALTER

DISTINCT

UNION

MySQL Keywords

Solution

Drag each keyword to the correct group

DELETE

Verbs

Aggregates

MAX

GROUP_CONCAT

ALTER

DISTINCT

UNION

MySQL Keywords

Solution

Drag each keyword to the correct group

LIKE

Joins

Conditions

LEFT

RIGHT

INNER

IN

BETWEEN

MySQL Data Types

Solution

Drag each type into its correct classification

INT

Strings

Numerics

VARCHAR

DOUBLE

TEXT

ENUM

FLOAT

Verbs

DELETE UNION ALTER

Aggregates

DISTINCT MAX GROUP_CONCAT

Verbs

INNER LEFT RIGHT

Conditions

LIKE BETWEEN IN

Verbs

DELETE UNION ALTER

Aggregates

DISTINCT MAX GROUP_CONCAT

String

VARCHAR ENUM TEXT

Numerics

INT FLOAT DOUBLE

Verbs

SELECT INSERT UPDATE

Aggregates

COUNT SUM AVG