WELCOME TO THE GRADIANCE SQL TUTORIAL

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.

Gradiance was spun out of a research project led by Prof. Jeffrey Ullman, former chair of the Stanford CS department and the winner of ACM's Karlstrom award for Outstanding CS Educators. The result is an innovative approach to automated instruction through problem-solving and programming exercises. Gradiance materials for SQL and other subjects have been used extensively in classes at Stanford and many other universities around the world.

SAMPLE OUR TUTORIAL AT NO CHARGE

You are welcome to try out a sample of our SQL tutorial free of cost. Moreover, we do not require you to fill any forms and or download any software! Just click on the link above and enjoy the ride. If you like what you experience, you can sign up for the whole tutorial and master the core concepts of SQL programming methodically.

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.

SIGN UP FOR SQL TUTORIAL