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
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 DiagramLogical Model Create an Entity Relationship Diagram by identifying entities, attributes, relationships. Normalize the Entity Relationship Diagram to third Normal formRelational 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 scriptsFinally, at the end of the course, you would understand the importance of data modelling and database design.Happy Learning!!
Overview
Section 1: Course Overview
Lecture 1 Course Overview
Section 2: Using SQL Data modeler
Lecture 2 Using SQL Data modeler
Section 3: An overview about Data modelling and Data base design
Lecture 3 Why Data modelling and Data base design are important?
Lecture 4 introduction to Data modelling and Database design
Lecture 5 Navigation overview of Oracle SQL Data Modeler
Section 4: Oracle SQL Modeler - Process Model - Data flow diagram
Lecture 6 Process Model - Data flow diagram - overview presentation
Lecture 7 Process Model - Data flow diagram - Demonstration 1
Lecture 8 Process Model - Data flow diagram - Demonstration 2
Lecture 9 Case lite - Process Model - Data flow diagram
Lecture 10 Case lite - Process Model - Data flow diagram - solution
Section 5: Oracle SQL Modeler - Logical Model - ERD
Lecture 11 Entity Relationship Diagram - Overview presentation - Part 1
Lecture 12 Entity Relationship Diagram - Overview presentation - Part 2
Lecture 13 SQL Modeler - Logical Model - Navigation overview
Lecture 14 SQL Modeler - Logical Model - ERD - Demonstration - Part1
Lecture 15 SQL Modeler - Logical Model - ERD - Demonstration - Part2
Lecture 16 SQL Modeler - Subview
Section 6: Database Design- Normalization
Lecture 17 Database design through Normalization overiew
Lecture 18 First form of Normalization
Lecture 19 Second form of Normalization
Lecture 20 Third form of Normalization
Section 7: Logical to Relational model and DDL scripts through SQL Datamodeler
Lecture 21 Engineer Logical to Relational model through SQL modeler
Lecture 22 DDL script creation and execution in Oracle DB
Lecture 23 Importing Database Datamodel Structure
Section 8: Other SQL Data Modeler features
Lecture 24 Business information
Lecture 25 Design rules - Validation
Lecture 26 Others features in SQL DataModeler
Section 9: Learn SQL in a easy way - without any installs
Lecture 27 Learning SQL is easy and fun through LiveSQL
Computer science students who wants to learn data modeling and data base design,System Analyst,Database designers,Application Developer,Database administrator
Homepage

https://www.udemy.com/course/data-modelling-and-relational-database-design/