SQL by Example

✍ Scribed by John Russo

• Publisher: Momentum Press
• Year: 2017
• Tongue: English
• Leaves: 128
• Series: Computer Science Collection
• Category: Library

✦ Synopsis

SQL by Example uses one case study to teach the reader basic structured query language (SQL) skills.

The author has tested the case study in the classroom with thousands of students. While other SQL texts tend to use examples from many different data sets, the author has found that once students get used to one case study, they learn the material at a much faster rate.

The text begins with an introduction to the case study and trains the reader to think like the query processing engine for a relational database management system. Once the reader has a grasp of the case study then SQL programming constructs are introduced with examples from the case study. In order to reinforce concepts, each chapter has several exercises with solutions provided on the book's website.

SQL by Example is designed both for those who have never worked with SQL as well as those with some experience. It is modular in that each chapter can be approached individually...

✦ Table of Contents

Cover
Contents
List of Figures
List of Tables
Acknowledgments
Introduction
Chapter 1: The Shore to Shore Shipping Case Study
Chapter 2: Basic SQL Syntax
Chapter 3: Single Table Queries
Chapter 4: Introduction to Joins
Chapter 5: Advanced Join Operations
Chapter 6: Sub-queries
Chapter 7: Grouping Data
About the Author
Index
Adpage
Backcover