Data Concepts B

Module 1: Advanced Data Modeling

2.5.1 The Extended Entity Relationship Model (pb. 168 - 175) [5 minutes]
2.5.2 Entity Clustering (pg. 175 - 176) [5 minutes]
2.5.3 Entity Integrity: Selecting Primary Keys (pg. 176 - 180) [5 minutes]
2.5.4 Design Cases: Learningn Flexible Database Design (pg. 180 - 186) [5 minutes]

2.6.1 Database Tables and Normalization (pg. 200) [5 minutes]
2.6.2 The Need for Normalization (pg. 200 - 203) [5 minutes]
2.6.3 The Normalization (pg. 203 - 209) [5 minutes]
2.6.4 Improving the Design (pg. 213 - 217) [5 minutes]
2.6.5 Surrogate Key Considerations (pg. 217 - 218) [5 minutes]
2.6.6 Higher-Level Normal Forms (pg. 218 - 224) [5 minutes]
2.6.7 Normalization and Database Design (pg. 213 - 217) [5 minutes]
2.6.8 Denormalization (pg. 227 - 230) [5 minutes]
2.6.9 Data-Modeling Checklist (pg. 230 - 231) [5 minutes]

2.7.1 Introduction to SQL (pg. 245 - 248) [5 minutes]
2.7.2 Basic SELECT Queries (pg. 249 - 250) [5 minutes]
2.7.3 SELECT Statement Options (pg. 250 - 256) [5 minutes]
2.7.4 FROM Clause Options (pg. 256 - 266) [10 minutes]
2.7.5 ORDER BY Clause Options (pg. 266 - 268) [5 minutes]
2.7.6 WHERE Clause Options (pg. 269 - 281) [10 minutes]

2.7.7 Aggregate Processing (pg. 281 - 290) [10 minutes]
2.7.8 Subqueries (pg. 290 - 301) [10 minutes]
2.7.9 SQL Functions (pg. 302 - 310) [10 minutes]
2.7.10 Relational Set Operators (pg. 311 - 316) [5 minutes]
2.7.11 Crafting SELECT Queries (pg. 317 - 319) [5 minutes]