L'Obel Certified Erwin

L'Obel’s Erwin course will help you acquire advanced skills for becoming a skilled Data Warehouse Specialist.

Internship Options
L'Obel ITP is unique in its training and delivery methodology as it is the first in India to provide the participant Hi-End technology training followed by rigorous INTERNSHIP in its SOFTWARE DEVELOPMENT CENTER. This gives the participant real time software-development experience through Software Development Life Cycle to making him/her a complete Software Professional.

DATAWAREHOUSING@L'Obel is designed to make the participant the most sought after Datawarehousing Expert. This makes the participant familiar with the most popular tools and technologies in Datawarehousing. On completion of this course the participant can join the industry as a Datawarehousing Consultant/Specialist.

ERwin Data Modeler (ERwin) is a software tool for data modeling (data requirements analysis, database design etc) of custom developed information systems, including databases of transactional systems and data marts. ERwin's data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well.

Distinguishing features

• Logical Data Modeling: Logical only models may be created, from which physical models may be derived. Also combinations logical and physical models are supported. Supports entity-type and attribute logical names and descriptions, logical domains and data types, as well as relationship naming.

• Physical Data Modeling: Physical only models may be created as well as combination logical and physical models. Supports table and column naming and descriptions, user defined data types, as well as primary key, foreign key, alternate key and check constraint definition and naming. Support for indexes, views, stored procedures and triggers is also included.

• Logical to Physical Transformation: Includes an abbreviation/naming dictionary called "Naming Standards Editor" and logical to RDBMS data type mapping facility called "Datatype Standards Editor", each customizable with entries and basic rule enforcement.

• Forward engineering: Once the database designer is satisfied with the physical model, the tool will automically script SQL Data Definition Language (DDL), directly executing on the RDBMS environment or saved as script file.

• Reverse engineering: If an analyst needs to examine and understand an existing data structure, ERwin will faithfully capture a depiction of the physical database objects in an ERwin model file.

• Model to model comparison: If an analyst or designer needs to understand what changes may have occurred between two model files (including real time reversed engineered files), ERwin presents "Complete/Compare" for that purpose.

Duration:

• 36-38 Hours. 3 days per week. 6-7 hours per day.

Contact us

For more information about this course write to info@lobelitp.com or walk into our IT Training centers located in Bangalore.