Items related to Database Systems Using Oracle

Shah, Nilesh Database Systems Using Oracle ISBN 13: 9780131018570

Database Systems Using Oracle - Softcover

 
9780131018570: Database Systems Using Oracle
View all copies of this ISBN edition:
 
 

This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and introduction to advanced SQL topics makes this a must for busy professionals. The many examples, with output shown as screenshots, provide ample opportunity for the reader to easily understand and learn to use Oracle and SQL. First introducing relational database concepts, the book covers SQL (Structured Query Language); Programming Language (the extension to SQL); and then proceeds to advanced topics, which include Oracle architecture and database administration with enterprise tools. For any IT professional who needs to understand SQL or Oracle database systems.

"synopsis" may belong to another edition of this title.

About the Author:

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.

Excerpt. © Reprinted by permission. All rights reserved.:
THE READER

The Relational Database Management System (RDBMS) is the most important database model today. The Oracle Corporation has established the Oracle database product as the prime database package in the world. Structured Query Language (SQL) is the universal query language for relational databases. Programming Language/Structured Query Language (PL/SQL), an Oracle extension to SQL, brings all the benefits and capabilities of a high-level programming language to the database environment.

This text is designed for use as a primary textbook in a database course at the college level or as a self-study guide for the information systems or business professional. With its in-depth coverage of relational database concepts, SQL, and PL/SQL, the textbook serves as an introductory guide as well as a future reference resource. The textbook can be used in a course that concentrates on database design and uses SQL to complement it. It also makes a perfect textbook to teach SQL only. Another use of this book is in an advanced database management system course, where more advanced features of SQL, along with PL/SQL and database administration, are emphasized. In a classroom environment, it is not possible to cover all 14 chapters in one semester. The book serves as a great resource to expand on the topics learned in the classroom. THE TEXTBOOK

The first part of the book provides adequate knowledge of relational concepts and database designing techniques to allow students to design and implement accurate and effective database systems. The second part concentrates on the primary nonprocedural relational database language SQL. SQL is supported by most relational database software packages installed on various platforms. The book primarily concentrates on Oracle 8 and points out the features available in Oracle8i. In reality, the SQL part of the book can be utilized in Oracle release 7.x, 8, or 8i. The third part of the textbook is devoted to the procedural language PL/SQL, which is Oracle's proprietary language extension to SQL. PL/SQL features data encapsulation, error handling, and information hiding, which are the capabilities of a typical high-level programming language. The fourth part of the textbook introduces the architecture and administration of Oracle 8, as well as new features of Oracle8i and the concept of object orientation.

Throughout the text, the general syntax of SQL and PL/SQL are supplemented by simple examples and illustrations. Each chapter in the textbook includes a brief summary, exercise questions, and lab activities. The textbook is supported by sample databases—one a typical college's student database with demographic, schedule, and registration information, and the other a corporation's employee database with employees' demographic and job-related data. In most cases, the examples are based on one of the sample databases and the lab activity is based on the other to test a student's ability to apply queries in a different scenario. A separate section on supplementary examples is included at the end of the SQL part of the textbook.

As the book is primarily designed as a college textbook, it also includes (exclusively for instructors) answers to the exercise questions and SQL queries and PT./SQL blocks for the lab activities. The script to create both sample databases is also included for the instructors. THE SOFTWARE

Oracle comes in many flavors. At your business or in college laboratory, Oracle might be implemented in a Windows NT, Unix, Linux, Solaris, or Novell Netware environment. The version of Oracle might vary from Oracle 7.x to Oracle 8 to Oracle8i. The beauty of this textbook is its versatility. The SQL and PL/SQL features covered in this text work with all versions, and the exceptions are pointed out in the individual topics, wherever necessary.

The reader is advised to join the Oracle Technology Network (OTN) by using the URL technet.oracle. One of the benefits of being a registered OTN user is access to a free download of Enterprise, Personal, or Lite version of Oracle 8i software. A user can also order a free Oracle software CD from the OTN site. USING THE TEXTBOOK

The book is designed for sequential reading from Chapter 1 through Chapter 14. If you are familiar with relational database concepts, you may skip the first two chapters. From my personal experience with students, Chapter 2 on data modeling and normalization helps students tremendously in designing effective databases. You will need access to the computer system to practice SQL statements and PL/SQL programs from Chapters 3 through 12. The fourth part of the text contains reading material on the architecture and administration of Oracle, and the object and Internet features of Oracle8i. Many popular SQL*Plus commands are also covered in Chapter 13. The reader must perform exercise questions and labs at the end of each chapter before moving over to the next chapter. Whether it is procedural or nonprocedural, you cannot learn programming by just reading about it. You need to practice to master the material. NILESH SHAH

"About this title" may belong to another edition of this title.

  • PublisherPearson
  • Publication date2004
  • ISBN 10 0131018574
  • ISBN 13 9780131018570
  • BindingPaperback
  • Edition number2
  • Number of pages456
  • Rating

Other Popular Editions of the Same Title

9789332549722: Database Systems Using Oracle

Featured Edition

ISBN 10:  ISBN 13:  9789332549722
Publisher: PEARSON INDIA, 2015
Softcover

  • 9780131911802: Database Systems Using Oracle: International Edition

    Pearson, 2004
    Softcover

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New soft cover Quantity: 1
International Edition
Seller:
Campustexxts
(Vicksburg, MI, U.S.A.)

Book Description soft cover. Condition: New. International Edition. No supplemental materials. International Editions may have a different cover or ISBN but generally have the exact same content as the US edition, just at a more affordable price. In some cases, end of chapter questions may vary slightly from the US edition. International Editions are typically printed in grayscale, and likely will not have any color throughout the book. New. Books ship from multiple locations depending on availability. All orders are shipped with tracking information. We take pride in our customer service. Please contact us if you have any questions regarding this listing. Seller Inventory # 10385

More information about this seller | Contact seller

Buy New
US$ 60.14
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Softcover Quantity: 1
Seller:
Front Cover Books
(Denver, CO, U.S.A.)

Book Description Condition: new. Seller Inventory # FrontCover0131018574

More information about this seller | Contact seller

Buy New
US$ 74.76
Convert currency

Add to Basket

Shipping: US$ 4.30
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Paperback Quantity: 1
Seller:
Grumpys Fine Books
(Tijeras, NM, U.S.A.)

Book Description Paperback. Condition: new. Prompt service guaranteed. Seller Inventory # Clean0131018574

More information about this seller | Contact seller

Buy New
US$ 75.48
Convert currency

Add to Basket

Shipping: US$ 4.25
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Paperback Quantity: 1
Seller:
Wizard Books
(Long Beach, CA, U.S.A.)

Book Description Paperback. Condition: new. New. Seller Inventory # Wizard0131018574

More information about this seller | Contact seller

Buy New
US$ 76.42
Convert currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Softcover Quantity: 1
Seller:
LibraryMercantile
(Humble, TX, U.S.A.)

Book Description Condition: new. Seller Inventory # newMercantile_0131018574

More information about this seller | Contact seller

Buy New
US$ 77.44
Convert currency

Add to Basket

Shipping: US$ 3.00
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Paperback Quantity: 1
Seller:
GoldenWavesOfBooks
(Fayetteville, TX, U.S.A.)

Book Description Paperback. Condition: new. New. Fast Shipping and good customer service. Seller Inventory # Holz_New_0131018574

More information about this seller | Contact seller

Buy New
US$ 79.51
Convert currency

Add to Basket

Shipping: US$ 4.00
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Softcover Quantity: 1
Seller:
BennettBooksLtd
(LOS ANGELES, CA, U.S.A.)

Book Description Condition: New. New. In shrink wrap. Looks like an interesting title! 1.5. Seller Inventory # Q-0131018574

More information about this seller | Contact seller

Buy New
US$ 78.41
Convert currency

Add to Basket

Shipping: US$ 5.24
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Paperback Quantity: 1
Seller:
GoldBooks
(Austin, TX, U.S.A.)

Book Description Paperback. Condition: new. New Copy. Customer Service Guaranteed. Seller Inventory # think0131018574

More information about this seller | Contact seller

Buy New
US$ 88.34
Convert currency

Add to Basket

Shipping: US$ 4.25
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Paperback Quantity: 1
Seller:
GoldenDragon
(Houston, TX, U.S.A.)

Book Description Paperback. Condition: new. Buy for Great customer experience. Seller Inventory # GoldenDragon0131018574

More information about this seller | Contact seller

Buy New
US$ 126.80
Convert currency

Add to Basket

Shipping: US$ 3.25
Within U.S.A.
Destination, rates & speeds
Stock Image

Shah, Nilesh
Published by Pearson (2004)
ISBN 10: 0131018574 ISBN 13: 9780131018570
New Softcover Quantity: 1
Seller:
Hafa Adai Books
(Moncks Corner, SC, U.S.A.)

Book Description Condition: new. Seller Inventory # Hafa_fresh_0131018574

More information about this seller | Contact seller

Buy New
US$ 159.07
Convert currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, rates & speeds