Advanced databases and data warehouses

Date
 Subject
 Deadline
 Score
1
 06/03/2014
 Procedural SQL: ORACLE pl/sql

2
 13/03/2014
 Advanced database objects
 pl/sql test
 10
3 20/03/2014
 SQL query optimization in practice
assignment 20
4
 27/03/2014
 Dimensional model in data warehouses I

5
 03/04/2014
 Dimensional model in data warehouses II assignment 20
6
 10/04/2014 Basic operations in data warehouses

7
 17/04/2014 Data warehouses: Analytical functions project - part I
8
 24/04/2014 Advanced SQL
 test 90
9
 28/04/2014 Dealing with internal/external data
 assignment 20
10
 08/05/2014 NoSQL databases I
 project - part II
 20
11
 15/05/2014 NoSQL databases II assignment 20
12
 22/05/2014
 Data analysis with Bayesian networks assignment 20
13
 29/06/2014 Bayesian networks: Causality discovery
 assignment 20
14
 05/06/2014 Documentation in MediaWiki

15
 12/06/2014
 Project presentation
60+10
total:
 310
scripts


Useful links:
Data Warehousing Information Center:  http://www.dwinfocenter.org/
GeNIe: http://genie.sis.pitt.edu/

ORACLE:
ORACLE Express Edition:http://www.oracle.com/technetwork/database/express-edition/overview/index.html

Dokumentacja ORACLE 11g Release 2:

http://www.oracle.com/pls/db112/homepage

ORACLE SQL Language Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm

ORACLE PL/SQL Language Reference:

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/toc.htm