Concepts & Conceptual Design

Beginner
  • 12 Videos | 1h 6m 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

BOOK Database Design and Relational Theory: Normal Forms and All That Jazz, Second Edition
JOURNEY Delighting Customers with Design Thinking
Likes 139 Likes 139  
COURSE Creating a Conceptual Design
Likes 90 Likes 90  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Cloud Data Architecture: Data Management & Adoption Frameworks
Likes 59 Likes 59  
COURSE Logical & Physical Design
Likes 106 Likes 106  
COURSE Models & Applications
Likes 43 Likes 43