Data Modeling and Warehousing Concepts
Live Instructor-Led Classroom Training
This 4-day workshop is designed to introduce and explain the principle concepts of data, data modeling, relational database design and data warehousing concepts. The students will acquire a practical understanding of the approaches, methods and tools of data modeling. The workshop begins with the fundamental principles of modeling using the leading Entity/Relationship Diagraming (ERD) methods. The data model, attributes and refinement, requirements analysis, data warehousing concepts all receive special emphasis.
The workshop is heavily "hands-on" (about 65%), with portions of lecture followed by workshops designed to help the students internalize and apply the concepts.
Who Should Attend
This workshop is beneficial for anybody that may be involved in software development, including managers (both business and IT) who may need to direct a requirements analysis effort, office personnel who may need to contribute business expertise, analysts who will need to define and organize the requirements, and developers who will need to construct the system.
- Identify and apply the various elements used for gathering data requirements.
- Document data requirements using entity relationship diagrams (ERD) with standard notation and add necessary meta-data information.
- Identify and understand the use of primary and foreign keys and relationships.
- Learn how to use basic and advanced techniques to refine the data model.
- Ability to integrate data and process requirements.
- Identify the uses of data requirements in building application systems, for well-designed interfaces and designing databases.
- Learn which skills facilitate communication and approaches to organize the data requirements gathering process.
A leader in live technical training since 1978
For many years New Instruction, LLC had been known as an innovative provider of training, consulting and software development services, and clients have often asked us to share our software quality methodologies with them. Those requests led to the development of our longest running workshop, "Testing and Quality Assurance Techniques", now in it's 11th edition.