SQL for SQL Server / Edition 1
by Bijoy Bordoloi, Douglas Bock
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
… See more details belowOverview
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.
Product Details
- ISBN-13:
- 9780131132993
- Publisher:
- Prentice Hall
- Publication date:
- 10/29/2003
- Edition description:
- New Edition
- Pages:
- 416
- Product dimensions:
- 8.10(w) x 10.06(h) x 0.93(d)
Table of Contents
Ch. 1 | Introduction | 1 |
Ch. 2 | Creating Tables and Indexes | 30 |
Ch. 3 | Single Table Query Basics | 65 |
Ch. 4 | Adding Power to Queries | 91 |
Ch. 5 | Aggregate Functions and Grouping of Data | 118 |
Ch. 6 | Joins | 139 |
Ch. 7 | Subqueries | 168 |
Ch. 8 | Views and Synonyms | 195 |
Ch. 9 | Additional Functions | 216 |
Ch. 10 | Stored Procedures and Triggers | 245 |
Ch. 11 | SQL Server Database Administration | 270 |
Ch. 12 | Embedded SQL | 302 |
App. A | Company Database Schema | 317 |
App. B | Riverbend Hospital Case | 333 |
App. C | End-of Chapter Solutions to Odd-Numbered Exercises | 343 |
Index | 385 |
Customer Reviews
Average Review: