#FN-611

Relational Database Design

Course Description:

This course is an ideal introduction to relational database concepts and terminology. Through a variety of exercises, learn how to model a business enterprise using the entity-relationship approach to relational database design. Learn data normalization techniques. Gain hands-on experience creating a database and tables using the Data Definition Language portion of Structured Query Language.

Your New Skills:

• Describe relational technology and its advantages
• Discuss relational database design concepts and terminology
• Construct entity-relationship diagrams to model a business enterprise
• Apply the rules of normalization to a database or database model
• Use SQL to create simple databases, tables, and data integrity constraints
• Use SQL to perform basic INSERT and SELECT operations

Who Should Attend: Application developers, database and systems administrators, system analysts, project leaders, technical support personnel

College Credit: This course has been recommended for college credit by the American Council on Education.

Prerequisites: None

Length: 2 days

Format: Lecture, hands-on and written exercises

Course Number: FN-611

Recommended Next Course:

• FN-613 Structured Query Language