CS 632 Class Material Spring 2018

This file will be updated whenever necessary.

Some material has not been written yet.

Assignments are at the bottom of the page.

Keep coming back.

PL/SQL Programs Part 1

p1-p6g, basics, if/then/else, variables, procedures, functions, parameters, booleans.

PL/SQL Programs Part 2

p7-p10b, recursion, for loops

Oracle System Tables

PL/SQL Programs Part 3

p11-p18, cursors

PL/SQL Programs Part 4

p19-p21b, relational algebra operations in programs

PL/SQL Programs Part 5

p22-p26, non-Select SQL statements in programs

PL/SQL Programs Part 6

p28-p33e (without p33d)

PL/SQL Programs Part 7

p33d, regular expressions

Introduction to Objects in Oracle

The following lecture is in PDF format because it is tedious to display XML in HTML.

XML Box Diagram

XML Tree Diagram

Basic Python Lecture

Lists and Tuples in Python

PL/SQL Programs Part 8

p34-p52b, XML in Oracle

Brief Intro to UNIX/AFS and vi editor

Security Lecture

JSON Lecture and Simple JSON Code in Oracle

Studio3T and Mongo Lecture (improved)

Oracle Indexing

MongoDB Indexing

Very briefly on exceptions and transactions.

Django Code Log Final Version

To be revised later in the semester.

Assignments

To be added later.