DiscoverCS 4750 - Database Systems - Spring 2011
CS 4750 - Database Systems - Spring 2011
Claim Ownership

CS 4750 - Database Systems - Spring 2011

Author: Mark Sherriff

Subscribed: 2Played: 74
Share

Description

Introduces the fundamental concepts for design and development of database systems. Emphasizes relational data model and conceptual schema design using ER model, practical issues in commercial database systems, database design using functional dependencies, and other data models. Develops a working relational database for a realistic application.
22 Episodes
Reverse
mmm... clouds...
We finish up RAID and locking, etc, but the recording fubared after a bit...
Lecture 23: Transaction

Lecture 23: Transaction

2011-04-1401:04:27

Trippin' ACID
Lecture 22: Indexing

Lecture 22: Indexing

2011-04-1201:08:12

Indexing fun
Lecture 21: File Structure

Lecture 21: File Structure

2011-04-0701:07:53

RAID and files on disk
Lecture 20: Hardware

Lecture 20: Hardware

2011-04-0501:10:38

I pull out my bag of tech and we discuss server hardware and RAID.
Lecture 19: XPath

Lecture 19: XPath

2011-03-3101:01:24

We finish XML with XPath.
Lecture 18: XML

Lecture 18: XML

2011-03-2901:13:24

We finish up privacy and security and begin on XML.
Lecture 17: Security

Lecture 17: Security

2011-03-2401:03:27

Database security
Lecture 16: Bagels

Lecture 16: Bagels

2011-03-2228:17

Today, we eat bagels.
Lecture 15: Normal Forms

Lecture 15: Normal Forms

2011-03-1701:01:34

BCNF and 3NF
After I finally make it to class, we discuss FDs, F, F+, and Fc.
Lecture 12: Exam Review

Lecture 12: Exam Review

2011-03-0101:03:41

After a hiatus to work on the wedding database, we take today to review for the midterm on Thursday.
Lecture 9: SQL

Lecture 9: SQL

2011-02-1701:10:13

We finish up SQL... and begin wedding planning?
It's more SQL...
Lecture 7: Basic SQL

Lecture 7: Basic SQL

2011-02-1001:11:49

Intro to SQL
Lecture 6: ER and SQL

Lecture 6: ER and SQL

2011-02-0856:44

We do some more ER examples and startup on SQL. I gave out your accounts today too.
Lecture 5: ER Diagrams 2

Lecture 5: ER Diagrams 2

2011-02-0301:11:36

We finish up with ER Diagrams.
Lecture 4: ER Diagrams 1

Lecture 4: ER Diagrams 1

2011-02-0201:09:08

We go through how to do some tough queries, and then move into ER diagrams.
Lecture 3: RA2

Lecture 3: RA2

2011-01-2801:12:06

With all of like 5 people here because of the snow, we finish up with RA. (Okay, there was more than 5...)
loading
Comments 
loading