ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Relational Database Design  (CF180)

Format: Formation en classe avec formateur
Autres formats:
 
 

After an overview of relational concepts that are important for designing relational databases, learn about the different views of the data of the application domain and the steps included in this comprehensive relational database design methodology. These steps include:

  • Analyzing a problem statement for an application domain
  • Establishing an Entity Relationship (ER) model to visualize and structure the business object types of the application domain as entity types
  • Illustrating the relationships between the business object types as relationship types
  • Modeling the constraints for the entity types and relationship types imposed by the business rules
  • Using the business information and the process inventories to produce a data inventory
  • Establishing tuple types for entity types and relationship types of an ER model
  • Transforming the tuple types for the application domain to the tables of the target database management system
  • Defining implementation techniques for the various types of integrity
  • Recommending the necessary indexes from a database design perspective
  • Transitioning from the storage view to the logical view by creating logical data structures

IACET Continuing Education Units: 3.2

Case Study Labs  

Six team-based lab exercises use a comprehensive case study to practice each major step and sub-step of the methodology.

"
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 
  • Design relational databases
  • Consider logical and physical aspects including integrity requirements during the design

Qui peut en profiter
 

This is a intermediate course for programmer analysts, database administrators, and other individuals, who design relational databases and need an in-depth understanding of data modeling.

Préalables
 

None.

What's Next

Use the link to the Training Path above for easy access to prerequisite courses, and other courses that might be of interest to you.

Abstract
 

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account

Case Study Labs
  Six team-based lab exercises use a comprehensive case study to practice each major step and sub-step of the methodology.
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: CF180
Format: Formation en classe avec formateur
Durée: 4 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
     
Manhattan/New York, NY Oct.9 - Oct.12.2012 course register
1 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

Relational Database Design  (CF180) Contenu détaillé
 
 
Relational concepts
  • identify the components of tables
  • explain the rules defined by the relational data model regarding:  uniqueness of rows and columns, physical ordering of rows and columns, and linkage of tables
Views and results during database design
  • explain the different views assumed for the data during database design: the conceptual view, the storage view, and the logical view
  • summarize the steps performed during database design and their results
  • relate the steps and results to the data views
Problem statement
  • explain the purpose of the problem statement for database design
  • discuss who has the responsibility for the creation of the problem statement
  • describe the role of the database designer in the creation of the problem statement
  • describe the contents of a problem statement
ER model
  • define the entity types for an application domain based on a problem statement
  • define the relationship types for an application domain based on a problem statement
  • define the supertypes and subtypes for an application domain
  • identify the constraints for the entity types and relationship types of an application domain
  • establish an ER model for an application domain
Data and process inventories
  • explain the purpose of data and process inventories
  • explain the significance of data inventories for database design
  • discuss who has the responsibility the creation of data and process inventories
  • describe the content data and process inventories should have for database design
  • summarize some methods for establishing data and process inventories
tuple types
  • explain the purpose of tuple types and position them in the design process.
  • identify the objects of an ER model for which tuple types are established
  • establish the tuple types for the appropriate objects of an ER model
  • explain the purpose and rules for the normalization of tuple types
  • normalize the tuple types for an application domain
From tuple types to tables
  • combine tuple types to reduce the number of tables required
  • split tuple types to cope with database limitations or performance degradations
  • denormalize tuple types as required for performance reasons
  • establish the tables for the tuple types including the translation of abstract data types for attributes, the definition of data types and column attributes for the columns of the tables, and the documentation of the necessary database objects
 
Integrity rules
  • describe the different types of integrity to be enforced for a database
  • explain the integrity rules for referential integrity
  • establish the referential constraints for the tables of an application domain
  • draw the referential structure for the tables of an application domain
  • relate how to ensure the integrity of redundant information
  • implement business constraints
  • describe the columns that should have indexes  
Logical data structures
  • explain the purpose of logical data structures
  • discuss who has the responsibility for the establishment of logical data structures
  • describe the components of logical data structures and their representation
  • explain the relationship between business processes and logical data structures
  • describe the interrelationship between logical data structures and views
Daily Agenda
 
Day 1
  • relational concepts
  • views and results during design
  • problem statement
  • exercises: problem statement
  • review exercises: problem statement
  • ER model (part 1)
Day 2
  • ER model (part 2)
  • exercises: ER model
  • review exercises: ER model
  • data and process inventories
Day 3
  • exercises: data and process inventories
  • review exercises: data and process inventories
  • tuple types
  • exercises: tuple types
  • review exercises: tuple types
  • from tuple types to tables (part 1)
Day 4
  • from tuple types to tables (part 2)
  • exercises: from tuple types to tables
  • review exercises: from tuple types to tables
  • integrity rules
  • exercises: integrity rules
  • review exercises: integrity rules
  • logical data structures


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI