Course Time plan

IT

Basics about relational databases

Why database design

tables and entities

Facts and attributes

Normal forms – redundancy

relations
Design globally use locally

Introduction til SQL

Database creation

Table creation

Data types

index

Performance

SQL DDL

Temporary tables

Changing tables

Secondary index

Criteria for index

Constraints

Views

Other DDL

Database systems and tools

Commercial databases

Open Source databases

What is best?

MySql with Apache and PHP (Foxserv)

Tables

Insert into table

Select from table
Insert from other systems

SQL DML

Simple Select

Where

Joins

Set operators between tables

Delete

Simple Update

Analysis of a system

Analysis methods

Processes and data structures

User interface contra table design

ER-diagrammer

Exercises

create databases

create tables

Insert values

Postal code table

Extending the problem with entities and tables

Exercises

Extending the problem

Inserting values into lookup tables

Update

Simple join

Exerciser

Describe a relevant problem
ER-diagram

4. day

Repetition

5. day

Repetition

6. day

Repetition

Select – operators and functions

functions numerical data

String functions

Date, time functions

Group by, having and order by

Select – advanced

Join of multiple tables

Derived tables and views

Performance problems and tools

Derived or inherited tables

Sub select

Stored Procedures

Data warehouse

Dimension handling in databases.

Base tables and lookup tables

Data extraction and data cleaning. OT tables

Best practise for data warehouse.

Quality assurance in databases and data warehouse

Joins and Cartesian products

Joins with and

Left and right join

Null values i joins – coalesce
Case – simple and select

Exercises

Extending the problem

Multiple join

Sub select

Exercises

Redesign of database for a data warehouse

Design of dimension hierarchies

Exercises

Extending the problem

Left join

Cartesian products – useful

and problematic.

Use of case

End of course
course evaluation