Difference between revisions of "C01"
m (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...) |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 32: | Line 32: | ||
| CCNP 3 - Selvstudie | | CCNP 3 - Selvstudie | ||
| C01 | | C01 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| 4. August | | 4. August | ||
| Line 54: | Line 48: | ||
| Tirsdag | | Tirsdag | ||
| 12:00 - 13:00 | | 12:00 - 13:00 | ||
| − | | CCNP 3 - | + | | CCNP 3 - Teori |
| A18 | | A18 | ||
|- | |- | ||
| Line 70: | Line 64: | ||
|- | |- | ||
| 5. August | | 5. August | ||
| − | | | + | | Onsdag |
| 12:00 - 13:00 | | 12:00 - 13:00 | ||
| − | | CCNP 3 - | + | | CCNP 3 - Teori |
| A18 | | A18 | ||
|- | |- | ||
| Line 90: | Line 84: | ||
| Torsdag | | Torsdag | ||
| 12:00 - 13:00 | | 12:00 - 13:00 | ||
| − | | CCNP 3 - | + | | CCNP 3 - Teori |
| A18 | | A18 | ||
|} | |} | ||
| Line 142: | Line 136: | ||
--> | --> | ||
[[Category:Skema]] | [[Category:Skema]] | ||
| + | |||
| + | = <u>'''UGE:49'''</u> Room C01 = | ||
| + | |||
| + | <u>'''Class: AMU <br>Courses: Microsoft SQL Server 2008 <br>Duration: 30th November 2009 to 4th December 2009'''</u> | ||
| + | |||
| + | <u>'''Day 1: Monday, 30st November 2009<br>Lecture 1:'''</u><br>Introduction to Databases<br>Database ?<br>Database Server ?<br>OLAP vs OLTP ?<br>SQL ?<br>DBMS ?<br>Introduction to MS SQL Server 2008<br>Design<br>Security<br>Administration<br>Core points in MS SQL Server 2008 Installation<br><u</u> | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 | ||
| + | |||
| + | <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 & Associates, Inc | ||
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