Data modeling and Relational database design
3.9 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled

Data modeling and Relational database design

Use Oracle SQL Data modeler for Data modeling and Database design. Professional approach to design and maintain Database
3.9 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled
Last updated 1/2019
English
English [Auto-generated]
Current price: $10.99 Original price: $74.99 Discount: 85% off
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Process Models - Understand and develop business process models( data flow diagrams) through Oracle SQL modeler.
  • Logical Models - Easily understand and create Entity relationship Diagram through Oracle SQL Modeler

  • Relationship - One to Many, Many to Many, Recursive relationship

  • Database Normalization with Examples - 1st, 2nd and 3rd form of Normalization
  • Use Oracle SQL data modeler to effective creative Process models, Logical data models and Relational data model
  • How to Use SQL data modeler tool to engineer Relational Data model and auto generate DDL scripts
  • Work with design rules that can be applied to check and enforce the integrity
Course content
Expand all 26 lectures 02:50:53
+ Downloading SQL Data modeler
1 lecture 02:58
Downloading and using SQL Data modeler
02:58
+ An overview about Data modelling and Data base design
3 lectures 19:24
introduction to Data modelling and Database design
10:09
Navigation overview of Oracle SQL Data Modeler
04:51
Quiz 1
2 questions
+ Oracle SQL Modeler - Process Model - Data flow diagram
5 lectures 36:52
Process Model - Data flow diagram - overview presentation
07:20
Process Model - Data flow diagram - Demonstration 1
12:26
Process Model - Data flow diagram - Demonstration 2
05:34
Case lite - Process Model - Data flow diagram
02:35
Case lite - Process Model - Data flow diagram - solution
08:57
Quiz 2
2 questions
+ Oracle SQL Modeler - Logical Model - ERD
6 lectures 43:48
Entity Relationship Diagram - Overview presentation - Part 1
07:01
Entity Relationship Diagram - Overview presentation - Part 2
06:34
SQL Modeler - Logical Model - Navigation overview
04:43
SQL Modeler - Logical Model - ERD - Demonstration - Part1
13:04
SQL Modeler - Logical Model - ERD - Demonstration - Part2
06:12
SQL Modeler - Subview
06:14
+ Database Design- Normalization
4 lectures 28:30
Database design through Normalization overiew
10:00
First form of Normalization
04:16
Second form of Normalization
06:13
Third form of Normalization
08:01
+ Other SQL Data Modeler features
3 lectures 12:40
Business information
05:01
Design rules - Validation
05:07
Others features in SQL DataModeler
02:32
Requirements
  • SQL Data Modeler - The course provides details as how to use the tool
  • Basic understanding of Database.
Description

Modern database and applications development software is so easy to use that  many  people  can  quickly  learn  to   implement  a  simple  database  and  develop  simple  applications  within  a  week  or  so,  without  giving  design  much thought. As data volume grows and when users request addition functionality, they might incorrectly add columns in table since appropriate database design is not available. This  not only causes data redundancy in database but also can cause performance issue to application and database as well. Ultimately, due to poor database design, the business would be the loser.

A good database design not only avoids data redundancy but also improves database performance over period of time as the database volume grows and when business changes are requested , it would be far more easier to understand as where to make the appropriate changes in the Database. The data modelling and database design is like a building blue print and ultimately it would  make application users happy and business would benefit.

This course uses the Oracle SQL Data modeler extensively to discuss and demonstrate  Database modelling  and Database design.

Oracle SQL Data modeler is a tool, which make learning Data modelling and Database design much easier and also provides you with  a professional approach design database for business application effectively to plan, develop, implement and maintain them on an ongoing process.

In this course you would learn:

  • Process Modelling

    • Develop a Data Flow Diagram by identifying processes, external agents, information stores and information flows that show how the information flows  Business flow Diagram

  • Logical Model

    • Create an Entity Relationship Diagram by identifying entities, attributes, relationships.

    • Normalize the Entity Relationship Diagram to third Normal form


  • Relational Model

    • Validate  Logical and Relational Model through Design rules

    • Engineer the Entity Relationship Model into an relational database design

    • Complete the Physical Model and generate the DDL scripts

Finally, at the end of the course, you would understand the importance of data modelling and database design.

Happy Learning!!


Who this course is for:
  • Computer science students who wants to learn data modeling and data base design
  • System Analyst
  • Database designers
  • Application Developer
  • Database administrator