Physical Database Design

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.
Course Objectives :
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
Course Topics :
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.

Who Should Attend : Database Designers, Application Developers, Database Administrators

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


...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server
Troubleshooting Adaptive Server Data Structures
Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Logical Database Design
XML Certification Boot Camp
Introduction to Cascading Style Sheets
Introduction to JavaScript
Introduction to Java 2 Programming
Intermediate Java 2 Programming
Advanced Java 2 Programming
Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Building Wireless Enterprise Applications using Pocket PowerBuilder

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.