This course covers database design and the use of databases in applications, with a focus on applications in the life sciences. Topics include the relational model, database design principles, the structured query language (SQL), including temporal and spatial queries. Data lifecycle topics and contemporary issues for data scientists and practitioners are also introduced, i.e. big data, FAIR principles, data governance, licensing, and privacy.
The course includes extensive practical work in the design, construction, and use of databases in the students’ field of study. Practical work involves MySQL and PowerBI. Students tend to value these hands-on database design and building skills as the most valuable part of the course.
