Preferred method of contact:

Relational Database Design, Tools and Techniques

COURSE TYPE

Foundation

Course Number

382

Duration

4 Days

PDF Add to WishList

Relational databases often drive the company-critical and web-enabled applications essential for achieving success in a highly competitive market. This training course is designed to deliver the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enabling you to develop and use relational databases in your environment.

You Will Learn How To

  • Extract core business data requirements from source documents
  • Design both conceptual and logical data models using requirements
  • Recognize and accurately model complex data relationships
  • Apply data normalization methods to refine data models
  • Physically deploy a relational schema from a logical model complete with tables, indexes, keys, and constraints

Important Course Information

Software:

  • Oracle's free SQL*Developer Data Modeler is used to design and generate a database
  • PostgreSQL RDBMS along with the SQL Workbench/J IDE are used for database demonstrations and samples
  • Concepts apply to any relational database environment

Course Outline

  • An Overview of DBMS Technology
  • How data is accessed, organized, and stored
  • Relational and NoSQL database comparisons
  • Roles involved in database design, development, and administration
  • The database development process

  • How a Relational DBMS Works

Relational technology fundamentals

  • Terminology and definitions
  • Tables, attributes and relationships
  • Primary and foreign keys
  • Manipulating data: selection, projection, join, union, intersection, difference

Components of a relational DBMS

  • An integrated, active data dictionary
  • Databases, accounts, and schemas
  • Designing Data Models

A step-by-step approach and techniques

  • Extracting core business information from requirements
  • Generating conceptual data entities
  • Transforming a conceptual model into a logical one
  • Building a physical database from a logical model
  • Building database documentation

Conceptual modeling

  • Capturing core entities
  • Identifying entity attributes
  • Creating unique identifiers
  • Graphically representing a conceptual model

Logical modeling

  • Apply data types to entity attributes
  • Describing relationships: one-to-one, one-to-many, many-to-many
  • Building recursive relationships
  • Understanding different modeling notations
  • Normalization Techniques
  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalization
  • Normalizing multi-valued attributes
  • Building a Relational Database

Physical database design

  • Implementing keys from unique identifiers
  • Building foreign keys from relationships
  • Enforcing business rules with check constraints

Working with design software

  • Generating the DDL to build the database
  • Reverse engineering to capture the design of an existing database

Applying best practices to database design

  • Natural versus surrogate keys
  • Exploring lookup table deployment options
  • Examine vertical and horizontal data partitioning strategies
  • Using record timestamps

Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $3285   Government: $2890

Mar 6 - 9 (4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

May 1 - 4 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jun 12 - 15 (4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Jul 24 - 27 (4 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Sep 4 - 7 (4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Oct 30 - Nov 2 (4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Dec 4 - 7 (4 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Private Team Training

Enroling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$3285

Government

$2890

Private Team Training

Contact Us »

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Training Hours

Standard Course Hours:9:00 am – 4:30 pm


FREE Online Course Exam (if applicable) – Last Day:3:30 pm – 4:30 pm


By successfully completing your FREE online course exam, you will:

  • Earn College Credit Units — Many Learning Tree courses are recommended for College Credits, which are accepted by over 2,000 colleges and universities, and may qualify you to receive Tuition Reimbursement.
  • Receive a Certificate of Achievement with the designation "Awarded with Distinction."

Each Course Day - Informal discussion with instructor about your projects or areas of special interest:4:30 pm – 5:30 pm

“Before taking the Relational Database course, I had tried to learn database design concepts from books. But I found it challenging to follow the technical terminology. Not so in this course--the instructor defined and clarified the basic terms at a level that worked for all of us. Plus, I am now able to run crude queries that help me with the many analyses I need to perform.”

- G. Meyrick, Computer System Analyst
SAIC

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français