Logical & Physical Design

Beginner
  • 8 Videos | 56m 48s
  • Includes Assessment
  • Earns a Badge
Likes 106 Likes 106
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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 43 Likes 43  
Likes 379 Likes 379  
Likes 108 Likes 108