Relational Database Design Essentials Course
Learn to use Oracle SQL Data Modeler extensively to discuss and demonstrate database modeling and database design
Updated on Jun, 2025
Language - English
Development ,Database and Design Development,DBMS
Lectures -28
Resources -1
Duration -2.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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 additional functionality, they might incorrectly add columns in the table since the appropriate database design is not available. This not only causes data redundancy in the database but also can cause performance issues to the 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 a period of time as the database volume grows, and when business changes are requested, it would be far easier to understand where to make the appropriate changes in the database. The data modelling and database design is like a building blueprint, and ultimately it would make application users happy and businesses would benefit.
This course uses the Oracle SQL Data Modeler extensively to discuss and demonstrate database modeling and database design.
Oracle SQL Data Modeler is a tool that makes learning data modelling and database design much easier and also provides you with a professional approach to designing databases for business applications effectively to plan, develop, implement, and maintain them as an ongoing process.
In this course, you'll 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, and relationships.
- Normalize the Entity Relationship Diagram to the third Normal form.
Relational Model
- Validate Logical and Relational models through Design rules.
- Engineer the Entity-Relationship Model into a relational database design.
- Complete the Physical Model and generate the DDL scripts.
Finally, at the end of the course, you will understand the importance of data modelling and database design.
Happy Learning!!
Goals
- Process Models: Understand and develop business process models (data flow diagrams) through Oracle SQL Modeler.
- Logical Models: Easily understand and create Entity-relationship Diagrams 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 create effective creative Process models, logistical data models and Relational data models.
- How to Use SQL Data Modeler tool to engineer Relational Data models and auto-generate DDL scripts.
- Work with design rules that can be applied to check and enforce integrity.
Prerequisites
- Basic understanding of relational databases and their objects like tables, views, etc.
- Oracle SQL Data Modeler: The course provides details on how to use the tool.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction about the course
2 Lectures
-
Introduction
04:55
04:55
-
Course Overview
04:19
04:19
Oracle SQL Data Modeler
1 Lectures
Data Modeling and Data Base Design
3 Lectures
Process Model - Data Flow diagram using Oracle SQL Modeler
5 Lectures
Logical Model - ERD using Oracle SQL Modeler
6 Lectures
Relational Database - Normalization Process
4 Lectures
Logical to Relational Model with DDL scripts using Oracle SQL modeler
3 Lectures
Other Important features of SQL modeler
3 Lectures
Instructor Details
Guha Rajan M., B.Engg, MBA
Having over 25 + years of IT industry experience (Product development, Consulting & Training).
His last engagement was with Oracle India (initially with consulting and then with Oracle university) , which was for more than 12 years. Prior to this, had worked with Cap Gemini (formerly iGate Global Solution), GE to name a few.
Had managed projects and programs in Enterprise Resource Planning and Business Intelligence implementations in the range of 3000 man days with revenue about 6mil US$ per year. These projects are on industry domains, such as Oil and Gas, Process Manufacturing, Hi-Tech Retail & Telecom across the globe.
Was awarded with "pace setter" , "best managed " project awards in recognition of efforts in project management.
He was also instrumental in design, development and roll-out of Graduate Hire program on Oracle Products stack for partner IT services companies in recent times.
Right from college was fascinated about devices and sensor interaction with computer, which made him focus on micro-controller in early 90's and that eventually attracted him towards field of ERP, BI , Cloud technologies - Saas, Iaas, Paas, Internet of things, Machine learning, AI and open source software tools these days.
Due to his vast experience, he has crafted varied unique courses in Tutorialspoint related project management, Internet of things, ERP & BI, Database modeling and design, SQL, Linux and more importantly on Cloud Infrastructure. Has plans to create more, as his passion has been on knowledge acquisition and sharing.
He is certified as
Oracle Financials Business Process Certified Foundations Associate
Oracle Cloud Infrastructure 2021 Architect Professional.
Oracle Cloud Infrastructure 2021 Architect Associate.
Oracle Cloud Infrastructure 2021 Cloud Operations Associate.
Oracle Cloud Infrastructure Security 2021 Certified Associate
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Machine Learning using Autonomous Database 2021 Certified Specialist
Also certified in Python, IOT by NPTEL (Govt of India ) 2018.
He holds a degree in engineering (Computer science) with MBA
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now