Database Design and Management

Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.
4.5 (353 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
12,053 students enrolled
Free
Start Learning Now
  • Lectures 14
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course 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.

What are the requirements?

  • Basic software development concept
  • PC or OSX or Linux

What am I going to get from this course?

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

What is the target audience?

  • Database Engineer
  • Developer

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Database Design and Management
11: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.

07: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.

14: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.

17: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.

05: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.

18: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.

08: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.

07: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.

Section 2: Database Engineering
18: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.

07: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.

10: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).

Section 3: Java Database Programming
16: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.

Section 4: Best Practices
08: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.

08: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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Visual Paradigm, Design & Management Tool for Business IT System Development

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!

Ready to start learning?
Start Learning Now