did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780071768856

Oracle Database 11g & MySQL 5.6 Developer Handbook

by
  • ISBN13:

    9780071768856

  • ISBN10:

    0071768858

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2011-10-21
  • Publisher: McGraw Hill

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $50.00 Save up to $20.75
  • Rent Book $29.25
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 24-48 HOURS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

Supplemental Materials

What is included with this book?

Summary

The definitive Oracle Press guide to programming and working with Oracle Database 11 gand Oracle MySQL in a mixed environment. Oracle Database 11g and MySQL 5.5 Database Developer Handbookis a comparative handbook to support developers moving from MySQL to Oracle or Oracle to MySQL. The book compares and demonstrates development environments, architecture, security, transactions, and referential integrity concepts. It compares and contrasts SQL dialects and approaches across the spectrum of SQL commands and discusses their portability. The book also compares and contrasts stored programs in both databases and discusses their design portability. Clear examples, instructions, and explanations make this single volume handbook the standard for porting dialects between the Oracle and MySQL databases. Best practices are highlighted throughout the chapters. Mastery questions are provided at the end of each chapter with an appendix containing answers with explanations. Oracle Database 11g and MySQL 5.5 Database Developer Handbook Focuses on how to port the SQL dialects to either database as needed Explains comparable SQL and PL/SQL/Stored Procedure development techniques Compares and contrasts development strategies in solving problems with SQL and PL/SQL/Stored Procedures Features best practices in database development to support web-based applications Highlights Oracle Database 11 gand Oracle MySQL 5.5 unique SQL and PL/SQL/Stored Program features

Table of Contents

Part I: Development Components
Chapter 1. Architecture
Chapter 2. Client Interface
Chapter 3. Security Models
Chapter 4. Transaction Models
Chapter 5. Constraints
Part II: SQL Development
Chapter 6. Creating Users and Structures
Chapter 7. Modifying Users and Structures
Chapter 8. Inserting Data
Chapter 9. Updating Data
Chapter 10. Deleting Data
Chapter 11. Querying
Chapter 12. Merging Data
Chapter 13. PL/SQL Programming Language
Chapter 14. SQL/PSM Basics
Chapter 15. Triggers
Mastery Check Answers
Index

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program