Databanken voorbeelden (SQLite) (2022–2023)

Brecht Willems · Universiteit Gent

Documentation: https://github.com/dodona-edu/judge-sql#readme

You are currently not able to subscribe to this course.

Register

Exercise series

Ruimtevaart

Title Class progress
Create table
Fill table
Database scheme spaceflight
Select first names
Select nationalities
Select first and last names
Unique nationalities
Cosmonauts
Astronaut id
Non-Americans
American or Belgian astronaut
Michael Barratt
Cosmonauts Sergei and Elena
Sort by last name
Sort by last name (NLD&BEL)
Sort by nationality
Beginning with 'M'
Ending with 's'
Contains 'us'
No e in first name
Nationality with an s
Number of astronauts
Number of countries
Last astronaut
Land code
ISO code
Nationality

Voorbeeldoefeningen

Title Class progress
Database scheme
Example SELECT 1
Example SELECT 2
Example SELECT 3
Example ORDER BY
Example WHERE 1
Example LIKE
Example SUM
Example GROUP BY
Example HAVING
Example exercise 1
Example exercise 2
Example exercise 3

Introduction

Title Class progress Status
Create table
Add data
Add data 2
Retrieving data
Retrieving ordered data
Retrieve data with where
Retrieve data with where like
Remove data
Update data
Update data with current date

Multiple tables

Title Class progress Status
Create second table
Inner join where
Inner join alternative
Outer join (right)
Subqueries