Request availability or book by selecting a date: Central London
City
England
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course is designed to give delegates practical experience in data modelling using entity relationship diagrams and data normalisation, and designing relational databases using the normalised entity model. Audience Delegates who require an understanding of relational databases. Skills Gained On completion of this course, delegates will have an understanding of the structure of a Relational Database Management System and have sufficient knowledge to converse with RDBMS professionals. Prerequisites An understanding of Information Technology concepts and computer terms. Course Outline - Introduction to Databases
- Database Management Systems
- Database System Development
- Conceptual Data Models
- Entities
- Attributes
- Relationships
- Constraints
- Assumptions
- Identifying Entities, Attributes, Relationships
- Sub-type/Super-type relationships
- Arc, Non-transferable and Redundant Relationships
- Recursive Relationships
- Normalisation
- The Relational Model
- Structure
- Relational Terminology
- A Relational Schema
- Implementing Constraints
- Implementing Sub-type/Super-type Relationships
- Views
- Denormalisation
Follow On Courses Introduction to SQL.
How to make a booking for the RDI-2 course
|
