Oracle Database 12c The Complete Reference

Inbunden, Engelska, 2013

712 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Beskrivning

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Master the Cutting-Edge Features of Oracle Database 12c

Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, andadministration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions.

Set up Oracle Database 12c or upgrade from an earlier version
Design Oracle databases and plan for application implementation
Construct SQL and SQL*Plus statements and execute powerful queries
Secure data with roles, privileges, virtualization, and encryption
Move data with SQL*Loader and Oracle Data Pump
Restore databases using flashback and the Oracle Database Automatic Undo Management feature
Build and deploy PL/SQL triggers, procedures, and packages
Work with Oracle pluggable and container databases
Develop database applications using Java, JDBC, and XML
Optimize performance with Oracle Real Application Clusters

Produktinformation

Utgivningsdatum:2013-10-16
Mått:193 x 238 x 53 mm
Vikt:2 299 g
Format:Inbunden
Språk:Engelska
Antal sidor:1 472
Förlag:McGraw-Hill Education
ISBN:9780071801751

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

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

Innehållsförteckning

Part I: Critical Database Concepts1. Oracle Database 11g Architecture Options2. Installing Oracle Database 11g and Creating a Database3. Upgrading to Oracle Database 11g4. Planning Oracle Applications--Approaches, Risks, and StandardsPart II: SQL and SQL Plus5. The Basic Parts of Speech in SQL6. Basic SQL Plus Reports and Commands7. Getting Text Information and Changing It8. Searching for Regular Expressions9. Playing the Numbers10. Dates: Then, Now, and the Difference11. Conversion and Transformation Functions12. Grouping Things Together13. When One Query Depends Upon Another14. Some Complex Possibilities15. Changing Data: Insert, Update, Merge, and Delete16. DECODE and CASE: If, Then, and Else in SQL17. Creating and Managing Tables, Views, Indexes, Clusters, and Sequences18. Editioning19. Basic Oracle SecurityPart III: Beyond the Basics20. Advanced Security--Virtual Private Databases21. Advanced Security--On-Disk Encryption and Secure Backup22. Working with Tablespaces23. Using SQL Loader to Load Data24. Using Data Pump Export and Import25. Accessing Remote Data 26. Using Materialized Views27. Using Oracle Text for Text Searches28. Using External Tables29. Using Flashback Queries30. Flashback--Tables and Databases31. Change, Replay, and SQL ReplayPart IV: PL/SQL32. An Introduction to PL/SQL33. Online Application Upgrades34. Triggers35. Procedures, Functions, and Packages36. Using Native Dynamic SQL and DBMS_SQL37. PL/SQL TuningPart V: Object-Relational Databases38. Implementing Object Types, Object Views, and Methods39. Collectors40. Using Large Objects41. Advanced Object-Oriented ConceptsPart VI: Java in Oracle42. An Introduction to Java43. JDBC Programming44. Java Stored ProceduresPart VII: Hitchhiker's Guides45. The Hitchhiker's Guide to the Oracle Data Dictionary46. The Hitchhiker's Guide to Tuning Applications and SQL47. Client-side query cache--use, configuration, and benefits48. Case Studies in Tuning49. Advanced Architecture Options--Records database, Vault, and Content Database50. Oracle Real Application Clusters, Grid Architecture, and Management51. The Hitchhiker's Guide to Database Administration52. The Hitchhiker's Guide to XML in Oracle