Introduction to Oracle SQL Developer Data Modeler ERDs | Logical & Relational Diagrams
This video is a simple introduction to Oracle SQL developer data modeler.
0:00 Introduction
0:19 Install Oracle SQL developer data modeler on Mac
0.28 Install Oracle SQL developer data modeler on Windows
1:48 Creating a new design in Oracle SQL developer data modeler
2:17 Simple library scenario to create an ERD
3:28 Data dictionary
3:34 Tools on the interface of Oracle SQL developer data modeler
4:07 Drawing a logical model in Oracle SQL developer data modeler
4:14 Adding attributes to entities to create an entity relationship diagram
6:46 Adding relationships to the entities
8:44 Converting a logical model to the relational model in Oracle SQL developer data modeler
9:05 Generate DDL script in Oracle SQL developer data modeler
You will be shown how to create entity relationship diagrams using the modeler. You will create a logical model which can be converted into a relational model. You will also be shown how you can automatically generate DDL scripts for these models.
This video will show you how to install Oracle SQL developer data modeler on Windows. The Oracle SQL developer data modeler download link is:
www.oracle.com/tools/download...
To install Oracle SQL Developer Data Modeler on a Mac check out this video:
• Install Oracle SQL Dat...
Пікірлер: 6
You clear define the keys thank you
Great Tutorial! Fast, easy to understand and the most important features good explained!
Thank you for the excellent explanation. I went through this explanation and if I may suggest, continue this as a series of tutorials how to create small example app started inside SQLDD Modeler and finished inside Oracle Apex. That logical flow of steps is missing for all of us who are starting to learn SQLDD Modelers. I believe this would be a complete hit for all future viewers of your channel. Thank you again. Ivan
@simple4037
2 жыл бұрын
Thanks Ivan, I'm glad you found this useful. Thanks for your suggestion, I will try, as I'm working full time, it's difficult cut time for more videos.
@ivanjakic1587
2 жыл бұрын
@@simple4037 Thank you for your efforts. When I saw video I just thought, there’s an idea, there’s a drawn part, there’s DDL - after such a great lecture only what is "missing" is some kind of “final product” inside the free Apex low code environment. I didn't find that anywhere on KZread. However, thank you again for your effort. Thanks to you I have taken one step forward in my CV and job search.
❤