Skema uge 32

Dato	Ugedag	Tid	Emne	lokale
3. August	Mandag	08:00 - 09:30	Velkomst	A19
3. August	Mandag	10:00 - 15:20	Netværksdesign II - Selvstudie	C01
3. August	Mandag	10:00 - 15:20	CCNP 2 - Selvstudie	C01
3. August	Mandag	10:00 - 15:20	CCNP 3 - Selvstudie	C01
4. August	Tirsdag	08:30 - 09:30	Netværksdesign II - teori	A18
4. August	Tirsdag	10:00 - 11:00	CCNP 2 - Teori	A18
4. August	Tirsdag	12:00 - 13:00	CCNP 3 - Teori	A18
5. August	Onsdag	08:30 - 09:30	Netværksdesign II - teori	A18
5. August	Onsdag	10:00 - 11:00	CCNP 2 - Teori	A18
5. August	Onsdag	12:00 - 13:00	CCNP 3 - Teori	A18
6. August	Torsdag	08:30 - 09:30	Netværksdesign II - teori	A18
6. August	Torsdag	10:00 - 11:00	CCNP 2 - Teori	A18
6. August	Torsdag	12:00 - 13:00	CCNP 3 - Teori	A18

UGE:49 Room C01

Class: AMU
Courses: Microsoft SQL Server 2008
Duration: 30th November 2009 to 4th December 2009

Day 1: Monday, 30st November 2009
Lecture 1:
Introduction to Databases
Database ?
Database Server ?
OLAP vs OLTP ?
SQL ?
DBMS ?
Introduction to MS SQL Server 2008
Design
Security
Administration
Core points in MS SQL Server 2008 Installation
<u</u>

Objectives and Tasks
1. Understanding general theory of Databases.
2. Complete installation of MS SQL Server 2008
3. Understanding SQL Server 2008 Environment
Reading Chapter 1, 2 and 3

Day 2: Tuesday, 1th December 2009
Lecture 2:
Database Design
Normalization
ER Diagram

MS SQL Server Administration
SQL Server Management Studio
Creating Databases
Creating Tables
Creating Views
Database constraints
Index

Objectives and Tasks:
1. Understanding database design concepts
2. Design and normalize database tables
3. Learning to work with SQL Server management studio
Reading Chapter 4, 5, 6

Day 3: Wednesday, 2nd December 2009
Lecture 3:
MS SQL 2008 Server Security
Users and Login
Roles and Permission
Database level security
Database object level security
MS SQL Server 2008 Configuration Manager
Server Configuration
Client Configuration
Network Protocols

Objectives and Tasks
1. Managing security on Database Server
2. Implementing security for database
3. Learning database schema
4. Configuring Database server and client on Network
Reading: Chapter 16 plus reading material

Day 4: Thursday, 3rd August 2009
Lecture 4:
Introduction to SQL Language
DDL
DML
Functions
Aggregate Functions (Algebra)
Joins

Objectives and Tasks:
1. Developing databases using the SQL language
2. Querying with important SQL commands, clauses and functions
3. Making sub quires
4. Working with joins and functions
5. Knowing the use and purpose of built in store procedures
6. Making store procedures
7. Working with database triggers
8. SQL command prompt
Reading: Chapter 7, 8, 9, 10, 11

Day 5: Friday, 4th December 2009
Lecture 5:
Database Backups
Objectives and Tasks:
1. Knowing theory of database backup models
2. Scheduling database backups and restoration
3. Working with database backup strategy
4. Transferring data between different database servers
Reading: Chapter 18
Books:
1. Microsoft SQL Server 2008 for Dummies, Mike Chapple, Wiley Publishing Inc.
2. Microsoft SQL Server 2008, Beginners guide, Dusan Petkovic, McGraw Hills
3. SQL in Nutshell, Kevin Kline with Daniel Kline, O’Reilly & Associates, Inc