SQL Exercises

The purpose of any exercise is to steadily develop skills and to acquire the automatic algorithms for fulfilling certain operations. As for the SQL language, practical exercises are intended to enable the database programmer to quickly devise SQL queries in order to solve practically any problem, by having already studied similar problems in exercises. This book provides such a collection of practical solved SQL exercises.

For an introduction to the SQL language, please refer to the wikibook Structured Query Language.

Contents


Cover · Contributors
  1. 50% developed The computer store
  2. 50% developed Employee management
  3. 50% developed The warehouse
  4. 50% developed Movie theatres
  5. 50% developed Pieces and providers
  6. 25% developed Scientists
  7. 25% developed Planet Express
  8. 50% developed The Hospital Category:Alphabetical/S Category:Book:SQL Exercises#%20 Category:Subject:SQL#SQL%20Exercises
Category:Subject:SQL/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer programming/all books Category:Subject:Computer science/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Database management systems/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Book:SQL Exercises#%20 Category:Book:Wikibooks Stacks/Books#SQL%20ExercisesCategory:Shelf:SQL Category:Shelf:SQL/all books Category:Shelf:Computer programming/all books#Computer%20programming Category:Shelf:Computer programming languages/all books#Computer%20programming%20languages Category:Shelf:Computer science/all books#Computer%20science Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Shelf:Database management systems/all books#Database%20management%20systems Category:Half-finished booksCategory:Books by completion status/all books
Category:Alphabetical/S Category:Book:SQL Exercises Category:Book:Wikibooks Stacks/Books Category:Books by completion status/all books Category:Department:Computing/all books Category:Half-finished books Category:Shelf:Computer programming/all books Category:Shelf:Computer programming languages/all books Category:Shelf:Computer science/all books Category:Shelf:Computer software/all books Category:Shelf:Database management systems/all books Category:Shelf:SQL Category:Shelf:SQL/all books Category:Subject:Books by subject/all books Category:Subject:Computer programming/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer science/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Database management systems/all books Category:Subject:SQL Category:Subject:SQL/all books