Practical Guide To Using SQL In Oracle

Practical Guide To Using SQL In Oracle

by Dr. Richard Earp, Dr. Sikha Bagui
     
 

ISBN-10: 1598220632

ISBN-13: 9781598220636

Pub. Date: 08/22/2008

Publisher: Jones & Bartlett Learning

Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently.

This book provides a systematic

…  See more details below

Overview

Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle’s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently.

This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on experience with Oracle programming.

Gain an understanding of basic SQL principles.
Learn to generate, store, and edit SQL queries in Oracle.
Develop joins, subqueries, and correlated subqueries.
Work with XML and Oracle databases.
Test your SQL knowledge with the exercises at the end of each chapter!

Product Details

ISBN-13:
9781598220636
Publisher:
Jones & Bartlett Learning
Publication date:
08/22/2008
Pages:
485
Sales rank:
806,782
Product dimensions:
6.00(w) x 8.90(h) x 1.10(d)

Table of Contents

Prologue: The Software Engineering Process and Relational Databases 1

Ch. 1 Getting Started with Oracle 25

Ch. 2 More "Beginning" SQL Commands 63

Ch. 3 Joins 111

Ch. 4 Functions 145

Ch. 5 Query Development, Privileges, and Derived Structures 175

Ch. 6 Set Operations 205

Ch. 7 Subqueries versus Joins 227

Ch. 8 GROUP BY and HAVING 247

Ch. 9 Correlated Subqueries 269

Ch. 10 CREATE TABLE and SQLLOADER 307

Ch. 11 Multiple Commands, START Files, and Reports in SQLPLUS 335

Ch. 12 Beginning PL/SQL: Anonymous Blocks, Procedures, Functions, and Packages 361

Ch. 13 Introdudion to Triggers 387

Ch. 14 SQL and XML 405

Appendix A Some UNIX Commands 421

Appendix B The Data Dictionary 429

Appendix C The Student Database and Other Tables Used in This Book 447

Appendix D Glossary of Terms 453

Appendix E Important Commands and Functions 467

Index 479

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >