developerWorks: Database Development with Apache Derby, Part 7

[ Thanks to An Anonymous Reader for
this link. ]

“With this article you’ve reached an important point in
mastering fundamental database concepts as they relate to the
Apache Derby database. This article reviews how to modify an SQL
query to group related rows together to provide summary statistics
database information. Then it 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. Finally, you’ll 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…”

Complete Story

Get the Free Newsletter!

Subscribe to Developer Insider for top news, trends, & analysis