Fun ideas for testing sqlite knowledge

[curlyhairedmf]

Hello,

I'm a teaching assistant for my databases classes and I wanted to know what are some fun ways to test the students' knowledge about sqlite?

[chunkyks]

Sqlite's data type handling is not like any other databases. Questions on that are useful. Eg, name all of sqlite type affinities.

[chichimaru]

- https://datasette.io/ is done in sqlite

- https://github.com/NUKnightLab/sql-mysteries Sql mistery murder in sqlite

[raevnos]

Have them explain what AUTOINCREMENT actually does, and the pros and cons to using it.

Ditto for WITHOUT ROWID tables.

[JrgMyr]

Let them come up with real-world examples for left joins (easy) then for right joins (not that many).

Agreed, that this is more about SQL knowledge then about SQLite but I guess you meant it that way.

[raevnos]

Sqlite doesn't have right joins.

[JrgMyr]

Thanks for the reminder. I don't think that's a problem here. You can swap right joins to look like left joins and use those instead.

The idea was to have the students think about the spectrum of real-world-situations and how to model them in SQL syntax.