Integrated Process Engineering and Auditing solution for compliance
with: SOX, SAS 70,
CMM and ISO 9001
Click here to review book and place order
Database Design & Management
 
Overview: Database technologies have made information accessible to the largest audience ever. This is due to the convergence of Microcomputer Systems, the Relational Model, integrated spreadsheet applications, computer graphics and computer objects technologies.

This course assumes some knowledge of Information Processing System concepts and principles and at least one programming language.

   
Course Objectives:
• To provide an understanding of database design and management concepts
• To provide an understanding of the current trend towards distributed systems, objected oriented systems, knowledge-based systems
• To provide and understanding of the Relational and CODASYL Models
Target Audience:
• Project Managers
• System Engineers
• System Analysts
• Test Analysts
• Staff Personnel seeking to advance their IT career
   
ISC-5001 Database Design and Management Course Content
INTRO TO DBMS DATABASE DESIGN
History Of Database Design Goals
Advantages of Database User Views
Disadvantages of Database Design Methodology
DBMS FUNCTIONS Entity Relationship Model
Data Storage, Retrieval/Update Representing Views as Relations
Data Definition Mapping to the Relational Model
User Access Control Mapping to the CODASYL Model
Transaction Processing Space Requirement Analysis
Concurrency Control DATABASE ADMINISTRATION
Recovery Techniques Technical Functions
Data Communications Techniques Application Functions
Data Integrity Constraints Management Functions
THE RELATIONAL MODEL CURRENT TREND
Data Manipulation Distributed Database System
Structured Query Language Database Platform
Query By Example Object Oriented System
Relational Algebra Knowledge Base System
DB2 Database Server
NORMALIZATION CASE STUDY (MS ACCESS)
Functional Dependence Creating a Database
Database Keys Data Entry Functions
1st, 2nd & 3rd Normal Forms Modifying Database Structured
Multi-Valued Dependencies Reporting
Fourth Normal Form Query Functions
Higher Normal Forms Performing Update
Application to Database Design Creating Custom Forms

 
Copyright © 1999-2008 Independent Software Certification