Til startside / to start page

WEB Development: Database & XML 7. sem.

(based upon former courses by Anders Børjesson & Jørgen Schou)

Litterature:

Elmasri: Fundamentals of Database Systems, Elmasri & Navathe, 5th + 6th edition - selected chapters as copies in pdf

SQL Server: Beginning Microsoft SQL Server 2012 Programming, Atkinson & Vieira, ISBN 978-1-118-10228-2



Links:

Microsoft SQL Server reference: http://msdn.microsoft.com/en-us/library/618ayhy6.aspx

Database Engine Tutorials: http://technet.microsoft.com/en-us/library/32bd8af8-a832-4dc8-afff-01668e6b2b51

SQL reference: http://msdn.microsoft.com/en-us/library/bb510741.aspx

 

 

Teaching normally: Friday 9:10 - 13:50
Week / day Topic

Litterature

 

Remarks + bigger exercises + solutions
36 / Friday 6/9

Introduction to the course

Data modeling using E/R diagramming

 



Curriculum for the course

Elmasri chapt. 3, page 57-91

Slides - E/R diagramming

Make an E/R diagram of the data behind Amazon http://www.amazon.co.uk
- focus on books only
- use a tool such as Dia (http://dia-installer.de/), Visio or a similar

Homework for week 38 / Friday 20/9:
Setup Microsoft SQL Server 2012

37 / Friday 13/9

The relational model

ER to relational mapping

 



Elmasri chapt. 5, page 141-162

Slides - The relational model

Elmasri chapt. 7, page 217-230

Slides - E/R to relational mapping

Follow up on ER for Amazon

My E/R solution for Amazon

38 / Friday 20/9

Normalization

Overview SQL Server Management Studio

SQL Data definition language (DDL): create, alter, drop



SQL Server chapt. 8

Slides - Normalization

SQL Server chapt. 2

SQL Server chapt. 5 + page 175-206top

Slides - SQL Server Management Studio & SQL DDL

Follow up on relational model for Amazon
39 / Friday 27/9

NB!!! No teaching due to course for the teachers 26/9+27/9



 

NB!!! No teaching due to course for the teachers 26/9+27/9

 

40 / Mon 30/9

NB! No teaching due to illness



 

 

40 / Fri 4/10

SQL Data manipulation language (DML): Simple select, insert, update, delete

SQL Server chapt. 3

Adwentureworks database

Create & populate Amazon

SQL examples from book

Slides - SQL DML

 

 

 
41 / Fri 11/10

SQL advanced select: joins

Views

SQL advanced select: sub-queries

 



SQL Server chapt. 4

SQL Server page 353-370

Slides - joins & views

INNER JOIN 1

INNER JOIN 2

OUTER JOIN 1

OUTER JOIN 2

SQL Server page 213-239middle + 252top-254

 

 
42 / Mon 14/10 including Fri 18/10

 Autumn vacation



No teaching No teaching due to autumn vacation
43 / Fri 25/10

SQL advanced SELECT: subqueries

Writing scripts and batches

 

 



SQL Server page 213-239mid + 252top-254

SQL Server chapt. 11

Slides - subqueries and scripts & batches

 

 

 
44 / Fri 1/11

Stored procedures

Triggers

Transactions



SQL Server page 435-472top

SQL Server chapt. 15

Elmasri chapt. 20, page 721-750

Slides - stored procedures and transactions & triggers

 
45 / Fri 8/11

XML

 

Object-oriented DBMS

 

Programming in the database vs. programming in a server based programming language

 



SQL Server chapt. 16

Slides - XML

Elmasri chapt. 10, page 341-394 ---> Slides - object oriented databases

 

When to use stored procedures

Slides in pdf format

Crossdisciplinary project will be handed out on Wednesday 6/11

46 / Fri 15/11

NB! until 14:45

Work on crossdisciplinary project



   

47 / Fri 22/11

NB! until 14:45

Work on crossdisciplinary project

  Hand-in of crossdisciplinary project by Friday 22/11 4pm in 3 copies
48 / Fri 29/11

Distributed DBMS

Feedback on solution for crossdisciplinary project for each group

Preparation for presentation

Elmasri chapt. 26, page 971-996top + 1001middle-1009bottom

Slides - distributed DBMS

 

49 / Wed 4/12

Mutual presentation of crossdisciplinary project in room 112 from 9:10



 


 
50 / Fri 13/12 NB! Presentation of exam questions + overview of knowledge & holes



Exam areas & prototype question

How to prepare for the exam

 
51 / Mon 16/12

Re-cap and/or talk about exam



 

 

 

52 / Mon 23/12

X-mas holiday



   
2 / Mon 6/1 2014 Oral exam    
5 / Re-exam    



Opdateret / updated: 11/12-2013