Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Introduction to Sybase IQ
Sybase Training Overview:

The INTRODUCTION TO SYBASE IQ class will teach participants how to utilize this product to accomplish their data warehousing requirements. Students will be taught how to write intelligent queries and interactive ad hoc statements. Multiplexing, efficient query execution, incremental loading, fast aggregations, parallel processing, stored procedure processing and indexing will all be discussed in great detail. Participants attending this class will also be taught how to use the Sybase IQ administration utilities such as Sybase Central and DBISQL.

Sybase Training Objectives:

Upon successful completion of this course, participants will be able to create and process SYBASE IQ tables and all related entities. The students will be able to efficiently access Sybase IQ data, and be capable of creating and managing stored procedures, databases, users, groups and views. The students will understand the concepts and facilities provided through Sybase IQ and will efficiently be able to access their required data.

Sybase Training Prerequisites:

Having worked with a relational database management system will be of advantage for a prospective student, but is not required.

Sybase Training Audience:

This course is recommended for applications programmers, systems programmers, database administrators, database designers and all other related personnel who require an in depth understanding of the SYBASE IQ facility.

Course duration:

2 days

Sybase Training Course outline

The Sybase IQ product

Sybase IQ Components

Utilities

The demo database

Sybase IQ Concepts
  • Catalog store
  • Dbfile
  • Dbspace
  • Free list
  • IQ main store
  • IQ temporary store
  • IQ transaction log
  • Join index
  • Partition key
  • Proxy table
  • Range partition
  • Synchronization
  • Table partition
  • Tablespace
  • Tables
  • Primary and foreign keys
  • Queries
  • System tables
Connecting to servers

Viewing a database schema

Viewing database tables

Viewing objects

Sending commands to the database

Disconnecting

Managing databases

Managing tables

Editing existing tables

Deleting tables

Managing procedures

Managing users

Managing groups

Creating column indexes

Creating join indexes

Loading data

Managing dbspaces
  • Creating and altering
Adding rows to a table

Deleting rows

Updating rows

Data consistency

Synchronizing join indexes

Deleting dbspaces, tables and indexes

Using views

Defining a view

Restrictions on views

Student Lab Assignments




 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy