SQL for SQL Server

Features

• Cover Type: Paperback with 416 pages
• Published by: Prentice Hall November 8, 2003
• Written in: English
• ISBN 10 Number: 0131132997
• ISBN 13 Number: 978-0131132993
• Book Dimensions: 9.9 x 7.9 x 0.7 inches
• Weighs: 1.6 pounds

Product Description


This book focuses on teaching standard ANSI SQL, flavored with additional examples of the supplemental commands provided in the Oracle implementation of SQL. All of the SQL concepts and covered are equally applicable to database management system software that follows the ANSI SQL standard, including DB2, SQL Server, and SYBASE, among others. This book organizes SQL subtopics into small chapters. These include coverage of basic relational database and database management system concepts, with the use of the SQL Query Analyzer for executing SQL statements; how to define and create database and tables for data storage, including the use of DDL (data definition language) and DML (data manipulation language); all primary components of SQL, including querying single tables, multiple tables (“joins” ), coding nested and correlated subqueries, using common functions, defining views, and much more. Because of its comprehensive coverage of Oracle SQL, this book is an great resource for SQL programmers, systems analysts, database programmers, and database administrators.

Reader Reviews
While I bought this book for a intro to TSQL class, I feel that it was well written enough that I could have used it on my own and learned quite well with the book alone. The authors were very concise, and the concepts were explained well. For anyone trying to learn how to query SQL 2000, I would recommend this book as a great place to start.