Logical & Physical Design
8 Videos | 1h 18s - Includes Assessment
- Earns a Badge
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
-
1.DBMS Selection6m 28sUP NEXT
-
2.Overview of the Physical Database Design Phase7m 18s
-
3.Transforming Entities to Tables5m 39s
-
4.Transforming Attributes to Columns6m 15s
-
5.Implementing Views5m 27s
-
6.Implementing Clustered and Non-Clustered Indexes8m 29s
-
7.Implementing Hash and Bitmap Indexes8m 29s
-
8.Exercise: Design the Logical and Physical Database8m 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.
