Developing Database Applications with Optim Development Studio and pureQuery Training

Duration: 3 days
Course code: SS-PQ-001

  • Anyone who develops database applications with Java

We recommend that the attendees have:

  • basic knowledge of SQL
  • knowledge of fundamental concepts of relational databases
  • basic knowledge of Java

The Developing Database Applications with Optim Development Studio and pureQuery training course introduces IBM Data Studio, a new environment for design, development, deployment and management of data, database, and data-driven Java applications throughout the entire data management life cycle. We first approach the rich data management and development features of Data Studio and make developers proficient in daily development tasks involving creation and working with databases and SQL and stored procedures. Numerous hands on exercises ensure that these tasks are mastered.

Next, the participants get immersed into pureQuery, a productive high-performance approach for writing database applications that significantly simplifies common database development tasks. We explore inline and annotated styles, and after establishing the foundation we dive into the rich set of pureQuery features. Every topic is explained through numerous examples and hands-on exercises.

The Developing Database Applications with Optim Development Studio and pureQuery training course uses the latest Optim Development Studio. If desired, the course can be delivered using previous version of the tool (IBM Data Studio Developer). The course can be delivered using DB2 LUW or DB2 z/OS.


Upon completion of this course, attendees will be able to:

  • Learn how to develop data applications with Optim Development Studio
  • Become familiar with rich Optim Development Studio set of tools
  • Use pureQuery for efficient database access from Java
  • Develop with inline pureQuery methods
  • Develop with annotated pureQuery methods
  • Work with static SQL
  • Be prepared to approach advanced pureQuery topics

Outline for Developing Database Applications with Optim Development Studio and pureQuery Training Course

First Steps with Data Studio

  • Introduction and Background
  • Overview of the IBM Integrated Data Management Software: InfoSphere Data Architect, Optim Development Studio, Optim Database Administrator
  • The Eclipse Heritage and Key Concepts
  • Data Studio Perspectives
  • Data Development Projects

Working with Databases

  • Connecting to Databases
  • Exploring Databases with Database Explorer
  • Data Project Explorer
  • Database Explorer
  • Data Output view
  • Working with SQL Queries
  • SQL Editor
  • SQL Builder
  • Working with Stored Procedures
  • Debugging and Profiling
  • Working with Overview Diagrams
  • Exporting and Importing Database Connection Information
  • Other Useful Features

Introducing pureQuery

  • Database Access from Java Programs: Non-Managed and Managed Approaches
  • Comparison of Database Access Approaches: JDBC, EJB2, EJB3, JPA, Hibernate and other Object-Relational approaches
  • Where Does pureQuery Fit in?
  • Inline and Annotated pureQuery Methods for Accessing Databases

Developing with Inline pureQuery

  • A First Inline pureQuery Example
  • Creating a pureQuery Enabled Project
  • Setting pureQuery Preferences
  • Runtime Creation of SQL Statements Using Inline pureQuery Methods
  • Working with Return Types: First Row, ResultSet, Collections, Generics
  • Working with Target Types for Inline Methods: Objects, Wrappers, Maps, pureQuery Beans
  • Supported Update Types
  • Invoking Stored Procedures

Developing with Annotated pureQuery

  • A First Annotated pureQuery Example
  • Introducing Java Annotations
  • Creating pureQuery Code from Existing Database
  • Working with Results
  • Invoking Stored Procedures
  • Batch Updates
  • Using Static SQL

Using pureQuery with In-Memory Collections

  • A First Example
  • Overview of In-Memory Collections
  • Inline Methods for Queries over In-Memory Collections

Overview of Advanced pureQuery Topics

  • pureQuery Generator
  • pureQuery for JDBC Applications
  • pureQuery for Packaged Java JDBC Applications
  • Working with Result Handlers
  • Using pureQuery Hooks
  • Data Web Services (Optional)
  • pureQuery and Web 2.0 through WebSphere sMash/Project Zero (optional)

Comments are closed.