CMU - Intro to Database Systems (Fall 2022) - Topics
Course Details Course: https://15445.courses.cs.cmu.edu/fall2022/# Youtube: https://www.youtube.com/playlist?list=PLSE8ODhjZXjaKScG3l0nuOiDTTqpfnWFf Lectures 01 - Relational Model & Relational Algebra Notes: https://15445.courses.cs.cmu.edu/fall2022/notes/01-introduction.pdf Slides: https://15445.courses.cs.cmu.edu/fall2022/slides/01-introduction.pdf Topics: Data (Integrity, Durability, Implementation), DBMS (Database Management Systems), Data Model, Schema, SQL, noSQL, Relational Model (Structure, Integrity, Manipulation), Relation (Table), Tuple (Row, Record), Domain, atomic/scalar values, primary key, foreign keys, DML (Data Manipulation Language), Procedural DML (Relational Algebra), Non-Procedural/Declarative DML (Relational Calculus), Relational Algebra, Fundamental Operators: Select (predicates, conjunctions, disjunctions), Projection, Union (UNION ALL), Intersection (INTERSECT), Difference (EXCEPT), Product (Cartesian Product, CROSS JOIN), join, intersection (need same schema) vs join, extra operators: (rename, assignment, duplicaiton elimination, aggregation, sorting, division), Queries, Document Data Model 02 - Modern SQL Notes: https://15445....