Skip to main content

DatabasesLaajuus (5 cr)

Code: TT00BM52

Credits

5 op

Objective

After completing the course the student can:
- 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

Qualifications

Computer Skills

Enrollment

02.07.2024 - 06.09.2024

Timing

02.09.2024 - 18.12.2024

Number of ECTS credits allocated

5 op

Virtual portion

1 op

Mode of delivery

80 % Contact teaching, 20 % Distance learning

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • Finnish
  • English
Seats

20 - 100

Degree programmes
  • Degree Programme in Information and Communication Technology
  • Degree Programme in Information and Communications Technology
Teachers
  • Kimmo Tarkkanen
  • Sami Pyöttiälä
Groups
  • PTIVIS23O
    Software Engineering and Project Management

Objective

After completing the course the student can:
- 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

Lecture slides and examples by the teacher
Lot of internet material available
Supporting books about relational databases and SQL are available in Internet.
MongoDB has good tutorials and documentation as well.

Teaching methods

The course consists of
1) lecture and home exercises (small queries and design tasks)
2) personal practical work (creating your own database) and
3) exam (testing your acquired skills).

Lecture exercises are divided into weekly topics. Each week introduces a new topic that builds on top of previous weeks. Each lecture begins with an introduction to the topic of the week, which includes practical examples and learning material. Exercises are done individually or in small groups with the help of the teacher .

NOTE! Lecture exercises can be returned only by participating in the lecture session!

Exam schedules

The exam is performed in ViLLE system www.ville.utu.fi which supports SQLite.
1st exam is organized in the class room (during the regular meeting time: the last lecture time) where Internet use is allowed for information retrieval.
Re-exams, i.e. 2nd and 3rd exams, are e-exams in the e-exam room premises (EduCity, Library) where Internet use is not allowed. E-exams are open 6 months after the course has ended.

International connections

- Learning by doing and trial&error with lecture exercises,
- Introductory lectures and examples provided by the teacher.
- Collaborating with other students in the lectures.

Completion alternatives

Participation in the lecture is not compulsory, but exercises can be returned only during the lecture.

Online course is available for those whose attendance in lectures is not possible. This self-study option has slightly different emphasis of topics and grading. These will be introduced in the beginning of the course in the first lecture. Students can choose their preferred method after the first lecture.

Student workload

Participating weekly in lectures (exercises): a' 3 hours * 13 = 40h
Home exercises 10h
Individual practical work 60h
Exam 3 hours + preparing 20h

Student workload is about 5-8 h / week if you are new to relational databases.

Content scheduling

In this course, students learn to use and design relational databases as well as understand differences to NoSQL/document databases. First, students familiarize 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. Second, students apply structured query language (SQL) to create a database (SQL DDL), and to manipulate and search data in the database (SQL DML). Last, students learn differences between SQL and NoSQL databases through desinging and using MongoDB document database. The course consists of lectures, exercises, a practical work and final exam.

Topics (and hours used in teaching sessions) in the order of appearance:
- Relational DBMS and DB use 6h
- Relational database design 9h
- Basics of SQL 18h
- Introduction to document database MongoDB 6h

Further information

All returns and communications take place through the It's Learning platform (except for the online course).

There are no pre-requisites for course performance in this course, and this course does not require previously acquired skills. It is necessary to have your own computer and know how to use it.
We use the relational database and its management environment for practical training (MySQL, MariaDB, SQLite or similar used in UwAmp, XAMPP or WAMP or similar) and must be installed on the student's personal computer. The necessary applications are installed in a lecture together.
In addition to relational databases, students learn about MongoDB cloud services, Mongo Shell, and practice designing and using a document-based database.

Evaluation scale

H-5

Assessment methods and criteria

The course is graded from 0-5. The grade is based on collected points during the course.
Each returned exercise is 1 point unless mentioned otherwise. The exam is compulsory part and must be passed with 40% of total points of the exam, in order to pass the course.

Division of points:
Lecture and home exercises 70 p points in total
Practical work 60 points
Exam 70 p points
Total 200 points

Course grading:
Points Grade
0-99 NOT PASSED
100-119 1
120-139 2
140-159 3
160-179 4
180-200 5

Assessment criteria, fail (0)

Less than 50% of total points collected or the exam is failed (less than 40% of total points of the exam). Check the points-to-grade table

Assessment criteria, satisfactory (1-2)

- Is able to implement relational database management software (DBMS) and know the tasks related to database maintenance
- Is able to design a relational database using conceptual model technique (ER or similar notation)
- Can implement a relational database with SQL statements
- Can retrieve, add and edit data in a relational database with simple SQL statements
- Knows different types of databases and their uses

Less than 70% of total points collected.

Assessment criteria, good (3-4)

In addition
- Can interpret the concept model and implement a relational database based on it
- Understands the meaning and use of keys and reference integrity in relational databases
- Is able to use SQL statements for data retrieval in various ways, such as combining data from different tables
- Understands the principle and purpose of normalization
- Can introduce non-relational databases and evaluate their suitability for different purposes (MongoDB)


70-90% of total points collected.

Assessment criteria, excellent (5)

In addition
- Is able to independently develop a high-quality concept model based on the user requirements
- Can use normalization to improve the quality of a relational database
- Can use SQL statements for information retrieval in various ways, such as sub-groupings and sub-queries
- Can do basic queries and design a simple NoSQL database (MongoDB)

More than 90% of total points collected.

Qualifications

Computer Skills

Enrollment

26.07.2023 - 14.09.2023

Timing

04.09.2023 - 15.12.2023

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • English
Seats

25 - 50

Degree programmes
  • Degree Programme in Information and Communications Technology
Teachers
  • Kimmo Tarkkanen
  • Sami Pyöttiälä
Groups
  • PTIVIS22O
    Software Engineering and Project Management

Objective

After completing the course the student can:
- 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

Lecture slides by the teacher
Lot of internet material available
Supporting books about relational databases and SQL are available in Internet.
MongoDB has good tutorials and documentation as well
Supporting book about NoSQL in general:
Connolly, Thomas M.; Begg, Carolyn E. - Database Systems: A Practical Approach to Design, Implementation and Management - 4. edition or later
Vaish, Gaurav: Getting Started with NoSQL. Packt Publishing Ltd 2013. Check Ebrary for online version

Teaching methods

The course consists of exercises (db queries and design tasks). Exercises are divided into weekly topics. These are practiced both individually and with the help of the teacher in the session. Each session begins with an introduction to the topic of the week, which includes practical examples with lecture slides.

Exam schedules

The exam is performed in Ville system www.ville.utu.fi.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval.
Re-exams, i.e. 2nd and 3rd exams, are e-exams in the e-exam room premises where Internet use is not allowed.
E-exams are open the rest of the year.

International connections

Learning by doing, trial-error, listening carefully the teacher, and collaborating with other students.

Completion alternatives

Participation in the teaching session is not compulsory, but highly recommended.
Each week we introduce a new topic that builds on top of previous weeks.

Student workload

Participating weekly in teaching sessions: a' 3 hours * 12 = 36h
Individual work for exercises 50h
Practical work 30h
Exam 20h

This course requires about 8 h / week

Content scheduling

In this course, students learn to use and design relational and document databases.
Weekly meetings, probably online and offline depending on the recommendations.
Topics (and hours used in teaching sessions):
- DBMS and DB use 2h
- Basics of SQL 12h
- Database design with ER 4h
- Database design with normalization 2h
- Introduction to document database MongoDB 4h

Further information

We will use a relational DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer or school network Z: drive (available in the class room computer).

The environment for using relational DBMS is some LAMP stack with graphical user interface like UwAmp or similar like XAMPP or WAMP.
In addition to relational databases, we will take a look at MongoDB Cloud and Mongo Shell and practice creating and using a document-based database.

Evaluation scale

H-5

Assessment methods and criteria

Course is evaluated with scale 0-5. Grading is based on collected points during the course. Each correct exercise answer gives one point.

Exercises 80 p points in total
Practical work 50 p
Exam 70 p max points
Total 200 points

Course grading:
0-49% of the maximum points = FAIL
50-59% = grade 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5

Detailed grading will become available during the course. However, to pass the course you need roughly half of the max points, and passing the exam is compulsory in the course.

Assessment criteria, satisfactory (1-2)

- Is able to implement relational database management software (DBMS) and know the tasks related to database maintenance
- Is able to design a relational database using conceptual model technique (ER or similar notation)
- Can implement a relational database with SQL statements
- Can retrieve, add and edit data in a relational database with simple SQL statements
- Knows different types of databases and their uses

Assessment criteria, good (3-4)

In addition
- Can interpret the concept model and implement a relational database based on it
- Understands the meaning and use of keys and reference integrity in relational databases
- Is able to use SQL statements for data retrieval in various ways, such as combining data from different tables
- Understands the principle and purpose of normalization
- Can introduce non-relational databases and evaluate their suitability for different purposes (MongoDB)

Assessment criteria, excellent (5)

In addition
- Is able to independently develop a high-quality concept model based on the user requirements
- Can use normalization to improve the quality of a relational database
- Can use SQL statements for information retrieval in various ways, such as sub-groupings and sub-queries
- Can do basic queries and design a simple NoSQL database (MongoDB)

Qualifications

Computer Skills

Enrollment

01.06.2022 - 11.09.2022

Timing

29.08.2022 - 22.12.2022

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • English
Seats

0 - 100

Degree programmes
  • Degree Programme in Information and Communication Technology
  • Degree Programme in Information and Communications Technology
Teachers
  • Kimmo Tarkkanen
  • Sami Pyöttiälä
Teacher in charge

Kimmo Tarkkanen

Groups
  • PTIVIS21O
    Software Engineering and Project Management

Objective

After completing the course the student can:
- 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

Lecture slides by the teacher
Lot of internet material available
Supporting books about relational databases and SQL are available in Internet.
MongoDB has good tutorials and documentation as well
Supporting book about NoSQL in general:
Connolly, Thomas M.; Begg, Carolyn E. - Database Systems: A Practical Approach to Design, Implementation and Management - 4. edition or later
Vaish, Gaurav: Getting Started with NoSQL. Packt Publishing Ltd 2013. Check Ebrary for online version

Teaching methods

The course consists of exercises (db queries and design tasks). Exercises are divided into weekly topics. These are practiced both individually and with the help of the teacher in the session. Each session begins with an introduction to the topic of the week, which includes practical examples with lecture slides.

Exam schedules

The exam is performed in Ville system www.ville.utu.fi.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval.
Re-exams, i.e. 2nd and 3rd exams, are e-exams in the e-exam room premises where Internet use is not allowed.
E-exams are open the rest of the year.

International connections

Learning by doing, trial-error, listening carefully the teacher, and collaborating with other students.

Completion alternatives

Participation in the teaching session is not compulsory, but highly recommended.
Each week we introduce a new topic that builds on top of previous weeks.

Student workload

Participating weekly in teaching sessions: a' 3 hours * 12 = 36h
Individual work for exercises 50h
Practical work 30h
Exam 20h

This course requires about 8 h / week

Content scheduling

In this course, students learn to use and design relational and document databases.
Weekly meetings, probably online and offline depending on the recommendations.
Topics (and hours used in teaching sessions):
- DBMS and DB use 2h
- Basics of SQL 12h
- Database design with ER 4h
- Database design with normalization 2h
- Introduction to document database MongoDB 4h

Further information

We will use a relational DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer or school network Z: drive (available in the class room computer).

The environment for using relational DBMS is some LAMP stack with graphical user interface like UwAmp or similar like XAMPP or WAMP.
In addition to relational databases, we will take a look at MongoDB Cloud and Mongo Shell and practice creating and using a document-based database.

Evaluation scale

H-5

Assessment methods and criteria

Course is evaluated with scale 0-5. Grading is based on collected points during the course. Each correct exercise answer gives one point.

Exercises 80 p points in total
Practical work 50 p
Exam 70 p max points
Total 200 points

Course grading:
0-49% of the maximum points = FAIL
50-59% = grade 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5

Detailed grading will become available during the course. However, to pass the course you need roughly half of the max points, and passing the exam is compulsory in the course.

Assessment criteria, satisfactory (1-2)

- Is able to implement relational database management software (DBMS) and know the tasks related to database maintenance
- Is able to design a relational database using conceptual model technique (ER or similar notation)
- Can implement a relational database with SQL statements
- Can retrieve, add and edit data in a relational database with simple SQL statements
- Knows different types of databases and their uses

Assessment criteria, good (3-4)

In addition
- Can interpret the concept model and implement a relational database based on it
- Understands the meaning and use of keys and reference integrity in relational databases
- Is able to use SQL statements for data retrieval in various ways, such as combining data from different tables
- Understands the principle and purpose of normalization
- Can introduce non-relational databases and evaluate their suitability for different purposes (MongoDB)

Assessment criteria, excellent (5)

In addition
- Is able to independently develop a high-quality concept model based on the user requirements
- Can use normalization to improve the quality of a relational database
- Can use SQL statements for information retrieval in various ways, such as sub-groupings and sub-queries
- Can do basic queries and design a simple NoSQL database (MongoDB)

Qualifications

Computer Skills

Enrollment

01.06.2022 - 11.09.2022

Timing

29.08.2022 - 22.12.2022

Number of ECTS credits allocated

5 op

Mode of delivery

Contact teaching

Unit

Engineering and Business

Campus

Kupittaa Campus

Teaching languages
  • English
Seats

0 - 100

Degree programmes
  • Degree Programme in Information and Communication Technology
  • Degree Programme in Information and Communications Technology
Teachers
  • Kimmo Tarkkanen
  • Sami Pyöttiälä
Teacher in charge

Kimmo Tarkkanen

Groups
  • PTIVIS20O
    Software engineering and Project Management

Objective

After completing the course the student can:
- 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

Lecture slides by the teacher
Lot of internet material available
Supporting books about relational databases and SQL are available in Internet.
MongoDB has good tutorials and documentation as well
Supporting book about NoSQL in general:
Connolly, Thomas M.; Begg, Carolyn E. - Database Systems: A Practical Approach to Design, Implementation and Management - 4. edition or later
Vaish, Gaurav: Getting Started with NoSQL. Packt Publishing Ltd 2013. Check Ebrary for online version

Teaching methods

The course consists of exercises (db queries and design tasks). Exercises are divided into weekly topics. These are practiced both individually and with the help of the teacher in the session. Each session begins with an introduction to the topic of the week, which includes practical examples with lecture slides.

Exam schedules

The exam is performed in Ville system www.ville.utu.fi.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval.
Re-exams, i.e. 2nd and 3rd exams, are e-exams in the e-exam room premises where Internet use is not allowed.
E-exams are open the rest of the year.

International connections

Learning by doing, trial-error, listening carefully the teacher, and collaborating with other students.

Completion alternatives

Participation in the teaching session is not compulsory, but highly recommended.
Each week we introduce a new topic that builds on top of previous weeks.

Student workload

Participating weekly in teaching sessions: a' 3 hours * 12 = 36h
Individual work for exercises 50h
Practical work 30h
Exam 20h

This course requires about 8 h / week

Content scheduling

In this course, students learn to use and design relational and document databases.
Weekly meetings, probably online and offline depending on the recommendations.
Topics (and hours used in teaching sessions):
- DBMS and DB use 2h
- Basics of SQL 12h
- Database design with ER 4h
- Database design with normalization 2h
- Introduction to document database MongoDB 4h

Further information

We will use a relational DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer or school network Z: drive (available in the class room computer).

The environment for using relational DBMS is some LAMP stack with graphical user interface like UwAmp or similar like XAMPP or WAMP.
In addition to relational databases, we will take a look at MongoDB Cloud and Mongo Shell and practice creating and using a document-based database.

Evaluation scale

H-5

Assessment methods and criteria

Course is evaluated with scale 0-5. Grading is based on collected points during the course. Each correct exercise answer gives one point.

Exercises 80 p points in total
Practical work 50 p
Exam 70 p max points
Total 200 points

Course grading:
0-49% of the maximum points = FAIL
50-59% = grade 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5

Detailed grading will become available during the course. However, to pass the course you need roughly half of the max points, and passing the exam is compulsory in the course.

Assessment criteria, satisfactory (1-2)

- Is able to implement relational database management software (DBMS) and know the tasks related to database maintenance
- Is able to design a relational database using conceptual model technique (ER or similar notation)
- Can implement a relational database with SQL statements
- Can retrieve, add and edit data in a relational database with simple SQL statements
- Knows different types of databases and their uses

Assessment criteria, good (3-4)

In addition
- Can interpret the concept model and implement a relational database based on it
- Understands the meaning and use of keys and reference integrity in relational databases
- Is able to use SQL statements for data retrieval in various ways, such as combining data from different tables
- Understands the principle and purpose of normalization
- Can introduce non-relational databases and evaluate their suitability for different purposes (MongoDB)

Assessment criteria, excellent (5)

In addition
- Is able to independently develop a high-quality concept model based on the user requirements
- Can use normalization to improve the quality of a relational database
- Can use SQL statements for information retrieval in various ways, such as sub-groupings and sub-queries
- Can do basic queries and design a simple NoSQL database (MongoDB)

Qualifications

Computer Skills