Concepts & Conceptual Design

Database    |    Beginner
  • 12 videos | 1h 6m 26s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 241 users Rating 4.5 of 241 users (241)
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

  • 7m 13s
    After completing this video, you will be able to describe the logical data model used during the design process of a database. FREE ACCESS
  • 7m 2s
    Upon completion of this video, you will be able to describe the physical data model that is used during the design process of a database. FREE ACCESS
  • Locked
    3.  Database Design Methodology
    7m 8s
    After completing this video, you will be able to describe the design methodology and outline the characteristics of a well-designed database. FREE ACCESS
  • Locked
    4.  Data Modeling
    8m 23s
    In this video, you will learn how to use data modeling to represent real-world concepts. FREE ACCESS
  • Locked
    5.  Three-schema Database Architecture (Part 1)
    6m 24s
    After completing this video, you will be able to describe the three-schema database architecture. FREE ACCESS
  • Locked
    6.  Three-schema Database Architecture (Part 2)
    5m 40s
    After completing this video, you will be able to describe the three-schema database architecture and data independence provisioning. FREE ACCESS
  • Locked
    7.  The Database Design Life Cycle (Part 1)
    3m 23s
    Upon completion of this video, you will be able to describe the first two phases of the database design life cycle. FREE ACCESS
  • Locked
    8.  The Database Life Cycle (Part 2)
    7m 8s
    After completing this video, you will be able to describe the last two phases of the database design life cycle. FREE ACCESS
  • Locked
    9.  Requirements Gathering and Analysis Overview
    3m 47s
    Find out how to identify the objectives for gathering information for the requirements of the database design phase. FREE ACCESS
  • Locked
    10.  Information Gathering Techniques (Part 1)
    2m 18s
    After completing this video, you will be able to describe the different techniques used for requirements gathering when designing a database. FREE ACCESS
  • Locked
    11.  Information Gathering Techniques (Part 2)
    4m 4s
    Learn how to identify the advantages and disadvantages of the techniques used to conduct interviews for database design. FREE ACCESS
  • Locked
    12.  Planning and Performing the Interviews
    3m 58s
    In this video, you will identify the factors, types of questions, and who the interviewees will include when planning the interviews for database design. 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

Course CompTIA IT Fundamentals: Database Concepts
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)
Course Database Fundamentals: Database Concepts
Rating 4.4 of 503 users Rating 4.4 of 503 users (503)
Course CompTIA Data+: Understanding Databases
Rating 4.8 of 44 users Rating 4.8 of 44 users (44)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Azure Data Fundamentals: Modern Data Warehousing
Rating 4.3 of 63 users Rating 4.3 of 63 users (63)
Course Agile Software Projects: Software Requirements
Rating 4.4 of 223 users Rating 4.4 of 223 users (223)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)