jackmyers.info

Schedule for DB

Week of (Tues) Tuesday Thursday Assignments
9/6 1. Introduction to Databases
2. Data Modeling

Modeling our Movie Database and Using the MySQL Workbench Wizard

2. Data Modeling


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)

Chapter 3: Data Modeling Using the ER Model (n-ary relationships)
Read chapters 3, 4, 9
9/13 2. Data Modeling
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)
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)

Section Tally Modeling

Chapter 3: Data Modeling Using the ER Model (n-ary relationships)
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm
Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations

2. Data Modeling


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 an EER diagram to a Physical Model.mp4   (16:00)
RDBMS 1.12 Union types.mp4   (12:42)

MySQL Workbench: queries, table creation, data population, primary and foreign keys


Read chapters 5, 6
ASSIGNMENT DUE: 9/21

Baseball Modeling

A database is being constructed to keep track of the teams and games of a baseball sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make.
9/20 3. Keys, SELECT and inner joins
Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
3. SELECT, inner joins, variables

MySQL Workbench, Sakila and AdventureWorks queries


Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
Read chapter 10

PROJECT Part 1: Submission due 10/3;
Graded with final project.

Building a database for Research Papers
Create the tables and constraints for a citation management system. Populate the tables.

**ASSIGNMENT START
You can begin the SQL Self Study Assignment(s)

9/27 4. Database Programming
    Procedures/Functions/Triggers

Chapter 10: Introduction to SQL Programming Techniques
4. Database Programming
    PHP

Read chapter 7
TEST 1: Data Modeling
10/14 5. Adv. SQL: Outer Joins, UNIONS,

Section 7.1.6: Joined Tables in SQL and Outer Join

Joining Tables in Adventureworks

5. Advanced Queries:
    Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
PROJECT Part 2: Submission due ;
Graded with final project.

PHP — Research Paper System
10/11 6. Subqueries:
Sections 7.1.2: Nested Queries
6. Subqueries:
    Correlated Queries

Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE

Subqueries in AdventureWorks


**ASSIGNMENT END: Due
SQL Self Study Assignment(s)
10/18 7. NoSQL, CAP Theorem,
    Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems
7. MongoDB
TEST 2 take home
10/25 8. Normalization
    Intro to Funct. Dependencies

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
8. 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
Read chapter 14

ASSIGNMENT DUE: MongoDB
11/1 8. 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
8. Normalization
    BCNF, higher forms

RDBMS 2.09 Higher Normal Forms.mp4   (10:54)
Read chapter 29
11/8 TBD 9. Views
Section 29.6 Data Warehouse vs. Views
PROJECT Part 3: Graded with final project via appointment when completed.

Views, Materialized Views and Triggers
11/15 10. Performance: Indexes
Chapter 17: Indexing Structures for Files and Physical DB design
10. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design
Read chapter 17, 24
11/22 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
Read chapter 20
 
11/29 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
13. DB Security
Chapter 30: Database Security
Read chapter 30

ASSIGNMENT DUE : Neo4j database
12/1
12/13 Finals Week begins



Modified:
Preserve Security.mp4 2021-08-13 11:46 23M (8:33)