Course Recordings - Fall 2020 ============================== All course recordings can be found either on RPI Mediasite or on Vimeo. Recordings on RPI Mediasite: ----------------------------- Access all recordings here: `RPI Mediatesite `_ - Note all in class recordings are posted on Mediasite alone. Vimeo recordings (listed by topic): ----------------------------------- - `Lecture 1: Introduction to Databases `_ - `Lecture 1.2: Introduction to Relational Data Model `_ - `Lecture 2.1: Introduction to Relational Algebra (set operators) `_ - `Lecture 2.2: Relational Algebra (Rename, Select, Project) `_ - `Lecture 2.3: Relational Algebra (Cartesian Product) `_ - `Lecture 3.1: Relational Algebra (Join) `_ (Errata: Note a mistake at 10 minute mark: hid=hid1 should be hid<>hid1, like in the first solution to the same This is why, due to inequality, we cannot use natural join for this query easily.) - `Relational Algebra tl;dr (Short Summary) `_ - `Lecture 3.2: Normalization (Functional dependencies, inference, keys), informercial style! `_ - `Lecture 4:1: Normal Forms `_ - `Lecture 4:2: Minimal Basis `_ - `Lecture 5:1: Normalization (Introduction to Decompositions: Lossless Decocompositions) `_ - `Lecture 5:2: Normalization (Dependency Preserving Decompositions) `_ - `Lecture 5:3: Normalization (3NF Decomposition) `_ Errata: in the example in this video, one of the keys is missing for R, BCD should also be a key! - `Lecture 5:4: Normalization (BCNF Decomposition) `_ - `Lecture 5:Bonus: Normalization (BCNF Decomposition, Second example) `_ - `Lecture 6:1: Normalization (Fourth Normal Form) `_ - `Lecture 6:2: Entity Relationship Diagrams (Entities) `_ - `Lecture 6:3: Entity Relationship Diagrams (Relationships and Participation Constraints) `_ - `Lecture 7:1: Converting ER Diagrams to Relational Data Model `_ - `Lecture 7:2: ER Diagrams (Cardinalities Reexamined) `_ - `Lecture 8:1: ER Diagrams (Entities Reexamined, Weak Entities) `_ - `Lecture 8:2: ER Diagrams (Entity Hierarchies) `_ - `Lecture 10:1: SQL: Intro, SELECT, WHERE `_ - `Lecture 10:2: SQL: FROM `_ - `Lecture 11:1: Set/bag operators, order by, limit `_ - `Lecture 11:2: Group by/Having `_ - `Lecture 12:1: SQL Outer Join `_ - `Lecture 12:2: SQL Anonymous and Scalar Queries `_ - `Lecture 12:3: SQL Set Comparisons `_ - `Lecture 13:1: SQL Correlated Set Comparisons `_ - `Lecture 13:2: Transactions and SQL Insert `_ - `Lecture 13:3: SQL Update/Delete `_ - `Lecture 14:1: SQL Constraints `_ - `Lecture 14:2: SQL Isolation `_ - `Lecture 14:3: SQL Introduction to Procedural SQL `_ - `Lecture 15:1: PL/pgSQL `_ - `Lecture 15:2: SQL Triggers `_ - `Lecture 16_1: Views and Access Control `_ - `Lecture 16_2: Other SQL Features (case, recursion, advanced group by) `_ - `Lecture 19 1: Indexing `_ - `Lecture 19 2: B-trees `_ - `Lecture 19 3: B-trees: insertion/deletion `_ - `Lecture 20 1: B-trees: duplicate values and multiple attributes `_ - `Lecture 20 2: Other types of indices `_ - `Lecture 21 1: Query Execution `_ - `Lecture 21 2: Index Scans `_ - `Lecture 21 3: Block Nested Loop Join `_ - `Lecture 22 1: External Sort `_ - `Lecture 22 2: Pipelining `_ - `Lecture 22 3: Query Optimization Introduction `_ - `Lecture 22 4: Query Plan Generation `_ - `Lecture 22 5: Size Estimation `_ - `Lecture 23 1: Concurrency Control Introduction `_ - `Lecture 23 2: Checking Serialiazibility `_ - `Lecture 24 1: Two Phase Locking `_ - `Lecture 24 2: Lock Management `_ - `Lecture 24 3: Durability introduction `_ - `Lecture 25 1: Durability: Logging `_ - `Lecture 25 2: Durability: Force/Steal `_ - `Lecture 25 3: Durability: Recovery: Aries Algorithm `_ Why I chose Vimeo? `You can read about it here `_