𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

Oracle SQL developer data modeler for database design mastery

✍ Scribed by Helskyaho, Heli


Publisher
McGraw-Hill Education
Year
2015
Tongue
English
Leaves
338
Series
Oracle Press
Edition
1
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


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.

✦ Table of Contents


Content: 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

✦ Subjects


Oracle (Computer file);Database design;SQL (Computer program language)


πŸ“œ SIMILAR VOLUMES


Oracle SQL Developer Data Modeler for Da
✍ Heli Helskyaho πŸ“‚ Library πŸ“… 2015 πŸ› McGraw-Hill Education 🌐 English

<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, inc

Oracle SQL Developer Data Modeler for Da
✍ Helskyaho, Heli πŸ“‚ Library πŸ“… 2015 πŸ› McGraw-Hill Education 🌐 English

Design world-class databases with this powerful free tool. This book provides best practices for planning, executing, installing, deploying, and maintaining any kind of database of any size. The author contrasts the ease of functionality and compatibility of Oracle SQL Developer Data Modeler against

Beginning Oracle SQL: for Oracle Databas
✍ Gorman, Tim;Jorgensen, Inger;Cafffrey, Melanie πŸ“‚ Library πŸ“… 2014 πŸ› Apress 🌐 English

<em>Beginning Oracle SQL</em>is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used i

Beginning Oracle SQL for Oracle Databas
✍ Lex deHaan, πŸ“‚ Library πŸ“… 2014 πŸ› APRESS 🌐 English

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creati

Formal SQL Tuning for Oracle Databases
✍ Leonid Nossov, Hanno Ernst, Victor Chupis πŸ“‚ Library πŸ“… 2016 πŸ› Springer 🌐 English

The target of SQL tuning is the improvement of the existing execution plan. The authors discuss the removal of brakes in the execution plan. Such Β«brakesΒ» or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is espec