Sybase IQ Administration Training Online
Sybase IQ DBA Training, Sybase IQ DBA Online Training, Sybase IQ DBA Support Training, Best Sybase IQ DBA Online Training, Best Sybase IQ DBA Training in USA,UK,Canada,Australia.
Sybase IQ Administration Training Online Course Contents
Sybase IQ Overview and Architecture
- Sybase IQ Introduction
- Advantages of Sybase IQ
- Key Principles
- Sybase IQ Architecture
- Sybase IQ Server Overview
- Sybase IQ Database
- Dbspace and Dbfiles
Installation
- Preparing For Installation
- Installing Sybase IQ Server
- Installing Sybase IQ Client Components
- Updating Server Licenses
Sybase IQ Tools
- Connection to Sybase IQ Server
- Sybase IQ Agent
- Sybase IQ Tools
Sybase IQ Databases
- Planning For Sybase IQ Databases
- Creating a Sybase IQ Database: Command Line
- Creating a Sybase IQ Database: Sybase Central
- Managing Dbspaces
Server and Database Configuration
- Configuring the Server
- Configuring the Database
Memory Configuration
- Sybase IQ Memory Components
- Caches
- Uses of Memory
- Setting Cache Size
- Memory and Swap Usage
Sybase IQ Data and Index Types
- Sybase IQ Data Types
- Sybase IQ Index Types
Table and Index Creation
- Sql Refresher
- Base Table
- Temporary Tables
- Table Partitioning
- Views
- System Tables and System Views
- Indexes
Data Loading
- Data Loading Overview
- Load Table
- Data Loading Considerations
- Incremental Loads
- Partial-Width Loads
- Inserting Data
- Data Loading Issue Resolution
- Common Issues
- Handling Data Problems In Load Table
- Analyzing Error Log Files
User Administration
- User Administration Overview
- Login Policies
- Creating Use Account
- Defining Permissions
- Managing Users and Groups
Multiplex Configuration
- Multiplex Architecture
- Multiplex Configuration
- Multiplex Components
- Multiplex Creation
- Multiplex Management
Transaction Management and Locking
- Transactions
- Locking
- Snapshot Versioning
Monitoring Sybase IQ
- Monitoring Tools and Utilities
- Monitoring Users
- Monitoring the Server
- Monitoring the Database
- Monitoring Offer Caches: IQ Utilities
- Performance Monitoring
Troubleshooting Sybase IQ
- Sybase IQ Logs
- Diagnostic Tools
- Troubleshooting Scenarios
Backup And Restore
- Backup
- Restore
- Diagnostic Stored Procedures
Database Options
System Procedures
System Tables and Views
System Functions
System Procedures
System Tables and Views
System Functions
EmoticonEmoticon