Concepts & Conceptual Design

Beginner
  • 12 Videos | 1h 12m 26s
  • Includes Assessment
  • Earns a Badge
Likes 141 Likes 141
Good database design sets the foundation for database implementation and ensures business requirements can be met. Learn how to design a database, including database modeling, the design life cycle, and requirements.

WHAT YOU WILL LEARN

  • describe the logical data model that is used during the design process of a database
    describe the physical data model that is used during the design process of a database
    describe the design methodology and outline the characteristics of a well-designed database
    use data modeling to represent real-world concepts
    describe the three-schema database architecture
    describe the three-schema database architecture mappings and data independence provisioning
  • describe the first two phases of the database design life cycle
    describe the last two phases of the database design life cycle
    identify the  objectives for gathering information for the requirements of the database design phase
    describe the different techniques used for requirements gathering when designing a database
    identify the advantages and disadvantages of the techniques used to conduct interviews for database design
    identify the factors, types of questions, and who the interviewees will include when planning the interviews for database design

IN THIS COURSE

  • Playable
    1. 
    Overview of the Logical Data Model
    7m 13s
    UP NEXT
  • Playable
    2. 
    Overview of the Physical Data Model
    7m 2s
  • Locked
    3. 
    Database Design Methodology
    7m 8s
    FREE ACCESS
  • Locked
    4. 
    Data Modeling
    8m 23s
    FREE ACCESS
  • Locked
    5. 
    Three-schema Database Architecture (Part 1)
    6m 24s
    FREE ACCESS
  • Locked
    6. 
    Three-schema Database Architecture (Part 2)
    5m 40s
    FREE ACCESS
  • Locked
    7. 
    The Database Design Life Cycle (Part 1)
    3m 23s
    FREE ACCESS
  • Locked
    8. 
    The Database Life Cycle (Part 2)
    7m 8s
    FREE ACCESS
  • Locked
    9. 
    Requirements Gathering and Analysis Overview
    3m 47s
    FREE ACCESS
  • Locked
    10. 
    Information Gathering Techniques (Part 1)
    2m 18s
    FREE ACCESS
  • Locked
    11. 
    Information Gathering Techniques (Part 2)
    4m 4s
    FREE ACCESS
  • Locked
    12. 
    Planning and Performing the Interviews
    3m 58s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

JOURNEY Delighting Customers with Design Thinking
Likes 74 Likes 74  
COURSE Database Design Fundamentals
Likes 74 Likes 74  
COURSE Microsoft Azure Architect Design: Azure Database Solution Design
Likes 19 Likes 19  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Logical & Physical Design
Likes 106 Likes 106  
COURSE Creating a Conceptual Design
Likes 90 Likes 90  
COURSE Data Architecture Getting Started
Likes 214 Likes 214