If 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.
Here are 5 of the ways that our book differs from the others
#1: You'll see how to take advantage of the Oracle SQL Developer tool
SQL Developer is a free tool for working with database objects and SQL statements. Its graphical interface makes it more intuitive and easier to use than older command-line tools like SQL*Plus. I think you'll find it boosts your productivity as you use it to write and run queries, to work with database objects, or to debug stored procedures.
#2: You'll start off with how to query a database, not how to design one
This book is written for application developers, and the first thing an application developer needs to know is how to write queries. So that's what's covered in the first 8 chapters of this book. It starts with simple queries, then moves on to complex inner and outer joins, summary queries, and subqueries that do more of the database processing so that your applications can do less.
Once you're comfortable with querying databases, this book shows how to design a database and how to create database tables. Having this background can help you query a database more effectively. And it provides a solid introduction to DBA skills if you're interested in that career path.
#3: You get 2 books in 1: A SQL book and a PL/SQL book
PL/SQL allows you to write complex scripts, stored procedures, functions, and triggers, all essential skills for most application developers. So along with SQL, this book covers the PL/SQL that you'll use most of the time; there's no need to buy a second book to learn PL/SQL.
#4: Complete applications show you how all the pieces interact
One key to mastering SQL is to have plenty of coding examples that show how the features you re learning work and what problems you may run into as you use them on your own. So this book provides dozens of SQL statements and PL/SQL scripts for various jobs that are routine in business applications. Download the examples for free from our website and use them as starting points for your own SQL routines.
#5: The paired-pages format lets you set your own pace
Depending on what you already know about Oracle SQL and how fast you want to go, you can read every page and study each example...skim through the headings for topics you don't know...scan through the righthand pages for development details you might have missed in the past...or turn to any two-page spread when you need reference information. The paired-pages format makes it easy and fast for you to use the book the way you want to.
(If you aren't familiar with how the paired pages work, please be sure to download a sample chapter from our website)
"synopsis" may belong to another edition of this title.
Joel Murach has been writing and editing books about computer programming for over 10 years. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. When he's not programming or writing books about programming, he can be found surfing or writing music.
"About this title" may belong to another edition of this title.
Shipping:
US$ 3.30
Within U.S.A.
Seller: Austin Goodwill 1101, Austin, TX, U.S.A.
paperback. Condition: Good. Get fast and secure shipping knowing your purchase helps empower our community to transform their lives through work. Seller Inventory # 4RZURM000SR7
Quantity: 1 available
Seller: HPB-Red, Dallas, TX, U.S.A.
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!. Seller Inventory # S_420756697
Quantity: 1 available
Seller: SecondSale, Montgomery, IL, U.S.A.
Condition: Good. Item in good condition and has highlighting/writing on text. Used texts may not contain supplemental items such as CDs, info-trac etc. Seller Inventory # 00082019369
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Used book that is in clean, average condition without any missing pages. Seller Inventory # 12756692-6
Quantity: 6 available
Seller: GF Books, Inc., Hawthorne, CA, U.S.A.
Condition: Very Good. Book is in Used-VeryGood condition. Pages and cover are clean and intact. Used items may not include supplementary materials such as CDs or access codes. May show signs of minor shelf wear and contain very limited notes and highlighting. 2.85. Seller Inventory # 1890774804-2-3
Quantity: 1 available
Seller: Book Deals, Tucson, AZ, U.S.A.
Condition: Good. Good condition. This is the average used book, that has all pages or leaves present, but may include writing. Book may be ex-library with stamps and stickers. 2.85. Seller Inventory # 353-1890774804-gdd
Quantity: 1 available
Seller: TextbookRush, Grandview Heights, OH, U.S.A.
Condition: Very Good. Ships SAME or NEXT business day. We Ship to APO/FPO addr. Choose EXPEDITED shipping and receive in 2-5 business days within the United States. See our member profile for customer support contact info. We have an easy return policy. Seller Inventory # 53793432
Quantity: 1 available
Seller: Textbooks_Source, Columbia, MO, U.S.A.
paperback. Condition: Good. 2nd ed. Ships in a BOX from Central Missouri! May not include working access code. Will not include dust jacket. Has used sticker(s) and some writing or highlighting. UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes). Seller Inventory # 001670772U
Quantity: 2 available
Seller: TextbookRush, Grandview Heights, OH, U.S.A.
Condition: Good. Ships SAME or NEXT business day. We Ship to APO/FPO addr. Choose EXPEDITED shipping and receive in 2-5 business days within the United States. See our member profile for customer support contact info. We have an easy return policy. Seller Inventory # 53556848
Quantity: 1 available
Seller: HPB-Emerald, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority!. Seller Inventory # S_429813721
Quantity: 1 available