Relational Database Design

PT6244
Training Summary
This course is designed to provide the student with an introduction to relational database design concepts. Students will learn methodologies such as entity relationship modeling and normalization techniques that will allow them to create a logical database design with business rules and performance in mind. The course focuses on different levels of data integrity, including referential integrity considerations between entities. The lab session allows the students to practice designing a logical data model.
Prerequisites
There are no prerequisites required for this course.
Duration
1 Day/Lecture & Lab
Audience
This course is designed for systems analysts and programmers who are responsible for analyzing business areas, designing and creating relational databases.
Course Topics
  • Basic Structured Analysis Concepts
  • Entity Relationship Modeling
  • Data Normalization
  • Referential Integrity
  • Logical and Physical System Models

Related Scheduled Courses