Oracle SQL Developer Data Modeler for Database Design Mastery,9780071850094

Oracle SQL Developer Data Modeler for Database Design Mastery

by
Edition: 1st
ISBN13: 9780071850094
ISBN10: 0071850090
Format: Paperback
Pub. Date: 2015-05-18
Publisher(s): McGraw Hill
List Price: $63.00

Buy New

Usually Ships in 2-3 Business Days.
$60.00
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$82.13
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$82.13*
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $28.06

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Design Databases with Oracle SQL Developer Data Modeler

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

Table of Contents

1. Introduction to Database Design
2. What is Oracle SQL Developer Data Modeler
3. Getting started with Data Modeler
4. Requirement analysis (Logical Model)
5. Conceptual design (Logical Model)
6. Logical design (Relational Model)
7. Physical design (Physical Model)
8. Multidimensional
9. Version control
10. Export/import/reverse engineering
11. Reporting
12. Compare/Merge/ Syncronize
13. Tips and Tricks and Techniques

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.