Call us at 1-800-413-0939
Hands On Technology Transfer, Inc.

Relational Database Training

Attend face-to-face, remote-live, on-demand or on site at your facility.

Travel Packages Discount Programs

Relational Database Design Concepts

Duration: 3 days

Price: $1595

Remote Attendance: Click here for more information.

Students Will Learn:

  • Design normalized table structures for relational databases
  • Create databases and tables
  • Using primary and foreign keys
  • building a logical data model
  • Implementing the data model with DDL
  • Creating, modifying and dropping database objects
  • Writing SQL Queries
  • Using inner and outer joins
  • Manipulating query results

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.

Follow-up SQL 2012 Courses: Microsoft SQL Server 2012 Administration, SQL Server 2012 Reporting Services, SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2012 Business Intelligence: Integration Services and Analysis Services

Follow-up SQL 2014 Courses: Microsoft SQL Server 2014 Administration, SQL Server 2014 Reporting Services, SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2014 Business Intelligence: Integration Services and Analysis Services

Follow-up SQL 2016 Courses: SQL Server 2016 Reporting Services, SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS), SQL Server 2016 Business Intelligence: Integration Services and Analysis Services

Developing Relational Databases
  • Overview of Relational Database Concepts
  • Relational Databases and Relational Database Management Systems
  • Database Development Methodology Overview
    • Conceptual, Logical and Physical Data Models
Building a Logical Data Model
  • Identifying Entities and Attributes
  • Relationships Between Entities (One-to-One, One-to-Many, Many-to-Many)
  • Creating Entity-Relationship Diagrams
  • Normalization as a Design Technique
  • Progressive Steps to Normalization (First, Second, and Third Normal Form)
Transforming to Physical Design
  • Migrating Entities to Tables
  • Selecting Primary Keys
  • Defining Columns
  • Enforcing Relationships with Foreign Keys
  • Enforcing Business Rules with Constraints
Constructing the Database Using DDL
  • Creating Objects with CREATE
    • Creating Tables, Indexes, Stored Procedures, Triggers and Views
  • Modifying Objects with ALTER
    • Adding Columns to a Table
    • Modifying Parameters to a Stored Procedure
    • Adding Constraints to a Column
    • Modifying the Timing of a Trigger
    • Changing the Body of Stored Procedures and Views
  • Removing Objects with DROP
    • Dropping Tables, Indexes, Constraints and Views
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
    • Beginning Explicit Transactions
    • Committing Transactions
    • Rolling Back Transactions
    • Defining Save Points
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 (CAST and CONVERT)
  • Using the CASE Function
  • Handling Null Values
Working with Views
  • Benefits of Using Views
  • Creating Views
Advanced Query Techniques
  • Inner Joins
  • Outer Joins (Left, Right, Full)
  • Joining a Table to Itself
  • Subqueries
  • Tips for Developing Complex SQL Queries
  • Using Aggregate Functions
    • AVG
    • COUNT
    • SUM
    • MIN
    • MAX
  • Aggregating Results Using GROUP BY
  • Restricting Groups with the HAVING Clause
  • Creating Temporary Tables
  • Course materials include student guide, hands-on lab manual and USB flash drive for examples and lab work
  • Students receive a certificate of completion at the end of class
  • Students can retake any portion of a class that has been completed, within 12 months at no extra cost
  • There are no registration fees or cancellation fees

In the ten years I've been an IT professional and taken 1-3 courses per year in that time, I found this instructor to be the best educator bar none. He is extremely articulate and is impeccably skilled in hearing the real need behind the question. He is energetic, enthusiastic and fun. Humor is used effectively in his presentations...Because of this training experience, I prefer HOTT courses to other courses such as Global Knowledge, etc.
— T.L., W.L. Gore and Associates

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

Individual training passes: save up to 43%! For complete discount options » click here «

# Courses Total Cost Cost Per Course % Savings
2 $4,090 $2,045 22%
3 $5,490 $1,830 30%
4 $6,690 $1,672 36%
5 $7,790 $1,558 40%
6 $8,890 $1,482 43%

Multiple Training Locations - Convenience and Cost Control

Attend Regularly Scheduled Courses in More than 100 Cities Across North America and the United Kingdom or via Remote Attendance