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

  • Design, build, and use a relational database using proven methods
  • Ensure database designs accurately model business requirements
  • Normalize and denormalize your data to optimize performance
  • Work with integrity constraints
  • Automatically generate database documentation using CASE tools

Important Course Information

Software:

  • Access is used as the front-end to an Oracle database and/or a standalone system
  • Oracle's free SQL Developer tool is used as a cross-platform tool to generate SQL/build a database

Course Outline

  • Introduction

An overview of DBMS technology

  • How data is accessed, organized and stored
  • The database development process

DBMS and related user tools

  • Query and application development tools
  • CASE tools for database analysis and design
  • How a Relational DBMS Works

Relational technology fundamentals

  • Tables, attributes and relationships
  • Primary and foreign keys
  • Relational integrity constraints
  • Manipulating data: selection, projection, join, union, intersection, difference

Components of a relational DBMS

  • An integrated, active data dictionary
  • The query optimizer
  • Designing Relational Databases

A step-by-step approach and techniques

  • Developing the logical data model
  • Mapping the data model to the relational model
  • Specifying integrity constraints
  • Defining the data in the data dictionary

Entity-relationship modeling

  • Capturing entities, attributes and identifiers
  • Describing relationships: one-to-one, one-to-many, many-to-many
  • Optional and mandatory relationships
  • Resolving many-to-many relationships for implementation

Normalizing data to design tables

  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalization

Working with a CASE tool

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

Physical database design

  • Assigning tables to disk files for performance and maintenance
  • Fragmenting large tables
  • Planned denormalization vs. accidental denormalization
  • Indexing for performance and integrity
  • Building and Querying a Relational Database

Fundamentals of SQL

  • A dynamic and evolving language
  • ANSI and ISO standards

Creating a relational database

  • Defining the database and its objects: tables, keys, views and indexes
  • Declaring integrity constraints

Accessing the database with SQL

  • Querying the database to retrieve desired information
  • Updating data while maintaining database integrity

Constructing and using views

  • Defining views for simplicity and security
  • Customizing windows into the database
  • Querying and updating through views
  • The Future of Database Design

Enforcing business rules for data integrity

  • Defining declarative constraints
  • Server-side programming in a procedural language

Trends

  • Modeling in analysis and design
  • Focusing on business rules
  • Creating an intelligent server
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: 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: $2990   Government: $2659

Sep 12 - 15 (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 31 - Nov 3 (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 12 - 15 (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

Jan 23 - 26 (4 Days)
9:00 AM - 4:30 PM EST
Online (AnyWare) Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online

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

Guaranteed to Run

Show all dates
Show fewer dates

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 »

Tuition

Standard

Government

In Classroom or
Online

Standard

$2990

Government

$2659

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.

Free Course Exam
You can take your course exam on the last day of your course 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
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5: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:

  • Have a record of your growth and learning results
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

"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