DatabasesLaajuus (5 cr)
Code: 5051271
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
Enrollment
05.10.2023 - 21.01.2024
Timing
08.01.2024 - 30.04.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
0 - 80
Degree programmes
- Degree Programme in Business Information Technology
Teachers
- Kimmo Tarkkanen
- Sami Pyöttiälä
Groups
-
PTIETS23APTIETS23A
-
PTIETS23BPTIETS23B
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
Internet material about SQL and noSQL
Teaching methods
The course consists of 1) exercises (db queries and design tasks) 2) practical work tasks and 3) exam. 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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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, self- and peer-assessments.
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.
Remote self-studying in online mode is possible (with slightly different emphasis in topics and grading, announced in the beginning of the course).
Student workload
Recommended 8 hours / week for lectures, solving exercises and practical work tasks, if you are new to relational databases.
Participating weekly in teaching sessions: a' 3 hours * 14 =42h
Individual work:
for exercises 50h
Practical work 30h
Exam 10h
Content scheduling
In this course, students learn to use and design relational databases as well as understand differences to document databases.
Weekly meetings.Topics (and hours used in teaching sessions):
- Relational DBMS and DB use 4h
- Basics of SQL 13h
- Relational database design 7h
- Introduction to document database MongoDB 4h
Further information
We will use a DBMS environment for practical training (MySQL), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
Evaluation scale
H-5
Assessment methods and criteria
The course is graded from 0-5. The grade is based on collected points.
Each exercise is 1 point unless mentioned otherwise. The exam must be passed.
Exercises: 65 points,
Practical work: 55 points
Exam 70 points;
Total 190 points
Grading by points:
Points Grade
0-89 NOT PASSED
90-107 1
108-124 2
125-144 3
145-159 4
160-190 5
Enrollment
02.12.2023 - 14.01.2024
Timing
01.01.2024 - 30.04.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
- English
Seats
20 - 50
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
-
PTIVIS22PGame and Interactive Technologies
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
Internet material about SQL and noSQL
Teaching methods
The course consists of 1) exercises (db queries and design tasks) 2) practical work tasks and 3) exam. 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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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, self- and peer-assessments.
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.
Remote self-studying in online mode is possible (with slightly different emphasis in topics and grading, announced in the beginning of the course).
Student workload
Recommended 8 hours / week for lectures, solving exercises and practical work tasks, if you are new to relational databases.
Participating weekly in teaching sessions: a' 3 hours * 14 =42h
Individual work:
for exercises 50h
Practical work 30h
Exam 10h
Content scheduling
In this course, students learn to use and design relational databases as well as understand differences to document databases.
Weekly meetings.Topics (and hours used in teaching sessions):
- Relational DBMS and DB use 4h
- Basics of SQL 13h
- Relational database design 7h
- Introduction to document database MongoDB 4h
Further information
We will use a DBMS environment for practical training (MySQL), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
Evaluation scale
H-5
Assessment methods and criteria
The course is graded from 0-5. The grade is based on collected points.
Each exercise is 1 point unless mentioned otherwise. The exam must be passed.
Exercises: 65 points,
Practical work: 55 points
Exam 70 points;
Total 190 points
Grading by points:
Points Grade
0-89 NOT PASSED
90-107 1
108-124 2
125-144 3
145-159 4
160-190 5
Enrollment
30.11.2022 - 19.01.2023
Timing
09.01.2023 - 28.04.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
50 - 80
Teachers
- Kimmo Tarkkanen
- Sami Pyöttiälä
Groups
-
PTIETS22R1PTIETS22, R1
-
PTIETS22R2PTIETS22, R2
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
Internet material about SQL
Supporting book about nosql:
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 1) exercises (db queries and design tasks) 2) practical work tasks and 3) exam. 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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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, self- and peer-assessments.
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
Recommended 8 hours / week for lectures, solving exercises and practical work tasks, if you are new to relational databases.
Participating weekly in teaching sessions: a' 2 hours * 13 = 28h
Individual work:
for exercises 60h
Practical work 40h
Exam 10h
Content scheduling
In this course, students learn to use and design relational databases as well as understand differences to document databases.
Weekly meetings.Topics (and hours used in teaching sessions):
- Relational DBMS and DB use 4h
- Basics of SQL 13h
- Relational database design 7h
- Introduction to document database MongoDB 4h
Further information
We will use a DBMS environment for practical training (MySQL), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
Evaluation scale
H-5
Assessment methods and criteria
The course is graded from 0-5. The grade is based on collected points.
Each exercise is 1 point unless mentioned otherwise. The exam must be passed.
Exercises: 65 points,
Practical work: 55 points
Exam 70 points;
Total 190 points
Grading by points:
Points Grade
0-89 NOT PASSED
90-107 1
108-124 2
125-144 3
145-159 4
160-190 5
Enrollment
02.12.2022 - 23.01.2023
Timing
09.01.2023 - 30.04.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
- 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
-
PTIVIS21PGame and Interactive Technologies
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
Internet material about SQL
Supporting book about nosql:
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 1) exercises (db queries and design tasks) 2) practical work tasks and 3) exam. 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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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, self- and peer-assessments.
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
Recommended 8 hours / week for lectures, solving exercises and practical work tasks, if you are new to relational databases.
Participating weekly in teaching sessions: a' 2 hours * 13 = 28h
Individual work:
for exercises 60h
Practical work 40h
Exam 10h
Content scheduling
In this course, students learn to use and design relational databases as well as understand differences to document databases.
Weekly meetings.Topics (and hours used in teaching sessions):
- Relational DBMS and DB use 4h
- Basics of SQL 13h
- Relational database design 7h
- Introduction to document database MongoDB 4h
Further information
We will use a DBMS environment for practical training (MySQL), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
Evaluation scale
H-5
Assessment methods and criteria
The course is graded from 0-5. The grade is based on collected points.
Each exercise is 1 point unless mentioned otherwise. The exam must be passed.
Exercises: 65 points,
Practical work: 55 points
Exam 70 points;
Total 190 points
Grading by points:
Points Grade
0-89 NOT PASSED
90-107 1
108-124 2
125-144 3
145-159 4
160-190 5
Enrollment
11.12.2021 - 17.01.2022
Timing
10.01.2022 - 30.04.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- Finnish
Seats
0 - 100
Teachers
- Kimmo Tarkkanen
- Balsam Abdulghani
Groups
-
PTIETS21R2
-
PTIETS21R1
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
Internet material about SQL
Supporting book about nosql:
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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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 80h
Exam 20h OR practical work 20h
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 DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
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 acceptable exercise answer gives one point.
Detailed grading plan will become available on the starting date
Session exercises XX points in total
Home exercises XX p
Practical work / Exam XX p
Total XXX points
Grading by points:
0-49% of maximum = FAIL
50-59% = grade 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5
Enrollment
02.12.2021 - 16.01.2022
Timing
01.01.2022 - 30.04.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Teaching languages
- Finnish
Seats
0 - 60
Degree programmes
- Degree Programme in Information and Communication Technology
- Degree Programme in Information and Communications Technology
Teachers
- Kimmo Tarkkanen
Teacher in charge
Kimmo Tarkkanen
Groups
-
PTIVIS20PGame and Interactive Technologies
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
Internet material about SQL
Supporting book about nosql:
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.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium 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 80h
Exam 20h OR practical work 20h
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 DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer.
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB cloud for practicing document databases.
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 acceptable exercise answer gives one point.
Detailed grading plan will become available on the starting date
Session exercises XX points in total
Home exercises XX p
Practical work / Exam XX p
Total XXX points
Grading by points:
0-49% of maximum = FAIL
50-59% = grade 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5