Introduction to the course

Exam areas 1+2: Terminology and modelling (ER)

Intro to databases
Terminology of the relational model (logical)
Anatomy of a relational database (physical)

SQLQUE, p. 3-17, 43-44, 47-49 (Relations & ER diagrams)
DATABASE, p. 33-63 + 69-74 (Database environment & The Relational Model)

DATABASE, p. 89-110 (Relational Algebra and Relational Calculus)

Slides intro-DB+ER-diagram

Good for Group-work
MSSQL: How to start with a database in AZURE
MSSQL-Management Studio

Good for stand-alone
MySQL: How to Start with MySQL
MySQL: Workbench

Modelling with ER-diagrams

Presentation of the modelling ERdiagram of 'Peters Pan'

Exam area 3: Normalization
Normalization (NB! Only NF 1-3)

Exam area 5: SQL, part 1
Intro SQL (DDL)
CREATE, ALTER, DROP (DDL)
Intro to Create tables + Query window in Management Studio / workbench
Date functions in SQL
Intro to mandatory, individual SQL assignment part 1: select (minus join & subqueries), insert, update, delete, view

DBDESIGN, p. 73-103 (Normalisation)
DATABASE, 176-186 (views)

https://www.codecademy.com/learn/learn-sql (unit 1-3: simple select)
http://sqlzoo.net/wiki/Main_Page (tutorial 0-3 + 5: simple select)
http://www.w3schools.com/sql/default.asp
(create table, constraints, primary,foreign key, check, index, auto incretement, dates)

Reference data types :
https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql

https://dev.mysql.com/doc/refman/5.7/en/data-types.html

DATABASE, p.387-415 (Normalisation)
DATABASE, p.157-197 (DDL)

Slides Normalisation     DDL

VISIT part 1: Tableau come to speak of their approach to Data - Introduction
Friday between 9-12 (in the cantina area)

Exam area 6: SQL, DML part 1
Date functions in SQL
individual SQL assignment part 1: select (minus join & subqueries), insert, update, delete, view

SQL reference : https://www.w3schools.com/sql/ (From SQL-HOME to SQL-ALIASES)
https://www.codecademy.com/learn/learn-sql (unit 1-3: simple select)
http://sqlzoo.net/wiki/Main_Page (tutorial 0-3 + 5: simple select)

For the visitor:
A tool to visualise Data - Tableau : https://www.tableau.com

DATABASE, p.112-156 (DML)
Slides : Select   |    Select-where    |   Select-group

VISIT part 2: Tableau come to speak of their approach to Data - workshop
Friday between 9-12 (in the cantina area)

Exam area 7+8: SQL, part 2 (join & subqueries)
SQL joins + subqueries

https://www.codecademy.com/learn/learn-sql (unit 4: join)
http://sqlzoo.net/wiki/Main_Page (tutorial 4+6+8: join & subqueries)
http://www.w3schools.com/sql/default.asp

Slides: Joins    |     Sub-querries

Setup Tableau

SQL-queries-part2      |        A solution

Catch up Reletaional (SQL) Databases

SQL: DDL, DML

Exercise and Presentation of work with Tableau

Internship information and presentation by Vibeke Sandau from 10 AM to 11AM

XML: Slides

Sign up at Udemy.com
Exam area 11: Big data & Hadoop
Introduction to Big data & Hadoop


Hadoop Distributed File System (HDFS)
MapReduce

Get cluster access

BIG, page 12m-16b + 21-28b
https://www.udemy.com/hadoopstarterkit/ Section 1+2, lesson 1-3

https://www.udemy.com/hadoopstarterkit/ Section 3, lesson 4+6

https://www.udemy.com/hadoopstarterkit/ Section 4, lesson 7+8

https://www.udemy.com/hadoopstarterkit/ Section 3, lesson 5

Bigdata + Hadoop: Slides

Homework: watch video about Big data & Hadoop
https://www.youtube.com/watch?v=6UtD53BzDNk

Access to Udemy - see last three Slides

Putty program download:
http://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html

Big Data - posponed

Back to SQL Databases

Exam areas 9: triggers

SERVER chap 15, p. 537-559

Triggers:
http://www.sqlteam.com/article/an-introduction-to-triggers-part-i
http://www.sqlteam.com/article/an-introduction-to-triggers-part-ii

Reference Triggers :
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql
examples: https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/

https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
examples: https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/

Trigger

A solution MS SQL as well as My SQL

Exam areas 10: Stored procedures, transactions
Stored procedures, transactions

SERVER chap 12, p. 435-472
DATABASE, p. 573-580

Reference Stored procedure:

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql
examples: https://www.mssqltips.com/sqlservertutorial/2911/working-with-triggers/

https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
examples: http://www.mysqltutorial.org/introduction-to-sql-stored-procedures.aspx

Stored procedures

A soæution MS SQL as well as My SQL

Easter

Easter

Sign up at Udemy.com
Exam area 12: Big data & Hadoop
Introduction to Big data & Hadoop


Hadoop Distributed File System (HDFS)
MapReduce

Get cluster access

BIG, page 12m-16b + 21-28b
https://www.udemy.com/hadoopstarterkit/ Section 1+2, lesson 1-3

https://www.udemy.com/hadoopstarterkit/ Section 3, lesson 4+6

https://www.udemy.com/hadoopstarterkit/ Section 4, lesson 7+8

https://www.udemy.com/hadoopstarterkit/ Section 3, lesson 5

Homework: watch video about Big data & Hadoop
https://www.youtube.com/watch?v=6UtD53BzDNk

Access to Udemy - see last three Slides

Putty program download:
http://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html

Hadoop exercise (big Data, HDFS, MapReduce)

Exam area 13: Hive
Using Hive for solving Big data problems

Exam area 14: Pig
Using Pig for solving Big data problems

BIG, page 32-33b
https://www.udemy.com/hadoopstarterkit/ Section 6

Homework: watch video about Hive
https://www.youtube.com/watch?v=Pn7Sp2-hUXE

BIG, page 37t-37b
https://www.udemy.com/hadoopstarterkit/ Section 5

Hadoop exercise (Hive and Pig)

No Classes

No Classes

No Classes

DATABASE, p.176-187

DATABASE, p.189-194

MsSQL reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-2017
Refrence2: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-2017

MySQL reference: https://dev.mysql.com/doc/refman/8.0/en/create-user.html

Views

Users+Grant

Exam rehearsal - see curriculum
Trail Exam
Note : prepare for the exam