Databases 1 (6 cr)

Evaluation scale

0-5

Objective

Almost all information systems need databases to process information content. For example, social media services store every messages and comments in databases. This course will introduce you to commonly used relational and NoSQL database technologies. You will learn how to design and create database and how to process the data stored.

Course competences
Systems and methods in ICT
Web development competence
Learning and information management competence

After completing the course, you understand the concepts and theories related to databases. You know the different application domains of relational and NoSQL databases. You are able to make data modeling and can create a database based on a data model. You know how to use SQL language to work with relational databases. You are familiar with NoSQL databases and know the basic commands for the document database in question.

Content

- Concepts and background theories related to databases
- Database technologies
- Database design and data modeling
- Relational database: MySQL
- SQL language
- NoSQL: MongoDB

Materials

Material written by the teacher can be found at Moodle.

Teaching methods

- Contact lessons
- Exercises
- Tests
- Final exams

The primary mode of delivery is a combination of in-class activities on campus and on-line lectures.

Exam schedules

The final exams are held during the course. Renewal opportunities will be announced at the end of the course.

Completion alternatives

You have the right to apply for recognition of your studies if you have prior learning (e.g. university studies completed elsewhere) that can be accredited towards the degree you are currently completing.

The recognition of prior learning is possible in three primary ways: accreditation (replacement or inclusion), recognition of informal learning and studification. More precise info: JAMK Degree Regulations, section 17.

Student workload

Approximately 162 hours.

Assessment criteria, satisfactory (1)

Sufficient 1: You know the application domains and basic functions of some database technologies. You know the basics of data modelling. You are able to create a database and perform simple data processing operations.

Satisfactory 2: You know the application domains and basic functions of database technologies. You know the basics of data modelling. You are able to create both relational and NoSQL databases and perform some data processing.

Assessment criteria, good (3)

Good 3: You are familiar with the application domains and basic functionalities of different database technologies. You can create a data model that is suitable for your needs and create a database based on that model. You know the database processing languages at a level sufficient for typical daily work.

Very good 4: You know the application domains and functionalities of different database technologies. You can create a data model that is suitable for your needs and create a database based on that model. You master the database processing languages and are able to apply that knowledge to produce complex queries.

Assessment criteria, excellent (5)

Excellent 5: You are know and understand the application domains and functionalities of different database technologies. You are able to analytically assess the suitability of each technology for the application domain in question. You can create a data model of the application domain and create a database based on that model. You master the database processing languages and are able to apply that knowledge to produce complex queries. You can independently expand and apply your knowledge and skills.

Qualifications

-

Further information

Avoin 5
EduFutura 5