You can[ Execute a SQL server stored procedure using Denodo](https://community.denodo.com/kb/view/document/Creating%20views%20on%20SQL%20Server%20Functions%20and%20Stored%20Procedures?category=Data+Sources). The link mentioned before will let you pass the required parameters and get the resultant table from the stored procedure and create a base view which can be used for further processing.
With Denodo you can also create stored procedures which is mentioned in [this post](https://community.denodo.com/answers/question/details?questionId=9060g000000fz3NAAQ&title=Store+procedure).
Note: Sample Java Programs for Denodo Stored Procedures are available under <DENODO_HOME>\samples\vdp\storedProcedures of your installation.
About the training materials, I think you can utilize our Online documentation: [Virtual DataPort Developer Guide](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/index#virtual-dataport-developer-guide) and the[ Virtual DataPort API](https://community.denodo.com/docs/html/browse/7.0/vdp/javadoc/index) Java documentation, which will provide you with more knowledge on Java which includes custom functions, developing stored procedures and custom wrappers. We are also progressing towards preparing new free tutorials for creating custom components and it will be available in our Denodo Community Site.
Hope this helps