By Kevin Loney

The Definitive consultant to Oracle Database 11g

Get complete info at the robust positive factors of Oracle Database 11g from this completely up to date Oracle Press consultant. Oracle Database 11g: the total Reference explains how you can use the entire new good points and instruments, execute strong SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge gadgets and object-relational databases. tips on how to enforce the newest safety features, track database functionality, and set up grid computing recommendations. a useful cross-referenced appendix containing Oracle instructions, key terms, positive aspects, and capabilities can be included.

  • Install Oracle Database 11g or improve from an prior version
  • Create database tables, sequences, indexes, perspectives, and person accounts
  • Construct SQL statements, strategies, queries, and subqueries
  • Optimize protection utilizing digital deepest databases and obvious info encryption
  • Import and export facts utilizing SQL*Loader and Oracle info Pump
  • Use SQL replay, switch administration, and outcome caching
  • Avoid human error utilizing flashback and automated undo management
  • Build and music PL/SQL triggers, capabilities, and packages
  • Develop database functions utilizing Java, JDBC, and XML
  • Optimize availability and scalability with Oracle actual software Clusters

Show description

Read or Download Oracle Database 11g The Complete Reference (Oracle Press) PDF

Similar Database Storage Design books

Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series)

Presents starting DBAs and builders with an effective beginning within the database management and programming fundamentals had to embark on an Oracle profession. the focal point is on Oracle Database 10g, yet you’ll get the basics appropriate to all Oracle database releases.

The Profit Impact of Business Intelligence

Company Intelligence (BI): It’s not only a expertise. It’s not only a technique. It’s a strong new administration procedure that – whilst performed correct – can carry wisdom, potency, greater judgements, and revenue to nearly any association that makes use of it. whilst BI first got here at the scene, it promised much yet usually did not bring.

Building the Agile Enterprise: With SOA, BPM and MBM (The MK/OMG Press)

Within the final ten years IT has introduced basic adjustments to the way in which the area works. not just has it elevated the rate of operations and communications, however it has additionally undermined simple assumptions of conventional company versions and elevated the variety of variables. this present day, the survival of significant organisations is challenged by means of a world-wide industry, foreign operations, outsourcing, worldwide groups, a altering group, protection threats, company continuity, net visibility, and consumer expectancies.

Oracle DBA Guide to Data Warehousing and Star Schemas

Oracle DBA consultant to information Warehousing and megastar Schemas is the definitiveguide to maximizing the functionality, flexibility, and manageability ofany Oracle 8i/9i info warehouse. mythical Oracle info warehouse expertBert Scalzo deals hard-won classes and confirmed ideas for designing,constructing, tuning, and protecting famous person schema facts warehouses inreal construction environments.

Additional info for Oracle Database 11g The Complete Reference (Oracle Press)

Show sample text content

Rated 4.09 of 5 – based on 38 votes