Relational Database Management Systems
11xWEBRip | MP4/AVC, ~283 kb/s | 320x240 | Duration: 09:32:47 | English: AAC, 72 kb/s (1 ch) | 1,25 GB
Genre: Development / Programming
11xWEBRip | MP4/AVC, ~283 kb/s | 320x240 | Duration: 09:32:47 | English: AAC, 72 kb/s (1 ch) | 1,25 GB
Genre: Development / Programming
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.
1/11: Overview, Query Processing, embedded SQL, Cursors, Triggers
2/11: Relational Algebra, Relational Calculus
3/11: Entity Relationship Diagrams
4/11: RDBMS Memory and Disk Storage, RAID, Buffer Management
5/11: Unordered/Sorted/Hashed Files, Indexes
6/11: Index Sequential Access Method, B+ Trees
7/11: Static and Dynamic Hash Indexing
8/11: External Sorting, Merge Sort, Double Buffering, Replacement Sort
9/11: Query Optimizers, Query Evaluation
10/11: Normal Forms
11/11: Query Analysis and Optimizing in Oracle
Welcome to the best movies collection (English, German, French, Italian language), best software, best eLearning video and many-many more: LINK
Do not forget to check my blog! Updated regularly!
Do not forget to check my blog! Updated regularly!
No mirrors pls! Read the rules.