Opinto-opas

Tavoitteet

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

Sisältö

- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases

Oppimateriaalit

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.

Opetusmenetelmät

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

Session exercises are divided into weekly topics. Each week introduces a new topic that builds on top of previous weeks. Each session begins with an introduction to the topic of the week, which includes practical examples with learning material. Exercises are practiced both individually and with the help of the teacher in the session. Exercises can be returned only by participating in the lecture session!

Tenttien ajankohdat ja uusintamahdollisuudet

The exam is performed in Ville system www.ville.utu.fi with SQLite.
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 6 months after the course has ended.

Pedagogiset toimintatavat ja kestävä kehitys

- Learning by doing and trial-error regarding the session exercises,
- Introduction lectures and examples provided by the teacher in the sessions.
- Collaborating with other students in the lectures.

Toteutuksen valinnaiset suoritustavat

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

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

Opiskelijan ajankäyttö ja kuormitus

Participating weekly in teaching sessions: a' 3 hours * 13 = 40h
Individual work for the practical work 50h
Exam 3 hours + preparing 20h

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

Sisällön jaksotus

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

Viestintäkanava ja lisätietoja

Exercise and practical work returns as well as communication takes place through It's Learning platform.

This course do not have prerequisite courses and do not require any previously acquired skills. Own computer is necessary.

We will use a relational DBMS environment for practical training (MySQL, MariaDB or SQLite) and it must be installed on student's personal computer.

The environment for using relational DBMS has a graphical user interface like in UwAmp, XAMPP or WAMP.

In addition to relational databases, we will take an introductory look at MongoDB Atlas cloud services and Mongo Shell, and practice designing and using a document-based database.

Arviointiasteikko

H-5

Arviointimenetelmät ja arvioinnin perusteet

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

Initial division of points:
Session exercises 70 p points in total
Practical work 60 points
Exam 70 p points (max.)
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 points to grade -table will become available in the beginning of the course.

Hylätty (0)

Less than 50% of total points collected and/or the exam is failed (less than 40% of total points)

Arviointikriteerit, tyydyttävä (1-2)

- Osaa ottaa käyttöön relaatiotietokannan hallintaohjelmiston (DBMS) ja tuntee tietokannan ylläpitämiseen liittyviä tehtäviä
- Osaa suunnitella relaatiotietokannan käsitemallia hyödyntäen (ER tai vastaava notaatio)
- Osaa toteuttaa relaatiotietokannan SQL lauseilla
- Osaa hakea, lisätä ja muokata relaatiotietokannassa olevaa tietoa yksinkertaisilla SQL lauseilla
- Tietää erilaisia tietokantatyyppejä ja niiden käyttötarkoituksia

Opiskelija on kerännyt alle 70% kokonaispisteistä.

Arviointikriteerit, hyvä (3-4)

Edellisten lisäksi
- Osaa tulkita käsitemallia ja toteuttaa relaatiotietokannan sen perusteella
- Ymmärtää avainten ja viite-eheyden merkityksen ja käytön relaatiotietokannoissa
- Osaa käyttää tiedonhakuun SQL lauseita monipuolisesti eri taulujen tietoja yhdistellen
- Ymmärtää normalisoinnin periaatteen ja tarkoituksen
- Osaa ottaa käyttöön myös muita kuin relaatiotietokantoja ja arvioida niiden sopivuutta eri tarkoituksiin (MongoDB)

Opiskelija on kerännyt 70-90% kokonaispisteistä.

Arviointikriteerit, kiitettävä (5)

Edellisten lisäksi
- Osaa itsenäisesti laatia laadukkaan käsitemallin vaatimuksiin perustuen
- Osaa käyttää normalisointia relaatiotietokannan laadun parantamiseen
- Osaa käyttää tiedonhakuun SQL lauseita monipuolisesti, kuten ryhmittelyjä ja ali- ja sisäkyselyjä
- Osaa tehdä peruskyselyjä ja suunnitella yksinkertaisen NoSQL-tietokannan (MongoDB)

Opiskelija on kerännyt yli 90% kokonaispisteistä

Esitietovaatimukset

Computer Skills