Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Oracle









Preferred method of contact?

Relational Database Design, Tools and Techniques

COURSE TYPE

Hands-On

Course Number

382

Duration

4 Days

Enroll

About This Course: Relational databases often drive company-critical and web-enabled applications; therefore, creating a database design that accurately captures user requirements is vital for success. This course provides a foundation for designing, building and working with relational databases, enabling you to effectively 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
  • Simplify code and improve performance by avoiding common errors

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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Sep 6 - 9 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Oct 18 - 21 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 6 - 9 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 17 - 20 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 31 - Feb 3 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 21 - 24 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 28 - Mar 3 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 30 - Jun 2 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 20 - 23 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jul 25 - 28 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 22 - 25 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

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

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

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)
  • Make progress toward one or more Learning Tree Specialist & Expert 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.

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