Oracle Database 12c The Complete Reference

Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 9780071801744
Release Date: 2013-08-05
Genre: Computers

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

Oracle Database 10g The Complete Reference

Author: Kevin Loney
Publisher: Mcgraw-hill
ISBN: 0072253517
Release Date: 2004-09-07
Genre: Computers

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Oracle Database 10g DBA Handbook

Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 0071770437
Release Date: 2005-04-14
Genre: Computers

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Oracle Database 12c PL SQL Programming

Author: Michael McLaughlin
Publisher: McGraw Hill Professional
ISBN: 9780071812443
Release Date: 2014-02-07
Genre: Computers

Master Oracle Database 12c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

Oracle Database 12c New Features

Author: Robert Freeman
Publisher: McGraw Hill Professional
ISBN: 9780071799317
Release Date: 2013-12-10
Genre: Computers

Maximize the New and Improved Features of Oracle Database 12c Written by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you’ll find everything you need to know to get up and running quickly on Oracle Database 12c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements

OCP Upgrade to Oracle Database 12c Exam Guide Exam 1Z0 060

Author: Sam R. Alapati
Publisher: McGraw-Hill Education
ISBN: 0071819975
Release Date: 2014-06-03
Genre: Computers

A Fully Integrated Study System for OCP Exam 1Z0-060 Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12c, including: Oracle Enterprise Manager Database Express and additional tools for database monitoring Multitenant container databases and pluggable databases Auditing, administrative privileges, data redaction, and other Oracle security features Adaptive execution plans, adaptive statistics, and automatic SQL plan management Oracle Recovery Manager backup and recovery improvements Oracle Database Resource Manager and other performance enhancements Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity Electronic content includes: 170 practice exam questions with detailed answer explanations PDF copy of the book

Oracle Database 12c DBA Handbook

Author: Bob Bryla
Publisher: McGraw-Hill Education
ISBN: 0071798781
Release Date: 2015-06-24
Genre: Computers

The Most Complete, Current Oracle DBA Resource Maintain a high-performance Oracle Database using the best practices and expert techniques in this Oracle Press guide. Oracle Database 12c DBA Handbook is thoroughly updated to cover the new features and utilities, including the multitenant architecture, Oracle Database In-Memory option, and cloud enhancements. Real-world examples for every major configuration are included. You’ll learn how to successfully manage a highly available, robust, secure, and extensible Oracle enterprise database environment. Upgrade to Oracle Database 12c Plan and manage tablespaces Maximize database performance using effective physical database layouts and storage management methods Monitor disk space used by database objects Manage transactions with undo tablespaces Implement expert performance-tuning techniques Increase query speed using the new Oracle Database In-Memory option Manage database security through authentication, authorization, and auditing Take full advantage of the multitenant database architecture Enable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data Guard Perform backup and recovery with Oracle Recovery Manager Manage distributed databases and VLDBs

OCP Oracle Database 12c Advanced Administration Exam Guide Exam 1Z0 063

Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 9780071830058
Release Date: 2015-06-12
Genre: Computers

A Complete Study System for OCP Exam 1Z0-063 Prepare for the Oracle Certified Professional Oracle Database 12c Advanced Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-063, including: Configuring and managing Oracle Recovery Manager (RMAN) settings Using the Oracle RMAN recovery catalog Performing backup and recovery Diagnosing database failures and using the automatic diagnostic repository Encrypting, securing, monitoring, and tuning Oracle RMAN backups Configuring and using flashback features Transporting and copying tablespaces and databases Creating and managing multitenant container databases and pluggable databases Using the Oracle Data Pump, SQL*Loader, and auditing features Electronic content includes: 150+ practice exam questions Test engine that provides practice exams or quizzes that can be customized by chapter or exam objective

Oracle8i

Author: Kevin Loney
Publisher: McGraw-Hill Osborne Media
ISBN: 0072123648
Release Date: 2000
Genre: Computers

Announcing the 10th Anniversary Edition of the best-selling Oracle book of all time--Oracle8i: The Complete Reference! Written by Oracle experts and complete with a fully searchable book and reusable code on CD-ROM, this is the most definitive resource available on Oracle8i. It's a must-have for every Oracle professional.

Oracle Database 11g The Complete Reference

Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 9780071598767
Release Date: 2008-10-15
Genre: Computers

The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters

Oracle Database 12c SQL

Author: Jason Price
Publisher: McGraw Hill Professional
ISBN: 9780071799362
Release Date: 2013-06-26
Genre: Computers

Write Powerful SQL Statements and PL/SQL Programs Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide contains everything you need to know to master SQL. Use SQL statements to access an Oracle database Work with SQL*Plus and SQL Developer Write PL/SQL programs Create tables, sequences, indexes, views, and triggers Design advanced queries containing complex calculations Create database objects to handle abstract data Use date, time stamp, and time interval data types Establish user roles and privileges Handle multimedia files using large objects Tune SQL statements to make them execute faster Generate, process, and store XML data Master the very latest Oracle Database 12c features Code examples in the book are available for download.

OCA OCP Oracle Database 12c All in One Exam Guide Exams 1Z0 061 1Z0 062 1Z0 063

Author: John Watson
Publisher: McGraw Hill Professional
ISBN: 9780071828079
Release Date: 2015-08-28
Genre: Computers

This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification. OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, and a score report performance assessment tool Ideal as both exam guide and on-the-job reference The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

Oracle Database 12c Release 2 New Features

Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 9781259837203
Release Date: 2017-04-24
Genre: Computers

Leverage the New and Improved Features of Oracle Database 12c Written by Oracle experts Bob Bryla and Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you’ll find everything you need to know to get up and running quickly on Oracle Database 12c Release 2. Supported by contributions from Oracle expert Eric Yen, Oracle Database 12c Release 2 New Features offers detailed coverage of: • Installing Oracle Database 12c and Grid Infrastructure • Architectural changes, such as Oracle Multitenant • The most current information on upgrading and migrating to Oracle Database 12c • The pre-upgrade information tool and parallel processing for database upgrades • Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System • Enhanced and new online operations: tables, indexes, and PDBs • Oracle RMAN enhancements, including cross-platform backup and recovery • Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync • SQL, PL/SQL, DML, and DDL new features • Improvements to partitioning manageability, performance, and availability • Advanced business intelligence and data warehousing capabilities • Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges • Manageability, performance, and optimization improvements

OCP Oracle Database 12c Administrator Certified Professional Study Guide

Author: Robert G. Freeman
Publisher: John Wiley & Sons
ISBN: 9781118644072
Release Date: 2014-08-25
Genre: Computers

An updated guide for an updated certification exam! As the most popular database software in the world, OracleDatabase 12c has been updated for the first time in nearly sixyears and the changes are significant. This study guide reviews howOracle 12c allows multiple instances to be used simultaneously viathe cloud. You'll sharpen your skills to prepare for the threelevels of certification: Oracle Certified Associate, OracleCertified Professional, and Oracle Certified Master. Workbookexercise appendix, test engine, chapter review questions,electronic flashcards, searchable PDF glossary, and two bonuspractice exams all help to enhance your preparation to take theOracle 12c exam. Addresses such topics as: database architecture, configuringand recoverability, configuring backup specifications, andperforming user-managed backup and recovery Reviews how to use RMAN to create backups, perform recovery,and duplicate a database Looks at performing tablespace point-in-time recovery and usingflashback technology Covers diagnosing the database, managing memory, managingresources, and automating tasks Focusing 100 percent on the exam objectives, OCP: OracleDatabase 12c Administrator Certified Professional Study Guideis designed for those who feel they are ready to attempt thischallenging exam.

Oracle Database 12c Oracle RMAN Backup and Recovery

Author: Robert G. Freeman
Publisher: McGraw Hill Professional
ISBN: 9780071847445
Release Date: 2016-04-01
Genre: Computers

This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, offering the most up-to-date information This fully updated volume lays out the easiest, fastest, and most effective methods of deploying RMAN in Oracle Database environments of any size. Keeping with previous editions, this book teaches computing professionals at all skill levels how to fully leverage every powerful RMAN tool and protect mission-critical data. Oracle Database 12c RMAN Backup and Recovery explains how to generate reliable archives and carry out successful system restores. You will learn to work from the command line or GUI, automate the database backup process, perform Oracle Flashback recoveries, and deploy third-party administration utilities. The book features full details on cloud computing, report generation, performance tuning, and security. Offers up-to-date coverage of Oracle Database 12c new features Examples and workshops throughout walk you through important RMAN operations