Oracle SQL Developer Data Modeler for Database Design Mastery cover image

Oracle SQL Developer Data Modeler for Database Design Mastery

By Heli Helskyaho
azw3
Format
2015
Year
English
Language
McGraw-Hill Education
Publisher

Summary

<h4>Design Databases with Oracle SQL Developer Data Modeler</h4> <p>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. <i>Oracle SQL Developer Data Modeler for Database Design Mastery</i> 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.</p><ul> <li>Configure Oracle SQL Developer Data Modeler <li>Perform requirement analysis <li>Translate requirements into a formal conceptual data model and process models <li>Transform the conceptual (logical) model into a relational model <li>Manage physical database design <li>Generate data definition language (DDL) scripts to create database objects <li>Design a data warehouse database <li>Use subversion for version control and to enable a multiuser environment <li>Document an existing database <li>Use the reporting tools in Oracle SQL Developer Data Modeler <li>Compare designs and the database</ul>

Related books


Algorithms and Data Structures
The Data Revolution: Big Data, Open Data, Data Infrastructures and Their Consequences
Rob Kitchin
Organization and Data Processing
Data Mining on Multimedia Data
Petra Perner (eds.)
Organization and Data Processing
The Chief Data Officer Handbook for Data Governance
Sunil Soares
Organization and Data Processing
Data Analytics with Hadoop: An Introduction for Data Scientists
Bengfort, B.; Kim, J.
Organization and Data Processing
Python for Data Analysis: Data Wrangling with Pandas, NumPy, and IPython
Wes McKinney
Organization and Data Processing
Data Insights: New Ways to Visualize and Make Sense of Data
Hunter Whitney