SE 385 Home Page

SE 385 is an introduction to Database theory.

This course is now complete.

Tests:


The final exam will be on Tuesday, December 13 at 1:00.

The assignments


The final project.

Presentations

The intent is to have the presentations available before the start of class. They will be left here for some time after presentation.
Not yet covered.
Database security.
Covered.
Data mining.
No SQL databases.
Data warehouse.
Big Data. Updated 11/18.
A trigger example that fires if student balance is too large.
Triggers.
Stored procedures.
Microsoft's enhancements to SQL.
Below this may be on the third test.
SQL index creation.
Distributed databases.
The disk manager.
Recovery of a DB.
Database concurrency considerations.
Transactiopn Management.
Schema refinement 3.
Schema refinement.
Schema refinement 2.
The SQL Data Manipulation Language.
The SQL Data Definition Language.
Below this may be on the second test.
Hash Indices.
Hashing.
BTrees.
SQL Join.
SQL Queries 3.
Client server paradigm.
SQL Queries 2.
Entity relationship diagrams.
SQL Queries.
Introduction to SQL.
Below this will be on the first test.
RAID.
Error Correction Codes.
Relational calculus.
Relational algebra.
The relational model.
Database models.
The functions a database should provide.
History of database.
File organizations.
Basics of disks.

Textbook

Fundamentals of Database Systems by Elmasri and Navathe.

Important documents overviewing the course:

The syllabus for SE 385 or the ADA friendly syllabus for SE 385.

Files and handouts


A description of the sample schemas for the college database (Word format). We will use this both for examples and exercises.

The SQL test page.

Articles of interest

SQL Injection Attacks.
SQL misconceptions illuminated.
The shrinking SQL NoSQL divide.
A ranking of popularity of data base engines.
How to fake database design.
First things to look for on a SQLServer implementation.
Survey of ACID implementation in common databases
Jim Gray's Data Management History This predates and foresees the NOSQL movement.
12 years of CAP

Other links of interest

Banks are BASE and not ACID.

Download the free version of SQL Server. Unless you are fabulously well to do scroll down to the Express download.

Feeling lucky? Download the free version of DB2.

Also of interest. Download the free version of Oracle 11.

The SQL test page.


DataBase Adminstrator Jokes.

Return links

Return to Curt Hill's home page.

Last time I updated this page: December 16, 2016.