logo

Data Modeling: Logical Database Design (DB6169)

This course, and its companion volume which follows, provide a solid basis from which one can successfully implement relational database, multidimensional data warehouse and business intelligence (BI) technologies. The principal objective of this initial course volume is to convey a practical and common sense guide to the theory and concepts of data modeling. Using these sophisticated techniques one can create an elegant logical design of a database. Within this course we discuss not only the premier modeling theories from the best industry experts but also present the practical and real-world experience of the past 20-years of Sideris data design practitioners.

The methodologies discussed are applicable to any relational database environment, including IBM DB2, the Oracle database, Microsoft SQL Server, the open-source MySQL and PostgreSQL databases as well as other RDBMS platforms. They are also applicable to other database technologies, such as object databases and legacy IMS and IDMS databases. Finally, while we use the free Oracle SQL Developer Data Modeler product as a demonstration modeling tool, one can complete the exercises of this course and apply the techniques learned using any other popular data model diagramming tool, such as IBM InfoSphere Data Architect, CA ErWin Data Modeler, Embarcadero ER/Studio and others.

Pohađajte naše Oracle obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd. Kontaktirajte nas da biste saznali više.

Termini obuke

Trajanje obuke: 
4 dana / 28 sati

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
4 dana / 28 sati
Cena na zahtev
srpski ili engleski
Plan obuke: 

DATA MODELING THEORY & CONCEPTS

  • ABOUT MODEL-BASED DESIGN
  • ABOUT DATA MODELING 
  • ABOUT DATA MODEL DIAGRAMS
  • ADVANCED MODELING METHODOLOGIES

BUILDING AN INITIAL DATA MODEL

  • PRINCIPLES OF DATA MODELING
  • BUILDING THE MODEL 
  • IDENTIFYING ENTITIES 
  • IDENTIFYING ATTRIBUTES
  • IDENTIFYING RELATIONSHIPS
  • A SIMPLE MODELING SCENARIO

DRAWING A MODEL USING SOFTWARE ENGINEERING TOOLS

  • ABOUT DATA MODELING TOOLS 
  • DRAWING A DATA MODEL DIAGRAM

INCREASING THE ACCURACY OF THE MODEL

  • STARTING WITH A CONCEPTUAL MODEL
  • SUPPLEMENTING THE REQUIREMENTS 
  • REFINING THE RELATIONSHIP DEFINITIONS

FINDING & FIXING ATTRIBUTE MISTAKES

  • CAPTURING MISSING ATTRIBUTE DETAILS
  • CHARACTER 
  • NUMERIC 
  • DATE 
  • CORRECTING ATTRIBUTE DEFINITIONS 
  • UNIQUE IDENTIFIERS
  • UNIT OF MEASURE ATTRIBUTES

SEMANTIC & OBJECT ORIENTED MODELING OF ENTITIES & RELATIONSHIPS

  • DEFINING SUPERTYPES & SUBTYPES 
  • ENTITY NAME PROBLEMS 
  • NAMING STANDARDS 
  • SPECIALIZATION & GENERALIZATION 
  • SUBTYPE CONSTRAINTS 
  • DEFINING RELATIONSHIP ARCS

SEMANTIC & OBJECT ORIENTED MODELING OF DOMAINS & TYPES

  • DEFINING DOMAINS 
  • DEFINING TYPES 
  • COLLECTION TYPES

TIME-DEPENDENCY & STATE-DEPENDENCY

  • ABOUT TIME & STATE 
  • TIME-DEPENDENT SUB-MODEL 
  • PERSON / INDIVIDUAL ROLES SUB-MODEL

CLASSIC STRUCTURES & PATTERNS

  • MASTER-DETAIL-DETAIL 
  • M:N RECURSION (BILL-OF-MATERIALS) 
  • ORGANIZATION UNIT HIERARCHY 
  • ENTITY LOCATIONS 
  • ENTITY CONTACTS

LOGICAL / PHYSICAL MODEL TRANSFORMATION

  • ABOUT PHYSICAL DATA MODELS
  • PHYSICAL RELATIONAL TRANSFORMATION
  • MODEL TRANSFORMATION EXAMPLE 
  • AUTOMATIC TRANSFORMATION 
  • SUPERTYPE TRANSFORMATION

RDBMS IMPLEMENTATION OF THE PHYSICAL MODEL

  • REVERSE ENGINEER A PHYSICAL MODEL 
  • ABOUT THE RELATIONAL DATABASE 
  • RELATIONAL DATABASE OBJECTS 
  • FORWARD ENGINEER A PHYSICAL MODEL
Benefiti: 
  • Video snimak predavanja u periodu od 180 dana posle kraja obuke

  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku

  • Sertifikat o pohađanju kursa

Poželjno predznanje: 

No mandatory prerequisites exist for this course. However a basic knowledge of computer systems, business systems requirements and database technologies is helpful.

Kontaktirajte nas za više informacija o ceni:

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 195
E-mail: Jelena.Mijanovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs

Eccentrix
Office: +381 11 71 38 192
Mobile: +381 65 31 38 197
E-mail: Boris.Gigovic@eccentrix.rs

Milutina Milankovića 9đ,
11070 Novi Beograd
www.eccentrix.rs