Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Database Design

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCSY156

Database Design
DURATION: 4 days

FEE: $1,580

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • System Analyst
  • Systrem Designer
  • Web Developer
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Overview
      • Examine and demonstrate database design concepts.
      • Review and expand upon the concepts specific to the environment of the participants attending the course.
    2. Introduction to Database Design
      • Examine and analyze a database design document.
      • Analysis of a simple database design; this will be expanded upon and modified later in the course.
    3. Entities
      • Create classes and then classify each of the entities that have been designed.
      • Manufacturing production case study: Creating a database.
      • Design entities which emphasize the physical attributes of each entity.
      • Code or generate the DDL and implement the database.
    4. Relationships
      • Create relationships and then classify each of the relationships.
      • Define each relationship.
      • Referential integrity relationships will be documented and implemented.
    5. Attributes
      • Create unique and check constraints.
      • Evaluate the type of data integrity and constraints.
      • Document and create unique indexes.
      • Perform data editing by checking constraints and utilizing triggers.
    6. Entity Keys
      • Create keys which demonstrate improved performance and other costs.
      • Design, classify, and create keys for each entity.
      • Evaluate the effect of the design on I/O cost, index levels, leaf and non leaf amounts, and space issues.
    7. Refining the Data Model
      • Refine the completed data model.
      • Review and refine the design.
    8. Normalization
      • Review the design for denormalization.
      • Calculate the approximate physical cost to retrieve the data.
      • Empirically determine whether denormalization is required.
      • Review the data model to determine if the appropriate level of denormalization has been used and whether there was an alternative for avoiding denormalization.
    9. Data Integrity
      • Review the design for data integrity.
      • Implement hierarchical structures to ensure that integrity, completeness, and the ability to traverse the hierarchy have been incorporated into the design.
    10. Physical Design Considerations
      • Utilize the physical design techniques on an existing database.
      • Case study: Identify and propose solutions for the partitioning of data, indexes, join techniques, and volatile columns.
    11. Application Design and Indexes
      • Determine optimization design techniques based upon the databases heuristics.
      • Determine the access path and cost for physical design.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.