Databases (5 cr)
Code: 5051264-3005
General information
- Enrollment
-
01.06.2023 - 17.09.2023
Registration for the implementation has ended.
- Timing
-
04.09.2023 - 31.12.2023
Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Engineering and Business
- Campus
- Kupittaa Campus
- Teaching languages
- English
- Seats
- 20 - 60
- Degree programmes
- Degree Programme in Information and Communications Technology
- Degree Programme in Information and Communication Technology
Evaluation scale
H-5
Content scheduling
Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)
Objective
After completing the course the student is able to:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system
- describe database management tasks
Content
- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases
Materials
course material in itslearning
Teaching methods
learning by doing
International connections
Weekly topics are handled with
- lecture
- examples
- assessed network exercises
- db excercise
Completion alternatives
The complete course can be completed with an exam. The date will be agreed upon during the first lesson.
Student workload
lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h