Oracle Database 12c The Complete Reference

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

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