To register online click here, or call
800-413-0939
Our Registrars will be happy to assist you.

Relational Database Design Training Course

Relational Database Design Concepts

Duration: 3 days | Price: $1595 | Class Dates:

Click here for information regarding remote access training.

Students Will Learn:

  • Building a Logical Data Model
  • Entity-Relationship Diagrams
  • Data Normalization Forms
  • SQL Statement Syntax
  • Manipulating Query Results
  • Designing for Performance
  • Table Indexing

Course Description: This relational database design class develops relational database design skills and techniques. Practical methodologies such as E-R diagrams and normalization forms are emphasized. Attention is placed on designing for data integrity and efficiency at the same time. During hands on lab sessions students are required to design multiple database models from business requirements and specifications. Through hands on experience using SQL programming code to create, populate and manage relational tables, students will experience the necessity of proper design methods and gain an in depth understanding of the link between design, creation, and utilization. The impact of alternative designs on maintainability and database performance is emphasized.

Course Prerequisites: General computer knowledge. Familiarity with relational database concepts is helpful but not required.

Relational Database Design Concepts Course Overview:

Developing Relational Databases
  • Overview of Relational Database Concepts
  • Relational Databases and Relational Database Management Systems
Transforming to Physical Design
  • Migrating Entities to Tables
  • Selecting Primary Keys
  • Defining Columns
  • Enforcing Relationships with Foreign Keys
    • Enforcing Business Rules with Constraints
  • Database Views
  • Designing for Security: Users and Roles
Building a Logical Data Model
  • Understanding Data Analysis and Modeling
  • Identifying Entities and Attributes
  • Isolating Keys
  • Relationships Between Entities (One-to-One, One-to-Many, Many-to-Many)
  • Creating Entity-Relationship Diagrams
  • Complex Modeling Issues
    • Exclusive and Recursive Relationships
  • Normalization as a Design Technique
  • Progressive Steps to Normalization (First, Second, and Third Normal Form)
  • Using Normalization to Build an E-R Diagram
  • Referential Integrity Enforcement and Implications
Designing for Performance
  • Indexing
  • Denormalization
  • Addressing Data Contention
Manipulating Table Data Using SQL's Data Manipulation Language (DML)
  • Inserting Data into Tables
  • Updating Existing Data
  • Deleting Records
  • Truncating Tables
  • Implementing Data Integrity with Transactions
    • COMMIT
    • ROLLBACK
    • SAVEPOINT
Constructing the Database
  • Constructing the Database Using DDL
    • Creating Tables, Indexes, Constraints and Views
  • Creating Roles and Granting Privileges
  • Managing Database Objects
    • Dropping Tables, Indexes and Views
    • Modifying Tables, Indexes and Views
    • Enabling and Disabling Constraints
    • Managing Security
Writing Basic SQL Queries
  • Displaying Table Structures
  • Retrieving Column Data From a Table or View
  • Selecting Unique Values
  • Obtaining a Row Count
  • Filtering Rows Using the WHERE Clause
  • Sorting Results Using ORDER BY
  • Joining Multiple Tables
  • Using Column and Table Aliases
Manipulating Query Results
  • Using Row Functions
    • Character
    • Numeric
    • Date and Time
    • Data Conversion
  • Using the CASE Function
  • Handling Null Values
  • Aggregating Results Using GROUP BY
  • Restricting Groups with the HAVING Clause
Advanced Query Techniques
  • Outer Joins
  • Joining a Table to Itself
  • Subqueries
  • Grouping, Filtering and Sorting Query Results
  • Tips for Developing Complex SQL Queries

Student Testimonials

"Fantastic instructor – obviously well-versed and has a lot of real-world experience. Was able to help me apply the course material to needs at my job. Excellent instructor, excellent class."
– J.N., Mary T. Inc


"The instructor is wonderful! She conveyed the material clearly and with the right amount of detail. Plus she held my attention throughout the class."
– B.D., Westvaco

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom