Want to create interactive content? It’s easy in Genially!

SQL DESERT ISLAND ESCAPE

Avelino Gomez

Created on January 25, 2024

SQL

Start designing with a free template

Discover more than 1500 professional designs like these:

Adventure Breakout

Team Building Mission Escape Game

Onboarding Escape Game

Christmas Escape Room

Flags Challenge

Museum Escape Room

Education Escape Room

Explore all templates

Adventures on

Notebook

the desert SQL island

Notes about the island

Use it with caution

Backpack

Equipped with a passport full of SQL queries and a backpack containing relational algebra, Data Explorer boarded a SQL-powered plane for this thrilling expedition. The plan was to traverse through the realms of MySQL, Oracle, SQL Server, and beyond, seeking knowledge and insights into the fascinating world of databases.

Tiririri-ri!

Introduction

Once upon a time, in the vast world of databases, there lived a curious character named Data Explorer. Fueled by a burning desire to unravel the mysteries of data, Data Explorer decided to embark on an adventurous journey to explore the far corners of the database world.

Backpack

Missions

Boat

Lorem ipsum dolor sit amet, consectetur adipiscing

Shrubbery

Plane

Shelter tent

Forest

Backpack

Mission

Plane

As the plane soared through the clouds of JOIN statements and nested queries, an unexpected storm struck. Lightning flickered around, and the SQL-powered engine sputtered, causing the plane to crash on a mysterious island in the vast ocean of SQL

Suitcases

Backpack

What is the menaing of SQL?

mmm

Secure Query Language

Structured Query Language

System Query Language

Standard Query Language

Backpack

"Query all the material at your disposal to survive using an SQL statement."

Let's go!

show material;

select food from material;

select * from material;

select knife from table;

Backpack

Woow!!

When Data Explorer regained consciousness, the surroundings were unfamiliar. The island appeared to be a desolate place, but Data Explorer noticed peculiar SQL-shaped rocks scattered around. It dawned upon our intrepid explorer that this was no ordinary island—it was the SQL Island, a place where lost queries and forgotten databases found refuge. With the SQL-shaped rocks as companions, Data Explorer began the quest for survival.

Yeah!

You've got food and cooking tools

Backpack

Missions

Boat

4Data Explorer also discovered an ancient SQL manual washed ashore, providing guidance on how to navigate this SQL-driven wilderness.

Shrubbery

Plane

Shelter tent

Forest

Backpack

Mission

Forest

As the days turned into weeks, Data Explorer learned to communicate with the SQL Island's native creatures—tables, rows, and indexes. In return for learning their language, the island bestowed upon our explorer the wisdom of optimizing queries and mastering transaction management.

Logs

Backpack

Amidst the solitude of SQL Island, Data Explorer found unexpected beauty in the simplicity and elegance of structured data. The SQL-shaped rocks and forests turned into a mosaic of knowledge, telling the story of databases, relationships, and the importance of data integrity.

In what application or program can you use SQL?

Backpack

B. Graphic Design Software

A. RDBMS

SQL is primarily used in graphic design software.

SQL is commonly used in relational database management systems (RDBMS).

Backpack

Next query Sort the names of items from the material table in alphabetical order

SELECT names FROM material ORDER BY item;

SELECT item FROM material ORDER BY item;

Backpack

Awesome!!

They will be added to your backpack. You will need them during the days you spend on the desert island

Yeah!

You've got a rope, maybe it will be useful

Backpack

Missions

Boat

Have you seen something shiny in the bushes?

Shrubbery

Plane

Shelter tent

Forest

Backpack

Mission

Shrubbery

"To access the shiny object hidden among the bushes, you'll need to use filters and subqueries to get there."

Food

Backpack

WHERE

Here we go!!

FROM

It is used to filter results

Backpack

Almost there!!

JOIN

Command to add new records

INSERT

Backpack

Almost there!!

Logical operator to combine conditions.

AND

Backpack

Almost there!!

SUM

Function that counts the number of records.

COUNT

Backpack

keep it up!!

They will be added to your backpack. You will need them during the days you spend on the desert island

Yeah!

You've got an axe, maybe it will be useful

Backpack

Missions

Boat

You have spotted a tent; it will come in handy for resting.

Shrubbery

Plane

Shelter tent

Forest

Backpack

Mission

Fabrics

Lorem ipsum

Lorem ipsum dolor sit amet, consectetur adipiscing

Shelter tent

Backpack

SELECT SUM(dias) AS total_dias FROM sobrevivientes WHERE pertenencia_id = (SELECT pertenencia_id FROM objetos WHERE nombre = 'Tienda de Campaña'); The subquery is being performed on the table named

A. sobrevivientes

B. total_dias

C. objetos

Backpack

What does the following SQL query return?

SELECT COUNT(*) AS numero_sobrevivientes FROM sobrevivientes WHERE pertenencia_id = (SELECT pertenencia_id FROM objetos WHERE nombre = 'Tienda de Campaña');

The number of survivors who have the tent as their belonging.

The total number of survivors in the sobrevivientes ' table."

the total number of objects

Backpack

SELECT AVG(edad) AS edad_media FROM sobrevivientes;

Media de sovrevivientes

Edad media de los sobrevivientes

Media de sobrevivientes por edad

Backpack

Oh yeah!!

They will be added to your backpack. You will need them during the days you spend on the desert island

Yeah!

You've got a lantern, maybe it will be useful

Backpack

Missions

Boat

you have found directions to where there is a boat to leave the island."

Shrubbery

Plane

Shelter tent

Forest

Wait, take a look in your backpack

Check items in your backpack and use the flashlight to look for the code to access the last mission that will allow you to leave the desert island.

Keep searching

Code: 1234

Keep searching

Enter the complete code you have obtained to access the last mission

Introduce la contraseña

Find your Knowledge backpack

You have already traveled the whole island, you have managed to build a raft, but now you do not remember where you left your backpack and you will need it before you can leave here. On the map you can see the places where your backpack could be.

Forest

Mountains

Plane

Shrubbery

Shelter tent

Desert island map

Drag the parts of the map to find where you have left your backpack and be able to flee from the desert island.

Congratulations!

Wow, you got it!

You have acquired the necessary knowledge to survive in the exciting adventure of the SQL language.

Play again!

Ouch!

your answer might have left you stranded on the shore. Let's explore the database knowledge with precision and find the right path to escape this adventure

Keep trying!

You should to review the SQL theory

Ouch!

your answer might have left you lost into the forest. Let's explore the database knowledge with precision and find the right path to escape this adventure

Keep trying!

You should to review the SQL theory

Ouch!

Let's explore the database knowledge with precision and find the right path to escape this adventure

Keep trying!

You should to review the SQL theory

Ouch!

Let's explore the database knowledge with precision and find the right path to escape this adventure

Keep trying!

You should to review the SQL theory