jackmyers.info

Schedule for DB

Week of (Tues) Tuesday Thursday
9/2 1. Introduction to Databases
2. Data Modeling
  • Welcome and syllabus review
  • Modeling a movie database
  • Introduction to ER diagrams
 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
9/9 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
9/16 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
9/23 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
9/30 2. Data Modeling (Review and Practice)
  • Modeling sample problems with Generative AI
 3. Keys, SELECT and inner joins
Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
  • Using MySQL Workbench
10/7
4. Outer joins, UNIONs
Section 7.1.6: Joined Tables in SQL and Outer Join
  • Review of Modeling Exam
10/14 4. Outer joins, UNIONs
8. Subqueries
Section 7.1.6: Joined Tables in SQL and Outer Join
Sections 7.1.2: Nested Queries
  • Review of outer joins
  • Subqueries
 6. Aggregation and Windows Functions
    Aggregation Queries
Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
10/21 6. Aggregation and Windows Functions
8. Subqueries: Correlated Queries
Sections 7.1.3 - 7.1.4 : Correlated Queries
  • Raw data vs aggregate data
  • GROUP_CONCAT
  • Windows functions (Aggregate, Ranking)
 6. Aggregation and Windows Functions
10. Views
Sections 7.1.2: Nested Queries
  • Windows functions (Value)
  • Creating Views
  • Views for column/row security
  • Views for derived attributes
  • Views for encapsulation
10/28 5. Database Programming
    Procedures, Functions, Triggers
Chapter 10: Introduction to SQL Programming Techniques
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
11/4 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)
11/18 7. NoSQL, CAP Theorem,
    Intro to MongoDB
Chapter 24: NoSQL DBs and Big Data Storage Systems		 9. Normalization
    Intro to Funct. Dependencies
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
11/18 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j
11/25 12. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design		 Thanksgiving
12/2 13. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory		 13. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
12/9 14. DB Security
Chapter 30: Database Security		 Reading Day