Logical & Physical Design
Database
| 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 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
-
6m 28sFind out how to determine the factors in selecting a DBMS for the physical database. FREE ACCESS
-
7m 18sAfter completing this video, you will be able to describe the physical database design process. FREE ACCESS
-
3. Transforming Entities to Tables5m 39sIn this video, you will transform entities to tables in the physical database design. FREE ACCESS
-
4. Transforming Attributes to Columns6m 15sDuring this video, you will learn how to transform attributes into columns in the physical database design. FREE ACCESS
-
5. Implementing Views5m 27sIn this video, you will learn how to implement views in a physical database. FREE ACCESS
-
6. Implementing Clustered and Non-Clustered Indexes8m 29sDuring this video, you will learn how to implement clustered and non-clustered indexes into a physical database. FREE ACCESS
-
7. Implementing Hash and Bitmap Indexes8m 29sFind out how to implement hash and bitmap indexes into a physical database. FREE ACCESS
-
8. Exercise: Design the Logical and Physical Database8m 43sIn this video, learn how to create a logical data model and how to implement the physical database. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
