C01 - Revision history

Azeem at 20:30, 29 November 2009

2009-11-29T20:30:02Z

Azeem: /* Skema uge 32 */

2009-11-26T14:19:38Z

‎Skema uge 32

Heth: /* Skema uge 32 */

2009-08-03T11:44:10Z

‎Skema uge 32

Heth: /* Skema uge 32 */

2009-08-03T11:41:33Z

‎Skema uge 32

Heth: /* Skema uge 32 */

2009-08-03T07:13:26Z

‎Skema uge 32

Heth: New page: NOTOC == Skema uge 32 == {| width="auto" border="1" cellpadding="1" cellspacing="1" summary="Cisco" |- bgcolor=lightgrey ! scope="col" | Dato ! scope="col" | Ugedag ! scope="col" | T...

2009-08-03T07:12:43Z

New page: __NOTOC__ == Skema uge 32 == {| width="auto" border="1" cellpadding="1" cellspacing="1" summary="Cisco" |- bgcolor=lightgrey ! scope="col" | Dato ! scope="col" | Ugedag ! scope="col" | T...

New page

__NOTOC__
== Skema uge 32 ==
{| width="auto" border="1" cellpadding="1" cellspacing="1" summary="Cisco"
|- bgcolor=lightgrey
! scope="col" | Dato
! scope="col" | Ugedag
! scope="col" | Tid
! scope="col" | Emne
! scope="col" | 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
|-
| 3. August
| Mandag
| 08:00 - 09:30
| Velkomst
| A19
|-
| 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 - Selvstudie
| 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
| Torsdag
| 12:00 - 13:00
| CCNP 3 - Selvstudie
| 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 - Selvstudie
| A18
|}

[[Category:Skema]]

@@ Line 137: / Line 137: @@
 [[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;
-== 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
-== 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
-== 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

← Older revision		Revision as of 14:19, 26 November 2009
Line 136:		Line 136:
	-->		-->
	[[Category:Skema]]		[[Category:Skema]]
		+
		+	= UGE 49 - 2009 =
		+
		+	== Mandag den 30. November 2009 ==
		+
		+	{\| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
		+	\|+ 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
		+	\|-
		+
		+
		+	== Torsdag den 1. December 2009 ==
		+
		+	{\| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
		+	\|+ 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 ==
		+
		+	{\| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
		+	\|+ 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 ==
		+
		+	{\| class="wikitable sortable" cellspacing="1" cellpadding="1" summary="Cisco" border="1"
		+	\|+ 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
		+	\|-

@@ Line 48: / Line 48: @@
 | Tirsdag
 | 12:00 - 13:00
-| CCNP 3 - Selvstudie
+| CCNP 3 - Teori
 | A18
 |-
@@ Line 66: / Line 66: @@
 | Onsdag
 | 12:00 - 13:00
-| CCNP 3 - Selvstudie
+| CCNP 3 - Teori
 | A18
 |-
@@ Line 84: / Line 84: @@
 | Torsdag
 | 12:00 - 13:00
-| CCNP 3 - Selvstudie
+| CCNP 3 - Teori
 | A18
 |}

@@ Line 32: / Line 32: @@
 | CCNP 3 - Selvstudie
 | C01
 |-
 | 4. August

C01 - Revision history

Azeem at 20:30, 29 November 2009

Azeem: /* Skema uge 32 */

Heth: /* Skema uge 32 */

Heth: /* Skema uge 32 */

Heth: /* Skema uge 32 */

Heth: New page: __NOTOC__ == Skema uge 32 == {| width="auto" border="1" cellpadding="1" cellspacing="1" summary="Cisco" |- bgcolor=lightgrey ! scope="col" | Dato ! scope="col" | Ugedag ! scope="col" | T...

Heth: New page: NOTOC == Skema uge 32 == {| width="auto" border="1" cellpadding="1" cellspacing="1" summary="Cisco" |- bgcolor=lightgrey ! scope="col" | Dato ! scope="col" | Ugedag ! scope="col" | T...