Description: This course covers how to complete a logical database design and how to implement the physical database. After the requirements are gathered from the organization and the conceptual ERD has been approved, you will learn that the logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. In this course, you will learn about identifying the entities, attributes, and the relationships that will exist and about normalizing the database to remove redundant information. You will also learn about creating tables, choosing columns and their specifications, and determining indexes and views.
Target Audience: People who want to get an understanding of the concepts and practices involved in designing relational databases
Duration: 03:00
Description: Database design is an important process for creating databases. In any organization, the process sets the foundation for good database implementation and ensures that everything required for the business is provided. It also ensures that the database will perform as expected for the users. In this course, you will learn how to design a database, including what database modeling and the design life cycle are. You will also learn how to meet the requirements for a database, how to analyze it, and how to work through the conceptual design phase.
Target Audience: People who want to get an understanding of the concepts and practices involved in designing relational databases
Duration: 02:13