Overview: This is a practical hands on course where the concepts of Conceptual and Logical Modeling are interwoven with practical group exercises and discussions. Throughout the course we discuss the interdependence of process analysis and data analysis (conceptual and logical design) and how they affect each other. The student is also shown how to approach the conversion of a logical database design to a physical database design.
Areas Covered in the Session:
Why should you attend: Develop and improve the skill and confidence to design databases effectively Recognize, document and exploit domains (Extended Data types) with SQL Create and use robust information models Develop helpful catalog extensions to facilitate logical and physical database design Design for Maximum Logical Physical and Distribution data independence.
Create "critical query profiles" to facilitate physical database design and tuning.
Who Will Benefit: