Data Concepts A

Module 1: Concepts of Data, Information, and Databases

• 1.1.1 Why Databases? (pg. 3 - 4) [5 minutes]
• 1.1.2 Data versus Information (pg. 4 - 6) [5 minutes]
• 1.1.3 Introducing the Database (pg. 6 - 11) [10 minutes]
• 1.1.4 Why Database Design is Important (pg. 12 - 14) [5 minutes]
• 1.1.5 Evolution of File System Data Processing (pg. 15 - 18) [5 minutes]
• 1.1.6 Problems with File System Data Processing (pg. 18 - 21) [5 minutes]
• 1.1.7 Database Systems (pg. 21 - 28) [10 minutes]
• 1.1.8 Preparing for Your Database Professional Career (pg. 28 - 30) [5 minutes]
• 1.1.9 Unstructured Data [5 minutes]
• 1.1.10 Structured Data [5 minutes]

Module 2: Data Models

• 1.2.1 Data Modeling and Data Models (pg. 35) [5 minutes]
• 1.2.2 The Importance of Data Models (pg. 36) [5 minutes]
• 1.2.3 Data Model Basic Building Blocks (pg. 36 - 37) [5 minutes]
• 1.2.4 The Evolution of Data Models (pg. 40 - 54) [10 minutes]
• 1.2.5 Degree of Data Abstraction (pg. 54 - 60) [10 minutes]
• 1.2.6 Database Naming Conventions [5 minutes]
• 1.2.7 History of Databases [5 minutes]
• 1.2.8 XML [5 minutes]
• 1.2.9 JSON [5 minutes]
• 1.2.10 How to Create a Crow's Foot Diagram in Visio [5 minutes]

Module 3: Describe Relational Database Model

• 1.3.1 A Logical View of Data (pg. 69 - 72) [5 minutes]
• 1.3.2 Keys (pg. 72 - 76) [5 minutes]
• 1.3.3 Integrity Rules (pg. 76 - 77) [5 minutes]
• 1.3.4 Relational Algebra (pg. 78 - 87) [15 minutes]
• 1.3.5 The Data Dictionary and the System Catalog (pg. 87 - 89) [5 minutes]
• 1.3.6 Relationships within the Relational Database [10 minutes]
• 1.3.7 Data Redundancy Revisited (pg. 97 - 99) [5 minutes]
• 1.3.8 Indexes (pg. 99 - 100) [5 minutes]
• 1.3.9 Codd's Relational Database Rules (pg. 100 - 101) [5 minutes]

Module 4: Reproduce a Relational Database Model

• 1.4.1 The Entity Relationship Model (pg. 114 - 138) [20 minutes]
• 1.4.2 Developing an ER Diagram (pg. 138 - 146) [10 minutes]
• 1.4.3 Database Design Challenges: Conflicting Goals (pg. 146 - 149) [5 minutes]