,

Oracle Database 12c The Complete Reference

Administer and Secure a Robust Cloud-Based Environment

Specificaties
Gebonden, 1435 blz. | Engels
McGraw-Hill Computing | 1e druk, 2013
ISBN13: 9780071801751
Rubricering
Hoofdrubriek : Computer en informatica
McGraw-Hill Computing 1e druk, 2013 9780071801751
Verwachte levertijd ongeveer 11 werkdagen

Samenvatting

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, and administration. 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

Specificaties

ISBN13:9780071801751
Taal:Engels
Bindwijze:gebonden
Aantal pagina's:1435
Druk:1
Verschijningsdatum:31-10-2013

Inhoudsopgave

Acknowledgments

Part I: Critical Database Concepts
1. Oracle Database 12c Architecture Options
2. Installing Oracle Database 12c and Creating a Database
3. Upgrading to Oracle Database 12c
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 on Another
14. Some Complex Possibilities
15. Changing Data: Insert, Delete, Update and Merge
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-Transparant Data Encryption
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. 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 (Nested Tables and Varying Arrays)
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. The Hitchhiker's Guide to SQL Result Cache and Client-Side Query Cache
48. Case Studies in Tuning
49. The Hitchhiker's Guide to Pluggable Databases
50. The Hitchhiker's Guide to Oracle Real Application
51. The Hitchhiker's Guide to Database Administration
52. The Hitchhiker's Guide to XML in Oracle

Part VIII:
Alphabetical Reference
About the CD-ROM
Index

Net verschenen

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Oracle Database 12c The Complete Reference