Hogeschool Gent
Geraard de Duivelstraat 5 - 9000 Gent
Tel: 09 243 33 33 - E-mail: info@hogent.be
Website: www.hogent.be
Databases III28563/3857/1617/1/14
Study guide

Databases III

28563/3857/1617/1/14
Academic year 2016-17
Is found in:
  • International Curriculum, programme stage 3
This is a single course unit.
Study load: 3 credits
Weight: 3,00
Total study time: 75,00 hours
Possible deadlines for learning account: 01.12.2016 ()

Organisation of education

Teaching Activities, Learning Activities, Assessment Activities
Lecture12,00 hours
Self-study39,00 hours
Seminar24,00 hours
Supervised independent work
This course unit is marked out of 20 (rounded to an integer).
Re-sit exam: is possible.
It is not possible to enrol in this course unit under
  • exam contract (to obtain a credit).
  • exam contract (to obtain a degree).
Special admission is required to enrol in this course unit under credit contract.
Co-ordinator: De Vreese Sabine
Language course: No
Languages: Dutch
Scheduled for: Semester 1

Objectives

To be able to execute basic Oracle database administration tasks
To understand the use of a NoSQL database
To understand the basics of Big Data

Contents

Oracle database architecture
Oracle database management
NoSQL
Big Data- introduction to HADOOP

Order of enrolment

There are no prerequisites for this course.

Prerequisites

Databases II

Final objectives

Partial competence 1: Is able to use database structured datamanipulation language (TI01)
Indicators:

1.1 Is familiar with the basics of Oracle PL/SQL
1.2 Is familiar witht the software developing techniques in Oracle PL/SQL

1.3 Is able to develop a program in Oracle PL/SQL

1.4 Is able to develop effciënt programs in PL/SQL
1.5 Is able to evaluate the performance of DBprograms

Partial competence 2: Is able to perform Oracle database administration tasks (TI06)
Indicators:

2.1 Understands the internal physical structures and processes of an Oracle database
2.2 Is able to manage DB objects

Partial competence 3: Knowledge of  techniques to manage non-relational databases (TI05)
Indicators:

3.1 Knowledge of the different NoSQL Database families

3.2 Knowledge of a NoSQL Database

Partial competence 4: Knowledge of  techniques for working with big data. (TI05)
Indicators:

4.1 Knowledge of HADOOP

4.2 Knowledge of  the basics of HDFS

4.3 Knowledge of Map Reduce

4.4 Knowledge of open source projects like Hive, Mahout, ...

Organisation of education

Teaching conversation

Coached and mandatory individual exercises on own laptop.

Study guidance

Individual learning problems can always be discussed with the lecturer.

Evaluation

First exam session:
  non-period bound evaluation: 30% (written test)
        period bound evaluation: 70% (partially written, partially on PC)


Second exam session:

100% (partially written, partially on PC)

Study costs

Printing costs

Key words

Key words + IWETO-code: Databases, Database management, Oracle, NoSQL, DBMS
IWETO-code: p175 – Computer technology