No Words Wasted Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | January 14, 2015

    Marie Mutsuki Mockett: IMG On Trimming Roses



    Gardens do not wait. Weeds grow and flowers wilt. In the days and weeks following my father's death, my parents' garden continued to flourish and... Continue »
    1. $18.87 Sale Hardcover add to wish list

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

SQL for SQL Server

SQL for SQL Server Cover

 

Synopses & Reviews

Publisher Comments:

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 excellent resource for SQL programmers, systems analysts, database programmers, and database administrators.

Table of Contents

 1. Introduction.

 2. Creating Tables and Indexes.

 3. Single Table Query Basics.

 4. Adding Power to Queries.

 5. Aggregate Row Functions.

 6. Joins.

 7. Subqueries.

 8. Views and Synonyms.

 9. Additional Functions.

10. Stored Procedures and Triggers.

11. SQL Server Database Administration.

12. Embedded SQL.

Appendix A: The Company Database Schema.

Appendix B: The Riverbend Hospital Case.

Appendix C: Solutions to Odd-Numbered Exercises.

Product Details

ISBN:
9780131132993
Publisher:
Prentice Hall
Location:
Upper Saddle River, N.J.
Author:
Bordoloi, Bijoy
Author:
Bock, Douglas B.
Subject:
Database Management - General
Subject:
Client-server computing
Subject:
Sql (computer program language)
Subject:
Sql server
Subject:
SQL
Copyright:
Edition Description:
Trade paper
Series Volume:
A01P0003
Publication Date:
October 2003
Binding:
Paperback
Grade Level:
College/higher education:
Language:
English
Illustrations:
Yes
Pages:
416
Dimensions:
10.14 x 8 x 0.88 in 803 gr

Related Subjects

Computers and Internet » Database » SQL

SQL for SQL Server
0 stars - 0 reviews
$ In Stock
Product details 416 pages Prentice Hall - English 9780131132993 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.