Database Design and Management

Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.
Free tutorial
Rating: 4.2 out of 5 (1,883 ratings)
63,820 students
Database Design and Management
Free tutorial
Rating: 4.2 out of 5 (1,883 ratings)
63,820 students
Design database with ERD
Maintain database productively and effectively
Use Visual Paradigm in database design
Use Visual Paradigm in database management

Requirements

  • Basic software development concept
  • PC or OSX or Linux
Description

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.

Who this course is for:
  • Database Engineer
  • Developer
Course content
4 sections • 14 lectures • 2h 41m total length
  • Introduction
    11:49
  • Entity and Column
    07:55
  • Entity in Detail
    14:14
  • Column in Detail
    17:00
  • The Three-Levels of ER Model
    05:22
  • Key and Relationship
    18:09
  • Database View
    08:09
  • Triggers and Stored Procedures
    07:55
  • Generate Database
    18:47
  • Patch Database
    07:51
  • Reverse Database to ERD
    10:03
  • Hibernate
    16:56
  • Database Design Best Practices
    08:41
  • Generate Data Specification
    08:24

Instructor
Design & Management Tool for Business IT System Development
Visual Paradigm
  • 4.2 Instructor Rating
  • 4,513 Reviews
  • 106,389 Students
  • 2 Courses

Visual Paradigm Training Team is formed by a group of software developers, with the core team members having over 15 years of experience in software development. We have extensive experience in software development, database design and requirements gathering. We fully understand what constitutes to the success of software development and we are honor to share our experiences with you. We believe that using online training is the most effective approach to share our experience and knowledge as well as to gather more people for self-learning.

If you are interested in designing and developing great software, Visual Paradigm is your choice! Visual Paradigm is the best of the breed software design product and Visual Paradigm Training Team will produce online training courses on many different topics, from capturing requirements to designing software and many other useful topics! Let’s check them out and enroll today!