Databases

Introduction

The course provides a hands-on introduction to using SQL databases and covers the basics of database modelling and design. Throughout the course we use dynamic webpages as an example application, which allows us to work with data extraction from databases and data input from webpages, as well as to present data from databases through online pages showing key numbers and graphs. A blended learning-by-doing approach is taken throughout the course. The course aims at being a general introduction to applied work with databases, illustrated through a simple application field. This means that, for example, webpage design is kept to an extreme minimum, and the technical focus is instead on themes that are of general value in the industry.

Course content

• Introduction to relational databases.
• SQL for defining, manipulating, and querying a database. 
• Basics of database modelling and design: ER diagrams and normalization. 
• Accessing and analysing data from a database with Python. 
• Introduction to web programming.
• The basics of dynamic webpages, implemented using Python and SQL.
• Frameworks for database-driven web applications.
• Using web applications to collect, store, analyse, and visualise data from web forms.