3 Database Courses from Purdue University
Here are three University Database Courses from
Purdue University that offer online content, including the
classroom lecture materials. These lectures cover many database related
topics, including: relational database design, database transactions,
data analysis, data mining, database system architectures, SQL, disk
storage, file organization, indexes, database tuning, database
security, concurrency control, crash recovery, parallel DBMS,
distributed databases.
CS348:
Information Systems
Lectures
for Information Systems course
1.
Introduction (ppt
,
pdf)
2.
Relational Model (ppt
,
pdf)
3.
Relational Algebra
and SQL (ppt
,
pdf)
4.
Other Relational
Languages (ppt
,
pdf)
5.
Integrity and
Security (ppt
,
pdf)
6.
Relational Database
Design and Normalization (ppt
,
pdf)
7.
Database Design: ER
(ppt
,
pdf)
8.
Object-Based
Databases (ppt
,
pdf)
9.
XML (ppt
,
pdf)
10.
Transactions (ppt
,
pdf)
11.
Data Analysis and
Mining (ppt
,
pdf)
12.
Information
Retrieval (ppt
,
pdf)
13.
Database System
Architectures (ppt
,
pdf)
14.
Application
Design and Development (ppt
,
pdf)
CS541:
Database Systems
Lectures
for Database Systems course
Introduction
to Database Systems [ps][pdf]
The
Entity-Relationship Model [ps][pdf]
The
Relational Model [ps][pdf]
Relational
Algebra [ps][pdf]
Relational
Calculus [ps][pdf]
SQL:
Queries, Programming,
Triggers [ps][pdf]
Query
By Example [ps][pdf]
Disk
Storage and Files [ps][pdf]
File
Organization and Indexing [ps][pdf]
Tree-Structured
Indexes [ps][pdf]
Hash-Based
Indexes [ps][pdf]
External
Sorting [ps][pdf]
Evaluation
of Relational Operations: Part I [ps][pdf]
Evaluation
of Relational Operations:
Part II [ps][pdf]
Introduction
to Query Optimization [ps][pdf]
Relational
Query Optimization [ps][pdf]
Schema
Refinement and Normal Forms [ps][pdf]
Database
Tuning [ps][pdf]
Physical
Database Design [ps][pdf]
Database
Security [ps][pdf]
Transaction
Management [ps][pdf]
Concurrency
Control [ps][pdf]
Crash
Recovery [ps][pdf]
Parallel
DBMS [ps][pdf]
Distributed
Databases [ps][pdf]
CS 590S:
Database Security
Lecture
Slides:
Introduction:
Data Protection and Access Control Policies. [PDF]
Guest Seminar [PDF]
Access Control in Commercial DBMS. [PDF]
The Chinese Wall Security Policy. [PDF]
Access Control Mechanisms -Research Directions. [PDF]
TRBAC- Temporal Role Based Access Control Model. [PDF]
Popularity: 14% [?]
Related Posts:
