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.

9781890774509

Murach's Oracle SQL and PL/SQL

by
  • ISBN13:

    9781890774509

  • ISBN10:

    1890774502

  • Format: Paperback
  • Copyright: 2008-08-01
  • Publisher: Mike Murach & Associates Inc
  • 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: $52.50

Summary

f you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.

Author Biography

Joel Murach has a background in software training and is a specialist in developing business applications, particularly web applications. In the past 5 years, he has written and edited books on Java, ASP.NET, and C# that have helped thousands of developers become proficient at creating the kind of applications that businesses rely on every day.

Table of Contents

An introduction to relational databases and SQL
How to use Oracle SQL Developer and other tools
How to retrieve data from a single table
How to retrieve data from two or more tables
How to code summary queries
How to code subqueries
How to insert, update, and delete data
How to work with data types and functions
How to design a database
How to create tables, indexes, and sequences
How to create views
How to manage database security
How to write PL/SQL code
How to manage transactions and locking
How to create stored procedures and functions
How to create triggers
How to work with timestamps and intervals
How to work with large objects
Index
Table of Contents provided by Publisher. All Rights Reserved.

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