jackmyers.info

Schedule for DB

Week of (Mon) Monday Wednesday
1/19 1. Introduction to Databases
2. Data Modeling
  • Welcome and syllabus review
  • Modeling a movie database
  • Introduction to ER diagrams
1/26 Lots of snow 2. Data Modeling
Chapter 3: Data Modeling Using the ER Model
RDBMS 1.00 Types of Database Models.mp4   (13:05)
RDBMS 1.01 Entity Types and Attributes.mp4    (5:51)
RDBMS 1.02 Relationships Cardinality and Participation.mp4   (11:54)
  • Participation
  • Derived, Multivalue, Composite Attributes
  • Relationship Attributes
2/2 2. Data Modeling
Chapter 3: Data Modeling Using the ER Model
RDBMS 1.03 Unary or Recursive Relationships.mp4    (4:15)
RDBMS 1.04 n-ary Relationships.mp4   (14:20)
RDBMS 1.05 Weak Entity Types and Identifying Relationships.mp4    (8:43)
RDBMS 1.06 Attributes of Relationships.mp4    (2:56)
  • Interpreting an ER diagram
 2. Data Modeling
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm
  • Converting ER diagrams to physical models
2/9 2. Data Modeling
Chapter 3: Data Modeling Using the ER Model
RDBMS 1.07a Converting an ER diagram to a Physical Model (part 1).mp4    (7:02)
RDBMS 1.07b Converting an ER diagram to a Physical Model (part 2).mp4   (14:11)
RDBMS 1.07c Converting an ER diagram to a Physical Model (part 3).mp4    (9:59)
RDBMS 1.07d Converting an ER diagram to a Physical Model (part 4).mp4   (12:18)
  • Converting ER diagrams to physical models
  • Ternary Relationships / Weak Entity Types
 2. Data Modeling (Review and Practice)
  • Modeling Section Tally
2/16 2. Data Modeling
Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations
RDBMS 1.08 The EER Diagram.mp4    (4:00)
RDBMS 1.09 Examining an EER Diagram.mp4    (9:23)
RDBMS 1.10 More about EER diagrams.mp4    (3:14)
RDBMS 1.11 Converting EER diagram to Physical Model.mp4   (16:00)
RDBMS 1.12 Union types.mp4   (12:42)
  • Interpreting an EER diagram
  • EER diagrams (w/inheritance)
  • Converting EER diagrams to physical models
 2. Data Modeling (Review and Practice)
  • Modeling sample problems with Generative AI
2/23
SQL Review
  • Basic SQL: Videos 1.xx
  • Multi-table SQL: Videos 2.xx
  • Aggregation: Videos 3.xx
  • Views: Videos 4.xx
  • Using MySQL Workbench
  • Planning for the project
3/2 5. Database Programming
    Procedures, Functions, Triggers
Chapter 10: Introduction to SQL Programming Techniques
7. NoSQL, CAP Theorem,
    Intro to MongoDB
Chapter 24: NoSQL DBs and Big Data Storage Systems
3/16 Spring Break
3/30 9. Normalization
    3NF to BCNF
RDBMS 2.06 3rd Normal Form.mp4   (11:45)
RDBMS 2.07 Practicing 3rd Normal Form.mp4    (9:46)
RDBMS 2.08 Boyce-Codd Normal Form.mp4   (13:00)
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB		 9. Normalization
    BCNF, higher forms
RDBMS 2.09 Higher Normal Forms.mp4   (10:54)
4/6 9. Normalization
    Funct. Dependencies, 1NF, 2NF
RDBMS 2.01 Functional Dependencies.mp4    (9:30)
RDBMS 2.02 Why Normalize.mp4   (15:53)
RDBMS 2.03 1st Normal Form.mp4   (12:56)
RDBMS 2.04 2nd Normal Form defined.mp4   (11:06)
RDBMS 2.05 Practicing 2nd Normal Form.mp4    (9:43)
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB		 9. Normalization
    Intro to Funct. Dependencies
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
4/13 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

 12. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design
4/20 TBD
4/27
  • Project-Review (41)
  • Project-Review (45)
  • Project-Review (46)
  • Project-Review (47)
5/4
  • Project-Review (42)
  • Project-Review (43)
  • Project-Review (44)