Book description
This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. The Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users.
The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL’s most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.
Highlights include:
Detailed coverage of SQL commands for creating databases, tables, and indexes, and for
adding, changing, and deleting data
Using the SELECT command to retrieve specific data
Handling NULL values (missing information) in a relational database
Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)
Working with nested queries (subqueries) to get data from multiple tables
Creating views (virtual tables) to provide customized access to data
Using SQL functions
A bonus CD-ROM contains a time-limited, full-feature version of the Sybase® Adaptive Server Anywhere™ software as well as the sample database, scripts, and examples included in the book.
The Practical SQL Handbook is the most complete reference available for day-to-day SQL implementations.
0201703092B05222001
Table of contents
- Copyright
- List of Figures
- Foreword to the Fourth Edition
- Preface
- Introduction
- SQL and Relational Database Management
- Designing Databases
- Creating and Filling a Database
- Selecting Data from the Database
- Sorting Data and Other Selection Techniques
- Grouping Data and Reporting from It
- Joining Tables for Comprehensive Data Analysis
-
Structuring Queries with Subqueries
- What Is a Subquery?
- How Do Subqueries Work?
- Joins or Subqueries?
- Subquery Rules
- Subqueries Returning Zero or More Values
- Subqueries Returning a Single Value
- Subqueries Testing Existence
- Subqueries in Multiple Levels of Nesting
- Subqueries in UPDATE, DELETE, and INSERT Statements
- Subqueries in FROM and SELECT Clauses
- Summary
- Creating and Using Views
- Security, Transactions, Performance, and Integrity
- Solving Business Problems
- Syntax Summary for the SQL Used in This Book
- Industry SQL Equivalents
- Glossary
- The bookbiz Sample Database
- Resources
- CD ROM Warranty
- Using the Practical SQL Handbook CD
Product information
- Title: Practical SQL Handbook, The: Using SQL Variants, Fourth Edition
- Author(s):
- Release date: June 2001
- Publisher(s): Addison-Wesley Professional
- ISBN: 0201703092
You might also like
book
Learn SQL Database Programming
Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide …
video
T-SQL Querying: Writing a SELECT Statement
This video provides you with the knowledge to write SELECT statements to retrieve data from a …
book
Discovering SQL: A Hands-On Guide for Beginners
Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you …
book
The Language of SQL, Second Edition
The Language of SQL, Second Edition Many SQL texts attempt to serve as an encyclopedic reference …