Crystal Reports 2008: Report Design I - Fundamentals of Report Design

About this class

Learn how to plan and implement Adaptive Server Enterprise (ASE) tables, indexes, and data integrity to satisfy the data and processing requirements of an enterprise. Gain exposure to all major physical design principles needed to create optimal database designs on the ASE 12.0 platform. Study a formal design methodology that starts with a logical data model, and translate that into a relational representation. Both local and distributed requirements are used to design the most optimal physical implementation possible.

Course material also covers parallel query processing; enhanced partition statistics updates; bi-directional scans of indexes; higher maximum number of table references; DOL locking schemes, page formats and indexes; mixed indexes; enhanced alter table command; table-specific identity gaps; and Java in the database.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

Database Designers, Application Developers, Database Administrators

What delegates will learn

Upon completion of this course, you will be able to:

• Present the essential tools to generate optimal database designs
• Introduce the Information Systems Architecture (IAS)
• Explain a formal database design methodology
• Describe the physical design deliverables of the data architecture
• Introduce the process matrix as a tool used to collect application requirements
• Show the impact that selecting an optimal primary key can have on the design and performance of a database
• Determine whether the “cost” of implementing integrity is beneficial
• Provide a solid foundation for implementing indexes and index strategies
• Introduce techniques that can reduce access time and disk I/Os for the most important processes
• Introduce techniques to eliminate joins and improve overall data access when joining tables
• Determine how to best place objects (indexes, tables, logs) for optimal performance given object placement guidelines

What prerequisites are required

• Fast Track to Adaptive Server Enterprise (EDB110) or equivalent experience, Logical Database Design (SYB144)

Contents of this class

• A review of specifying data, processing and distributed processing requirements, optimal indexing strategies, data integrity enforcement options, optimal data object placement strategies, security and auditing considerations, database administration issues, and distributed architecture options.