Linked by Thom Holwerda on Mon 13th Nov 2006 20:45 UTC, submitted by BlueVoodoo
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.
Thread beginning with comment 182166
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.
Member since:2005-07-18
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.
Member since:
2006-03-18
Views, Group By and Indexes are advanced?