jackmyers.info

Schedule for DB

Week of Monday Wednesday Assignments
8/30 No school yet 1. Introduction to Databases
2. Data Modeling

Modeling our Movie Database in Access and Using the Query Wizard


Chapter 3: Data Modeling Using the ER Model
Read chapters 3, 4
ASSIGNMENT DUE: 1/27
Getting setup for class
9/6 Labor Day

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

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
Read chapter 9

ASSIGNMENT DUE: 2/5
Complete exercise 3.22 in the textbook. Upload your Chen-based ER diagram, a screen shot of the physical model from Access, the Access database you have created, and a Word file that states the assumptions you have made. For this exercise, you must use a Baseball team.
9/13 2. Data Modeling
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)
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)

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.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
9/27 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 2/17;
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)

10/4 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/11 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 3/2;
Graded with final project.

PHP — Research Paper System
10/18 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 3/9
SQL Self Study Assignment(s)
10/25 7. NoSQL, CAP Theorem,
    Intro to MongoDB

Chapter 24: NoSQL DBs and Big Data Storage Systems
7. MongoDB
TEST 2 take home
11/1 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: 3/30 MongoDB
11/8 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/15 No class 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/22 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/29 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
 
12/6 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 4/27: Neo4j database
12/13 Finals Week Finals Week



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