Database Design and Management

Description

In this course, you will learn :

• ERD is used to create databases.
• Maintain the database in a productive and efficient manner.
• In database design, use Visual Paradigm.
• In database management, use Visual Paradigm.

Syllabus :

1. Introduction to Database Design and Management

• Entity and Column
• Entity in Detail
• Column in Detail
• The Three-Levels of ER Model
• Key and Relationship
• Database View
• Triggers and Stored Procedures

 

2. Database Engineering

• Generate Database
• Patch Database
• Reverse Database to ERD

 

3. Java Database Programming

• Hibernate

 

4. Best Practices

• Database Design Best Practices
• Generate Data Specification

Show more