Database Design and Management

Database Design and Management

Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.

  • 14 lectures
  • 2+ hours of quality videos
  • Access on the go
  • Conducted by Visual Paradigm
  • All for FREE
  • Join for FREE!

Training Overview

Database Design and Management is tailor-made for software development teams who need to develop application or software system that require data persistence. There are altogether 14 lectures with more than 2 hours of quality videos. All lectures come with clear voice-over as well as demonstrations to walk you through different tools step by step. We are sure you can master database design and management skills with ease and learn most key features in Visual Paradigm after attending the lectures.

The lectures cover a wide range of contents. Firstly, you will start by an introduction of database design, with description of ERD, entity and column. After gaining a better knowledge about ERD, you can then jump to keys, relationships, database view, triggers and stored procedures. This course also covers database management skills like the generation of database from ERD, database patching and reverse engineering of ERD. Developers may want to study the lecture about ORM for system development with database. Last but not least, the training introduces some best practices in database design and management, as well as the usage of data specification.

Once you have completed this online training, you will know how to design database productively and effectively.

Curriculum

Section 1: Introduction to Database Design and Management

  • Lecture 1: Introduction
  • Lecture 2: Entity and Column
  • Lecture 3: Entity in Detail
  • Lecture 4: Column in Detail
  • Lecture 5: The Three-Levels of ER Model
  • Lecture 6: Key and Relationship
  • Lecture 7: Database View
  • Lecture 8: Triggers and Stored Procedures

Section 2: Database Engineering

  • Lecture 9: Generate Database
  • Lecture 10: Patch Database
  • Lecture 11: Reverse Database to ERD

Section 3: Java Database Programming

  • Lecture 12: Hibernate

Section 4: Best Practices

  • Lecture 13: Database Design Best Practices
  • Lecture 14: Generate Data Specification