Overview

Full Product Details

Author:   Bob Bryla ,  Kevin Loney
Publisher:   McGraw-Hill Education - Europe
Imprint:   Osborne/McGraw-Hill
Dimensions:   Width: 19.30cm , Height: 5.30cm , Length: 23.90cm
Weight:   2.300kg
ISBN:  

9780071801751

ISBN 10:   0071801758
Pages:   1472
Publication Date:   16 October 2013
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Hardback
Publisher's Status:   Active
Availability:   Temporarily unavailable  
The supplier advises that this item is temporarily unavailable. It will be ordered for you and placed on backorder. Once it does come back in stock, we will ship it out to you.

Table of Contents

Part I: Critical Database Concepts 1. Oracle Database 11g Architecture Options 2. Installing Oracle Database 11g and Creating a Database 3. Upgrading to Oracle Database 11g 4. Planning Oracle Applications--Approaches, Risks, and Standards Part II: SQL and SQL Plus 5. The Basic Parts of Speech in SQL 6. Basic SQL Plus Reports and Commands 7. Getting Text Information and Changing It 8. Searching for Regular Expressions 9. Playing the Numbers 10. Dates: Then, Now, and the Difference 11. Conversion and Transformation Functions 12. Grouping Things Together 13. When One Query Depends Upon Another 14. Some Complex Possibilities 15. Changing Data: Insert, Update, Merge, and Delete 16. DECODE and CASE: If, Then, and Else in SQL 17. Creating and Managing Tables, Views, Indexes, Clusters, and Sequences 18. Editioning 19. Basic Oracle Security Part III: Beyond the Basics 20. Advanced Security--Virtual Private Databases 21. Advanced Security--On-Disk Encryption and Secure Backup 22. Working with Tablespaces 23. Using SQL Loader to Load Data 24. Using Data Pump Export and Import 25. Accessing Remote Data 26. Using Materialized Views 27. Using Oracle Text for Text Searches 28. Using External Tables 29. Using Flashback Queries 30. Flashback--Tables and Databases 31. Change, Replay, and SQL Replay Part IV: PL/SQL 32. An Introduction to PL/SQL 33. Online Application Upgrades 34. Triggers 35. Procedures, Functions, and Packages 36. Using Native Dynamic SQL and DBMS_SQL 37. PL/SQL Tuning Part V: Object-Relational Databases 38. Implementing Object Types, Object Views, and Methods 39. Collectors 40. Using Large Objects 41. Advanced Object-Oriented Concepts Part VI: Java in Oracle 42. An Introduction to Java 43. JDBC Programming 44. Java Stored Procedures Part VII: Hitchhiker's Guides 45. The Hitchhiker's Guide to the Oracle Data Dictionary 46. The Hitchhiker's Guide to Tuning Applications and SQL 47. Client-side query cache--use, configuration, and benefits 48. Case Studies in Tuning 49. Advanced Architecture Options--Records database, Vault, and Content Database 50. Oracle Real Application Clusters, Grid Architecture, and Management 51. The Hitchhiker's Guide to Database Administration 52. The Hitchhiker's Guide to XML in Oracle

Reviews

Author Information

Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands End in Dodgeville, Wisconsin. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley. Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions