Databases 1Laajuus (6 cr)

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

Qualifications

-

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.