Synopses & Reviews
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
2. Creating Tables and Indexes.
3. Single Table Query Basics.
4. Adding Power to Queries.
5. Aggregate Row Functions.
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.