Book (paperback)
In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful free tool that flawlessly supports Oracle and other database environments including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual logical and physical design, data warehousing reporting and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.
Configure Oracle SQL Developer Data Modeler
Perform requirement analysis
Translate requirements into a formal conceptual data model and process models
Transform the conceptual (logical) model into a relational model
Manage physical database design
Generate data definition language (DDL) scripts to create database objects
Design a data warehouse database
Use subversion for version control and to enable a multiuser environment
Document an existing database
Use the reporting tools in Oracle SQL Developer Data Modeler
Compare designs and the database
- ISBN-10: 0071850090
- ISBN-13: 978-0-07-185009-0
- Copyright 2015
- Dimensions: 9" x 7.3"
- Pages: 336
- Edition: 1st
In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful free tool that flawlessly supports Oracle and other database environments including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual logical and physical design, data warehousing reporting and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.
Book (paperback)
In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful free tool that flawlessly supports Oracle and other database environments including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual logical and physical design, data warehousing reporting and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.
Configure Oracle SQL Developer Data Modeler
Perform requirement analysis
Translate requirements into a formal conceptual data model and process models
Transform the conceptual (logical) model into a relational model
Manage physical database design
Generate data definition language (DDL) scripts to create database objects
Design a data warehouse database
Use subversion for version control and to enable a multiuser environment
Document an existing database
Use the reporting tools in Oracle SQL Developer Data Modeler
Compare designs and the database
- ISBN-10: 0071850090
- ISBN-13: 978-0-07-185009-0
- Copyright 2015
- Dimensions: 9" x 7.3"
- Pages: 336
- Edition: 1st
In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler—the powerful free tool that flawlessly supports Oracle and other database environments including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual logical and physical design, data warehousing reporting and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book.
