Opinto-opas

Osaamistavoitteet

Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types

Toteutustapa ja opetusmenetelmät

Lectures and excercises. The course is graded based on an assignment.

Ajoitus ja läsnäolo

Weekly lectures, attendance recommended.

Oppimateriaali ja suositeltava kirjallisuus

The materials on Moodle and WWW, also any introductory book on SQL recommended. The Moodle page also includes optional exercises regarding SQL.

Toteutuksen valinnaiset suoritustavat

Negotiable.

Uusintamahdollisuudet

Negotiable.

Oppimisympäristö

Moodle and group work. The assignment requires the use of XAMPP or similar environment.

Opiskelijan ajankäyttö ja kuormitus

5 credit course.

Sisältö

Learning outcomes of the course
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types

Lisätietoja opiskelijalle: mm. edeltävä osaaminen

Basic understanding of programming

Arviointimenetelmät

Based on course assignment

Arviointiasteikko

1-5

Hylätty (0)

Unable to form basic queries or understand how queries are used in software

Arviointikriteerit: taso 1: (arviointiasteikko 1-5)

Has rudimentary understanding of queries.

Arviointikriteerit: taso 3 (arviointiasteikko 1-5)

Can design databases in a normalized manner

Arviointikriteerit: taso 5 (arviointiasteikko 1-5)

Can form complex queries.