Oracle 11g

Overview (Book Download Link: Click here)

The examples, assignments, and cases in this book help you achieve the following objectives:

• Issue SQL commands that retrieve data based on criteria specified by the user.

• Use SQL commands to join tables and retrieve data from joined tables.

• Perform calculations based on data stored in the database.

• Use functions to manipulate and aggregate data.

• Use subqueries to retrieve data based on unknown conditions.

• Create, modify, and drop database tables.

• Manipulate data stored in database tables.

• Enforce business rules by using table constraints.

• Create users and assign the privileges users need to perform tasks.

The chapters’ contents build in complexity while reinforcing previous ideas. Chapter 1 introduces basic database management concepts, including database design. Chapter 2 shows how to retrieve data from a table. Chapter 3 explains how to create new database tables. Chapter 4 addresses the use of constraints to enforce business rules and ensure the integrity of table data. Chapter 5 explains adding data to a table, modifying existing data, and deleting data. Chapter 6 shows how to use a sequence to generate numbers, create indexes to speed up data retrieval, and create synonyms to provide aliases for tables. Chapter 7 steps you through creating user accounts and roles and shows how to grant (and revoke) privileges to these accounts and roles. Chapter 8 explains how to restrict rows retrieved from a table, based on a given condition. Chapter 9 shows how to link tables with

common columns by using joins. Chapter 10 describes the single-row functions supported by Oracle 11g. Chapter 11 covers using multiple-row functions to derive a single value for a group of rows and explains how to restrict groups of rows. Chapter 12 covers using subqueries to retrieve rows based on an unknown condition already stored in the database. Chapter 13 explains using views to restrict access to data and reduce the complexity of certain types of queries.

The appendixes support and reinforce chapter materials. Appendix A contains printed versions of the initial table structure and data for the JustLee Books database used throughout this textbook. Appendix B introduces the operation of the SQL*Plus and SQL Developer client software tools.  Appendix C lists Oracle resources for further study.

Appendix D introduces the SQL*Loader utility for importing data. Appendix E introduces basic SQL statement tuning concepts. Appendix F identifies SQL differences in some popular databases.

Book Download Link: Click here