Oracle SQL Developer Data Modeler for Database Design Mastery

AvHeli Helskyaho

Häftad, Engelska, 2015

648 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

E-bok

914 kr

Beskrivning

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 Modeler

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

Produktinformation

Utgivningsdatum:2015-06-16
Mått:190 x 231 x 17 mm
Vikt:567 g
Format:Häftad
Språk:Engelska
Antal sidor:336
Förlag:McGraw-Hill Education
ISBN:9780071850094

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

Heli Helskyaho has a master’s degree in computer science from Helsinki University and specializes in databases. Heli is also an Oracle ACE director and has been a frequent speaker at many conferences. She has worked in IT since 1990 and with Oracle products since 1993. She has been in several positions, but each role has always included database design. Heli has been an Oracle Designer user since 1996 and a Oracle SQL Developer Data Modeler user since 2010. Heli is an active member in Oracle user groups community, including Oracle User Group Finland as well as EMEA Oracle user groups community (EOUC) where she has served as their spokesperson/ambassador since 2007. Heli is also the CEO for Miracle Finland Oy. Heli believes that creating good database design and documentation reduces performance problems and makes solving them easier. You can follow her on Twitter @helifromfinland or read her blog on helifromfinland.wordpress.com.

Innehållsförteckning

1. Introduction to Database Design2. What is Oracle SQL Developer Data Modeler3. Getting started with Data Modeler4. Requirement analysis (Logical Model)5. Conceptual design (Logical Model)6. Logical design (Relational Model)7. Physical design (Physical Model)8. Multidimensional9. Version control10. Export/import/reverse engineering11. Reporting12. Compare/Merge/ Syncronize13. Tips and Tricks and Techniques

Mer från samma författare

Real World SQL and PL/SQL: Advice from the Experts

Arup Nanda, Brendan Tierney, Heli Helskyaho, Martin Widlake, Alex Nuijten

Häftad, 2016

648 kr

Real World SQL and PL/SQL: Advice from the Experts

Alex Nuijten, Martin Widlake, Heli Helskyaho, Brendan Tierney, Arup Nanda

E-bok

2016

921 kr

Machine Learning for Oracle Database Professionals

Heli Helskyaho, Jean Yu, Kai Yu

Häftad, 2021

682 kr

Machine Learning for Oracle Database Professionals

Kai Yu, Jean Yu, Heli Helskyaho

E-bok

2021

903 kr

Extending Oracle Application Express with Oracle Cloud Features

Adrian Png, Heli Helskyaho

Häftad, 2022

610 kr

Extending Oracle Application Express with Oracle Cloud Features

Heli Helskyaho, Adrian Png

E-bok

2022

903 kr

Du kanske också är intresserad av