Concepts & Conceptual Design

Beginner
  • 12 Videos | 1h 6m 26s
  • Includes Assessment
  • Earns a Badge
Likes 298 Likes 298
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

COURSE Creating a Conceptual Design
Likes 90 Likes 90  
BOOK RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
CHANNEL Architecting Data
Likes 77 Likes 77  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Secure Application Architecture & IAM
Likes 1981 Likes 1981  
COURSE Cloud Data Architecture: Data Management & Adoption Frameworks
Likes 59 Likes 59  
COURSE Normalization Concepts & Forms
Likes 186 Likes 186