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.
CONTENT AND OBJECTIVES:
Examine and demonstrate database design concepts.
Review and expand upon the concepts specific to the environment of the participants attending the course.
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.
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.
Create relationships and then classify each of the relationships.
Define each relationship.
Referential integrity relationships will be documented and implemented.
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.
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.
Refining the Data Model
Refine the completed data model.
Review and refine the design.
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.
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.
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.
Application Design and Indexes
Determine optimization design techniques based upon the databases heuristics.
Determine the access path and cost for physical design.
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.