Free Shipping In Australia
Currency:
AUD $ AUD
Database Systems Using Oracle By Nilesh Shah

Database Systems Using Oracle
by Nilesh Shah

In Stock
$12.99
+10% GST
Database Systems Using Oracle first introduces students to relational database concepts and database designing techniques, teaching them how to design and implement database systems. The author concludes with an introduction to the architecture and administration of Oracle 8, the new features of Oracle 8i, and the concepts of object orientation.
Only 1 left

Database Systems Using Oracle Summary


Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL by Nilesh Shah

For Database Systems courses focusing on SQL and/or Oracle, Oracle courses, and SQL courses offered in departments of Computer Science, CIS, MIS, IT and Continuing Education.

Database Systems Using Oracle first introduces students to relational database concepts and database designing techniques, teaching them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a future reference. The author concludes with an introduction to the architecture and administration of Oracle 8, the new features of Oracle 8i, and the concepts of object orientation.

Why buy from World of Books

Our excellent value books literally don't cost the earth
Free delivery in Australia
Read more here
Every used book bought is one saved from landfill

About Nilesh Shah


Nilesh Shah, Ph.D., has been teaching for more than a decade. He is currently an Assistant Professor at the New Jersey campus of DeVry. He also works as a systems analyst at Monroe College, New York. Dr. Shah is associated with many prestigious technology companies as a freelance consultant.

Table of Contents


Most chapters end with In a Nutshell, Exercise Questions, and a Lab Activity.

I. DATABASE CONCEPTS.

1. Database Concepts: A Relational Approach.

Database: An Introduction. Relationships. Database Management System (DBMS). The Relational Database Model. Integrity Rules. Theoretical Relational Languages.

2. Database Design: Data Modeling and Normalization.

Data Modeling. Dependency. Database Design. Normal Forms. Dependency Diagrams. Denormalization.

II. THE ORACLE SQL.

3. Oracle 8: An Overview.

Personal Databases. Client/Server Databases. Oracle 8: An Introduction. The SQL*Plus Environment. Structured Query Language. Logging In to SQL*Plus. SQL*Plus Commands. Sample Databases. Alternate Text Editors. Oracle Online Help.

4. Oracle Tables: Creation and Modification.

Naming Conventions. Data Types. Constraints. Creating an Oracle Table. Displaying Table Information. Altering an Existing Table. Dropping a Table. Renaming a Table. Truncating a Table. Spooling.

5. Working with Tables: Data Management and Retrieval.

Adding a New Row/Record. Customized Prompts. Updating Existing Rows/Records. Deleting Existing Rows/Records. Dropping a Constraint. Disabling/Enabling Constraints. Retrieving Data from a Table. Arithmetic Operations. Restricting Data with a WHERE Clause. Sorting. Built-in Functions. Grouping Data. Nesting Group Functions. Revisiting Substitution Variables. DEFINE Command.

6. Multiple Tables: Joins and Sub-Queries.

Join. Set Operators. Sub-Query. Top-N Analysis.

7. Advanced Features: Objects, Transactions, and Control.

Views. Sequences. Synonyms. Index. Transactions. Locking Rows for Update. Controlling Access. SQL Review: Supplementary Examples.

III. PL/SQL.

8. PL/SQL: Programming Language Basics.

A Brief History of PL/SQL. Fundamentals of PL/SQL. PL/SQL Block Structure. Comments. Data Types. Other Scalar Data Types. Variable Declaration. Anchored Declaration. Assignment Operation. Bind Variables. Substitution Variables in PL/SQL. Printing in PL/SQL. Arithmetic Operators.

9. SQL and Control Structures in PL/SQL.

Control Structures. Nested Blocks. SQL in PL/SQL. Data Manipulation in PL/SQL. Transaction Control Statements.

10. Cursors and Exceptions.

Cursors. Implicit Cursors. Explicit Cursors. Explicit Cursor Attributes. Implicit Cursor Attributes. Cursor FOR Loops. SELECT . . . FOR UPDATE Cursor. WHERE CURRENT OF Clause. Cursor with Parameters. Cursor Variables: An Introduction. Exceptions. Types of Exceptions. Sample Programs.

11. Composite Data Types: Records and Tables.

Composite Data Types. PL/SQL Records. PL/SQL Tables. Sample Programs.

12. Procedures, Functions and Packages.

Procedures. Functions. Packages.

IV. MISCELLANEOUS TOPICS.

13. Oracle Database Administration.

Database Administrator (DBA). Oracle Architecture: An Overview. Installation. Networking. Security. System Privileges. Roles. Users. Oracle Tools. SQL*Plus. Oracle Data Dictionary.

14. Oracle 8i: An Overview and Web Tools.

Oracle8i Core Package. An Object. SQL Queries for Objects. Internet Computing and Oracle8i. WebDB. JDeveloper.

Appendix A: Sample Databases: Table Definitions.

The Indo-US College Student Database. The NamanNavan Corporation College Database.

Appendix B: Quick Reference to SQL & PL/SQL Syntax.
Appendix C: Additional References.

Web Sites. Books and Other Published Material on Oracle.

Index.

Additional information

GOR001604470
Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL by Nilesh Shah
Nilesh Shah
Used - Very Good
Paperback
Pearson Education (US)
2001-07-10
326
0130909335
9780130909336
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us.