|Lost at SQL - The Game|
|Written by Nikos Vaggalis|
|Sunday, 21 May 2023|
Do you want to get conversant with SQL? "Lost at SQL" offers a gamified approach to learning the basics of SQL addressed to total beginners.
Built by Robin Lord who, as a digital marketing strategy and SEO expert, uses SQL not for CRUD applications but mostly for analytics and data exploration in scenarios like:
With an interface reminding of vintage computer games, your first step is to choose a picture from a set of available ones
After that you are ready to jump into the game. In typical noir narrative, the stories are told in the first person like we find on the very first chapter:
You awake to an ear-splitting screech.
So in order to complete the quest you just have to issue the command:
inside the embedded SQL editor.
The next task, Chapter 2, requires you to:
Using the "malfunctions" table again - get the issues and fix columns
Pretty simple stuff.
Of course that might sound trivial for someone already familiar with SQL but not for one that watches SQL for the very first time. As such there's a "Learn" button in each chapter which goes behind the concepts. For instance the one of chapter 2 explains :
In SQL we get information by using 'Select', then listing the columns we want back, then writing the table we want to take those columns from.
If that wasn't enough help to complete the task, you can still "Slide to get the answer" to reveal the SQL which you can then copy and pest on the editor to get over with. However that will reflect on your stats as a "Skip".
As the levels progress, the answers required become more "involved" the likes of:
And so on.
In the end, with a blend of gaming nostalgia, task orientation and explanations of the underlying theory this might be the perfect course to get your feet wet in SQL.
SQLBolt - Learn SQL The Interactive Way
To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.
or email your comment to: firstname.lastname@example.org
|Last Updated ( Sunday, 21 May 2023 )|