jackmyers.info

Schedule for DB

A Testable B Concept You'll Need to Use C For Your Benefit

Week of (Tues)

Tuesday

Thursday

9/1

Welcome / Syllabus
Intro to ER diagrams
Splitting into multiple tables
NoSQL vs SQL

Lesson 13 - Transactions.pptx

Transactions	Track 1: A Track 2: B
ACID	Track 1: A Track 2: B

9/8

Lesson 13 - Transactions.pptx
Lesson A - Database Concepts.pptx

Isolation Levels	Track 1: A Track 2: B
CAP Theorem	Track 1: C Track 2: A

Lesson R - Redis.pptx

Redis

Track 1: C Track 2: A

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)
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)

9/15

Lesson 02 - Data Modeling.pptx

Redis demo	Track 1: C Track 2: A
ER Modeling	Track 1: A Track 2: C

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)

Lesson 02 - Data Modeling.pptx

ER Modeling: Logical to Physical	Track 1: A Track 2: C
EER Modeling	Track 1: A Track 2: C

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)

9/22

9/29

10/6

10/13

11/3

11/10

11/17

11/24

Thanksgiving

12/1

12/8

Final Exams

12/15

Final Exams

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

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

7. NoSQL, CAP Theorem,
Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems

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

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

11/18

11/25

11. NoSQL: Neo4j a Graph DB

Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

Thanksgiving

12/2

TBD

Stock Market (36)
Weather (37)

12/9

Bakery (31)
Shopping "Amazon for dummies" (35)

Reading Day

12/16

Casino (32)
E! Hollywood Celebrity Events (33)
Gaming Characters (34)