Oracle Data Modeling and Relational Database Design

Sun/Oracle
Oracle Data Modeling and Relational Database Design
Oracle Data Modeling and Relational Database Design
This Oracle Data Modeling and Relational Database Design training covers the Data Modeling and
Database Development process and the models that are used at each phase of the lifecycle. Learn from
expert Oracle University instructors through interactive instruction and hands-on exercisese.Learn To:
Identify the types of models.Develop a process model (Data Flow Diagram).Use advanced data
modeling techniques.Create the Physical Model, add several Physical Model objects, and generate the
DDL.Use several real life examples to document business requirements.Work with design rules that can
be applied to check and enforce the integrity and consistency of your designs. Work in a collaborative
environment using Subversion.Benefits to YouBy taking this course, you will develop an understanding
of the data modeling and database development process, as well as the models used in each phase of
the development lifecycle. You'll develop the skills to model and understand the database development
lifecycle based on real life examples, while mapping the objects and engineer the logical model to a
relational model.Validate Data ModelsYou will also learn techniques to validate these data models.
Once the Relational Design has been validated, you can create physical models to add all physical
properties and finally generate a DDL to create the database objects for your database. You will also
better understand how you can work as a team on developing a model using Subversion.
Kursinhalt
• Understanding What to Model
• Documenting the Business Background
• Building a Process Model (Data Flow Diagram)
• Using Oracle SQL Developer Data Modeler to Create Your Process Model (Data Flow Diagram)
• Validating Your Process Model (Data Flow Diagram)
• Identifying Entities and Attributes
• Identify Relationships
• Assign Unique Identifiers
• Using Oracle SQL Developer Data Modeler to Create the Entity Relationship Diagram
• Validating your Entity Relationship Diagram
• Normalizing your Data Model
• Validating Relationships
• Adding and Using Data Types
• Put It All Together
• Map Your Entity Relationship Diagram to a Relational Database Design
• Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data
Modeler
• Defining Your Physical Model
• Generating Your Database
• Altering an Existing Design
• Working in a Collaborative Environment
Vormerkung und Buchung
Reservieren Sie den gewünschten Kurstermin
unverbindlich und kostenlos! Für die Dauer von
7 Tagen halten wir Ihnen einen Platz frei. Diese
Vormerkung sowie eine feste Kursbuchung können
Sie direkt auf unserer Website tätigen. Oder rufen
Sie einfach an: 06074 4868-0
Garantierte Kurstermine
Zur tagesaktuellen Übersicht der Termine führt Sie
der direkte Link: www.experteach.at/go/90N9
Alternativ scannen Sie einfach
den nebenstehenden QR-Code.
Beachten Sie dort bitte auch die
garantierten Kurstermine. Diese
erkennen Sie am Symbol
Ihr Kurs maßgeschneidert
Sie benötigen diesen Kurs mit speziell für Ihr Team
zugeschnittenen Inhalten? Für Ihr Projekt erstellen
wir Weiterbildungsprogramme, die exakt an Ihre
Anforderungen angepasst sind.
E-Book Jeder Teilnehmer erhält die englischsprachigen Original-Unterlagen in Form eines Oracle University eKits.
Zielgruppe
• Application Developers
• Business Analysts
• Data Modelers
• Database Administrators
• Database Designers
• System Analysts
Voraussetzungen
• Basic understanding of relational database concepts
Kursziel
• Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set
of requirements
• Normalize the Entity Relationship Diagram to third Normal form
• Enhance the Entity Relationship Diagram to utilize several data modeling techniques
• Create a Data Flow Diagram by identifying processes, external agents, information stores and information flows
that show how the information flows and how it is being transformed
• Engineer the Entity Relationship Model into an initial relational database design
• Optimize the Relational Database Design
• Complete the Physical Model and generate the DDL
• Use Oracle SQL Developer Data Modeler to document all the concepts learned throughout the course
4 Tage
€ 2.680,00 zzgl. MwSt.
Termin/Kursort
14.11.-17.11.16 Wien
Stand 20.12.2016
90N9
ExperTeach Networking
Technologie-Training
in deutscher Sprache
Über 30 Hersteller
Die wesentlichen
ITK-Anbieter
IT Management
Weiterbildung über
die Technik hinaus
Consulting Services
ITK-Experten für
Ihr Projekt
Garantierte Kurstermine
Planungssicherheit für
Ihre Fortbildung
Virtual Training
Hybrid Training
E-Books • E-Learning
Digitalisierung
Industrie 4.0 & IoT
Know-how für Experten
ExperTeach GmbH Training Center Wien
Hamburg
Millennium Tower, 32. Etage • Handelskai 94-96 • A-1200 Wien • Telefon +43 1 235 0383-0
[email protected] • www.experteach.at
Berlin
Utrecht
Breda
Partner
Training
Center
Düsseldorf
Bonn
Frankfurt/
Dietzenbach
Nürnberg
Karlsruhe
Stuttgart
ExperTeach
Training
Center
Ulm
Zürich
München
Wien
© ExperTeach GmbH, alle Angaben ohne Gewähr, 20.12.2016