- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (2) from $36.76
-
New (1) from $36.76
-
Used (1) from $199.99
More About This Textbook
Overview
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
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