Top

Relational Database Design Concepts

Delivery Options: Attend face-to-face in the classroom, remote-live or via on-demand training.

Pricing

Face-to-face or remote-live: CDN$2,275

On-demand: CDN$1,975

Discounts: We offer multiple discount options. Click here for more informaiton.

Duration

Face-to-face or remote-live: 3 Days

On-demand: Approximately 21 hours of coursework with personal facilitation, to be completed in a four week span.

Registration

Face-to-face: Click here to view our schedules and register for in-person sessions.

Remote-live: Click here to register for live remote class sessions within a date range of your choosing.

On-demand: Click here to register for on-demand training with personal facilitation, on a start date of your choosing.

View Schedule View Testimonials

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 training course 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.

Course Overview

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 CREATE DATABASE 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 Table Expressions Overview of Table Expressions Working with Views Using Derived Tables Common Table Expressions Table-Valued Functions	Advanced Query Techniques Inner Joins Outer Joins (Left, Right, Full) Performing Self-Joins Subqueries Simple Correlated Using the EXISTS Operator Tips for Developing Complex SQL Queries Using Aggregate Functions AVG COUNT SUM MIN MAX Performing Set Operations UNION INTERSECT EXCEPT/MINUS Aggregating Results Using GROUP BY Restricting Groups with the HAVING Clause Creating Temporary Tables

Related Courses

Testimonials

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

Course Schedule

Choose a city below to view a schedule of courses. Attend regularly scheduled classes across Canada, or attend via our Remote-Live and On-Demand training options.

Relational Database Training Course

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

Relational Database Design Concepts

Pricing

Duration

Registration

Students Will Learn

Address

Contact

Useful Links

Relational Database Training Course

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

Relational Database Design Concepts

Pricing

Duration

Registration

Students Will Learn

Address

Contact

Useful Links

Get Connected