Administering Sybase IQ for the Data Warehouse

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:

'' Acquire a working knowledge of Sybase IQ through a combination of lecture presentation and hands-on laboratory exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, loading, and maintaining a Sybase IQ database. Course material also covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the performance and tuning of Sybase IQ. Create a multiplex configuration of Sybase IQ to support large query loads, create tables and load data.
Course Objectives :
Upon completion of this course, you will be able to:
Effectively administer a Sybase IQ (Simplex or Multiplex)
Choose the correct Sybase IQ index types
Create Sybase IQ databases, tables, and indexes
Load data into Sybase IQ from a variety of sources
Create and load join indexes
Backup and restore a Sybase IQ database
Monitor and troubleshoot a Sybase IQ installation
Learn performance and tuning techniques for Sybase IQ
Setup a Multiplex Sybase IQ environment
Course Topics :
Sybase IQ product overview, environment, architecture and terminology, installing and configuring Sybase IQ, Sybase IQ index types, creating databases, tables and indexes, Sybase IQ memory configuration, loading data into Sybase IQ, Sybase IQ operational data administration, join indexes, backup and restore, monitoring and troubleshooting, performance and tuning, creating a multiplex database, multiplex architecture, and multiplex loading.

Who Should Attend : Database Administrators, System Administrators

Prerequisites :

Understanding of relational database concepts, including relational database design
Familiarity with Structured Query Language (SQL) and other database fundamentals
Solid 2-4 years DBA experience

...''

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.

High Availability: Adaptive Server Enterprise 12.0 Companion Server
Fast Track to Dynamic Archiving
Powering Up with Adaptive Server Enterprise 12.5
Powering Up with ASE 12.5.2
Managing and Tuning tempdb
Using Abstract Query Plans
Dynamic Reconfiguration for Managing Memory Nonstop Optimal Performance
Interpreting the Major ASE System Tables
Implementing ASE Replicator
Unix to Linux Migration for Adaptive Server Enterprise
Interpreting SP_SYSMON
Advanced Performance: Monitoring Tables Facility
Fooling, Cheating, Lying and Understanding the Optimizer
Open Client Programming Using Client-Library
Open Server Programming
Understanding Indexes
Harness the Power with Configurable Parameters
Using SybMigrate
Powering Up to ASE Interim Releases

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.