Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL / Edition 1
by Nilesh D. ShahISBN-10: 0130909335
ISBN-13: 9780130909336
Pub. Date: 07/10/2001
Publisher: Prentice Hall
Oracle is the premier database package used in industry and it is the preferred choice of many academic institutions to teach relational database applications. Database Systems Using Oracle provides the most comprehensive coverage of the Structured Query Language (SQL) and the Programming Language/ Structured Query Language (PUSQL) in Oracle version 8 or
Overview
Oracle is the premier database package used in industry and it is the preferred choice of many academic institutions to teach relational database applications. Database Systems Using Oracle provides the most comprehensive coverage of the Structured Query Language (SQL) and the Programming Language/ Structured Query Language (PUSQL) in Oracle version 8 or higher.
Mastery of Oracle SQL and PUSQL languages is greatly facilitated by the provision of clear, step-by-step instructions, supplemented by hands-on examples, exercise questions, and lab activities. Throughout the text the author uses two real-life running databases as a model as well as a dedicated section on SQL statements with an additional third database scenario. Exposure to these databases increases comprehension of real-life database issues.
Features:
- Comprehensive coverage of the relational concepts and the database designing techniques necessary to design and implement effective database systems.
- Thorough coverage of SQL.
- Complete coverage of PL/SQL.
- An introduction to the architecture and administration of Oracle 8, Oracle 8I, and the concept of object orientation.
- Each chapter contains many exercise questions and lab activities promoting the "learn-by-doing" approach.
- A companion website offers instant student assessment materials and PowerPoint slides for each chapter.
Product Details
- ISBN-13:
- 9780130909336
- Publisher:
- Prentice Hall
- Publication date:
- 07/10/2001
- Edition description:
- Older Edition
- Pages:
- 326
- Product dimensions:
- 6.90(w) x 9.30(h) x 0.52(d)
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.
2. Database Design: Data Modeling and Normalization.
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.
4. Oracle Tables: Creation and Modification.
5. Working with Tables: Data Management and Retrieval.
6. Multiple Tables: Joins and Sub-Queries.
7. Advanced Features: Objects, Transactions, and Control.
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 WHEREClause. 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.
9. SQL and Control Structures in PL/SQL.
10. Cursors and Exceptions.
11. Composite Data Types: Records and Tables.
12. Procedures, Functions and Packages.
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.
14. Oracle 8i: An Overview and Web Tools.
Appendix A: Sample Databases: Table Definitions.
Appendix B: Quick Reference to SQL & PL/SQL Syntax.
Appendix C: Additional References.
Index.
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.
Customer Reviews
Average Review: