Course objectives
During this course Red Hat JBoss Data Virtualization Development trainees will learn how to model data sources and virtual entities such as tables, views, and procedures. Through hands-on labs, participants will learn how to deploy these virtual entities for JDBC and web service consumption.
At the end of this course, trainees will be able to :
- Model data sources
- Model a virtual base layer
- Create virtual databases (VDB)
- Model unions, joins, and virtual procedures
- Model and deploy web services
- Server administration
- Develop client applications.
Who is this course for?
This course is intended for database administrators and database developers.
Prerequisites
In order to follow this course it is necessary to :
- Be fluent in Relational Database Concepts and SQL
- Have an experience in programming with the JDBC API.
JBoss Developer Studio or Eclipse experience is helpful but not required.
Programme
Introduction to Red Hat JBoss Data Virtualization
- Install Red Hat JBoss Data Virtualization
Model data sources
- Model connections to data sources and the Teiid server
Create a virtual base layer (VBL)
- Model a VBL on top of data sources
Create virtual databases (VDB)
- Create and deploy a VDB
Create view models with a union
- Model combined projections
Create view models with joins
- Model joins between tables (sources)
Create virtual procedures
- Model virtual procedures
Produce XML results
- Model for XML document results
Expose a model as a SOAP web service
- Build and deploy a web service model using JAX-WS (SOAP)
Expose a model as a REST web service
- Deploy a web service model using JAX-RS (REST)
Create a view from a web service data source
- Use a web service as a data source
Server administration
- Manage the data services server
Create materialized views
- Utilize materialized views when appropriate
Restrict access to a virtual database
- Implement access restrictions to the elements mapped in a virtual database
Access a virtual database in an application
- Access virtual databases in a Java application
Topics: JBoss / Wildfly