Physical Database Design (Certificate)

Sybase, Inc.
Ottawa, Toronto, Ontario, Canada

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:(978) 287-1626

School Address:

Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8

Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto

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.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.