|
|  |
| |
| | |
|
|
| |
| Developing Database Applications with IBM Data Studio and pureQuery |
|
|
Duration:
3 Days |
|
|
|
- Anyone who develops database applications with Java
| |
Basic knowledge of SQL;
knowledge of fundamental concepts of relational databases;
basic knowledge of Java
|
|
|
|
Description
|
|
This hands-on intensive 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 course uses the latest Data Studio Developer 1.2 and Data Studio
pureQuery Runtime 1.2.
|
|
|
Objectives
|
Upon completion of this course, attendees will be able to:
- Learn how to develop data applications with IBM Data Studio
- Become familiar with rich IBM Data Studio set of tools
- Use pureQuery for efficient database access from Java
- Develop with inline pureQuery methods
- Develop with annotated pureQuery methods
- Be prepared to approach advanced pureQuery topics
|
|
|
Course Outline
|
|
First Steps with Data Studio
- Introduction and Background
-
Overview of the IBM Integrated Data Management Software: Rational Data
Architect, Data Studio Developer, Data Studio Administrator, The Optim
family of tools
- 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
- pureQuery and Web 2.0 through WebSphere sMash (ProjectZero)
|
|
|
|
