Gradiance.com
Our approach to teaching SQL is to use a combination of coding exercises (writing queries) and quizzes, to emphasize the "learning by programming" paradigm, along with providing a set of slide sets covering the relevant material. The programming exercises are on-line and feature immediate constructive feedback about the correctness of the submitted queries. Test cases, comments and hints are provided to illustrate the errors and help you debug the queries on-line.
The Gradiance SQL tutorial covers the following core topics:
- Basics - the SELECT-FROM-WHERE framework for SQL queries
- Null Values and Aggregation - dealing with NULL values in SQL tables; aggregating column values
- Grouping and Ordering - GROUP BY and ORDER BY clauses
- Join queries - multi-table queries involving join operations
- Aggregation and NULL values in join queries - grouping and aggregation across multiple tables; NULL values and outer-join operations
- Subqueries - notion of queries embedded in other queries; IN, NOT IN, ANY, ALL and EXISTS operations
The estimated duration for the tutorial is from 30 to 60 hours, spread over a total of 150 slides, 30 problems to solve (in the quizzes) and 50 programming exercises to work on (in the lab projects). The material is organized into six lesson packages, with associated quizzes and lab projects, so that each item can be handled in a short session...........