How to use this website to succeed in ICS 321
Screencast 5 min
Course dynamics, prerequisites, software setup, and more
Lecture Notes
Course Syllabus, Grading, Policies
There is an art to watching screencasts effectively. Here are some heuristics.
Virtualization, VM, Containers
Virtualization, VMs, Containers, & Docker
web article
Data vs. Database vs. DBMS
10 pages
The relational model of data
50 pages
Relations, schemas, relational operators
CREATE TABLE statements, primary keys & foreign keys
Query languages
40 pages
Bag semantics, extended relational algebra
Database logic
Introduction to SQL
60 pages
Basics of SQL queries
Nested Queries in SQL
Aggregation Queries in SQL
Introduction to SQL servers
Basics of networking, three tier architecture
ODBC, JDBC, Stored Procedures, UDFs
JDBC & JSF
Documentation & Examples
DDL for the Blue Diner Restaurent
Database Schema
Requirements analysis, conceptual, logical, and physical database design
70 pages
Logical, physical, and conceptual database modeling
Normal forms
Functional Dependencies
Normal forms 1
Normal forms 2
Constraints and triggers
20 pages
Views and indexes
Introduction to handy database constructs
Transaction processing
Introduction to transaction processing: atomicity, scheduling
Introduction to transaction processing: concurrency control
Types of storage
B+ Trees, hash-based
Storage types
B+ trees, hash-based
Query planning
Query optimization
Query processing
Schema variability
Extensible markup language
Query variability and XML