Synopses & Reviews
Focusing on standard ANSI SQL with a learn-by-doing approach, this book organizes SQL subtopics into short chapters. Readers first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. Provides additional examples of the supplemental commands provided in the Oracle implementation of SQL. Ensures that all of the SQL concepts and commands covered (except in SQL *Plus and PL/SQL) are equally applicable to database management system software that follows the ANSI SQL standardincluding DB2, SQL Server, and SYBASE. Integrates numerous exercises and examples throughout. Offers detailed coverage of SQL, including SQL *Plus and Oracle Database Administration. Covers Data Definition Language with SQL. A valuable reference for SQL programmers, systems analysts, database programmers, and database administrators.
Table of Contents
(NOTE:
Each chapter begins with Objectives and concludes with Summary, Review Exercises, Learn These Terms, Concepts Quiz, and SQL Coding Exercises and Questions.)
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, Synonyms, and Sequences.
9. SQL *Plus Reports.
10. Additional Functions.
11. Embedded SQL.
12. Oracle Database Administration.
Appendix A: The Company Database Schema.
Appendix B: The Riverbend Hospital Case.
Appendix C: End-of-Book SQL Coding Exercises.
Appendix D: Solutions to Odd-Numbered Exercises.