|
STUDY GUIDELINES
Sybase Certified Approved Study Guidelines are an excellent way to stay up-to-date on Sybase products and technologies and effectively prepare for Sybase exams. All approved study guidelines are based on the exam's objectives and designed to help you meet them.
Section 1 - Sybase IQ Overview - 5% (3 Questions)
Focus is on general Sybase IQ overview and architecture.
- What is Sybase IQ
- Advantages, Benefits, and Principles of Sybase IQ
- Server, Database, Files, Tables and Index Architectures
Section 2 - Installation and Configuration - 10% (6 Questions)
Focus is on the environment, installation, server configuration parameters, and establishing connectivityÂ? interfaces (UNIX) and sql.ini file (NT).
- System Requirements
- Installing IQ and Validating the Installation
- Setting up ODBC, JDBC, and Open Client
- Database Options
- Communication Protocols
Section 3 - Databases - 10% - (6 Questions)
Focus is on creating databases, page sizes, and the use of devices.
- Creating aSybase IQ Database
- Sybase IQ dbspaces
- Page Size
Section 4- Tables, Indexes, and Datatypes - 18% - (10 Questions)
Focus is on the various types of tables, indexes, and datatypes, and their usages.
- Data Types and When to Use Them
- Index Types, when to use them
- Tables Types, when to use them, and how to create them
Section 5- Loading Data - 10% - (6 Questions)
Focus is on the various methods of loading data.
- Data Sources and Table Loading
- Loading Data from Files
- Loading Data using the Insert Command
- Load Commands
- Debugging Load Problems
- Database Options Associated with Loading Tables
Section 6- Querying on Sybase IQ- 8% - (4 Questions)
Focus is on specific IQ SQL features, functions, exporting data, and query plans.
- SQL Features and Functions
- Exporting Data
- Query Plans and Options
- Query Optimization
Section 7- User Administration and Security - 5% - (3 Questions)
Focus is on data security and users, creating users, and managing accounts.
- Data Security and Users
- Creating and Managing User Accounts
- Resource Authority
Section 8- Transaction Management - 10% - (6 Questions)
Focus is on transactions, locking, and snapshot versioning.
- Transactions
- Locking
- Snapshot Versioning
- DDL Operations
- Check Points
Section 9- Backup and Recovery - 5% - (3 Questions)
Focus is on the backup and restore methods.
- Backup Methods
- Restore Methods
Section 10- Multiplex - 8% - (4 Questions)
Focus is on the architecture, setup, and operation of an IQ-Multiplex database.
- Write and Query Servers
- Creating an IQ-Multiplex Database
- Steps to Setting Up Multiplex
- Multiplex Operations
- IQ Agent
Section 11- Performance and Tuning - 10% - (6 Questions)
Focus is on configuration parameters and performance optimization.
- Create Database Parameters
- Index Advisor
- Balancing Caches
- Disk Striping
- Parallel IQ
- Minimize Storage
Section 12- Troubleshooting Techniques - 5% - (3 Questions)
Focus is on monitoring and troubleshooting techniques.
- Monitoring
- Troubleshooting
|
Sybase IQ (Version 12.6) Administrator Professional
