Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Description:

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

  
  

  Download Link:

  
  

  http://www.mediafire.com/Practical_SQL_Handbook.rar