• No results found

Sybase Catalog

N/A
N/A
Protected

Academic year: 2021

Share "Sybase Catalog"

Copied!
48
0
0

Loading.... (view fulltext now)

Full text

(1)

2010 EDUCATION CATALOG

Get Serious

Get Sybase Education

WELL-TRAINED PROFESSIONALS POWER SYBASE SOLUTIONS

Classroom and Onsite Training SyberLearning LIVETM Training

SyberLearning OnDemand TechAdvantage Series Migration Training Services Professional Certification

Skills Assessment for Organizations • • • • • • •

(2)
(3)

TABLE OF CONTENTS

Overview and Promotions 2

Services, Special Offers, Promotions and More

Database Management 8

Adaptive Server Enterprise (ASE), Logical/Physical Database Design, OpenServer/Open Client

Business Continuity 14

Replication Server, Mirror Activator, OpenSwitch

Data Warehousing 18

Sybase IQ, InfoMaker, Sybase CEP, Sybase ETL

Mobile Solutions 23

SQL Anywhere, Afaria, Manage Anywhere Studio, RemoteWare, RFID Anywhere, OneBridge, PocketBuilder, Unwired Accelerator

Modeling and Metadata 27

PowerDesigner

Development 31

PowerBuilder, Appeon for PowerBuilder, Workspace EAServer

Industry Solutions and Linux 40

eBiz Impact, EDI Server Linux

(4)

A REWARDING EXPERIENCE

High-quality training from Sybase Education Services teaches you to work with Sybase and other relevant technology products more effectively and productively. Our extensive and comprehensive IT curriculum is designed to meet your needs. In depth, hands-on, and certification-focused training teaches solid, useful skills to help you work more effectively, more productively.

DELIVERY AT YOUR CONVENIENCE

Four convenient delivery formats help you maximize your time, learning, and budget. Our certified instructors teach our courses: at a convenient Sybase Learning Center, at your site, on line with SyberLearning OnDemand, or with SyberLearning LIVETM, a virtual classroom tool that brings the education experience along with the instructor—directly to your PC.

Our range of training services makes it easy to develop individual and team capability in today’s rapidly changing technology environment.

HANDS-ON AND IN-DEPTH CURRICULUM

Our curriculum covers all Sybase products, and supports major technologies, such as J2EE, Java, and XML. The main curriculum areas are listed below:

• Database Management • Business Continuity • Data Integration • Data Warehousing • Mobile Solutions • Modeling and Metadata • Development

• Industry Solutions and Linux

• Project Management and Professional Skills

For updated courses, course descriptions, schedule and booking information, please visit our website.

EXPERIENCED INSTRUCTORS

Our instructors follow a rigorous certification process, have hands-on experience with the technologies they teach and are always up to date on the latest products and developments. Many also have extensive consultancy and development experience to share with you.

QUALITY COMMITMENT

Your satisfaction is guaranteed. We work hard to provide a high quality experience from our course offerings. We have implemented a Quality Management System (QMS), certified to ISO9001, that ensures the quality of our business processes and delivery capability. We do this in order to constantly improve our service. Should we not meet your expectations, please advise us immediately and we will remedy the situation.

SATISFIED CUSTOMERS

“Very informative. Instructor very enthusiastic and eager for us to really understand!”

Annika Ericsson

“Technical details were exactly what I wanted to know.”

Ka Yui, Mizuho International Plc

“Almost too much material for 5 days, but I learned much and my expectations were exceeded.”

Christopher Otten, First Investors Corp.

“Definitely met more than what I was expecting. I am going back to my job on Monday with more confidence to tackle all my Sybase tasks.”

Prasad, Turner Broadcasting Systems

“The course content was very comprehensive and covered extensively by the trainer.”

Azilomen, Citigroup Limited

Sybase Education

(5)

Sybase Education Services

SYBERLEARNING LIVETM TRAINING

We bring the learning to you. We’ve combined the best of traditional instructor-led training with easy-to-use, powerful technology to create a great virtual classroom experience. SyberLearning LIVETM is instructor-led, student-interactive training delivered LIVE over the Internet. It leverages top, experienced certified instructors, LIVE interaction, support, and exchange of ideas, outstanding courseware, and an on-line lab environment on the Internet that’s accessible anytime, from anywhere. Try SyberLearning LIVETM today! SYBERLEARNING ONDEMAND

Take advantage of this offering now! Select only the courses that will help your team to achieve optimal performance from our SyberLearning OnDemand course catalog. For a preview of SyberLearning OnDemand or complete course descriptions of our SyberLearning OnDemand courses, visit http://www.sybase.com/support/ education/syberlearningondemand.

TechAdvantage Series

Sybase Education TechAdvantage Series is a subscription offering made up of product-focused recorded training tracks. Each Sybase Education TechAdvantage Series track is designed to provide you with access to a selection of advanced level training events - quickly, easily and cost-effectively. Each training track consists of up to 8 one-to-two hour recorded modules – and some of the OnDemand modules also include instructor-led demonstra-tions. Access to a Sybase Education TechAdvantage Series track is $795.00 USD per seat.

LEARNING CENTER TRAINING

Our training centers are conveniently located in major metropolitan areas. We maintain a public class schedule and compliment this schedule with our SyberLearning LIVETM schedule in order to meet most clients’ needs.

CUSTOMIZED TRAINING

Tailored just right to fit your needs. We have many years of experience creating special training programs that are tailored to our customers’ precise business needs. We can incorporate selected modules from our course library plus incorporate custom-developed material related to your specific environ-ment as required. This ensures that training integrates seamlessly into your IT solution projects. Based on your needs, this training can be delivered in our Learning Centers, at your site, or on-line with SyberLearning LIVETM.

Share Our Formula for Success

Our philosophy is to work closely with you, building a long-term relationship to help you achieve your business goals. We aim to be your education provider of choice, providing training services that integrate with your business and technology solutions.

To find out more about how we can help you maximize the value of your current investment in key technologies, visit www.sybase.com/support/education or call

1-800-8-SYBASE.

Online Assessment for Organizations and Certification Practice Exams

Whether you want to evaluate and improve your own Sybase product skills, prepare for your certification exam or get comprehensive skills analysis of your entire organization, Sybase’s Skills Assessment tools can help you and your organization achieve further success. Moreover, each assessment will recommend a personalized training path upon completion!

CORPORATE CURRICULUM DEVELOPMENT SERVICES Let Sybase’s Curriculum Development team build the custom courseware you need to deliver world-class training to your organization. Our philosophy is simple — to work closely with you in building top quality courseware, while fostering a long-term relationship to help you achieve your immediate

(6)

SyberLearning LIVE™

We bring the learning to you!

SyberLearning LIVETM delivers to your desktop the same high quality, interactive, intensive training you expect from any Learning Center or Client Site delivery. SyberLearning LIVETM benefits include:

• Lecture-only and full lecture/lab online course deliveries • Live interaction with Sybase Certified Instructors • Courseware delivered to you

• Hands-on labs for full lecture/lab courses • No travel. Take a class from your home or office

VIRTUAL LABS ENVIRONMENT

You can complete your SyberLearning LIVETM class labs remotely on a virtual machine (VM) in the Sybase Education Virtual Labs Environment. Optionally, you may be able to conduct the labs on your local PC if the appropriate licensed software is already installed and configured to class specifications. The connection to the Virtual Lab environment is completely separate from your SyberLearning LIVETM connection for lecture—which means that you have access to the labs environment for the duration of your class anytime, anywhere.

LISTEN TO WHAT OUR CUSTOMERS HAVE TO SA Y ABOUT SYBASE EDUCATION …

“It was great to get training without having to travel. The SyberLearning LIVETM method of delivery was great...highly recommended.”

—William, Cornell University

“A well written course maintained and updated well for ASE15. [The] course was delivered by [an] Instructor who knew his subject area well.”

—Hristo Musulanov, BNP Paribas

“I just completed the SyberLearning LIVETM class on Query Optimization... I have taken many different Sybase classes, but this was my first SyberLearning LIVETM class and it went very well...I’m glad to see Sybase placing top instructors in the SyberLearning LIVETM classes...”

—Micah, Pella Corporation

“A very well run course, the teaching quality has been fantastic and the material spot on for what I needed.”

—Paul Taylor, Lehman Brothers

(7)

SyberLearning Ondemand™

Sybase training—always available, when and where you need it!

SyberLearning OnDemand is intense, comprehensive,

always available, technical training from Sybase—delivered to you as a complete class, and presented by our very own Certified Sybase Instructors. This outstanding offering provides you with a self-paced training solution, complete with printed course materials, pre and post assessments for each Unit, and recorded Lab Solutions. With SyberLearning OnDemand, you choose when, where, and what you want to learn. Create an information edge for yourself and your company—through measurable skills improvement using SyberLearning OnDemand.

Visit http://www.sybase.com/support/education/ syberlearningondemand for a complete listing of SyberLearning OnDemand offerings.

license oPtions Individual OnDemand

Choose the training you need by purchasing a

SyberLearning OnDemand license from the list of available OnDemand courses. Not only can you control where and when you access Sybase training, but you’ll get a printed copy of the student manual and access to review the lectures and lab solutions.

Enterprise OnDemand

Organizations will see additional cost savings when purchasing 6 or more copies on a SyberLearning OnDemand order. Additional OnDemand courses may be available from our Enterprise OnDemand course list. Contact your Education Representative for pricing and availability.

test drive sYberlearning ondemand

See SyberLearning OnDemand in action by taking a Test Drive of several courses from various Sybase product groups:

• Adaptive Server® Enterprise • Replication Server® • PowerBuilder® • PowerDesigner® • Sybase IQ • InfoMaker®

• Logical Data Modeling

All test drive modules are active, but with abbreviated module and lab solution recordings. Pre-Post Assessments are limited to 2 questions each. Progress reporting is limited to a sample report. Once you test drive SyberLearning OnDemand, we know you’ll want more…

sYberlearning ondemand @ a glance

• Navigate the course tree

• Launch your recorded lecture and lab solutions • Take a pre/post-assessment before and after each unit • View your progress

(8)

register todaY! OnLInE: SYBASE.COM/SuPPORT/EduCATIOn CALL: 1-800-8-SYBASE (1-800-879-2273) certified sYbase Professional Program

with over 40,000 participants!

Certification programs from Sybase offer you the technical skills, experience, and confidence to design and implement real-world solutions, which make you valuable to your clients and your team. Ultimately, this provides a competitive advantage for your entire organization through enhanced service, higher productivity, and lower operating costs.

Whether it’s a Sybase Professional or a Third-Party Certification, you can be confident that we will provide the courses you need to get certified!

What’s in it for emPloYers?

• Strengthen your employees’ technical skills • Independently validate your employees’ skill levels • Increase your employees’ productivity

• Improve your employees’ ability to deliver projects more effectively

For more information on our professional certification program, please visit

www.sybase.com/support/education/certification

What’s in it for You?

• Demonstrate your in-depth technical skills • Earn recognition for your learning efforts • Accelerate your career development plans

• Increase your value as a member of your employer’s team certification Paths

Certification paths have been clearly defined to help you develop your skills and achieve professional certification. They list the courses, from Introductory (I) to Expert (E), that will get you on your way.

If you already have some experience or have taken some courses, speak with a Sybase Education Representative who can suggest where best to enter the Certification Path in order to optimize your learning experience.

assessment for organizations and PreParation exams

Sybase Education now offers Assessments for

Organizations. Each participant in the assessment receives a personalized training plan. Preparation Exams are also available at no charge.

certification exams

Certification exams are independently administered and may be taken at your convenience at any Prometric Testing Center. We provide you with practice exams, study guidelines and other material to help you achieve your desired certification.

Certification

Sample Certification Path shown below:

I Fast Track to PowerBuilder Part I (dEV133) E Fast Track to PowerBuilder Part II (dEV633)

Client/Server Curriculum Web/n-Tier Curriculum

E Performance and Tuning for PowerBuilder 10: Advanced Tips and Techniques (dEV540) Mastering Reuse: Enhancing Your PowerBuilder Skills for nTier development (dEV532)

PowerBuilder developer Professional Certification

(9)

Ways to Save

SYBASE EDUCATION PASSPORT

Save up to 50% and more versus our standard pricing!* The Sybase Education Passport lets one student attend an unlimited number of Sybase or Authorized Education Partner Learning Center or SyberLearning LIVETM classes in the US or Canada for one year. With the Sybase Education Passport, the more classes you attend, the sharper your skills become, and the quicker you’ll see an increase in return on your

investment. If professional certification is your goal, use your Passport to select the recommended courses that help build your technical skills, experience and confidence and prepare you to take a Certified Sybase Professional exam with your free exam voucher. For one year, you can have it all!

* Actual savings depends on actual usage. Subject to terms and conditions. Prices, schedules and discounts are subject to change without notice.

SYBASE EDUCATION PACKAGES Discounted days of training*

Sybase Education offers discounted training packages (10 or more days) that anyone on your staff can use. Education packages are a significant value for your training investment. These packages can be redeemed at any Sybase or Authorized Sybase Education Partner Learning Center, or on

FAST TRACK TO POWERBUILDER PACKAGE

Whether you are just about to begin to maintain legacy client/server PowerBuilder code, migrate existing applica-tions to the web, or design and develop an application from scratch, the Fast Track to PowerBuilder Pack gives you access to the training you need to build a solid skill set and succeed more quickly. The Pack also makes it very easy for you to start the training you need for your PowerBuilder Certification — with the Pack, you will have taken the first two required classes to help you pass your Certification.

Fast Track to PowerBuilder Pack includes: Fast Track to PowerBuilder Part I (DEV133) & Fast Track to PowerBuilder Part II (DEV633)

Available only in the US and Canada. Subject to terms and conditions. Prices, schedules and discounts are subject to change without notice.

(10)

Database Management

CERTIFICATION PATH ADDITIONAL COURSES ASE ADMINISTRATION EDB100 TAS602 EDB366 I INTRODUCTORY Introduction to SQL E EXPERT

Adaptive Server Enterprise 15 Migration Tips and Tricks I B BUILDING

Powering up with Adaptive Server Enterprise 15.0

High Availability: Adaptive Server Enterprise Companion Server EDB310

I Fast Track to Adaptive Server Enterprise(EDB115) B Adaptive Server Enterprise (EDB356)System & Database Administration:

E Performance & Tuning: Configuring Adaptive Server Enterprise(EDB356) ASE 12.5 OR ASE 15.0

ADMINISTRATOR ASSOCIATE CERTIFICATION E Advanced Administration and Troubleshooting forAdaptive Server Enterprise (EDB652) E Troubleshooting Adaptive Server Enterprise Data Structures(EDB557)

ASE 12.5 OR ASE 15.0

ADMINISTRATOR PROFESSIONAL CERTIFICATION

ASE Administrator Certification

ASE Developer Certification

I Fast Track to Adaptive Server Enterprise(EDB115)

ASE 12.5/15.0 SQL DEVELOPER ASSOCIATE CERTIFICATION Performance and Tuning: Adaptive Server Enterprise Query Optimizer

(EDB634) E

E Mastering Transact-SQL Programming: Advanced Tips & Techniques(EDB559) I Logical Database Design (SYB144)

I Physical Database Design (EDB110)

ASE 15.0 SQL DEVELOPER PROFESSIONAL CERTIFICATION

REGISTER TODAY! ONLINE: SYBASE.COM/SUPPORT/EDUCATION CALL: 1-800-8-SYBASE (1-800-879-2273)

(11)

Database Management

EDB115

DURATION 5 Days FORMAT 70% Lecture 30% Lab SKILL Introductory TYPE Classroom Onsite SyberLearning LIVETM

FAST TRACK TO ADAPTIVE SERVER ENTERPRISE

Gain hands-on experience with the newest features of Adaptive Server Enterprise (ASE), and learn to create database objects expertly using ANSI-standard SQL and Transact-SQL extensions. Study key features and functions of ASE including automatic recovery of transactions, writing Stored Procedures and triggers, and creating and using cursors. Course material also covers important concepts from Introduction to SQL (EDB100), new functions, increased number of arguments in IN statements, increased limits on object identifiers, and new datatypes.

COURSE TOPICS: Overview of relational database concepts; using the basic components of ASE to connect to a server database; Adaptive Server clients; isql and SQL Advantage; creating tables, modifying/querying data in tables, improving query

functionality and performance; using temporary tables and system tables; using constraints, defaults, and rules to enforce data integrity; writing Transact-SQL code with functions, variables, and control-of-flow statements; and managing transactions and locking.

WHO SHOULD ATTEND: Database administrators, database designers, end-users, SQL developers. PREREQUISITES: None.

EDB553

DURATION 5 Days FORMAT 70% Lecture 30% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

PERFORMANCE AND TUNING: CONFIGURING ADAPTIVE SERVER ENTERPRISE

Learn to tune Adaptive Server Enterprise (ASE) for optimal performance and explore ASE architecture in depth. Study topics that include designing databases for performance, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/O), optimizer statistics, SMP features, relevant data structures, benchmarking tuning methodology and techniques, table partitions, and parallel processing. Examine the use of Sybase performance monitoring utilities (Monitoring Tables, sp_sysmon, system Stored Procedures) and major performance trade-offs. Gain insight on choosing appropriate locking schemes.

COURSE TOPICS: Principles of performance and tuning; Adaptive Server architectural overview; the tuning toolbox; locking principles; data-only locking tables and table fragmentation; working with multiple engines named caches; large i/o and metadata caches; cache partitioning and cache strategies; procedure and statement cache; optimizing device usage; table partitioning; optimizer statistics; parallel concepts; parallel tuning; tuning with the logical process manager; bulk copy tuning; and putting it all together.

EDB356

DURATION 5 Days FORMAT 70% Lecture 30% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

SY STEM AND DATABASE ADMINISTRATION: ADAPTIVE SERVER ENTERPRISE

Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and tempdb space, with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backup and recovery strategies, job scheduling and user access issues.

COURSE TOPICS: ASE environment and installation; reconfiguring ASE dynamically; resource allocation; database creation; user permissions and security; transaction management and logging; backup up databases and transaction logs; database recovery and restoration; modifying default Adaptive Server configuration; connectivity issues and best practices. WHO SHOULD ATTEND: Database administrators, system administrators.

(12)

EDB652

DURATION: 5 Days FORMAT: 50% Lecture 50% Lab SKILL: Expert TYPE: Classroom On Site SyberLearning LIVETM

EDB557

DURATION: 4 days FORMAT: 50% Lecture 50% Lab SKILL: Expert TYPE: Classroom On Site SyberLearning LIVETM

TROUBLESHOOTING ADAPTIVE SERVER DATA STRUCTURES

NEW

Gain a deeper understanding of the internals of Sybase Adaptive Server Enterprise 15 and how the database really works. Drill down to the byte level to determine exactly how pages, objects, databases, devices, and the server obtain, use, and track physi-cal space. Use this knowledge to identify the root causes of data corruption, and to resolve a problem before it becomes a crisis.

COURSE TOPICS: Details of physical storage; space management structures (allocation pages, OAL pages, GAM pages); page types for APL and DOL tables and indexes; effects of ASE 15 partitioning on space; allocation and deallocation; DBINFO and DBTABLE; log structure, logging, and recovery; troubleshooting and corruption fixes; use of undocumented dbcc commands. WHO SHOULD ATTEND: Database administrators, performance tuning specialists, system administrators with two to four years database administration experience.

10

ADVANCED ADMINISTRATION AND TROUBLESHOOTING FOR ADAPTIVE SERVER ENTERPRISE

Learn the extended skills of server administration: what to do when hardware fails, and how to implement special-use features of Adaptive Server Enterprise 15. Practical troubleshooting techniques and disaster prevention will make ASE highly available. Special features allow for greater flexibility in migration and automating administration, server monitoring, integrated data spaces, and resource management.

COURSE TOPICS: Installation; LDAP and CIS; understanding Sybase asset management; controlling space allocation and fragmentation; advanced dbcc commands; troubleshooting database backup and recovery; advanced monitoring tools; device failures and recovery fault isolation; data security, encryption and auditing.

Database Management

WHO SHOULD ATTEND: Database administrators, system administrators. PREREQUISITES: System and Database Administration: Adaptive Server Enterprise.

PREREQUISITES: System and Database Administration; Adaptive Server Enterprise and Performance and Tuning; Configuring

Adaptive Server Enterprise.

(13)

PERFORMANCE AND TUNING: ADAPTIVE SERVER ENTERPRISE 15.0 QUERY OPTIMIZATION

Through lecture and hands-on lab exercises, this course explores the Adaptive Server Enterprise 15.0 Query Optimizer in depth to enable students to improve the performance of their queries. Learn to measure the performance of T-SQL queries and tune your query development for the specific requirements of your business. Take advantage of the monitoring and evaluation tools of Adaptive Server Enterprise 15.0, and interpret their diagnoses into specific plans of action. Perform tasks to evaluate the behavior of the optimizer in ASE 15, and implement the most efficient data-change and data-retrieval T-SQL code in your queries and stored procedures. You will use various Sybase utilities to identify causes of slow queries, and learn techniques in resolving these problems.

COURSE TOPICS: Access methods for queries and data modification; costs and benefits of indexes; query optimizer; statistics; optimization; joins and join types; parallel queries; stored procedure compilation and performance; new index and partitioning behavior; metrics, MDA monitoring, and abstract query plans.

WHO SHOULD ATTEND: SQL developers, application developers who use SQL code, database administrators and/or Sybase system administrators who are involved in tuning queries, performance and tuning specialists, any computer professional who needs an understanding of how the Sybase Query Optimization works.

PREREQUISITES: Fast Track to Adaptive Server Enterprise; Mastering Transact-SQL: Advanced Tips and Techniques.

EDB634

DURATION 5 Days FORMAT 70% Lecture 30% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM SyberLearning OnDemand

EDB559

DURATION 4 Days FORMAT 60% Lecture 40% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

MASTERING TRANSACT-SQL PROGRAMMING ADVANCED TIPS & TECHNIQUES

Learn an array of valuable tips, techniques, and advanced topics to implement cleaner and more efficient code. Lecture and lab emphasis is on good coding practices, manipulating numbers and dates, joins and subqueries, applied case logic, cursors, and proper Stored Procedure development and debugging, as well as generalized methods for solving specific problems.

COURSE TOPICS: Indexes and search arguments; joins and subqueries; case expression; transactions and locking; cursors; manipulating and formatting data.

WHO SHOULD ATTEND: Database administrators, SQL developers.

PREREQUISITES: Fast Track to Adaptive Server Enterprise or equivalent experience.

(14)

register todaY! OnLInE: SYBASE.COM/SuPPORT/EduCATIOn CALL: 1-800-8-SYBASE (1-800-879-2273)

sYb144

DuratION: 2 days FOrmat: 80% Lecture 20% Lab SkIll: Introductory typE: Classroom On Site SyberLearning LIVETM SyberLearning Ondemand

logical database design

Learn to apply a consistent methodology in creating a logical database design that is based on the relational data model and conforms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of the relational data model and how to apply its principles to produce a fully normalized logical data model. On completion, you will be able to take a set of data requirements and develop a fully normalized logical data model and design.

course toPics: distinguishing logical database design from physical database design; using Powerdesigner to examine data models; entities, attributes, and relationships; derived and subtype entities; dependent entities; diagramming a concep-tual model; converting the concepconcep-tual model to a logical model; converting many-to-many, n-ary, and recursive relationships; normalization and the relational data model; normal forms (first, second, third, Boyce-Codd, higher); when to de-normalize; and the next step—where the logical design goes from here.

Who should attend: database designers, application developers, database administrators. PrereQuisites: none.

edb110

DuratION: 3 days FOrmat: 50% Lecture 50% Lab SkIll: Introductory typE: Classroom On Site SyberLearning LIVETM

PhYsical database design

Learn how to plan and implement Adaptive Server Enterprise (ASE) tables, indexes, and data integrity to satisfy the data and processing requirements of an enterprise. Gain exposure to all major physical design principles needed to create optimal data-base designs on the ASE 12.0 platform. Study a formal design methodology that starts with a logical data model, and translate that into a relational representation. Both local and distributed requirements are used to design the most optimal physical implementation possible. Course material also covers parallel query processing; enhanced partition statistics updates; bi-directional scans of indexes; higher maximum number of table references; dOL locking schemes, page formats, and indexes; mixed indexes; enhanced alter table command; table-specific identity gaps; and Java in the database. course toPics: A review of specifying data, processing, and distributed processing requirements; optimal indexing strategies; data integrity enforcement options; optimal data object placement strategies; security and auditing considerations; database administration issues; and distributed architecture options.

Who should attend: Application developers, database administrators, database designers.

PrereQuisites: Fast Track to Adaptive Server Enterprise or equivalent experience; Logical Database Design.

edb100

DuratION: 1 day FOrmat: 75% Lecture 25% Lab SkIll: Introductory typE: Classroom, On Site SyberLearning LIVETM

introduction to sQl

An excellent entry-level course for end-users, new programmers and database administrators. Gain practical, hands-on experience writing database queries that retrieve, organize, and summarize data managed by an Adaptive Server. Learn to construct simple and complex queries using both AnSI-89 standard SQL and Transact-SQL extensions.

course toPics: Relational database concepts; client/server architecture; simple queries (queries that retrieve all data from a given table); queries (queries that retrieve only data that matches a given condition); aggregates (simple functions that summarize data); joins (queries that retrieve data from multiple tables); subqueries.

Who should attend: End-users, prospective database administrators, database designers, application developers. PrereQuisites: none.

database Management

(15)

POWERING UP WITH ADAPTIVE SERVER ENTERPRISE 15.0

Gain hands-on experience with the newest features of Adaptive Server Enterprise version 15. The new release of ASE includes a vast array of new capabilities for administrators, SQL developers, and end users alike. Major new abilities are expected to include data partitioning, new optimization logic, and extended support for large databases.

COURSE TOPICS: Installation and upgrade; what’s new in ASE 15.0; database changes; data partitioning; optimization improvements; computed columns and function-based indexes; scrollable cursors; advanced monitoring; and diagnosis and statistics.

WHO SHOULD ATTEND: Database administrators, performance and tuning specialists, database designers, system analysts and architects.

PREREQUISITES: None.

HIGH AVAILABILITY: ADAPTIVE SERVER ENTERPRISE COMPANION SERVER

Gain an introduction to and familiarity with the implementation of Mode-2 high availability, a high availability architecture (also called distributed workloads) in which disjoint applications can run on each of the nodes of a cluster. When one node fails, the surviving node takes over its workload avoiding the “e-nightmare” of lost data access during planned or unplanned server downtime. Use Adaptive Server Enterprise’s companion server functionality to provide continuous data availability during planned and unplanned outages. With a focus on installation and configuration, implement ASE on cluster subsystems and become familiar with the facilities and features used to enable database and client connection failover and failback.

COURSE TOPICS: High Availability definitions and concepts; the ASE Companion Server and its components; installing High Availability in ASE; configuration issues of companion servers.

WHO SHOULD ATTEND: Database administrators, system administrators. PREREQUISITES: None.

Database Management

EDB366

DURATION 2 Days FORMAT 50% Lecture 50% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM SyberLearning OnDemand

EDB310

DURATION 3 Days FORMAT 60% Lecture 40% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

TAS602

DURATION Self-paced OnDemand FORMAT 50% Lecture 50% Demonstration SKILL Expert TYPE Sybase TechAdvantage Series OnDemand

ADAPTIVE SERVER ENTERPRISE 15 MIGRATION TIPS AND TRICKS I

WHO SHOULD ATTEND: ASE Administrators and SQL Developers. PREREQUISITES: Intermediate level working knowledge of Sybase ASE.

The Adaptive Server 15 Migration Tips and Tricks I track consists of eight 1-2 hour modules and takes an in-depth look at some of the functionalities, utilities and tools that will assist system administrators who are planning or currently in the middle of a migration project to Adaptive Server Enterprise version 15.0.3 ESD #1 or later. Each track module will focus on a key area of concern when upgrading the server, including the identification of proper optimizer settings, tuning the procedure cache and working with new MDA tables and other utilities.

COURSE TOPICS: Upgrading with QPTune; What’s New with the MDA Tables; Tuning the Procedure Cache with the MDA Tables; Working with Deferred Compilation; It All Traces Back - Using Application Tracing; Using Compatibility Mode to Ease Migration; Understanding New Join Methodologies; Undocumented Functionality in 15.0.3 ESD #2

(16)

Business Continuity

CERTIFICATION PATH

B BUILDING

Powering Up to Replication Server 12.6 EDB372

Powering Up to Replication Server 15.0 EDB373

Fast Track to Mirror Activator EDB375

Fast Track to Sybase OpenSwitch EDB450

Implementing Mirror Activator for Sybase EDB675

ADDITIONAL COURSES

FAST TRACK TO REPLICATION SERVER ADMINISTRATION

Learn how to design, set up, and administer replication environments. Examine the fundamental differences between a state-consistent replicated data design and a distributed application data design. Learn the basic functions of Replication Server such as replication, architecture, and usage. Review administration issues, create replication definitions and subscriptions, and study materialization options, error handling, and routes. Explore general troubleshooting practices, complete a Replication Server installation, and experience the ease of setting up a basic warm standby, high availability environment. Optional material that introduces heterogeneous replication is available.

COURSE TOPICS: Fundamental data replication concepts; Replication Server system architecture; using Sybase Central and the technical library; deploying Stored Procedure replication; performing replication system modifications; implementing and maintaining warm standby; improving warm standby performance; troubleshooting common errors and exceptions; performing a

Replication Server installation.

WHO SHOULD ATTEND: Database administrators, system administrators.

PREREQUISITES: Fast Track to Adaptive Server Enterprise; Systems and Database Administration: Adaptive Server Enterprise

or equivalent experience.

Replication Server Certification

I Fast Track to Adaptive Server Enterprise(EDB115) B Adaptive Server Enterprise (EDB356)System & Database Administration: E Fast Track to Replication Server Administrator(EDB374) E Replication Server Masters(EDB576)

Replication Server Administrator Professional Certification

14

E EXPERT

Replication Server Performance and Tuning I TAS603

EDB374

DURATION 5 Days FORMAT 55% Lecture 45% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

(17)

Business Continuity

EDB576

DURATION 5 Days FORMAT 55% Lecture 45% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

REPLICATION SERVER MASTERS

Designed for Replication Server administrators who work in complex environments where performance, disaster recovery, and high availability are the greatest priority, this course addresses real-world performance and administration concerns that are encountered in today’s active production environments. Learn and apply recovery techniques and performance tuning safely in a Learning Center test environment. Highly advanced topics including disaster, recovery, internals, benchmarking, performance, tuning, and peer-to-peer replication are addressed specifically—subjects that you will need to know to become a Replication Server master.

COURSE TOPICS: Reviewing Replication Server; recovering the primary database; troubleshooting the replicate database; rebuilding the stable queue; recovering the RSSD; planning for Replication Server tuning; understanding Replication Server internals; using function strings; benchmarking the Replication Server system; tuning the primary database; tuning the Replication Server; tuning the replicate connection; analyzing with monitors and counters; designing peer-to-peer replication. WHO SHOULD ATTEND: Application developers, database and Replication Server administrators, data warehouse designers/architects. PREREQUISITES: Fast Track To Replication Server Administration 12.5.

EDB372

DURATION 3 Days FORMAT 60% Lecture 40% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

POWERING UP WITH RE PLICATION SERVER 12.6

Designed for Replication Server administrators who are moving from a RS 12.5 environment to RS 12.6. This course covers all the new features and/or enhancements made to the latest release of Replication Server. Get the latest information about setting up and managing complex environments where performance, disaster recovery, and high availability are the greatest priority. New feature topics include: disaster, recovery, internals, benchmarking, performance, tuning, embedded RSSD, MSA, SMP, Parallel DSI, and Replication Manager.

COURSE TOPICS: New features in Replication Server 12.6; Replication Server installation and upgrade; embedded RSSD, MSA, SMP, parallel DSI; performance tuning; Replication Manager.

WHO SHOULD ATTEND: Database and Replication Server administrators, system administrators, database and data warehouse designers/architects, application developers.

PREREQUISITES: Fast Track to Replication Server Administration 12.5; Fast Track to Adaptive Server Enterprise; System and Database

Administration: Adaptive Server Enterprise 12.5; or working experience with Rep Server 12.5 and Sybase ASE 12.5.1.

EDB373

DURATION 2 Days FORMAT 60% Lecture 40% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM SyberLearning OnDemand

POWERING UP TO REPLICATION SERVER 15.0

Designed for Replication Server administrators who are moving from a Replication Server 12.5.x or greater environment to RS 15.0. This course covers all the new features and/or enhancements made to the latest release of Replication Server 15. New feature topics include: support for longer identifiers, performance, tuning, embedded RSSD enhancements, new plug-ins and capabilities for Sybase Central, bidirectional replication support for DD L in MSA, new interface for monitor and counters, larger disk partitions and replicating computed and encrypted columns.

COURSE TOPICS: New features in Replication Server 15.0; Replication Server installation and upgrade; embedded RSSD with routes; Sybase Central; Monitor and Counters; rs_ticket; Sysam 2.0 features; Parallel DSI isolation levels.

WHO SHOULD ATTEND: Database and Replication Server administrators, system administrators, database and data warehouse designers/architects, application developers.

(18)

register todaY! OnLInE: SYBASE.COM/SuPPORT/EduCATIOn CALL: 1-800-8-SYBASE (1-800-879-2273)

edb375

DuratION: 5 days FOrmat: 60% Lecture 40% Labs SkIll: Building typE: Classroom Onsite SyberLearning LIVETM

fast track to mirror activator for sYbase

Intensive, hands-on labs will demonstrate tasks for the set up, configuration, deployment, maintenance, troubleshooting, performance tuning and monitoring of a Mirror Activator environment and teach you how to increase the efficiency and reduce the workload on the Storage Replication system. upon completion of this course, you should be able to describe Mirror Activator best practices and immediately perform the tasks required to enable Mirror Activator at your own site. This course does not include labs to perform setup and configuration of Storage Replication vendor products, but does include a lecture on integrating Mirror Activator within an EMC Storage environment.

course toPics: Mirror Activator architecture; Mirror Activator software components; data ownership in MA; replication and mirroring — a comparison; Replication Server fundamentals; Mirror Activator installation, configuration and maintenance; Sybase Central; Connection Manager, Repository (RASd); data flow through Mirror RepAgent; troubleshooting and performance tuning; using Mirror Activator with EMC/SRdF.

Who should attend: database and Replication Server administrators, recovery management professionals, enterprise storage professionals.

PrereQuisites: Working knowledge of ASE 12.5.2 or higher, some understanding of Storage Replication; Fast Track to

Adaptive Server Enterprise; System and Database Administration: Adaptive Server Enterprise; or equivalent working experience.

edb450

DuratION: 2 days FOrmat: 50% Lecture 50% Labs SkIll: Building typE: Classroom Onsite SyberLearning LIVETM

fast track to sYbase oPensWitch 15.0

Learn to install, configure, and administer Sybase OpenSwitch to enable continuous availability in an ASE and RS environment. You will gain hands-on experience working with OpenSwitch to deal with planned and unplanned downtime events. In addi-tion, you will work with a sample coordination module and learn the basics of the Coordination Module API.

course toPics: Introduction to OpenSwitch; installation and configuration; unplanned downtime; registered procedures; deployment considerations; sample coordination module; coordination module API.

Who should attend: database administrators and system administrators.

PrereQuisites: Fast Track to Adaptive Server Enterprise; System and Database Administration; Fast Track to Replication Server

Administration 12.5; an understanding of the C programming language is helpful, but not required.

edb675

DuratION: 3 days FOrmat: 60% Lecture 40% Labs SkIll: Expert typE: Classroom Onsite SyberLearning LIVETM

imPlementing mirror activator for sYbase

Intensive, hands-on labs will demonstrate tasks for the set up, configuration, deployment, maintenance, troubleshooting, performance tuning and monitoring of a Mirror Activator environment and teach you how to increase the efficiency and reduce the workload on the Storage Replication system. upon completion of this course, you should be able to describe Mirror Activator best practices and immediately perform the tasks required to enable Mirror Activator at your own site. This course does not include labs to perform setup and configuration of Storage Replication vendor products, but does include a lecture on integrating Mirror Activator within an EMC Storage environment.

course toPics: Mirror Activator architecture; Mirror Activator software components; data ownership in MA; replication and mirroring — a comparison; Mirror Activator installation, configuration and maintenance; Sybase Central; Connection Manager, Repository (RASd), data flow through Mirror RepAgent; troubleshooting and performance tuning; using Mirror Activator with EMC/SRdF.

Who should attend: database and replication server administrators, recovery management professionals, enterprise storage professionals.

PrereQuisites: Solid working experience with ASE 12.5.2 and Replication Server 12.5 or higher; some understanding of storage replication.

Business Continuity

(19)

Business Continuity

REPLICATION SERVER PERFORMANCE AND TUNING I

WHO SHOULD ATTEND: Replication Server Administrators.

PREREQUISITES: Intermediate level working knowledge of Sybase Replication Server.

The Replication Server Selected Topics I track consists of eight 1-2 hour modules that explore the performance and tuning features, techniques and enhancements made to Replication Server 15.x.

COURSE TOPICS: Replication Server Architecture; Configuring Parallel DSI; Measuring Latency with rs_ticket; Stored Procedure Replication; Replication Server 15.1 and 15.2 Performance Enhancements; rs_subcmp; Monitor and Counters; sp_sysmon Rep Agent Report

TAS603

DURATION Self-paced OnDemand FORMAT 70% Lecture 30% Demonstration SKILL Expert TYPE Sybase TechAdvantage Series OnDemand

(20)

Sybase IQ Administrator Certification

CERTIFICATION PATH

I INTRODUCTORY

Reporting with InfoMaker DEV138

I INTRODUCTORY

Fast Track to Sybase ETL EDB285

B BUILDING

Migrating to Sybase IQ 15 EDB784

E EXERT

Sybase IQ for Developers EDB772

E EXERT

Implementing Sybase CEP EDB788

E EXERT

Sybase IQ Advanced Administration EDB795

ADDITIONAL COURSES

E Sybase IQ Administration (EDB785) - 5 Days

Professional Certification

E Sybase IQ Advanced Administration (EDB795) - 4 Days

Data Warehousing

(21)

Data Warehousing

EDB785

DURATION 5 Days FORMAT 50% Lecture 50% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

EDB771

DURATION 1 Days FORMAT 90% Lecture 10% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

EDB792

DURATION 3 Days FORMAT 50% Lecture 50% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

SYBASE IQ ADMINISTRATION

WHO SHOULD ATTEND: New Administrators of either Sybase IQ 12.7 or Sybase IQ 15.

PREREQUISITES: Understanding of relational database concepts and database fundamentals; 2-4 years DBA experience.

Gain a working knowledge of Sybase IQ through a combination of lecture presentations and hands-on exercises. Learn Sybase IQ 15 architecture, concepts, and terminology while setting up, configuring, administering and maintaining a Sybase IQ database in both a simplex and multiplex environment. The course covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the efficiency of the Sybase IQ DBA. You will also be heavily involved in creating a multiplex configuration of Sybase IQ to support large query loads, creating numerous tables and extracting and loading gigabits of data into your environment. This course is designed to teach students on either Sybase IQ 12.7 or Sybase IQ 15.0. All labs will be performed on Sybase IQ 15.0.

COURSE TOPICS: Sybase IQ Overview and Architecture; Installation; Sybase IQ Tools; Sybase IQ Databases; Server and Database Configuration; Memory Configuration; Sybase IQ Data and Index Types; Table and Index Creation; User Administration; Data Loading; Data Loading Issue Resolution; Multiplex Configuration; Transaction Management and Locking; Sybase IQ Monitoring; Sybase IQ Troubleshooting; Backup and Restore; Miscellaneous Topics.

SYBASE IQ QUERY PLANS AND OPTIMIZATION

Learn Sybase IQ query plans and advanced optimization features and techniques. Explore the major differences between Sybase ASE and Sybase IQ while optimizing the system and making performance enhancing decisions. Instructions on how to build effective query plans and apply the appropriate use of join algorithms will help enhance capabilities in fine-tuning a Sybase IQ environment for optimum retrieval speed.

COURSE TOPICS: Differences between Sybase ASE and Sybase IQ; query plans; joins and group by; optimizing queries; query optimization options and user selectivity.

WHO SHOULD ATTEND: SQL developers and database Administrators who will assume responsibility of an Sybase IQ production environment.

PREREQUISITES: Administering Sybase IQ for the Data Warehouse; understanding of relational database concepts, including relational database design; familiarity with Structured Query Language (SQL) and other database fundamentals; solid 2-4 years DBA or SQL developer experience.

SYBASE IQ: UNDERSTANDING OPTIMIZATION AND IMPROVING PERFORMANCE

Learn through lectures and intensive hands-on instruction how to get the most out of your Sybase IQ. Explore how to optimize queries and indexes to achieve optimal query processing by thoroughly understanding the principles of the Sybase IQ runtime engines. This will allow you to better design indexes and queries that run optimally in your own environment.

Advisor and monitoring tools to troubleshoot and repair inefficient and ineffective queries. You will then learn how to read and interpret Query Timing Diagrams and Query Plans to troubleshoot your queries or indexes.

As part of the extensive hands-on lab exercises, you will develop simple to complex reports using Sybase ETL, through which you will identify where the underlying design structure is not performing to your satisfaction. You will assess other reporting tools available in the market, how to extract data into various formats, and a range of techniques for tuning reports to increase data warehouse performance.

(22)

Data Warehousing

FAST TRACK TO SYBASE ETL

PREREQUISITES: None.

IMPLEMENTING SYBASE CEP

SYBASE IQ ADVANCED ADMINISTRATION

20

EDB285

DURATION 1 Day FORMAT 50% Lecture 50% Lab SKILL Introductory TYPE Classroom Onsite SyberLearning LIVETM

EDB788

DURATION 2 Days FORMAT 100% Lecture 0% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

EDB795

DURATION 4 Days FORMAT 40% Lecture 60% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

COURSE TOPICS: Concepts and Architecture of Sybase ETL; ETL Components, Projects, and Jobs; The ETL Development Interface; Sybase ETL Server; The ETL Project Component Store; The ETL Query Designer and Content Explorer; Customizing SQL and Transfor-mation Rules in ETL; The ETL Runtime Manager.

COURSE TOPICS: Sybase CEP architecture and implementation; CCL language for application development; Sybase CEP Adapters; Sybase CEP Adapter SDKs; UDF; Sybase CEP Studio; Performance tuning techniques; Troubleshoot Sybase CEP.

COURSE TOPICS: Advanced Administration Overview; IQ Server Advanced Configuration; Information Lifecycle Management; Sybase IQ Index Maintenance; Large Object Management; Advanced Monitoring; Advanced Multiplex Management; Advanced Data Load Processing; Advanced Security; Remote Data Access; Advanced Troubleshooting; Best Practices.

Discover proactive measures in managing and administering Sybase IQ 15. Expand your knowledge of configuring Sybase IQ through advanced server settings and database options. Learn the techniques of optimizing storage capacity that results in an overall enhanced query performance. Understand the strategies of implementing Information Lifecycle Management to allow the capture, consolidation and partitioning of vast and growing volumes of real-time and historical data with the goal in mind of improving reporting and risk management. Become very familiar with advanced index maintenance concepts and gather the skills required to manage large object data, and much more.

This course focuses on Sybase CEP’s rich development and deployment environment for building event-based applications. You will learn Sybase CEP’s integrated architecture with Sybase RAP. Explore how Sybase CEP processes and stores market, trade, pre-analytics and other data in real time. Also learn how easy it can be to create a clustered environment for further scaling and high availability. Other rich functionalities of Sybase CEP will be covered.

Learn how to make use of Sybase ETL for data extraction, transformation and loading. Explore the ETL interface, and discuss the use of projects and jobs, as well as how data is moved from sources to destination targets. Once you have covered the basics, you will learn and explore the use of more advanced ETL development tools. Hands-on labs will reinforce common scenarios of installation and configuration as well as data extraction, loading and transformation. At the conclusion of this course, you will take away files, procedures and ideas, so as to execute in the workplace newly acquired techniques specific to Sybase ETL.

WHO SHOULD ATTEND: SQL/CCL Developers, Database Administrators, System Administrators. WHO SHOULD ATTEND: Data Warehouse Professionals responsible for loading data.

PREREQUISITES: Sybase IQ Administration (EDB785); Familiarity with Sybase RAP; Working knowledge of relational databases, SQL language and application development using SQL-like languages.

WHO SHOULD ATTEND: Sybase IQ Administrators.

PREREQUISITES: Understanding of relational database concepts and database fundamentals; Sybase IQ Administration; 2-4 years DBA experience.

(23)

Data Warehousing

REPORTING WITH INFOMAKER 10.0

In this intensive hands-on course, you learn to use the InfoMaker Query and Report painters. You practice the skills needed to develop queries, reports, and graphs with InfoMaker 10.0. You also configure the InfoMaker environment, and create an executable form of your report for distribution to other people in your company.

PREREQUISITES: Basic knowledge of working in a GUI environment; basic knowledge of SQL programming.

MIGRATING TO SYBASE IQ 15

Learn how to quickly migrate from Sybase IQ 12.6/12.7 to Sybase IQ 15. In this course, you will install Sybase IQ version 15 and examine the architectural differences from previous versions to help you better understand the architectural issues and alter native methods of migration you may encounter. You will learn new features and behavioral changes in the new version. You will begin with a Sybase IQ 12.7 database that you will migrate/upgrade to a Sybase IQ version 15 database. Data migration for simplex and multiplex environments will also be discussed.

For data extraction, transformation and loading, you will learn how to make use of Sybase IQ ETL. Explore the ETL interface, and discuss the use of projects and jobs, as well as how data is moved from sources to destination targets. Once you have covered the basics, you will learn and explore the use of more advanced ETL development tools.

Hands-on labs will reinforce common scenarios of installation and configuration as well as data migration. At the conclusion of this course, you will take away scripts, procedures and ideas, so as to execute in the workplace newly acquired techniques specific to Sybase IQ 15 migration.

DEV138

DURATION 3 Days FORMAT 35% Lecture 65% Lab SKILL Introductory TYPE Classroom Onsite SyberLearning LIVETM SyberLearning OnDemand

EDB784

DURATION 3 Days FORMAT 40% Lecture 60% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

COURSE TOPICS: What is InfoMaker?; InfoMaker Painters; client/server environment; what makes up a report; creating a simple report; adding objects to a report; creating a report from multiple tables; custom reporting; filtering, sorting, and grouping; report options; creating a query; working with graphs; working with crosstabs; managing objects.

COURSE TOPICS: Introduction to Sybase IQ 15; installing Sybase IQ 15; new features; Sybase Central new features; behavioral changes; improved server performance; partitioning and dbspace management; query performance; operational management; migrating data with simplex databases; migrating data with multiplex databases; concepts and architecture of Sybase IQ ETL; ETL components, projects, and jobs; the ETL development interface; Sybase ETL Server; the ETL Project Component Store; the ETL Query Designer and Content Explorer; customizing SQL and transformation rules in ETL; the ETL Runtime Manager.

WHO SHOULD ATTEND: Database administrators, system administrators.

WHO SHOULD ATTEND: Data and information professionals, strategic planners and business analysts, managers or support staff who want to produce quick, ad-hoc reports.

PREREQUISITES: Working knowledge of Sybase IQ, or completion of Administering Sybase IQ for the Data Warehouse, or Sybase IQ for

(24)

Data Warehousing

22

REGISTER TODAY! ONLINE: SYBASE.COM/SUPPORT/EDUCATION CALL: 1-800-8-SYBASE (1-800-879-2273)

SYBASE IQ FOR DEVELOPERS

EDB772

DURATION 3 Days FORMAT 40% Lecture 60% Lab SKILL Expert TYPE Classroom Onsite SyberLearning LIVETM

COURSE TOPICS: Sybase IQ product overview and environment; Sybase IQ architecture and terminology; Sybase IQ index and data types; creating tables, and indexes; using Sybase IQ client tools; loading data into Sybase IQ; transaction management and locking; difference between Sybase ASE and Sybase IQ; overview of query plans, joins and group bys; query optimization options and user selectivity.

Learn Sybase IQ architecture, concepts, and terminology from a developer’s perspective while setting up, loading and maintaining a Sybase IQ database. Understand the major differences between Sybase ASE and Sybase IQ when coding, optimizing the system and making performance enhancing decisions. Instructions on how to build effective query plans, applying the appropriate use of joins and group by clauses in a Sybase IQ platform will help you enhance your capabilities in fine-tuning the environment for optimum retrieval speed.

WHO SHOULD ATTEND: SQL developers who will assume responsibility for writing queries for Sybase IQ.

PREREQUISITES: Understanding of relational database concepts, including relational database design; familiarity with Structured Query Language (SQL) and other database fundamentals.

(25)

Mobile Solutions

COURSES OFFERED

I INTRODUCTORY

M-Business Anywhere Fundamentals IAS181

SQL Anywhere 10.0 Fundamentals IAS185

Fast Track to unwired Accelerator DEV107

B BUILDING

Fast Track to RFID Anywhere DEV300

Building Enterprise Wireless Applications Using PocketBuilder DEV333 MobiLink Synchronization with SQL Anywhere 10.0 IAS387

Afaria System Administration AFA351

RemoteWare System Administration RWR361

E EXPERT

Afaria Advanced Functionality AFA551

Remoteware Advanced Functionality RWR561

IAS181

DURATION 5 Days FORMAT 70% Lecture 30% Lab SKILL Introductory TYPE Onsite SyberLearning LIVETM

M-BUSINESS ANYW HERE FUNDAMENTALS

M-Business Anywhere provides a platform for extending web-based content and applications to mobile devices rapidly and cost-effectively. Learn how to leverage your existing skill sets and open standards to develop and deploy M-Business Anywhere applications with sync-and-go capabilities. This course begins with an introduction to M-Business Anywhere, including installation and configuration of M-Business servers and clients, and then teaches you how to develop your standalone applications

quickly and effectively.

COURSE TOPICS: Understand M-Business Anywhere server; introduction to the M-Business Anywhere server; M-Business

Anywhere server components and configuration; M-Business Anywhere client components and configuration; channel development; HTML DOM and JavaScript best practices; using the UltraLite database with M-Business Anywhere; using the UltraLite

JavaScript helper classes; re-branding and customizing the M-Business Anywhere client; Administration and client upgrades; security; troubleshooting.

WHO SHOULD ATTEND: Developers who will be building applications with M-Business Anywhere.

PREREQUISITES: Working knowledge of Microsoft Windows, web architecture fundamentals (HTML, JavaScript, web servers, HTTP) and familiarity with either Palm or Windows mobile devices.

(26)

register todaY! OnLInE: SYBASE.COM/SuPPORT/EduCATIOn CALL: 1-800-8-SYBASE (1-800-879-2273)

Mobile Solutions

ias185

DuratION: 4 days FOrmat: 60% Lecture 40% Lab SkIll: Introductory typE: On Site SyberLearning LIVETM

sQl anYWhere 10.0 fundamentals

Gain an understanding of mobile and workgroup database functionality and administration. Learn how to develop and manage standalone and server databases. Insert and retrieve data; meet enterprise standards for data availability, security, consistency and integrity. design databases, queries, and stored procedures for optimal performance.

course toPics: An overview of SQL Anywhere; connecting to the database; creating and using databases; database objects; manipulating data; programming interfaces overview; transaction processing, backup and recovery; security; common adminis-tration tools; stored procedures and triggers; automating tasks with schedules and events; performance and tuning; accessing remote data; and deployment issues.

Who should attend: database administrators, SQL Anywhere application developers. PrereQuisites: none.

dev107

DuratION: 3 days FOrmat: 50% Lecture 50% Labs SkIll: Introductory typE: Classroom On Site SyberLearning LIVETM

fast track to unWired accelerator

Learn to accelerate the mobilization of your web applications, web sites, intranets, portals, Web Services applications, and database-driven applications using Sybase unwired Accelerator. This course will demonstrate how to develop mobile applications for both connected and disconnected access using a point-and-click development toolset. non-technical users can quickly and easily mobilize a basic application without a programming requirement.

You will build applications to support desktops, laptops, tablets, BlackBerry devices, PocketPCs, and Smart Phones in a connected setting. When used with M-Business Anywhere, unwired Accelerator provides disconnected access on PocketPCs, Palms, and laptops. Intensive, hands-on labs will demonstrate tasks for the set up, configuration, development and deploy-ment of the above deploy-mentioned mobile applications. upon completion of this course, you should be able to navigate the unwired Accelerator GuIs and immediately perform the tasks required to mobilize your own applications.

course toPics: unwired Accelerator introduction; unwired Accelerator architecture; Mobile Web Studio; directory structure and configuration; Mobile Application Builder; building web and mobile applications; building a database application; Web Services element; building advanced mobile applications; administering the Mobile Web Studio; deploying applications to BlackBerry devices.

Who should attend: Web and mobile application development professionals.

PrereQuisites: Familiarity with web development scripting languages such as HTML, XML, JSP and JavaScript.

22

(27)

Mobile Solutions

DEV333

DURATION 2 Days FORMAT 50% Lecture 50% Lab SKILL Building TYPE Classroom Onsite

BUILDING WIRELESS ENTERPRISE APP LICATIONS USING POCKETBUILDER

PocketBuilder can be used to create sophisticated data-driven applications for the Pocket PC. Learn how to access and update enterprise data from a mobile device without requiring a wireless network connection. Design and build an application that uses Adaptive Server Anywhere and MobiLink synchronization. Practice techniques for connecting PocketBuilder applications to your ASA database using the DataWindow, and synchronize your mobile database application with your enterprise servers. Also learn how to refresh your Pocket PC device with specific subsets of corporate data for disconnected use, and the steps for deploying your database and applications to a Pocket PC device.

COURSE TOPICS: PocketBuilder overview; PocketBuilder vs. PowerBuilder; enterprise mobile applications; potential systems for mobile applications; migrating PowerBuilder applications; Pocket PC application design, development, and architecture; integrating with Windows CE APIs; tips for working with Windows CE; mobile computing architectures; a look at SQL Anywhere Studio; PocketSOAP and Web Services; application testing and deployment.

WHO SHOULD ATTEND: Application designers, application developers. PREREQUISITES: PowerBuilder Developer experience.

MOBILINK SY NCHRONIZATION WITH SQL ANYW HERE 10.0

MobiLink introduction and overview; setting up consolidated and remote databases; how MobiLink synchronization works; partitioning data; data uniqueness within a distributed database; resolving synchronization conflicts; handling synchronization errors; security in a distributed database environment; extended options and customization hooks for SQL Anywhere remotes; how to take advantage of the various utilities provided by SQL Anywhere.

COURSE TOPICS: MobiLink introduction and overview; setting up consolidated and remote databases; how MobiLink synchronization works; partitioning data; data uniqueness within a distributed database; resolving synchronization conflicts; handling

synchronization errors; security in a distributed database environment; extended options and customization hooks for SQL Anywhere remotes; how to take advantage of the various utilities provided by SQL Anywhere.

WHO SHOULD ATTEND: Technical professionals who have a need to maintain data between enterprise databases and

DEV300

DURATION 3 Days FORMAT 50% Lecture 50% Lab SKILL Building TYPE Classroom Onsite SyberLearning LIVETM

IAS387

DURATION 3 Days FORMAT 67% Lecture 33% Lab SKILL Building TYPE Onsite SyberLearning LIVETM

FAST TRACK TO RFID ANYW HERE

Gain critical knowledge and skills to utilize RFID Anywhere to plan, develop, deploy, manage and maintain sensor networks. Hands-on, developer focused, the course assumes you have working knowledge of the Auto-ID industry and solutions to the challenges associated with adopting Auto-ID technology. The class begins with the installation of RFID Anywhere and then moves to a series of lectures and hands-on labs covering the key features of the RFID Anywhere platform.

COURSE TOPICS: RFID Anywhere architecture overview; installing RFID Anywhere; the RFID Anywhere Administrator console; publication/subscription using ALE and Report Engine MP; RFID Anywhere business modules; RFID Anywhere advanced development concepts; other devices — GPIO, barcode, PLC, printers, sensors, mobile devices; Location Information System; Enterprise

Manager; RFID Anywhere Label Designer.

WHO SHOULD ATTEND: Developers, systems integrators, anyone who will be responsible for installing and implementing RFID Anywhere.

PREREQUISITES: Microsoft Visual Studio.Net with intermediate C# development experience; knowledge of the Auto-ID industry and challenges associated with adopting Auto-ID technology.

(28)

register todaY! OnLInE: SYBASE.COM/SuPPORT/EduCATIOn CALL: 1-800-8-SYBASE (1-800-879-2273)

afa351

DuratION: 4 days FOrmat: 50% Lecture 50% Lab SkIll: Building typE: Classroom

afaria sYstem administration

Learn how to get your Afaria system up and running quickly and efficiently. Covering installation, setup and system monitor-ing, this course focuses on hands-on practice with your own server, client machines and handheld devices. Learn to use chan-nels to deliver documents, back up data, deploy and install software, script sessions, configure handheld devices, and gather client hardware and software information. define whether clients access channels from a web page or Afaria’s Channel Viewer. during the workshop section, solve common business problems using the skills you’ve learned.

course toPics: Installation preparation; server and client installation and setup; content management with document Manager; data loss recovery with Backup Manager; application management with Software Manager; session automation with Session Manager; asset management with Inventory Manager; license tracking with License Manager; locking down lost/stolen devices with Security Manager; server administration; updates to the latest version of Afaria!

Who should attend: System administrators, support professionals, system engineers.

PrereQuisites: understanding of Internet and intranet concepts such as HTML and web page use; knowledge of Windows nT concepts such as nT services, user and group accounts and domains; familiarity with Windows standard GuI conventions; familiarity with handheld devices.

rWr361

DuratION: 5 days FOrmat: 50% Lecture 50% Lab SkIll: Building typE: Classroom

remoteWare sYstem administration

Learn to install and set up the RemoteWare Server, Clients, and Managed Client components. Find out how to define system tasks, distribute software applications, gather hardware and software asset data and monitor system activity.

course toPics: RemoteWare server and client installation and setup; RemoteWare managed client installation; work objects and events; inbound, outbound, both and process only sessions; assignments; session activity viewing; work object groups; master worklist; system and user-defined variables; software distribution and maintenance using Software Manager; software and hardware asset tracking with Inventory Manager; remote control and Interactive Session; antivirus solutions; work object and session workshop.

Who should attend: System administrators, support professionals, system engineers.

PrereQuisites: understanding of network administration and security basics; knowledge of Windows nT concepts such as nT services, user and group accounts and domains.

afa551

DuratION: 3 days FOrmat: 40% Lecture 60% Lab SkIll: Expert typE: Classroom

afaria advanced functionalitY

Take advantage of your current Afaria environment. This class will be primarily workshop based. The instructor will be there to guide participants to the solutions.

course toPics: How to plan for an installation; installing a Server Farm and Afaria Clients; advanced use of Session Manager events; disaster recovery.

Who should attend: System administrators, support professionals, system engineers. PrereQuisites: Attended Afaria System Administration Course or prior Afaria experience.

rWr561

DuratION: 2 days FOrmat: 30% Lecture 70% Lab SkIll: Expert typE: Classroom

remoteWare advanced functionalitY

Take advantage of your current RemoteWare environment. This class will be primarily workshop based. The instructor will be there to guide participants to the solutions that will be presented to them.

course toPics: Building on your current foundation; using SQL; performance tuning; disaster recovery. Who should attend: System administrators, support professionals, system engineers.

PrereQuisites: Current user of RemoteWare or attended RemoteWare System Administration Course.

Mobile Solutions

References

Related documents

It can further be inferred from the discussions that the emergence of gated communities affect urban planning and management in the area of infrastructure and

NOAC to warfarin - For dabigatran, the duration of concurrent treatment is based on renal function: CrCl ≥ 50 mL/ min: Start warfarin 3 days prior to stopping dabigatr an.. CrCl

Course Title Hours Duration 1 International Accounting & Finance 12 2-3 Days 2 International Operations Management 12 2-3 Days 3 Information Systems, Competition

2) Practitioner (Objective-testing format, 2 hours duration, 4 questions, 15 marks per question, 60 marks available, 30 marks (50%) or more are required to pass, Open- book

People will often tell me, “Come to my back yard; the turkeys aren’t even concerned about me.” The inference is that I couldn’t catch fish in a fish bowl, and that turkey

H a l: There is a statistically significant difference in the G rade 11 students’ proficiency in reading as m easured b y PSSA test scores betw een students w ho were

We agree that during the Period of Cover, should Your Product suffer Accidental Damage, Accidental Loss or Theft, We will elect at Our option, to repair the Product or if it is

• All annual update information is posted in the “Installed Capacity Market (ICAP)” section of the NYISO public website under “Reference Documents” > “Demand Curve