<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 database design mastery
β Scribed by Helskyaho, Heli
- Publisher
- McGraw-Hill Education
- Year
- 2015
- Tongue
- English
- Leaves
- 338
- Series
- Oracle Press
- Edition
- 1
- Category
- Library
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
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
<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 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
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