Developing with Apache Derby – Hitting the Trifecta

This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information and introduces the concept of a view, which can be used to simplify database application development by creating a virtual table that represents the results of an SQL query. Also learn about database indexes, which you can use to locate specific table rows. After you've mastered these advanced database concepts, you'll be well positioned to begin developing Java database applications with Apache Derby.

Full Story