Menu
Live Chat
Contact Us
Scheduling Tool
888-843-8733
 

Home ❯ Oracle

PDF Add to WishList









Preferred method of contact:

Relational Database Design, Tools and Techniques

COURSE TYPE

Foundation

Course Number

382

Duration

4 Days
Reserve Your Seat

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

888-843-8733

info@LearningTree.ca

Live Chat

In the Classroom — OR — Live, Online

Tuition — Standard: $3285   Government: $2890

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

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

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

Jan 21 - 24 ( 4 Days)
9:00 AM - 4:30 PM EST Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

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

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

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

Show all dates
Show fewer dates

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling 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 »

This event has been added to your cart.

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 any time after class.

Prev
Next

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*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