Oracle SQL Developer Data Modeler for Database Design Mastery

  • 4h 49m
  • Heli Helskyaho
  • Oracle Press
  • 2015

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

About the Author

Heli Helskyaho, Oracle ACE Director, is CEO of Miracle Finland Oy, a data management systems consultancy. She has been working with Oracle products since 1993. Heli has been a board member and/or president of Oracle User Group Finland since 2001 and spokesperson/ambassador for EMEA Oracle User Groups Community (EOUC) since 2007.

In this Book

  • Oracle SQL Developer Data Modeler for Database Design Mastery
  • Forewords
  • Introduction
  • Introducing Database Design and Oracle SQL Developer Data Modeler
  • Getting Started with Oracle SQL Developer Data Modeler
  • Introducing Requirements Analysis
  • Introducing Conceptual Database Design (Logical Model)
  • Introducing Logical Database Design (Relational Model)
  • Introducing Physical Database Design
  • Generating DDL Scripts for Creating Database Objects
  • Designing a Data Warehouse Database
  • Using Version Control and Working in a Multiuser Environment (Subversion)
  • Documenting an Existing Database
  • Generating Reports and Using Search
  • Comparing Designs and the Database
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Book RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
Course Database Fundamentals: Getting Started with SQL
Rating 4.5 of 272 users Rating 4.5 of 272 users (272)