Data Concepts C

Module 1: Advanced SQL - Creating Tables

• 3.8.1 Data Definition Commands (pg. 360 - 366) [5 minutes]
• 3.8.2 Creating Table Structures (pg. 366 - 375) [10 minutes]

Module 2: Advanced SQL - Altering Tables

• 3.8.3 Alter Table Structures (pg. 375 - 378) [5 minutes]
• 3.8.4 Data Manipulation Commands (pg. 379 - 387) [10 minutes]

Module 3: Advanced SQL - Other Database Objects

• 3.8.5 Virtual Tables: Creating a View (pg. 387 - 391) [5 minutes]
• 3.8.6 Sequences (pg. 391 - 396) [5 minutes]
• 3.8.7 Procedural SQL (pg. 396 - 418) [15 minutes]
• 3.8.8 Embedded SQL (pg. 419 - 423) [5 minutes]

Module 4: Database Design

• 3.9.1 The Information System (pg. 440 - 441) [5 minutes]
• 3.9.2 The System Development Life Cycle (pg. 442 - 445) [5 minutes]
• 3.9.3 The Database Life Cycle (pg. 445 - 457) [15 minutes]
• 3.9.4 Conceptual Design (pg. 457 - 467) [10 minutes]
• 3.9.5 DBMS Software Selection (pg. 467) [5 minutes]
• 3.9.6 Logical Design (pg. 468 - 471) [5 minutes]
• 3.9.7 Physical Design (pg. 471 - 473) [5 minutes]
• 3.9.8 Database Design Strategies (pg. 473 - 474) [5 minutes]
• 3.9.9 Centralized versus Decentralized Design (pg. 474 - 476) [5 minutes]