Treasure Inspiration
Databases
T

Relational Databases and SQL Basics

Push a bit harder. Apply what you know to less familiar problems.

Computer Science · Medium

5

questions · ~4 min · 3 hints each (−5 pts)

Confidence tracking, 3-tier hints and instant feedback.

What you'll learn

Each question helps you build key knowledge and skills.

  • 1Relational databases use foreign keys, fields that reference a primary key in another table, to create relationships between tables.
  • 2Structured Query Language, or SQL, is used to create, read, update and delete data in a relational database.
  • 3The SELECT statement retrieves data, the WHERE clause filters rows, and ORDER BY sorts the results returned.
  • 4Data integrity rules such as validation checks help make sure the data entered into a database is sensible and accurate.

Question mix

A mix of question types to build your skills.

  • Multiple choice×4
  • Short answer×1

Different question types help you think in different ways.

How it works

A simple 3-step process

  1. 1

    Rate your confidence

    Tell us how sure you feel before answering. It helps us understand your starting point.

  2. 2

    Use hints if stuck

    Get up to 3 helpful hints per question. Each hint costs 5 Treasure Points.

  3. 3

    See what went wrong

    Get instant feedback with clear explanations, so you can learn and improve.

Ready when you are

This takes about 4 minutes.