Database Design and Management

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

Created byVisual Paradigm

Last updated 6/2016

English

What you'll learn

Design database with ERD
Maintain database productively and effectively
Use Visual Paradigm in database design
Use Visual Paradigm in database management

Course content

4 sections • 14 lectures • 2h 41m total length

Introduction11:49
Database is an integral part of information system. Knowing database design is the blueprint of database, the better the design, the better the performance of your database, thus the system. In this lecture you will learn what database design is and why it is important. The content of this training course will also be covered.
Entity and Column7:55
Database can be designed by drawing Entity Relationship Diagram (ERD). A typical ERD is formed by entities and each entity consists of a set of columns that represent the properties of that entity. In this lecture you will be given an introduction of entity and column. You will also learn how to draw entities and add columns into entities, in Visual Paradigm.
Entity in Detail14:14
When it comes to documenting database design or to construct database from database design, you need to specify a lot more details for your entities instead of just providing simple names and description. In this lecture we will go through the properties you can set for entities.
Column in Detail17:00
As said earlier, to document database design or to construct database from database design require detailed specification of entities and columns. In the previous lecture we have gone through the properties that you can for entity. In this lecture we will talk about the properties that you can set for columns.
The Three-Levels of ER Model5:22
There are three levels of entity-relationship model – Conceptual, Logical and Physical. While conceptual and logical model are primarily used in discussing requirements, the physical model is used in database construction and maintenance. In this lecture we will go through the three levels in detail. We will talk about the differences between these levels by providing you with some samples.
Key and Relationship18:09
In ERD, 'key' can be used for identifying records. There are several kinds of keys. A primary key is a column for uniquely identifying a record within a database table, while a foreign key is for identifying a record referenced from another table. In this lecture you will learn what a key is and how to create keys in your database design. We will also talk about the factors to consider when choosing a column to be the key column.
Database View8:09
Database view is a virtual table that provides the result set of a pre-established query command. In this lecture we will introduce the concept of database view, how to create database view in Visual Paradigm and the various tips in defining a view, say, to use join and filter in database view.
Triggers and Stored Procedures7:55
Database triggers and stored procedures are two well-known techniques in database management. You can use database trigger to define procedures that will be automatically executed in response to certain events on a database table, and to define stored procedure for quick validation and retrieval of data. In this lecture you will learn the concept of both database trigger and stored procedure. You will learn how the benefits of using them in database management, as well as the steps you need to take to create them in Visual Paradigm.

Generate Database18:47
We don't design database just for the sake of designing. In the end, we will create a real database for use in system development and at that moment, database design can let you know what entities and columns should be created. Instead of reading the design and creating database manually, Visual Paradigm features database generation from ERD. In this lecture we will walk you through the steps as well as the configuration options you can set for database generation.
Patch Database7:51
Information systems keep changing at all time. Very often, those changes will lead to a change in database structure. In order to introduce a new database structure you cannot just throw away the previous one and re-create a new one simply because your database contains production data and you need to keep it, and to make sure it is intact throughout the process of changing. Visual Paradigm features database patching, which helps you patch design changes onto a running database. In this lecture we will introduce the concept of database patching and show you how to do this in Visual Paradigm.
Reverse Database to ERD10:03
To maintain or to migrate a legacy database is never an easy job, especially when there is a lack of documentation. In Visual Paradigm you can make use of the reverse engineering feature to reverse engineer your ERD from database. With this feature you can produce ERD from a legacy database, examine the design, make changes carefully and patch the changes back to the database. In this lecture you will learn how the reverse engineering of ERD works. We will cover both to reverse a database, and to reverse from a Data Definition File (DDL file).

Hibernate16:56
Programming language like Java is object-oriented, which represent data as interconnected graph of objects. But in the relational word, data is represented in tabular format (like a spreadsheet). Due to the mismatch between object model and relational model, data persistence is difficult. In order to solve this problem, you can make use of Hibernate, which is an object-relational mapping (ORM) library for use in data retrieval when developing application. In this lecture we will introduce Hibernate to you, as well as to explain the idea of mapping between ERD and UML class diagram. Finally we will show you how to generate ORM code from Visual Paradigm.

Database Design Best Practices8:41
The typical approach of database management lacks control of database structure. It is not efficient and may introduce a lot of problems and overheads. Visual Paradigm suggest a number of approaches that make database management both efficient and safe. In this lecture we will talk about them one by one.
Generate Data Specification8:24
Data spec. can be helpful in communication database design ideas. It also gives development a guide to follow when building a system. In this lecture you will learn how to generate a data spec. from your database design. We will also talk about the use of Word template in detail.

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

Database Design and Management

What you'll learn

Explore related topics

Course content

Introduction to Database Design and Management8 lectures • 1hr 31min

Database Engineering3 lectures • 37min

Java Database Programming1 lecture • 17min

Best Practices2 lectures • 17min

Requirements

Description

Who this course is for: