Logical & Physical Design

  • 8 Videos | 1h 18s
  • Includes Assessment
  • Earns a Badge
Likes 83 Likes 83
Learn about the physical database design phase, including transforming entities to tables and attributes to views, as well as implementing views and various types of indexes.

WHAT YOU WILL LEARN

  • determine the factors in selecting a DBMS for the physical database
    describe the physical database design phase
    transform entities to tables in the physical database design
    transform attributes to columns in the physical database design
  • implement views into a physical database
    implement indexes into a physical database - Clustered and Non-Clustered Indexes
    implement indexes into a physical database - Hash and Bitmap Indexes
    create a logical data model and implement the physical database

IN THIS COURSE

  • Playable
    1. 
    DBMS Selection
    6m 28s
    UP NEXT
  • Playable
    2. 
    Overview of the Physical Database Design Phase
    7m 18s
  • Locked
    3. 
    Transforming Entities to Tables
    5m 39s
  • Locked
    4. 
    Transforming Attributes to Columns
    6m 15s
  • Locked
    5. 
    Implementing Views
    5m 27s
  • Locked
    6. 
    Implementing Clustered and Non-Clustered Indexes
    8m 29s
  • Locked
    7. 
    Implementing Hash and Bitmap Indexes
    8m 29s
  • Locked
    8. 
    Exercise: Design the Logical and Physical Database
    8m 43s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 141 Likes 141  
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
COURSE SOLID & GRASP
Likes 3218 Likes 3218