SAP Sybase IQ Administration (EDB785)

  • SAP
    Certifications:
    SAP CAA - SAP IQ 16.0 Administration
    Quantity

    $3,695.00

    New Age Technologies has been delivering Authorized Training since 1996. We offer SAP’s full suite of authorized courses including courses pertaining to PowerDesigner, Sybase IQ, Enterprise Resource Planning (ERP), BusinessObjects, Product Lifecycle Management (PLM), and more. If you have any questions or can’t seem to find the SAP class that you are interested in, contact one of our SAP Training Specialists. Invest in your future today with SAP training from New Age Technologies.

    SAP Training Specialists | ☏ 502.909.0819


    COURSE INFORMATION

    SAP Sybase IQ Administration (EDB785) Course Overview:

    The SAP Sybase IQ Administration (EDB785) course will teach you how to keep SAP IQ up, running, stable and productive for your users while you explore the optional and advanced features of the product.

    NOTE: Course based on software release – SAP IQ 16 Service Pack 3

    SAP Sybase IQ Administration (EDB785) Course Goals:

    • Describe the SAP IQ architecture
    • Install SAP IQ
    • Connect to SAP IQ
    • Plan for and create an SAP IQ database
    • Configure the server and database
    • Configure memory
    • Define SAP IQ datatypes and index types
    • Load data and manage data loading issues
    • Manage SAP IQ security
    • Create and manage multiplexes
    • Manage transactions and locking in SAP IQ
    • Monitor SAP IQ
    • Troubleshoot SAP IQ
    • Back up and restore SAP IQ databases

    Who Should Attend:

    • Database Administrator

    SAP Sybase IQ Administration (EDB785) Course Prerequisites:

    Before attending this course, you must have the following:

    • Understanding of database concepts and database fundamentals
    • Knowledge of SQL
    • Recommended 2-4 years DBA experience

    SAP Sybase IQ Administration (EDB785) Course Content:

    SAP IQ Overview and Architecture
    • Describing SAP IQ
    • Describing SAP IQ Architecture
    Installation
    • Installing SAP IQ
    SAP IQ Tools
    • Connecting to SAP IQ
    SAP IQ Databases
    • Planning for SAP IQ Databases
    • Creating SAP IQ Databases
    Server and Database Configuration
    • Configuring the Server
    Memory Configuration
    • Configuring Memory
    SAP IQ Data and Index Types
    • Defining SAP IQ Datatypes and Index Types
    Table and Index Creation
    • Describing SQL in SAP IQ
    • Creating Tables
    • Creating Views
    • Creating Indexes
    Data Loading
    • Loading Data
    Additional Data Loading Topics
    • Inserting data
    • Resolving Data Loading Issues
    Security Management
    • Designing a Security Model
    • Implementing a Security Model
    • Migrating Authorization
    Multiplex
    • Creating a Multiplex
    • Managing a Multiplex
    • Managing Resources Through Logical Servers
    Transaction Management and Locking
    • Describing Transactions and Locking in SAP IQ
    SAP IQ Monitoring
    • Monitoring SAP IQ
    SAP IQ Troubleshooting
    • Troubleshooting SAP IQ
    Backup and Restore
    • Backing Up SAP IQ databases
    • Restoring SAP IQ databases
    Licensing and Premium Features
    • Generating SAP IQ Licenses

    Average Salary for Skill: Sybase

      Top