Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

Relational Database Concepts and Design

Course Objective


In-House Training for as few as 3 Attendees >>

Or Call Toll Free
1-888-230-9052

Database Management systems are designed to manage large bodies of information. The management of data involves both the definition of structures for the storage of information and the provision of mechanisms for the manipulation of information. In addition, the database system must provide for the safety of the information stored, despite system crashes or attempts to unauthorized access. If data is to be shared among several users, the system must avoid possible anomalous results.

Database Design is the process of developing data base structures from user requirements for data. It starts with requirements analysis, which identifies user needs for data. It then proceeds by translating these user requirements into first a conceptual, then a physical, data base design. The resulting design must satisfy user needs in terms of completeness, integrity, performance, constraints, and other factors.

In this course you will gain an understanding of both the fundamentals of relational databases and relational database design. It is scheduled to be highly interactive and problems will be solved throughout the class hours. A mini-workshop will be presented in the classroom on the fifth day for the students to get a good understanding of the database design process.

What will you learn

  • A background on database management
  • The ANSI-SCHEMA 3 level architecture
  • Understanding the Entity/Relationship Model
  • Relational Database Theory
  • SQL & SQL Queries
  • File Structures, Indexing and Hashing
  • Query Processing & Query Optimization
  • Crash Recovery
  • Concurrency Control/Transaction Processing
  • Security and Integrity
  • Database Planning & Information Engineering
  • Database Analysis
  • Logical Design
  • Conceptual Design
  • Physical Design
  • The role of the Database Administrator

Who should attend

This course is targeted towards Data and Database Managers, Information Systems Managers, Programmers, and Designers, Database Administrators, Database Users, Database Internals Programmers and anybody interested in understanding Relational Database Systems from a fundamental perspective.

 

Onsite Training  Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey