SE 385 Home Page

SE 385 is an introduction to Database theory.

Tests:


The third test was on Friday, November 16. This will contain lots of things, but the largest are SQL DDL, DML and normalization.
The final exam will be on Tuesday, December 11 at 1:00.

The assignments


Create a trigger in Transact SQL. Due on Wednesday, 11/14.
Create a Transact SQL program. Due on Friday, 11/9.
Create a normalized schema. Due on Wednesday, 10/31.
The sales data. We will use this for a couple of assignments.
Fifth SQL Query Worksheet. Due on Wednesday, 10/24.
Creating the college database on your machine. Due on Friday, 10/12. This will require that you download the free Express version of SQL Server and then install. At the end of the install click on the Install SSMS button.
Fourth SQL Query Worksheet. Due on Monday, 10/8.
ERD exercise. Due on Wednesday, 10/3.
Third SQL Query Worksheet. Due Monday, 10/1.
A BTree worksheet. Due on Friday, 9/21. Hand in the paper copy during class.
Second SQL Query Worksheet. Due on Monday, 9/24.
First SQL Query Worksheet. Due on Monday, 9/17. Be sure to follow all the instructions on the sheet.

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.
SQL security statements.
Encryption.
Big Data.
Hadoop, an open source system for processing big data.
Data warehouse.
Data mining.
Database concurrency.
No SQL databases.
Database concurrency considerations.
Covered.
The corrected trigger from class on 11/7. We will talk about and enhance.
XML.
JavaScript Object Notation.
Triggers.
Stored Procedures.
Distributed Databases.
Query Evaluation.
The Transact_SQL program to count zero, low, high balance students.
Microsoft's enhancements to SQL. Updated again on 10/26.
Below this will be on the third test.
Schema refinement 3.
Index Creation in SQL.
Schema refinement.
Schema refinement 2.
Transaction Management.
The SQL Data Manipulation Language.
The SQL Data Definition Language.
Below this will be on the second test, except the MakeMoo thing.
Recovery of a DB.
The disk manager.
The MakeMoo utility. This is what will keep you from typing in all of the college data.
Entity relationship diagrams.
Client server paradigm.
SQL Queries 3.
SQL Join.
Hash Indices. Updated 9/19.
Hashing.
SQL Queries 2.
BTrees.
SQL Queries.
Introduction to SQL.
Below this will be on the first test.
RAID.
Relational calculus.
System catalog.
Error Correction Codes.
Relational algebra.
The relational model.
The functions a database should provide.
Database models.
History of database.
File organizations.

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. Revised 9/11.

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 Express version of SQL Server, which is free.

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: November 16, 2018.