Tietokannat ja tietokantapalvelimen ylläpito (5 op)

Tavoitteet

The objective of the course is to teach students both theoretical and practical aspects of SQL databases. The course begins with the introduction of SQL server, setting up SQL server, database modeling and designing, creating databases, managing and maintaining databases. Students will also learn to execute SQL queries.

The maintenance part of the course includes lectures and tasks in the database technology such as designing secure databases, practically implementing fault tolerance and recovery of databases, setting up automatic backups, database user management, import and export functions, developing and basic maintenance of SQL database server.

Sisältö

• Database modelling, normalisation
• SQL
• Implementing a database
• Import and export functions into and from the database
• Installing a SQL server
• SQL server architecture
• Management tools
• SQL server databases
• Faults and recovery
• Users and rights
• SQL server basic maintenance tasks

Arviointikriteerit, tyydyttävä (1)

Students will be able to work in complex situations, organize and instruct a group and work responsibly.

Arviointikriteerit, hyvä (3)

The students will be able to apply their professional competence doing different jobs, work independently and responsibly and as a group towards common goals.

Arviointikriteerit, kiitettävä (5)

The students will be able to demonstrate their familiarity with the knowledge base of the field, work on given tasks in an appropriate manner and participate in group activities using their own competences.

Esitietovaatimukset

Basic understanding of computer applications, operating systems (Windows/Linux) and databases.