Want to learn more about SQL? “Lost at SQL” offers a gamified approach to learning the basics of SQL for absolute beginners.
Built by Robin Lord. As an expert in digital marketing strategies and his SEO, he uses his SQL primarily for analysis and data exploration in scenarios such as:
- When working with large internal datasets, SQL prepares and extracts data for simple exploration or as a key step in machine learning (prediction, mixed-media modeling, data preparation for large-scale language models, etc.) help you to
- Explore Google Analytics with automatic export to BigQuery
- Look up site speed data
- Explore Raw Search Console. Many Search Console analytics tools pull data into BigQuery, and Google will soon offer bulk export as an option.
With an interface reminiscent of vintage computer games, the first step is to select an image from the set of images available
and give the character a name.
After that, you are ready to enter the game. In a typical noir story, the story is told in the first person, as seen in the first chapter.
A deafening screech wakes you up.
You are Captain Nikos of the SS. QL, you are in big trouble.
Before I lost consciousness, all I could remember was an explosion and the road blocked by falling debris.
Now you know that the submarine is sinking deeper and deeper into the depths of the icy black sea.
Somewhere in the distance, you hear the sound of water falling on metal.
It’s your only chance to reach one of the computer terminals and use it to free yourself and repair your ship.
First, you need to know what kind of damage it does.
First, get all problems from the “failures” table.
So to complete the quest, just issue the following command:
select issues from malfunctions
Within the embedded SQL editor.
For the next task, Chapter 2, you will need to:
Reuse the ‘dysfunctional’ table – get the problem and fix the column
It’s pretty simple.
Of course, this may sound trivial to those already familiar with SQL, but not to those new to SQL. That’s why each chapter has a “learn” button behind the concepts. For example, Chapter 2 states:
In SQL, use “Select” to retrieve information, list the columns you want to retrieve, and create a table to retrieve those columns.
To list multiple columns, list each column in order, separated by commas.
Therefore, you can select the Issue and ID columns from the table named. using table_name
select problem, id from table_name
If you want the id column first, write:
select id and issue issue from table_name
If this alone doesn’t complete your task, you can “slide to get the answer” to see the SQL, copy it and paste it into the editor to finish your work. However, it will be reflected in the status as “Skip”.
As you progress through the levels, the required answers become “complicated” such as:
Select *
from crew
where role="first officer"
again
Select *
from pods_list where
status="functioning"
and range > 1500
and so on.
Ultimately, this course is a blend of game nostalgia, task orientation, and explanations of underlying theory that could be the perfect course to learn the basics of SQL.
For more information
lost to SQL
Related article
SQLBolt – Learn SQL in an interactive way
To stay informed about new articles about I Programmer, sign up for our weekly newsletter, subscribe to our RSS feed, and follow us. twitter, Facebook or LinkedIn.
comment
Or email your comments to comments@i-programmer.info.
