Concepts & Conceptual Design

  • 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

CHANNEL Systems Engineering
Likes 23 Likes 23  
COURSE Traditional Data Architectures: Relational Databases
Likes 0 Likes 0  
CHANNEL Architecting Data
Likes 58 Likes 58  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Architecture Getting Started
Likes 214 Likes 214  
COURSE Models & Applications
Likes 34 Likes 34  
COURSE SQL & Concurrency Concepts
Likes 79 Likes 79