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.
A view? how novel. really. shesh. While we are at it, lets create an index.
Views, Group By and Indexes are advanced?
This is just sad. This kind of stuff should be covered in the first 2 weeks of “Introduction to Database Systems”.
Advanced database concepts should be things like understanding the difference between traditional 3rd Normal Form and Boyce-Codd Normal Form, or applying the concepts of set theory to constraints, domains and user-defined datatypes.
In fact, even these topics are not *really* advanced. Try diving into books on “temporal” extensions to the relational model, or try figuring out why it is that SQL is not really relational by definition.