Computer Science — SQL Fundamentals
Practise the building blocks of relational queries: filtering, sorting, grouping, aggregation, and joining tables.
Topics covered
- Tables and keys
- SELECT and WHERE
- Sorting and limiting rows
- Grouping and aggregates
- INNER and LEFT JOIN
Card preview
Question 01In a relational database, what does a table represent?
A relation of records organized into rows and named columns; each row represents one record and each column a field.
Question 02What does SELECT do in a basic SQL query?
It chooses the columns or expressions to return in the query result.
Question 03What does FROM specify in a basic SELECT query?
The table or tables from which the query reads rows.
Question 04What does WHERE do?
It filters input rows to keep only those that satisfy a condition, before grouping and aggregation.
Question 05Write a query that returns the name of each active student, alphabetically.
SELECT name FROM students WHERE active = TRUE ORDER BY name;
Import this deck into Rivio
The downloaded JSON uses Rivio's deck_name, question, and answer format. Rivio recognizes those fields and suggests them automatically.
- 1Download the JSON deck
Save the file to your device.
- 2Open Rivio → Flashcards → Import Deck
Choose the downloaded file and select a subject or deck destination.
- 3Check the import preview
Question and answer fields are suggested for this format. Review the cards, then import.
- 4Start reviewing
Open the imported deck in Rivio and practise recall.
The preview shows a sample of the deck. The download contains all 20 cards.
Get Rivio on Google PlaySources for further study
Use these references to check definitions and connect the cards to your course material.