DatabasesLaajuus (3 cr)
Code: KL25AB77000
Objective
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.
Content
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Qualifications
No previous studies are required.
Assessment criteria, satisfactory (1)
- Satisfactory (1-2) The student knows the basics
Assessment criteria, good (3)
- Good (3-4): The student is familiar with the principles of database design and basic of SQL language
Assessment criteria, excellent (5)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
Materials
Material:
Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison
Enrollment
22.04.2024 - 04.09.2024
Timing
26.08.2024 - 13.10.2024
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Engineering, Automation Engineering
Teachers
- Jarkko Loima
Student groups
-
AUTE23SADegree Programme in Automation Engineering, Full-time studies
Objective
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.
Content
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Materials
Material:
Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
- Satisfactory (1-2) The student knows the basics
Assessment criteria, good (3)
- Good (3-4): The student is familiar with the principles of database design and basic of SQL language
Assessment criteria, excellent (5)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
Qualifications
No previous studies are required.
Enrollment
17.04.2023 - 06.09.2023
Timing
28.08.2023 - 15.10.2023
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Engineering, Automation Engineering
Teachers
- Marko Hietamäki
Student groups
-
AUTE22SADegree Programme in Automation Engineering, Full-time studies
Objective
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.
Content
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Materials
Lecture materials,
Additional material: Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley
Teaching methods
Lectures and exercises
Student workload
scheduled studies 50% and autonomous studies 50%
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
- Satisfactory (1-2) The student knows the basics
Assessment criteria, good (3)
- Good (3-4): The student is familiar with the principles of database design and basic of SQL language
Assessment criteria, excellent (5)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
Assessment methods and criteria
Class exercises and an examination
Qualifications
No previous studies are required.
Enrollment
16.04.2022 - 07.09.2022
Timing
29.08.2022 - 16.10.2022
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Engineering, Automation Engineering
Teachers
- Marko Hietamäki
Student groups
-
AUTE21SA
Objective
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.
Content
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Materials
Lecture materials,
Additional material: Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo
Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley
Teaching methods
Lectures and exercises
Student workload
scheduled studies 50% and autonomous studies 50%
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
- Satisfactory (1-2) The student knows the basics
Assessment criteria, good (3)
- Good (3-4): The student is familiar with the principles of database design and basic of SQL language
Assessment criteria, excellent (5)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
Assessment methods and criteria
Class exercises and an examination
Qualifications
No previous studies are required.
Enrollment
07.02.2022 - 20.03.2022
Timing
07.03.2022 - 08.05.2022
Credits
3 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Engineering, Automation Engineering
Teachers
- Marko Hietamäki
Student groups
-
AUTE20SA
Objective
The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.
Content
The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
- Satisfactory (1-2) The student knows the basics
Assessment criteria, good (3)
- Good (3-4): The student is familiar with the principles of database design and basic of SQL language
Assessment criteria, excellent (5)
- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language
Qualifications
No previous studies are required.