SQL Fundamentals: Second Edition (Second Edition)

Author: Patrick
Publisher:
Publish Date: 2003-09-01
Features: Every concept in the book is illustrated with an SQL example. In most cases, a task is set, and then the SQL code to complete the task is provided. The book also shows the original data table and the result table. There are over 200 examples in total, with each section being independent. You can read the book sequentially or selectively read the parts you need. This book is based on the SQL course taught by John J. Patrick at the University of California, Berkeley, and precisely explains how to retrieve the required data in any application (from temporary reports to data warehouses). Whether it's simple Select statements or complex join operations, Patrick explains in detail how to write SQL queries that are easy to understand, verify, personalize, and extend. This book will teach you:
- Writing simple SQL statements to retrieve, restore, or modify data;
- Creating complex queries to obtain information from multiple tables;
- Building your own tables;
- Summarizing data;
- Basic and advanced techniques;
- Understanding and ensuring data integrity;
- Mastering unions, subqueries, self-joins, cross joins, inner joins, and outer joins.
To obtain all the SQL program code and database tables, Microsoft Access formatted databases, and corresponding Oracle database code in this book, please visit www.tupwq.net and download from the book's webpage.