Oracle Database 11g The Complete Reference - Bookswagon UAE
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Oracle Database 11g The Complete Reference
Oracle Database 11g The Complete Reference

Oracle Database 11g The Complete Reference


     0     
5
4
3
2
1



Available


X
About the Book

The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

  • Install Oracle Database 11g or upgrade from an earlier version
  • Create database tables, sequences, indexes, views, and user accounts
  • Construct SQL statements, procedures, queries, and subqueries
  • Optimize security using virtual private databases and transparent data encryption
  • Import and export data using SQL*Loader and Oracle Data Pump
  • Use SQL replay, change management, and result caching
  • Avoid human errors using flashback and automatic undo management
  • Build and tune PL/SQL triggers, functions, and packages
  • Develop database applications using Java, JDBC, and XML
  • Optimize availability and scalability with Oracle Real Application Clusters


Table of Contents:
PART I: Critical Database Concepts
Ch 1: Oracle Database 11g Architecture Options
Ch 2: Installing Oracle Database 11g and Creating a Database
Ch 3: Upgrading to Oracle Database 11g
Ch 4: Planning Oracle Applications—Approaches, Risks, and Standards
PART II: SQL and SQL*Plus
Ch 5: The Basic Parts of Speech in SQL
Ch 6: Basic SQL*Plus Reports and Commands
Ch 7: Getting Text Information and Changing It
Ch 8: Searching for Regular Expressions
Ch 9: Playing the Numbers
Ch 10: Dates: Then, Now, and the Difference
Ch 11: Conversion and Transformation Functions
Ch 12: Grouping Things Together
Ch 13: When One Query Depends upon Another
Ch 14: Some Complex Possibilities
Ch 15: Changing Data: insert, update, merge, and delete
Ch 16: DECODE and CASE: if, then, and else in SQL
Ch 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Ch 18: Partitioning
Ch 19: Basic Oracle Security
PART III: Beyond the Basics
Ch 20: Advanced Security—Virtual Private Databases
Ch 21: Advanced Security: Transparent Data Encryption
Ch 22: Working with Tablespaces
Ch 23: Using SQL*Loader to Load Data
Ch 24: Using Data Pump Export and Import
Ch 25: Accessing Remote Data
Ch 26: Using Materialized Views
Ch 27: Using Oracle Text for Text Searches
Ch 28: Using External Tables
Ch 29: Using Flashback Queries
Ch 30: Flashback—Tables and Databases
Ch 31: SQL Replay
PART IV: PL/SQL
Ch 32: An Introduction to PL/SQL
Ch 33: Online Application Upgrades
Ch 34: Triggers
Ch 35: Procedures, Functions, and Packages
Ch 36: Using Native Dynamic SQL and DBMS_SQL
Ch 37: PL/SQL Tuning
PART V: Object-Relational Databases
Ch 38: Implementing Types, Object Views, and Methods
Ch 39: Collectors (Nested Tables and Varying Arrays)
Ch 40: Using Large Objects
Ch 41: Advanced Object-Oriented Concepts
PART VI: Java in Oracle
Ch 42: An Introduction to Java
Ch 43: JDBC Programming
Ch 44: Java Stored Procedures
PART VII: Hitchhiker's Guides
Ch 45: The Hitchhiker's Guide to Oracle Data Dictionary
Ch 46: The Hitchhiker's Guide to Tuning Applications and SQL
Ch 47: SQL Result Cache and Client-Side Query Cache
Ch 48: Case Studies in Tuning
Ch 49: Advanced Architecture Options--DB Vault, Content DB, and Records DB
Ch 50: Oracle Real Application Clusters
Ch 51: The Hitchhiker’s Guide to Database Administration
Ch 52: The Hitchhiker’s Guide to XML in Oracle
Part VIII Alphabetical Reference
Index


About the Author :
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


Best Sellers


Product Details
  • ISBN-13: 9780071598750
  • Publisher: McGraw-Hill Education - Europe
  • Publisher Imprint: Osborne/McGraw-Hill
  • Height: 239 mm
  • No of Pages: 1368
  • Spine Width: 51 mm
  • Width: 203 mm
  • ISBN-10: 0071598758
  • Publisher Date: 16 Feb 2009
  • Binding: Hardback
  • Language: English
  • Returnable: N
  • Weight: 2200 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle Database 11g The Complete Reference
McGraw-Hill Education - Europe -
Oracle Database 11g The Complete Reference
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle Database 11g The Complete Reference

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!