Data modeling and Relational database design

Data modeling and Relational database design, available at $39.99, has an average rating of 3.8, with 28 lectures, 4 quizzes, based on 67 reviews, and has 327 subscribers.

You will learn about 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 This course is ideal for individuals who are Computer science students who wants to learn data modeling and data base design or System Analyst or Database designers or Application Developer or Database administrator It is particularly useful for Computer science students who wants to learn data modeling and data base design or System Analyst or Database designers or Application Developer or Database administrator.

Enroll now: Data modeling and Relational database design

Summary

Title: Data modeling and Relational database design

Price: $39.99

Average Rating: 3.8

Number of Lectures: 28

Number of Quizzes: 4

Number of Published Lectures: 28

Number of Published Quizzes: 4

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: ?5,900

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Computer science students who wants to learn data modeling and data base design

System Analyst

Database designers

Application Developer

Database administrator

Target Audiences

Computer science students who wants to learn data modeling and data base design

System Analyst

Database designers

Application Developer

Database administrator

                    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!!

Course Curriculum

Chapter 1: Course Overview

Lecture 1: Course Overview

Chapter 2: Using SQL Data modeler

Lecture 1: Using SQL Data modeler

Chapter 3: An overview about Data modelling and Data base design

Lecture 1: Why Data modelling and Data base design are important?

Lecture 2: introduction to Data modelling and Database design

Lecture 3: Navigation overview of Oracle SQL Data Modeler

Chapter 4: Oracle SQL Modeler – Process Model – Data flow diagram

Lecture 1: Process Model – Data flow diagram – overview presentation

Lecture 2: Process Model – Data flow diagram – Demonstration 1

Lecture 3: Process Model – Data flow diagram – Demonstration 2

Lecture 4: Case lite – Process Model – Data flow diagram

Lecture 5: Case lite – Process Model – Data flow diagram – solution

Chapter 5: Oracle SQL Modeler – Logical Model – ERD

Lecture 1: Entity Relationship Diagram – Overview presentation – Part 1

Lecture 2: Entity Relationship Diagram – Overview presentation – Part 2

Lecture 3: SQL Modeler – Logical Model – Navigation overview

Lecture 4: SQL Modeler – Logical Model – ERD – Demonstration – Part1

Lecture 5: SQL Modeler – Logical Model – ERD – Demonstration – Part2

Lecture 6: SQL Modeler – Subview

Chapter 6: Database Design- Normalization

Lecture 1: Database design through Normalization overiew

Lecture 2: First form of Normalization

Lecture 3: Second form of Normalization

Lecture 4: Third form of Normalization

Chapter 7: Logical to Relational model and DDL scripts through SQL Datamodeler

Lecture 1: Engineer Logical to Relational model through SQL modeler

Lecture 2: DDL script creation and execution in Oracle DB

Lecture 3: Importing Database Datamodel Structure

Chapter 8: Other SQL Data Modeler features

Lecture 1: Business information

Lecture 2: Design rules – Validation

Lecture 3: Others features in SQL DataModeler

Chapter 9: Cloud based Data modeler on OCI – Oracle Autonomous Database : An Overview

Lecture 1: Cloud based Data modeler on OCI – Oracle Autonomous Database – An Overview

Chapter 10: Learn SQL in a easy way – without any installs

Lecture 1: Learning SQL is easy and fun through LiveSQL

Instructors

Guha Rajan M., B.Engg, MBA
Founder and CEO – Capstone Solutions, Trainer

Rating Distribution

1 stars: 7 votes

2 stars: 4 votes

3 stars: 20 votes

4 stars: 21 votes

5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!