PODCAST · education
CS 4750 - Database Systems - Spring 2011
by Mark Sherriff
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
Lecture 26: Distributed Databases
mmm... clouds...
-
21
Lecture 24: Concurrency Control
We finish up RAID and locking, etc, but the recording fubared after a bit...
-
20
Lecture 23: Transaction
Trippin' ACID
-
19
Lecture 22: Indexing
Indexing fun
-
18
Lecture 21: File Structure
RAID and files on disk
-
17
Lecture 20: Hardware
I pull out my bag of tech and we discuss server hardware and RAID.
-
16
Lecture 19: XPath
We finish XML with XPath.
-
15
Lecture 18: XML
We finish up privacy and security and begin on XML.
-
14
Lecture 17: Security
Database security
-
13
Lecture 16: Bagels
Today, we eat bagels.
-
12
Lecture 15: Normal Forms
BCNF and 3NF
-
11
Lecture 14: Functional Dependencies
After I finally make it to class, we discuss FDs, F, F+, and Fc.
-
10
Lecture 12: Exam Review
After a hiatus to work on the wedding database, we take today to review for the midterm on Thursday.
-
9
Lecture 9: SQL
We finish up SQL... and begin wedding planning?
-
8
Lecture 8: Intermediate SQL
It's more SQL...
-
7
Lecture 7: Basic SQL
Intro to SQL
-
6
Lecture 6: ER and SQL
We do some more ER examples and startup on SQL. I gave out your accounts today too.
-
5
Lecture 5: ER Diagrams 2
We finish up with ER Diagrams.
-
4
Lecture 4: ER Diagrams 1
We go through how to do some tough queries, and then move into ER diagrams.
-
3
Lecture 3: RA2
With all of like 5 people here because of the snow, we finish up with RA. (Okay, there was more than 5...)
-
2
Lecture 2: RA1
The history of databases and the beginning of relational algebra.
-
1
Lecture 1: Welcome!
Welcome to CS 4750!
No matches for "" in this podcast's transcripts.
No topics indexed yet for this podcast.
Loading reviews...
ABOUT THIS SHOW
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.
HOSTED BY
Mark Sherriff
CATEGORIES
Loading similar podcasts...