Cecil, I like the idea but I can't give an outline. It will depend on your audience. Tables, Views, Indexes, Triggers, Joins...
One piece of advice I can give you: use an example anyone can understand. I once have a db training and I got lost because the example was about football and the only thing I know about football is that there are 2 teams of 11 players. That ways enough to understand the first 10 minutes of the training. And then I got lost. Not because the DB stuff was too complicated but because football is too complicated ;-) One of the things you should probably also explain is how to work in a shell and how to work in a tool like the SQLite Expert. And maybe also how to use an SQLite db in an online environment like PHP and how to protect yourself against sql-injections. Also how to use extensions might be useful. You could ask your future audience what they need. gert 2016-05-05 17:17 GMT+02:00 Cecil Westerhof <cldwesterhof at gmail.com>: > Last year I gave a presentation at T-DOSE about SQLite. It was received > enthusiastic, so I am thinking about giving a set of workshops about SQLite > this year. What are good subjects to treat? And what are the pitfalls to > expect? > I am thinking to do it on several levels. At least people that have never > worked with databases, but would benefit from using something better as > just files. And people that have experience with databases, but would like > to switch to SQLite for certain cases. > > -- > Cecil Westerhof > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >