Design and Use of Relational DatabasesLaajuus (5 op)
Tunnus: TT00CP38
Laajuus
5 op
Osaamistavoitteet
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.
Ilmoittautumisaika
01.01.2023 - 31.01.2024
Ajoitus
23.10.2023 - 31.05.2024
Opintopistemäärä
5 op
Virtuaaliosuus
5 op
Toteutustapa
Etäopetus
Yksikkö
ICT
Opetuskielet
- Englanti
Paikat
0 - 200
Koulutus
- Ammattikorkeakoulun yhteiset vapaasti valittavat opinnot
- Degree Programme in Information and Communications Technology
Opettaja
- Kimmo Tarkkanen
- Tommi Tuomola
Ajoitusryhmät
- Avoimen AMK:n kiintiöpaikat (Koko: 500. Avoin AMK: 500.)
Pienryhmät
- Avoimen AMK:n kiintiöpaikat
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.
Pedagogiset toimintatavat ja kestävä kehitys
Students collect points from exercises and tests in Ville.
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
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.
Viestintäkanava ja lisätietoja
Ville-system
Discord channels
Arviointiasteikko
H-5
Arviointimenetelmät ja arvioinnin perusteet
The student requires min. 50% of points to pass the course. Tests, practical work and the final exam are compulsory.
The course is graded on scale 0-5:
Grading is based on total points collected:
50%-59% of points --> grade 1
60-69% --> 2
70-79% --> 3
80-89% --> 4
90-99% --> 5
The exact number of total points and points per type will be announced in Ville system.
Ilmoittautumisaika
01.01.2023
Ajoitus
15.05.2023 - 31.07.2023
Opintopistemäärä
5 op
Virtuaaliosuus
5 op
Toteutustapa
Etäopetus
Yksikkö
ICT
Opetuskielet
- Englanti
Paikat
0 - 200
Koulutus
- Avoin ammattikorkeakoulu
Opettaja
- Kimmo Tarkkanen
- Tommi Tuomola
Ajoitusryhmät
- Avoimen AMK:n kiintiöpaikat. (Koko: 500. Avoin AMK: 500.)
Pienryhmät
- Avoimen AMK:n kiintiöpaikat.
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, material and tests in Ville online system
Tenttien ajankohdat ja uusintamahdollisuudet
Final exam will be available in Ville system.
Pedagogiset toimintatavat ja kestävä kehitys
Students collect points from exercises and tests in Ville.
Opiskelijan ajankäyttö ja kuormitus
70 h Ville-tutorials about database design and SQL
15 h Videos and materials in Ville
40 h Exercises and tests.
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 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.
Viestintäkanava ja lisätietoja
Ville-system
Discord channels
Arviointiasteikko
H-5
Arviointimenetelmät ja arvioinnin perusteet
The student requires min. 50% of points and accepted final test to pass the course.
The course is graded on scale 0-5:
Grading is based on total points collected:
50%-59% of points --> grade 1
60-69% --> 2
70-79% --> 3
80-89% --> 4
90-99% --> 5
The number of total points available will be announced later.