WK
DATE | TOPICS | READING | PTS | ASSIGNMENT |
1
08/24 |
Admin, Survey
SQL Server 2005 Overview
Installation |
01:01-50 |
20 |
Survey
51 Pgs OLQ |
2
08/31 |
Configuring
Tables & Types |
02:51-102
03:103-145 |
|
52 Pgs OLQ
43 Pgs OLQ |
3
09/07 |
No Class
Labor Day |
|
|
|
4
09/14 |
Indexes
Transact-SQL |
04:147-167
05:169-205 |
|
21 Pgs OLQ
37 Pgs OLQ |
5
09/21 |
Partitions
Implementing Views |
06:207-234
07:237-253 |
|
28 Pgs OLQ
17 Pgs OLQ |
6
09/28 |
No Class |
|
|
|
7
10/05 |
Functions, Stored Procedures,
and Triggers
Test Review |
09:349-377 |
|
ILA Topic Due
29 Pgs OLQ |
8
10/12 |
Test: Ch: 1-7,9
Import/Export Flat Files |
10:379-411 |
300 |
33 Pgs OLQ |
9
10/19 |
DB Backup, Restore & Move |
11:413-446 |
|
34 Pgs OLQ |
10
10/26 |
DB Management
Jobs |
12:447-476
14:493-526 |
|
30 Pgs OLQ
34 Pgs OLQ |
11
11/02 |
Performance Monitoring
Test Review |
15:529-600 |
|
72 Pgs OLQ |
12
11/09 |
Test: Ch: 10-12,14-15
Snapshots
Mirroring
Log Shipping |
16:601-613
17:615-649
18:651-692 |
300 |
13 Pgs OLQ
35 Pgs OLQ
42 Pgs OLQ |
13
11/16 |
Replication
Test Review |
19:695-773 |
|
79 Pgs OLQ |
14
11/23 |
Test: Ch: 16-19
HTTP Endpoints
Service Broker |
13:477-492
20:775-811 |
300 |
16 Pgs OLQ
37 Pgs OLQ |
15
11/30 |
Managing XML Data |
08:255-348 |
|
94 Pgs OLQ |
16
12/07 |
Full-Text Catalogs
Test Review |
21:813-838 |
|
26 Pgs OLQ
ILA Due |
17
12/14 |
Final: Ch: 8,13,20-21+ |
|
20
300 |
Evaluation |
