|
DATE
|
CL AS
|
ASSESSMENT
|
PARTIAL LIST OF
LECTURE TOPICS (Approximate Dates)
|
|
1-17
|
1
|
|
Introduction
|
|
1-17
|
|
|
PL/SQL Basics,
IF/THEN/ELSE, etc.
|
|
1-24
|
2
|
|
Set up SQL DEVELOPER/plain insert into my table
Intro to SQL
DEVELOPER
System Tables
|
|
1-24
|
|
|
PL/SQL WHILE loops,
Procedures, etc.
PL/SQL parameter
passing, functions
PL/SQL data types,
Recursion, FOR loops
|
|
1-31
|
3
|
(Hwk 1 assigned: SQL review, basic PL/SQL, cursors)
|
Regular Expressions
in MS Word, etc.
Data cleaning, SQL
DEVELOPER importing
|
|
1-31
|
|
|
Cursors
|
|
2-7
|
4
|
|
Working in AFS/cp my file and
email it back
Cursors continued
Object-oriented
theory UML
|
|
2-7
|
|
|
UML Objects,
attributes, methods
Relationships,
hierarchies, aggregates
|
|
2-14
|
5
|
HWK 1 Due
|
Working in vi/edit a file and email me
DBLP
Six properties of
OODBs following Bertino
|
|
2-14
|
|
|
Object-Relational
DBs
Selection/Projection
with cursors. Update, Delete, etc.
|
|
2-21
|
6
|
(Hwk 2 assigned: Object data, more cursors, triggers, github, vi)
|
Set up GitHub Account
Cursors for update,
Intro to triggers
Special cases of
triggers. Review of ASCII table
|
|
2-21
|
|
|
Objects in Oracle.
Selects from dual. Methods.
Sysdate
in select statements.
|
|
2-28
|
7
|
Midterm
1
|
---------------
|
|
2-28
|
|
|
---------------
|
|
3-7
|
8
|
|
Anaconda install/email screen dump
Year-safe method, dropping
object tables
Intro to XML
|
|
3-7
|
|
|
Box diagrams and
tree diagrams
Attribute value
pairs and other syntax of XML
|
|
3-14
|
|
SPRING BREAK
|
|
|
3-14
|
|
NO CLASS
|
|
|
3-21
|
9
|
HWK 2 Due
|
XML insert
XML in Oracle
|
|
3-21
|
|
|
XML select
Python
|
|
3-28
|
10
|
Midterm 2
|
---------------
|
|
3-28
|
|
(Hwk 3 assigned: XML data, Python)
|
---------------
|
|
4-4
|
11
|
|
Django server setup
Django introduction
|
|
4-4
|
|
|
Django complete
implementation
|
|
4-11
|
12
|
(Hwk 4 assigned: Django, JSON, MongoDB)
HWK 3 Due
|
No-SQL databases
MapReduce
JSON
JSON tree diagrams
|
|
4-11
|
|
|
JSON insert
JSON in Oracle
|
|
4-18
|
13
|
|
Mongo Login
MongoDB
|
|
4-18
|
|
|
MongoDB
Neo4J (if time
allows)
|
|
4-25
|
14
|
HWK 4 Due
|
Make your table public
Database security
Access control in
Oracle
|
|
4-25
|
|
|
Intro to indexing,
performance tuning, Buffering
|
|
5-2
|
|
READING DAY
|
|
|
5-9(?)
|
|
FINAL EXAM
|
|
|
|
|
|
|
|
|
|
|
|