- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Currently out of stock.
available for shipping or prepaid pickup only
Oracle SQLby Bijoy Bordoloi
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.
Book News Annotation:
Intended as the primary text for a junior college course or as a supplement for a database management course, this book explains the core commands for data retrieval in the structured query language (SQL), and how they are applied in an Oracle database. Annotation (c)2003 Book News, Inc., Portland, OR (booknews.com)
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.)
2. Creating Tables and Indexes.
3. Single Table Query Basics.
4. Adding Power to Queries.
5. Aggregate Row Functions.
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.
What Our Readers Are Saying