Logical & Physical Design

Database    |    Beginner
  • 8 videos | 56m 48s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 169 users Rating 4.6 of 169 users (169)
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 28s
    Find out how to determine the factors in selecting a DBMS for the physical database. FREE ACCESS
  • 7m 18s
    After completing this video, you will be able to describe the physical database design process. FREE ACCESS
  • Locked
    3.  Transforming Entities to Tables
    5m 39s
    In this video, you will transform entities to tables in the physical database design. FREE ACCESS
  • Locked
    4.  Transforming Attributes to Columns
    6m 15s
    During this video, you will learn how to transform attributes into columns in the physical database design. FREE ACCESS
  • Locked
    5.  Implementing Views
    5m 27s
    In this video, you will learn how to implement views in a physical database. FREE ACCESS
  • Locked
    6.  Implementing Clustered and Non-Clustered Indexes
    8m 29s
    During this video, you will learn how to implement clustered and non-clustered indexes into a physical database. FREE ACCESS
  • Locked
    7.  Implementing Hash and Bitmap Indexes
    8m 29s
    Find out how to implement hash and bitmap indexes into a physical database. FREE ACCESS
  • Locked
    8.  Exercise: Design the Logical and Physical Database
    8m 43s
    In 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.

YOU MIGHT ALSO LIKE

Channel Construction
Journey Learn Design Thinking: Iteration
Channel SQL Database Development & Design
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Relational Database Concepts
Rating 4.4 of 649 users Rating 4.4 of 649 users (649)
Book Fundamental of Database Management System
Course SQL 2016 Tables
Rating 4.5 of 473 users Rating 4.5 of 473 users (473)