# You can also click the upper-left icon to select videos from the playlist.
source: Jaap Weel 2012年8月19日
ArsDigita University Course 10: Relational Database Management Systems (RDBMS)
A more formal approach to Relational Database Management Systems, compared the way they were covered during Web Applications. Database systems are discussed from the physical layer of B-trees and file servers to the abstract layer of relational design. Also includes alternative and generic approaches to database design and database management system including relational, object-relational, and object-oriented systems, SQL standards, algebraic query languages, integrity constraints, triggers, functional dependencies, and normal forms. Other topics include tuning database transactions, security from the application perspective, and data warehousing.
Text: Database Management Systems, Ramakrishnan and Gehrke.
http://www.archive.org/details/arsdig...
http://www.aduni.org/courses/databases/
Lecture 1/11 1:24:31 Overview, Query Processing, Embedded SQL, Cursors, Triggers
Lecture 2/11 43:03 Relational Algebra, Relational Calculus
Lecture 3/11 57:24 Entity Relationship Diagrams
Lecture 4/11 43:21 RDBMS Memory and Disk Storage, RAID, Buffer Management
Lecture 5/11 33:35 Unordered/Sorted/Hashed Files, Indexes
Lecture 6/11 55:26 Index Sequential Access Method, B+ Trees
Lecture 7/11 39:18 Static and Dynamic Hash Indexing
Lecture 8/11 1:24:07 External Sorting, Merge Sort, Double Buffering, Replacement Sort
Lecture 9/11 43:16 Query Optimizers, Query Evaluation
Lecture 10/11 51:00 Normal Forms
Lecture 11/11 37:54 Query Analysis and Optimizing in Oracle
1. Clicking ▼&► to (un)fold the tree menu may facilitate locating what you want to find. 2. Videos embedded here do not necessarily represent my viewpoints or preferences. 3. This is just one of my several websites. Please click the category-tags below these two lines to go to each independent website.
No comments:
Post a Comment