Main Pages

Trainingwarehouse | Courseware | IT Instructor-Led Courseware | Databases | Database Design & Management

Trainingwarehouse > Courseware > IT Instructor-Led Courseware > Databases > Database Design & Management

Database Design & Management Ref: CMDDM

Course length: 30-40 hours. This course provides managers and database administrators with valuable background information about the planning, design and implementation of professional database systems.

Course content:

Overview
        Data Systems
        Data Models
        The Database Design Process

The Business Narrative
        The Importance of the Business Narrative
        Source of the Data
        Content of the Document
        The Document Creation Process

Entity-Relationship Diagrams
        The Entity-Relationship Model
        The Entity-Relationship (ER) Diagram
        Unique Identifiers (UID)
        Laying Out the ER Diagram
        Reading Relationship Statements

Designing the Database
The Process of Normalization
        Converting the Business Narrative to an ER Diagram

Table Instance Charts
Mapping ER Diagrams to the Table Instance Charts

SQL Tables
The Create Table Command
        Constraints
        Constraint Name Naming Conventions
        The Column Constraint Clause
        The Table Constraint Clause
        TIC to CREATE TABLE Statement

Data Flow Diagrams
        A Typical Data Flow Diagram
        Constructing a Data Flow Diagram
        Levelling the DFD

Database Design & Management Student Manual

Price: (4 or fewer items) £39.95
Price: (5 to 19 items) £35.96
Price: (20 to 49 items) £31.96
Price: (50 or more items) £27.97

Quantity:

Trainingwarehouse > Courseware > IT Instructor-Led Courseware > Databases > Database Design & Management