Linux Today: Linux News On Internet Time.

developerWorks: Database Development with Apache Derby, Part 7

Nov 14, 2006, 05:30 (0 Talkback[s])
(Other stories by Robert Brunner)

[ 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

Related Stories: