STUDY

Database Academy

Learn databases – the skills behind Microsoft Access, LibreOffice Base and SQL. Sixteen lessons: tables, fields and data types, creating tables, primary keys, relationships and foreign keys, queries with criteria, sorting and wildcards, calculated fields, totals and grouping, joins, insert/update/delete, forms, reports, import/export, backups and looking after people’s data. Then practise on a real SQLite database of a small shop, running in your browser as WebAssembly: a datasheet and design view, a query builder that shows its SQL, an SQL window, a data-entry form, a printable grouped report and a relationships diagram, with eleven tasks checked against the database.

Ready to try · Learn databases – the skills behind Microsoft Access, LibreOffice Base and SQL. Sixteen lessons: tables, fields and data types, creating tables, primary keys, relationships and foreign keys, queries with criteria, sorting and wildcards, calculated fields, totals and grouping, joins, insert/update/delete, forms, reports, import/export, backups and looking after people’s data. Then practise on a real SQLite database of a small shop, running in your browser as WebAssembly: a datasheet and design view, a query builder that shows its SQL, an SQL window, a data-entry form, a printable grouped report and a relationships diagram, with eleven tasks checked against the database.