Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL LIKE NEW

Come and Gettem Textbooks
(329)
Seller's other items
Contact seller
US $9.75
ApproximatelyRM 40.29
Condition:
Like New
“No hi-lighting writing or notes in text. Cover has very little shelf wear. Binding is strong.”
Breathe easy. Returns accepted.
Shipping:
Free USPS Media MailTM.
Located in: Gainesville, Florida, United States
Delivery:
Estimated between Thu, 4 Dec and Tue, 9 Dec to 94104
Delivery time is estimated using our proprietary method which is based on the buyer's proximity to the item location, the shipping service selected, the seller's shipping history, and other factors. Delivery times may vary, especially during peak periods.
Returns:
30 days return. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Coverage:
Read item description or contact seller for details. See all detailsSee all details on coverage
(Not eligible for eBay purchase protection programmes)
Seller assumes all responsibility for this listing.
eBay item number:166479232494

Item specifics

Condition
Like New
A book in excellent condition. Cover is shiny and undamaged, and the dust jacket is included for hard covers. No missing or damaged pages, no creases or tears, and no underlining/highlighting of text or writing in the margins. May be very minimal identifying marks on the inside cover. Very minimal wear and tear. See all condition definitionsopens in a new window or tab
Seller Notes
“No hi-lighting writing or notes in text. Cover has very little shelf wear. Binding is strong.”
ISBN
9780130909336
Category

About this product

Product Identifiers

Publisher
Prentice Hall PTR
ISBN-10
0130909335
ISBN-13
9780130909336
eBay Product ID (ePID)
1981923

Product Key Features

Number of Pages
326 Pages
Language
English
Publication Name
Database Systems Using Oracle : a Simplified Guide to Sql and PL/Sql
Subject
Desktop Applications / Databases, Programming Languages / Sql, Databases / General
Publication Year
2001
Type
Textbook
Subject Area
Computers
Author
Nilesh D. Shah
Format
Trade Paperback

Dimensions

Item Height
0.6 in
Item Weight
17.4 Oz
Item Length
9.3 in
Item Width
9.3 in

Additional Product Features

Intended Audience
College Audience
LCCN
2001-034596
Dewey Edition
21
Illustrated
Yes
Dewey Decimal
005.75/85
Table Of Content
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.
Synopsis
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, 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.
LC Classification Number
QA76.9.D3S487 2002

Item description from the seller

About this seller

Come and Gettem Textbooks

96.8% positive feedback•2.5K items sold

Joined Jan 2011
Visit storeContact

Seller feedback (338)

All ratingsselected
Positive
Neutral
Negative
  • a***7 (85)- Feedback left by buyer.
    Past 6 months
    Verified purchase
    Fast delivery - product as expected
    Practical Business Statistics by Michael R. Wagner and Andrew F. Siegel GOOD (#167702861988)
  • c***3 (15)- Feedback left by buyer.
    Past 6 months
    Verified purchase
    Thanks so much! Quick shipping! Thanks
    Social Problems by Margaret L. Andersen and Frank R. Scarpitti VERY GOOD (#155708197022)
  • 7***3 (0)- Feedback left by buyer.
    More than a year ago
    Verified purchase
    Item arrived fast and came as described, only had minor damage on the cover but think is was from shipping , probably just needed a bit more wrapping, but other than that all good
    Introduction to Quantum Mechanics by Griffiths, David J. BRAND NEW (#156364541432)
See all feedback

More to explore :