Logical & Physical Design
Beginner
- 8 Videos | 56m 48s
- 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 databasedescribe the physical database design phasetransform entities to tables in the physical database designtransform attributes to columns in the physical database design
-
implement views into a physical databaseimplement indexes into a physical database - Clustered and Non-Clustered Indexesimplement indexes into a physical database - Hash and Bitmap Indexescreate 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.