- Learn how to design and manage database with ERD, database generation and reversal with Visual Paradigm.
- Free tutorial
- Rating: 4.8 out of 54.8 (2,358 ratings)
- 90,899 students
- 2hr 41min of on-demand video
- Created by Visual Paradigm
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
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
Show less
Course content
4 sections • 14 lectures • 2h 41m total lengthCollapse all sections
Introduction to Database Design and Management8 lectures • 1hr 31min
- Introduction11:49
- Entity and Column07:55
- Entity in Detail14:14
- Column in Detail17:00
- The Three-Levels of ER Model05:22
- Key and Relationship18:09
- Database View08:09
- Triggers and Stored Procedures07:55
Database Engineering3 lectures • 37min
- Generate Database18:47
- Patch Database07:51
- Reverse Database to ERD10:03
Java Database Programming1 lecture • 17min
- Hibernate16:56
Best Practices2 lectures • 17min
- Database Design Best Practices08:41
- Generate Data Specification08:24
