New game
Download
Get Academic Plan
Share game
Fill in the Blanks
Fill in the Blanks

Intro to SQL Databases

Integrate it into your platform

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Intro to SQL Databases

Fill in the Blanks

Played 8

About this activity

Test your knowledge of Basic Microsoft SQL with this engaging fill-in-the-blanks game!

Created by

United Kingdom

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game

Top Games

%
Anonymous
Anonymous
%
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Print your game
Intro to SQL Databases
 

Fill in the Blanks

Intro to SQL DatabasesOnline version

Test your knowledge of Basic Microsoft SQL with this engaging fill-in-the-blanks game!

by Mrs Robbie
1

SELECT Query Structured primary

SQL is a foundational aspect of database management . SQL , or Language , is used to communicate with databases . It allows users to create , read , update , and delete data efficiently . Understanding the basic commands such as , INSERT , UPDATE , and DELETE is crucial for anyone working with databases . The SELECT statement retrieves data from one or more tables , while INSERT adds new records . UPDATE modifies existing data , and DELETE removes records from the database . Additionally , learning about data types , keys , and foreign keys is essential for designing effective databases .

2

foreign link relational two one uniquely repeated record

Flat file databases consist of table .
As a result , a large database will most likely have data which is unnecessarily several times in the same table .
The way to avoid insert , delete and update anomalies is to design databases that use or more linked tables to store data .
A primary key is a field used to identify every in the database .
A key is a primary key from one table that appears in another table to the two together .

3

smallest field Ascending Descending largest

A sort orders the data on a which you choose .
order starts with the smallest first and works its way up to the .
Surname in alphabetical order A ? Z
order starts with the largest first and works its way down to the .

4

BY SELECT FROM WHERE ORDER

- Used to extract the fields
- The table where the records are coming from
- The condition that has to be met
- Sorting the results ascending or descendin g

Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.