Difference between revisions of "C01"

From Teknologisk videncenter
Jump to: navigation, search
(→‎Skema uge 32)
 
Line 137: Line 137:
 
[[Category:Skema]]
 
[[Category:Skema]]
  
−
= UGE 49 - 2009 =
+
= <u>'''UGE:49'''</u> Room C01 =
  
−
== Mandag den 30. November 2009 ==
+
<u>'''Class: AMU&nbsp;<br>Courses: Microsoft SQL Server 2008 <br>Duration: 30th November 2009 to 4th December 2009'''</u>
  
−
{| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
+
<u>'''Day 1: Monday, 30st November 2009<br>Lecture 1:'''</u><br>Introduction to Databases<br>Database&nbsp;?<br>Database Server&nbsp;?<br>OLAP vs OLTP&nbsp;?<br>SQL&nbsp;?<br>DBMS&nbsp;?<br>Introduction to MS SQL Server 2008<br>Design<br>Security<br>Administration<br>Core points in MS SQL Server 2008 Installation<br>&lt;u&lt;/u&gt;
−
|+ Undervisning Mandag
 
−
|- bgcolor="#d3d3d3"
 
−
! scope="col" | Tid
 
−
! scope="col" | Klasse
 
−
! scope="col" | Emne
 
−
! scope="col" | Fag
 
−
! scope="col" | Underviser
 
−
! scope="col" | lokale
 
−
|-
 
−
| 08:00 - 15:15
 
−
| AMU
 
−
| Introduktion til MS SQL Server 2008
 
−
| Nettenik Serversytemer teknisk adm database
 
−
| Azeem Umar
 
−
| C01
 
−
|-
 
  
 +
<u>'''Objectives and Tasks'''</u><br>1. Understanding general theory of Databases.<br>2. Complete installation of MS SQL Server 2008<br>3. Understanding SQL Server 2008 Environment<br>Reading Chapter 1, 2 and 3
  
−
== Torsdag den 1. December 2009 ==
+
<u>'''Day 2: Tuesday, 1th December 2009'''</u><br><u>'''Lecture 2:'''</u><br>Database Design<br>Normalization<br>ER Diagram<br><br>MS SQL Server Administration<br>SQL Server Management Studio<br>Creating Databases<br>Creating Tables<br>Creating Views<br>Database constraints<br>Index
  
−
{| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
+
<u>'''Objectives and Tasks:'''</u><br>1. Understanding database design concepts<br>2. Design and normalize database tables<br>3. Learning to work with SQL Server management studio<br>Reading Chapter 4, 5, 6
−
|+ Undervisning Torsdag
 
−
|- bgcolor="#d3d3d3"
 
−
! scope="col" | Tid
 
−
! scope="col" | Klasse
 
−
! scope="col" | Emne
 
−
! scope="col" | Fag
 
−
! scope="col" | Underviser
 
−
! scope="col" | lokale
 
−
|-
 
−
| 08:00 - 15:15
 
−
| AMU
 
−
| SQL Server 2008 Administration
 
−
| Nettenik Serversytemer teknisk adm database
 
−
| Azeem Umar
 
−
| C01
 
−
|-
 
  
−
== Onsdag den 2. December 2009 ==
+
<br><u>'''Day 3: Wednesday, 2nd December 2009<br>Lecture 3:'''</u><br>MS SQL 2008 Server Security <br>Users and Login<br>Roles and Permission<br>Database level security<br>Database object level security<br>MS SQL Server 2008 Configuration Manager<br>Server Configuration<br>Client Configuration<br>Network Protocols
  
−
{| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
+
<u>'''Objectives and Tasks <br>'''</u>1. Managing security on Database Server<br>2. Implementing security for database<br>3. Learning database schema<br>4. Configuring Database server and client on Network<br>Reading: Chapter 16 plus reading material
−
|+ Undervisning Onsdag
 
−
|- bgcolor="#d3d3d3"
 
−
! scope="col" | Tid
 
−
! scope="col" | Klasse
 
−
! scope="col" | Emne
 
−
! scope="col" | Fag
 
−
! scope="col" | Underviser
 
−
! scope="col" | lokale
 
−
|-
 
−
| 08:00 - 15:15
 
−
| AMU
 
−
| SQL Server 2008 Network Administration
 
−
| Nettenik Serversytemer teknisk adm database
 
−
| Azeem Umar
 
−
| C01
 
−
|-
 
  
−
== Tirsdag den 3. December 2009  ==
+
<u>'''Day 4: Thursday, 3rd August 2009<br>Lecture 4:<br>'''</u>Introduction to SQL Language<br>DDL<br>DML<br>Functions<br>Aggregate Functions (Algebra)<br>Joins<br><br><u>'''Objectives and Tasks:'''</u><br>1. Developing databases using the SQL language<br>2. Querying with important SQL commands, clauses and functions<br>3. Making sub quires<br>4. Working with joins and functions<br>5. Knowing the use and purpose of built in store procedures<br>6. Making store procedures<br>7. Working with database triggers<br>8. SQL command prompt<br>Reading: Chapter 7, 8, 9, 10, 11
  
−
{| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
+
<u>'''Day 5: Friday, 4th December 2009<br>Lecture 5:'''</u><br>Database Backups<br>Objectives and Tasks:<br>1. Knowing theory of database backup models<br>2. Scheduling database backups and restoration<br>3. Working with database backup strategy<br>4. Transferring data between different database servers<br>Reading: Chapter 18<br><u>'''Books:'''</u><br>1. Microsoft SQL Server 2008 for Dummies, Mike Chapple, Wiley Publishing Inc.<br>2. Microsoft SQL Server 2008, Beginners guide, Dusan Petkovic, McGraw Hills<br>3. SQL in Nutshell, Kevin Kline with Daniel Kline, O’Reilly &amp; Associates, Inc
−
|+ Undervisning Tirsdag
 
−
|- bgcolor="#d3d3d3"
 
−
! scope="col" | Tid
 
−
! scope="col" | Klasse
 
−
! scope="col" | Emne
 
−
! scope="col" | Fag
 
−
! scope="col" | Underviser
 
−
! scope="col" | lokale
 
−
|-
 
−
| 08:00 - 15:15
 
−
| AMU
 
−
| Database Functions, Triggers and Store Procedures
 
−
| Nettenik Serversytemer teknisk adm database
 
−
| Azeem Umar
 
−
| C01
 
−
|-
 

Latest revision as of 21:30, 29 November 2009

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

Retrieved from "http://mars.merhot.dk/w/index.php?title=C01&oldid=10110"