Basics of DatabasesLaajuus (4 cr)
Code: LT00DB37
Objective
The student knows the basic concepts related to databases, the basics of data management, the relational model, and the data design process in accordance with the steps of data analysis. The student knows the basics of the query language.
Content
- the basics of the relational model
- relational database
- conceptual modeling
- ER diagram
- key commands in the query language
- basics of NoSQL databases.
Qualifications
Information and Communication Technology
Assessment criteria, satisfactory (1)
The student knows how to design a database structure. The student knows the basics of the query language and is able to perform addition, deletion, update, and search operations on the database.
Assessment criteria, good (3)
The student is able to design and build a database. The student is able to use the survey language effectively.
Assessment criteria, excellent (5)
The student is able to design and build a database according to good practices. The student is able to use the query language effectively and in a versatile way. The student has a broad understanding of the aspects related to databases, for example in connection with information security and optimization.
Enrollment
22.04.2024 - 04.09.2024
Timing
02.09.2024 - 13.10.2024
Credits
4 op
Teaching languages
- Finnish
Degree programmes
- Bachelor of Business Administration, Business Management
Teachers
- Mikko Kulmala
Scheduling groups
- Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 10. Open UAS: 10.)
Student groups
-
LITA22D
Education groups
- Open UAS (Doesn't apply to degree student)
Objective
The student knows the basic concepts related to databases, the basics of data management, the relational model, and the data design process in accordance with the steps of data analysis. The student knows the basics of the query language.
Content
- the basics of the relational model
- relational database
- conceptual modeling
- ER diagram
- key commands in the query language
- basics of NoSQL databases.
Evaluation scale
1-5
Assessment criteria, satisfactory (1)
The student knows how to design a database structure. The student knows the basics of the query language and is able to perform addition, deletion, update, and search operations on the database.
Assessment criteria, good (3)
The student is able to design and build a database. The student is able to use the survey language effectively.
Assessment criteria, excellent (5)
The student is able to design and build a database according to good practices. The student is able to use the query language effectively and in a versatile way. The student has a broad understanding of the aspects related to databases, for example in connection with information security and optimization.
Qualifications
Information and Communication Technology