Week
/ Class
|
Date
|
Lecture |
Lab(s)
|
Homework
Due
|
Project
Deliverables |
Unit 1: Foundations
|
|
1 01
|
Wed Jan 21
|
Housekeeping - Intro
|
|
Read This
|
|
|
2 02
|
Mon Jan 26
|
Tables II
|
|
1
|
|
|
2 03
|
Wed Jan 28
|
Tables III, Beginning SQL
|
|
|
|
|
3 04
|
Mon Feb 2
|
Normalization
XL example
|
Set up Server 2000
|
Listen
to this
|
|
|
3 05
|
Wed Feb 4
|
Data Types - SQL Environ
|
|
|
|
|
4 06
|
Mon Feb 9
|
SQL Environment 2 EM
|
Set up SQL Server
|
|
|
|
4
|
Wed Feb 11
|
Review
|
|
|
|
|
5
|
Mon Feb 16
|
President's Day - no class
|
|
5
|
Wed Feb 18
|
Midterm 1
|
|
hw14102
|
|
Unit 2: Queries & Language
|
|
6 07
|
Mon Feb 23
|
Simple Select - Best Practices
|
|
|
pd14101
|
|
6
|
Wed Feb 25
|
Cancelled by Cuesta College
|
|
|
|
|
7 08
|
Mon Mar 1
|
Create - OLAP/OLTP Single Table SELECT I
|
|
|
|
|
7 09
|
Wed Mar 3
|
Single Table Select II, INSERT, DROP
|
|
|
|
|
8 10
|
Mon Mar 8
|
Multi-Table SELECT I
|
|
hw14103
|
|
|
8 11
|
Wed Mar 10
|
Multi-Table SELECT II
|
|
|
|
|
9
|
Mon Mar 15
|
Review
|
|
hw14104
|
|
|
9
|
Wed Mar 17
|
Midterm 2
|
|
|
|
Unit 3: SQL Server
|
|
10 12
|
Mon Mar 22
|
Test Review, Physical & Logical Archictecture
|
|
|
|
|
10 13
|
Wed Mar 24
|
Security Issues
|
|
|
|
|
11 14
|
Mon Mar 29
|
Changing Data
|
|
|
|
|
11 15
|
Wed Mar 31
|
Stored Procedures, Triggers, UDFs
|
|
|
|
|
12 16
|
Mon Apr 5
|
Data Scrubbing
|
|
hw14105
|
|
|
12
|
Wed Apr 7
|
Data Scrubbing
|
|
|
|
|
13
|
Mon Apr 12
|
* * * Vacation * * *
|
|
13
|
Wed Apr 16
|
|
14 17
|
Mon Apr 19
|
DTS
|
|
|
|
|
14 Web
based
|
Wed Apr 21
|
DTS/XML
|
|
|
|
Unit 4: Presentation & Beyond
|
|
15 18
|
Mon Apr 26
|
XML
|
|
hw14106
|
|
|
15 19
|
Wed Apr 28
|
Reports / Lab Set up
|
Set up your Cuesta Lab Computer
|
Read this
|
|
|
16 20
|
Mon May 3
|
Labs
|
|
|
|
|
16 21
|
Wed May 5
|
ASP pages, connectors
|
|
hw14107
|
|
|
17 22
|
Mon May 10
|
More ASP
|
|
|
|
|
17
|
Wed May 12
|
Review
|
|
|
|
|
18
|
Mon May 17
|
Midterm 3 4:30pm hw14108
|
|
|
18
|
Wed May 19
|
*** No Class ***
|
|