Sybase Education Times - Issue 11
> TechWave 2007 Pre-Conference > New Classes > New Certifications and a Brand New Logo > PowerDesigner Certification


Don't miss out on our TechWave 2007 Pre-Conference sessions: 2-day intensive classes with labs

Two days of accelerated learning in Vegas

If you’re attending TechWave 2007, you can’t afford to miss the Pre-Conference event and all the NEW sessions being offered. You'll get a comprehensive technical learning experience that delivers accelerated training on new and current product releases from our own instructors and other Sybase experts.

TechWave 2007 will be hosted at Mandalay Bay, Las Vegas, August 6-10, 2007. Our Pre-Conference Sessions will begin on August 5-6, 2007. Continental breakfast and hot buffet lunch will be provided each day.

Testimonials from previous Pre-Conference attendees:

“The course was very informative. I really like the hands-on lab work that the pre-conference courses provide.”

“Looking forward to implementing the new features of ASE 15. And this training gave us a lot of information for us to consider upgrading to ASE 15.”

“Thoroughly enjoyed the class. I learned a ton. Thanks!”

“Although my knowledge with this technology is limited, the whole learning-process experience for this class was very positive.

“Great knowledge and excellent delivery of the course”

Prize Drawings:

Sybase Education will have exciting prize drawings each day during your pre-conference training. Look for details in our future email correspondences to you.

Registration:

For early TechWave registration discounts including Pre-Conference training, click here to register or to learn more about TechWave 2007. If you are interested only in attending Pre-Conference, call us at 1-800-8-SYBASE (1-800-879-2273) or contact your Education Consultant.

TechWave 2007 Pre-Conference Sessions:

PC01 Moving to PowerBuilder 11.0
Product Focus: PowerBuilder
Experience Level: Experienced
Job Description: Applications Developer


Get hands-on experience and learn how to use the new features of PowerBuilder 11: User Interface changes, new language features, database support additions and Application Server deployment options. You will be exposed to the latest .Net features of PowerBuilder 11.0, including deploying PowerBuilder applications as .Net Web applications (ASP.Net 2.0), deploying PowerBuilder applications as .Net WinForm applications and the creation of Smart Client applications. You will learn how to create .Net Assemblies from PowerBuilder and use these assemblies in a true .Net (C#) application. We will also show you how to access members of true .Net assemblies (.Net framework classes or your own) from a PowerBuilder application. Finally, you will create, deploy and test .Net Web services from PowerBuilder. As a PowerBuilder developer, this session will help you learn Sybase’s approach to web-based development using the .NET capabilities of PowerBuilder 11.0 more quickly and efficiently.

PC02 Performance and Tuning for PowerBuilder: Advanced Tips and Techniques
Product Focus: PowerBuilder
Experience Level: Experienced
Job Description: Applications Developer


This session presents advanced performance enhancing techniques and procedures to the mature PowerBuilder developer. Learn how to improve your application performance using proven techniques for client/ server based technologies, as well as performance improvement techniques for developers writing or migrating to web-enabled applications. You will learn about handling XML with the PBDOM, file management, database technologies, scripting tips, and must-know internal mechanisms of PowerBuilder to help you develop the most robust and fastest applications possible.

PC03 Building .Net Applications with C# and DataWindow.Net 2.0
Product Focus: PowerBuilder, DataWindow. Net
Experience Level: Intermediate
Job Description: Applications Developer


This session bridges the gap between PowerBuilder and Visual Studio. Learn to reuse your PowerBuilder DataWindow/DataStore skills when building .Net applications using C#. Basic knowledge of the .Net framework classes as well as the C# language is assumed and required. You can meet these pre-requisites by completing an on-line self study which will be provided to all who register for this session. Using hands-on exercises, you will learn how to develop DataWindow objects, connection and transaction management code using the “legacy” Sybase Transaction object as well as perform similar functionality using the ADO.Net interface(s). Many advanced DataWindow topics will be covered, including how to dynamically create DataWindows and dynamically change the behavior of DataWindows, and creating an ASP.Net Web application using the DataWindow .Net technology. All labs and examples are developed in C#.

PC04 Advanced Modeling Techniques using PowerDesigner 12
Product Focus: PowerDesigner
Experience Level: Experienced
Job Description: Database Administrator (DBA), Consultant, Applications Developer, System Administrator, Object Administrator, IS/IT Management, System Analyst


Learn advanced PowerDesigner features and techniques such as how to customize the PowerDesigner interface. You will gain a better understanding of the PowerDesigner Generation Template Language and MetaModel, how to use impact analysis, properly control generation settings and behaviors using transformations. You will also learn how to implement naming standards and conversion tables, define Extended Model Definitions and customize Language files to include custom stereotypes, menu items and custom forms. For the more advanced user of PowerDesigner, this session will give you a more in-depth skill set on customizing PowerDesigner to fit your business needs.

PC05 Essential Techniques for Object Oriented Modeling using PowerDesigner 12
Product Focus: PowerDesigner
Experience Level: Intermediate
Job Description: Applications Developer


This session is highly interactive, where you are expected to be part of a design and development team working towards a solid design of an online banking system. You will use the UML and PowerDesigner 12 to assist in making all the decisions towards a final solution. Starting with high-level requirements you will create a high-level Domain model, move on to creating UML Use Case diagrams and Use Case Specifications, detailing all the requirements. Interaction diagrams (Sequence Diagrams) will be created to show detailed interaction between the objects identified by the Use Cases, resulting in further definition of the operations needed by the application. The culmination of the design session will include the creation of UML Class diagrams showing the detail and relationship between all objects, their attributes and operations. New and advanced PowerDesigner Object-Oriented modeling features will be highlighted by the instructor, such as Code generation, Reverse engineering, Reporting options, Repository, Extended Model Definitions, and Requirements models.

PC06 Powering Up with Adaptive Server Enterprise (ASE) 15.0
Product Focus: Adaptive Server Enterprise (ASE)
Experience Level: Intermediate
Job Description: Database Administrator (DBA)


Gain hands-on experience with the newest features of ASE version 15.0. The latest release of ASE includes a vast array of powerful features for administrators, SQL developers, and end users alike. Major new abilities include data partitioning, new optimization logic, and extended support for large databases.

PC07 Performance and Tuning: Adaptive Server Enterprise (ASE) 15.0 Query Optimization New Features
Product Focus: Adaptive Server Enterprise (ASE)
Experience Level: Experienced
Job Description: Consultant, Applications Developer, Database Administrator (DBA),System Administrator,


This session will highlight the new features and functionality of the Query Optimizer in ASE release 15.0. It includes new optimization techniques and enhanced configuration options to customize server behavior resulting to improve overall query performance. Instruction and lab exercises will cover new tools for interpreting and evaluating decisions made by the Query Optimizer.

PC08 Advanced Administration and Troubleshooting for ASE 15
Product Focus: Adaptive Server Enterprise (ASE)
Experience Level: Experienced
Job Description: Database Administrator (DBA), System Administrator

This session covers new and advanced ASE 15.0 server administration techniques. Learn what to do when hardware fails, and how to implement the need-to-know special-use features of Adaptive Server Enterprise 15. Using hands-on labs, you will practice troubleshooting techniques and disaster prevention to demonstrate how you can make ASE highly available. Learn the special features that allow for greater flexibility in migration and automating administration, server monitoring, data security, and resource management.

PC09 Replication Server Masters v15.0
Product Focus: Replication Server (RS)
Experience Level: Experienced
Job Description: Replication Server Administrator (DBA), System Administrator

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

PC10 Sybase WorkSpace Boot Camp: Developing Robust Applications
Product Focus: WorkSpace
Experience Level: Novice
Job Description: Applications Developer, Systems Integrator, Database Administrator (DBA)


Learn the fundamentals of Sybase Workspace, an advanced IDE for SOA development, to get you started on your projects. Using a financial business application use case, you will explore how to design, develop, explore, deploy and debug your applications in an integrated environment using the open-source Eclipse platform.

PC11 ebiz Impact Master Class
Product Focus:eBiz Impact
Experience Level: Experienced
Job Description: Applications Developer


Learn how to use and gain hands-on experience with powerful, flexible and emerging techniques for getting the most out of eBiz Impact. The session will cover four topics. The first, Custom External C/C++ Functions in ODL Projects, can be used to enable otherwise difficult solutions. You will learn how to create, implement, install, deploy, test and call these functions. The second, Implementing Java AIMs, will present basic concepts and techniques for Object Oriented Programming and how to apply them to writing Java AIMs using two methods - a remote access method and a plugin access method. The third, Integrating Web Services with Impact, will show how to provide attractive web-based options for application interfaces. A sample query and response application will be reviewed. The fourth, Implementing Web-based CNC functions with Impact, will explore Impact's Java CNC interface and demonstrate how to call these functions from Java applications and web browser interfaces.

New Classes

New and improved classes now available

Adaptive Server Enterprise/SQL Anywhere:

Advanced Administration and Troubleshooting for Adaptive Server Enterprise (EDB652)
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. More

MobiLink Synchronization with SQL Anywhere 10.0 (IAS387)
MobiLink technology allows SQL Anywhere remotes and UltraLite applications to synchronize data with Sybase SQL Anywhere and Adaptive Server Enterprise (ASE), Microsoft SQL Server, Oracle, and DB2. This course presents an overview of how MobiLink technology works, discusses basic to advanced level implementation techniques, and indicates when MobiLink technology is most suitable for your applications. Read more about this offering...

Data Federation:

Fast Track to Data Federation Administration (AVK330)
4-day Heavily hands-on administration course that teaches you the most flexible, scalable, and efficient way to install, configure, administer, monitor, troubleshoot, integrate and deliver distributed data from diverse sources to your key enterprise applications. More

Data Federation for Developers (DEV445)
Create data and web services as well as other applications to integrate data from many distributed sources. This 2-day course is heavily hands-on with lab exercises that teach you the most flexible, scalable, and efficient way to develop data/web services and other applications to integrate data from diverse distributed sources to key enterprise applications. More

PowerDesigner:

Essential Techniques for Object-Oriented Modeling using PowerDesigner 12 (DEV338)
5-day intensive, hands-on course that will teach you how to create Object-Oriented models by using a case study through which you will work as a group with other students in your class - modeling a solution to a set of provided requirements. The class will take turns “driving” the PowerDesigner product during the lab sessions in order to gain hands-on experience. There is no right-or-wrong answer for the labs – they will depend on class interaction and decisions. More

NEW Certification Exam and a Brand New Certification Logo

 

Brand new  - Adaptive Server Enterprise 15.0 SQL Developer Professional Certification

Adaptive Server Enterprise 15.0 SQL Developer Professional Certification Exam:

Our new Certification for Adaptive Server Enterprise 15.0 SQL Developer Professional is designed to help you gain that competitive edge to prove to the industry your knowledge and expertise on Sybase ASE 15.0 SQL development. Take advantage of the exam's availability and be the first to be certified.

We have an extensive and comprehensive Adaptive Server Enterprise SQL Developer curriculum path to meet your certification needs. See path below:

Certification Path:

  • Fast Track to Adaptive Server Enterprise(EDB115)
  • Performance and Tuning: Adaptive Server Enterprise Query Optimizer (EDB634)
  • Mastering Transact-SQL Programming: Advanced Tips and Techniques (EDB559)
  • Logical Database Design (SYB144)
  • Physical Database Design (EDB110)

Approximately 65% of the exam draws its focus on actual class materials; the remaining 35% of the exam draws from experience working with the product. The passing grade is 70%, which means that Sybase Education classes will give you just about enough preparation you need to pass the exam.

NEW ONLINE ASSESSMENTS AND PRACTICE EXAMS:

We have just made available both the ASE 15 SQL Developer Professional Practice Exam and the ASE 15 SQL Developer Level II assessment online! Sybase Education's Certification Practice Exams and Skills Assessments are powerful and FREE tools that enable you to assess your skill gaps and improve your skills. Our goal is always to help you, our customer, realize your full potential.

PowerDesigner Data Modelers Can Now Get Certified!

Sybase Education to premier the very first PowerDesigner Data Modeling Professional Certification at TechWave 2007

Yes, PowerDesigner will now join the product groups at Sybase with Certification support. As with any certification, you can now gain that competitive edge to prove to the industry your knowledge and expertise on Sybase PowerDesigner Data Modeling. Take advantage of this new exam and be the first to be certified.

We have a comprehensive PowerDesigner Data Modeling curriculum path in place to help you meet your certification needs. To be prepared to pass the certification exam in August, why not begin your training NOW.

Certification Path:

  • DEV326: Data Modeling with PowerDesigner 12 - Learn how PowerDesigner 12.0 can be used as a tool during the data analysis, data modeling, and database design processes. A well-known “best practice” in Information Engineering (IE) is to model the information at both a conceptual and physical level. Employ PowerDesigner to create a conceptual data model with entities, attributes, and relationships. Learn to target a DBMS, generate and enhance a physical data model, and then generate a database creation script for database tables, indexes, views, triggers, and stored procedures. You will also explore the reverse engineering features of PowerDesigner to create physical, conceptual, and object-oriented models from an existing database, as well as learn iterative modeling by using compare and merge model features and synchronizing physical data models with corresponding databases and vice versa. Finally, learn how to use and mange the Enterprise Repository for storing and sharing enterprise models across disparate groups and locations. Read more and enroll.

  • SYB144: Logical Database Design - Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms 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 and design. Read more and enroll.

  • EDB110: 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 database 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. Read more and enroll.

Several Ways to Save

Education Passport
Provides you with unlimited training for one year at any North American Sybase or Authorized Education Partner Learning Center. With the Sybase Education Passport, the more classes you attend, the sharper your skills become. Learn more...

SyberLearning LIVE TM Pass
provides you with unlimited SyberLearning LIVETM training for one year. Learn more...

Education Packages
Offers 10, 15, 30, 50 and 100-day discounted training packages that anyone on your staff can use—a significant value for your training investment. Learn more...


Sybase, Inc.
One Sybase Drive
Dublin, CA 94568