Design and Use of Relational Databases - TESTI (5 op)

Arviointiasteikko

H-5

Sisällön jaksotus

Students familiarize themselves with database thinking and the principles of data management from a quality perspective. Key topics include data modeling using ER diagrams, relational schema representations and normalization technique for validating the quality of the database design. In the database use part of the course, students apply structured query language (SQL) to create a database (SQL DDL), and to manipulate and search data in the database (SQL DML). The course consists of self-study materials, exercises, midterm tests, a practical work and final exam.

Learning rounds are the following:
- Introduction
- ER model 1
- ER model 2
- Relational model
- Normalization
- SQL 1: basic queries
- SQL DDL & DML: creating database and inserting data
- SQL 2: more complex queries

The study schedule is personal. Please note, however, that the course and registration to the Ville study platform will close at a certain time.

Tavoitteet

Opintojakso vastaa sisällöltään ja tavoitteiltaan opintojaksoa TT00BM52 Databases.

Opintojakson osaamistavoitteiden kuvaus englanniksi: After completing the course, the student understands the basics of database systems, and especially the operating principles of relational databases. The student learns how to design and model a database with ER technique, transform it to relational schema and further implement it as a relational database. After the course, the student knows how to use at least one well-known database management system (SQLite, MySQL or similar), can plan and create relational databases as well as apply SQL for most common query and update operations to the database..

Sisältö

Opintojakso vastaa sisällöltään ja tavoitteiltaan opintojaksoa TT00BM52 Databases.

Opintojakson sisällön kuvaus englanniksi: In the database design part of the course, students familiarize themselves with database thinking and the principles of data management from a quality perspective. Key topics include data modeling using ER diagrams, relational schema representations and normalization technique for validating the quality of the design. In the database use part of the course, students apply structured query language (SQL) to create a database (SQL DDL), and to manipulate and search data in the database (SQL DML). The course consists of self-study materials and practical exercises with a final test.

Oppimateriaalit

Published in Ville-system

Opetusmenetelmät

Remote self-study.
Lecture videos & slides, exercises, text material and tests in Ville online system

Tenttien ajankohdat ja uusintamahdollisuudet

Final exam will be available in Ville system.

Kansainvälisyys

Students collect points from exercises and tests in Ville.

Toteutuksen valinnaiset suoritustavat

No

Opiskelijan ajankäyttö ja kuormitus

Estimated working hours usage:
20 h Reading materials
40 h Exercises
30 h Practical work
30 h Tests and exams

Esitietovaatimukset

The course is suitable for beginners and no previous studies are necessary.

Lisätiedot

Ville-system