Read more
Informationen zum Autor 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 Klappentext 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 versionDesign Oracle databases and plan for application implementationConstruct SQL and SQL*Plus statements and execute powerful queriesSecure data with roles, privileges, virtualization, and encryptionMove data with SQL*Loader and Oracle Data PumpRestore databases using flashback and the Oracle Database Automatic Undo Management featureBuild and deploy PL/SQL triggers, procedures, and packagesWork with Oracle pluggable and container databasesDevelop database applications using Java, JDBC, and XMLOptimize performance with Oracle Real Application Clusters Zusammenfassung An all-new edition of the bestselling Oracle Press book ever published! fully revised and updated for the latest database release! Oracle Database 12c. Inhaltsverzeichnis 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. Ch...
