Skip to main content Site map

Oracle SQL Developer Data Modeler for Database Design Mastery


Oracle SQL Developer Data Modeler for Database Design Mastery

Paperback by Helskyaho, Heli

Oracle SQL Developer Data Modeler for Database Design Mastery

WAS £65.99   SAVE £9.90

£56.09

ISBN:
9780071850094
Publication Date:
16 Jun 2015
Language:
English
Publisher:
McGraw-Hill Education - Europe
Imprint:
McGraw-Hill Inc.,US
Pages:
336 pages
Format:
Paperback
For delivery:
Estimated despatch 16 - 21 May 2024
Oracle SQL Developer Data Modeler for Database Design Mastery

Description

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Design Databases with Oracle SQL Developer Data ModelerIn 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

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

Back

London Metropolitan University logo