Physical Database Design (Certificate)

Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

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. ...''

Elements of this syllabus are subject to change.

Phone:1-800-8-SYBASE

School Address:

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

Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612


Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,

Search other schools for Physical Database Design training resources.

Mastering Transact-SQL Programming: Advanced Tips & Techniques
Implementing ASE Cluster Edition
M-Business Anywhere Fundamentals
SQL Anywhere 10.0 Fundamentals
Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Replicating Data using SQL Remote 9.0
MobiLink Synchronization with Adaptive Server Anywhere 9.0
MobiLink Synchronization with SQL Anywhere 10.0
Logical Database Design
Data Modeling with PowerDesigner 12
Business Process Modeling with PowerDesigner 12
Business Process Modeling Using PowerDesigner 11
Data Modeling with PowerDesigner 11
Essential Techniques for Object-Oriented Modeling using PowerDesigner 12
Object-Oriented Modeling with PowerDesigner 11.0
Object-Oriented Modeling with PowerDesigner 12
Data Modeling with PowerDesigner 15
Business Process Modeling with PowerDesigner 15

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 can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.