Oracle Database 12c The Complete Reference

The Complete Reference

Author: Bob Bryla,Kevin Loney

Publisher: McGraw Hill Professional

ISBN: 007180174X

Category: Computers

Page: 1472

View: 1777

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 SQL

Das umfassende Handbuch

Author: Jürgen Sieben

Publisher: N.A

ISBN: 9783836237178

Category: Computers

Page: 1011

View: 6724


Oracle Database 10g für Einsteiger

Grundkonzepte der Oracle-Datenbank

Author: Ian Abramson,Michael Abbey,Michael J. Corey

Publisher: N.A

ISBN: 9783446227989

Category:

Page: 420

View: 3960

In diesem Buch lernen Einsteiger die Grundkonzepte der Oracle Database 10g kennen. Die Grundlagen der Datenbanktechnologie, die Aufgaben von Administratoren und die Features großer Datenbanken werden vorgestellt. Ebenso bieten die Autoren eine ausführliche Einführung in die Programmierung mit SQL, PL/SQL, Java und XML. Dieser bewährte Band aus der Oracle Press vereinfacht die ersten Schritte auf dem Weg, ein erfahrener DBA, Entwickler oder Benutzer von Oracle zu werden. Die Highlights: Jedes Kernthema ist in logisch aufgebaute Lerneinheiten gegliedert, die sich einzeln und entsprechend dem eigenen Lerntempo bearbeiten lassen. Jedes Kapitel beginnt mit einer Übersicht der Qualifikationen, die angehende DBAs erwerben. Zahlreiche Übungen ermöglichen, die erworbenen Kenntnisse direkt in die Praxis umzusetzen. Jedes Kapitel enthält Tests, um den Lernfortschritt zu kontrollieren und den Wissensstand zu überprüfen. Die Abschnitte "Fragen an den Experten" enthalten wertvolle Tipps von Datenbank-Profis.

Achieving Buzzword Compliance

Data Architecture Language and Vocabulary

Author: David C. Hay

Publisher: Technics Publications

ISBN: 163462372X

Category: Computers

Page: N.A

View: 1330

Understand the language and vocabulary of Data Architecture. The Data Architecture field is rife with terms that have become “fashionable”. Some of the terms began with very specific, specialized, meanings – but as their use spread, they lost the precision of their technical definitions and become, well, “buzzwords”. A buzzword is “a word or expression from a particular subject area that has become fashionable because it has been used a lot”. Compliance is “the obeying of an accepted principle or instruction that states the way things are or should be done.” The assignment is to take buzzwords and follow rules to use them correctly. We cut through the hype to arrive at buzzword compliance – the state where you fully understand the words that in fact have real meaning in the data architecture industry. This book will rationalize the various ways all these terms are defined. Of necessity, the book must address all aspects of describing an enterprise and its data management technologies. This includes a wide range of subjects, from entity/relationship modeling, through the semantic web, to database issues like relational and “beyond relational” (“NoSQL”) approaches. In each case, the definitions for the subject are meant to be detailed enough to make it possible to understand basic principles—while recognizing that a full understanding will require consulting the sources where they are more completely described. The book’s Glossary contains a catalogue of definitions and its Bibliography contains a comprehensive set of references.

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

Author: Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 0071830057

Category: Computers

Page: 752

View: 5634

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

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

Author: Sam R. Alapati

Publisher: McGraw Hill Professional

ISBN: 0071819967

Category: Computers

Page: 528

View: 6008

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

OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061)

Author: Roopesh Ramklass

Publisher: McGraw Hill Professional

ISBN: 0071820299

Category: Computers

Page: 592

View: 6971

A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this 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 OCA objectives for exam 1Z0-061, including: Data retrieval using the SQL SELECT statement Restricting and sorting data Single-row functions Using conversion functions and conditional expressions Reporting aggregated data with the group functions Displaying data from multiple tables with joins Using subqueries to solve problems Using the set operators Manipulating data with DML statements Using DDL statements to create and manage tables Electronic content includes: 150+ practice exam questions with detailed answers and explanations Score report performance assessment tool

OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062)

Author: John Watson

Publisher: McGraw Hill Professional

ISBN: 0071831274

Category: Computers

Page: 768

View: 4637

A Complete Study System for OCA Exam 1Z0-062 Prepare for the Oracle Certified Associate Oracle Database 12c Installation and 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 OCA objectives for exam 1Z0-062, including: Installing and upgrading Oracle Database software Managing the database instance Configuring the Oracle network environment Managing database storage structures Administering user security Managing undo data and data concurrency Implementing Oracle Database auditing Performing database maintenance Managing performance and tuning SQL Managing resources using Oracle Database Resource Manager Automating tasks Moving data Performing backup and recovery Installing Oracle Grid Infrastructure for a standalone server Electronic content includes: 185+ practice exam questions with detailed answers and explanations Test engine that provides custom exams by chapter or by domain

Oracle Essentials

Oracle Database 12c

Author: Rick Greenwald,Robert Stackowiak,Jonathan Stern

Publisher: "O'Reilly Media, Inc."

ISBN: 1449343171

Category: Computers

Page: 432

View: 3179

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions

Encyclopedia of Information Science and Technology, Third Edition

Author: Khosrow-Pour, Mehdi

Publisher: IGI Global

ISBN: 1466658894

Category: Computers

Page: 10384

View: 9228

"This 10-volume compilation of authoritative, research-based articles contributed by thousands of researchers and experts from all over the world emphasized modern issues and the presentation of potential opportunities, prospective solutions, and future directions in the field of information science and technology"--Provided by publisher.

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

Author: John Watson,Roopesh Ramklass,Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 0071828079

Category: Computers

Page: 1072

View: 1187

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 WebLogic Server 12c Administration Handbook

Author: Sam R. Alapati

Publisher: McGraw Hill Professional

ISBN: 0071824073

Category: Computers

Page: 576

View: 808

Best Practices for Oracle WebLogic Server 12c Configuration and Administration Maintain a high-performance enterprise application framework using the detailed information in this authoritative resource. Through expert instruction and real-world examples, Oracle WebLogic Server 12c Administration Handbook fully explains the latest management tools and techniques. Learn how to work from the Oracle WebLogic Server Administration Console or command line, configure servers and clusters, deploy applications, and optimize application performance. Tuning, troubleshooting, and load balancing are thoroughly covered in this Oracle Press guide. Install Oracle WebLogic Server 12c or perform an upgrade Manage domains, server instances, networks, and virtual hosts Work with the WebLogic Scripting Tool feature and Node Manager Build custom network channels and resource adapters Monitor performance with the WebLogic Diagnostics Framework feature Prioritize requests using Oracle WebLogic Server Work Managers Configure Oracle WebLogic clusters and migrate servers and services Deploy web applications, Enterprise JavaBeans, and Java EE modules Establish security realms and authenticate and authorize users Allocate memory, optimize throughput, and tune the Java Virtual Machine

Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX

Author: Arie Geller,Brian Spendolini

Publisher: McGraw Hill Professional

ISBN: 007184306X

Category: Computers

Page: 464

View: 7633

This Oracle Press guide shows how to build and deploy powerful Web applications with Oracle Application Express and features full coverage of the latest version, APEX 5.0 This comprehensive volume from Oracle Press offers up-to-date coverage of Oracle Application Express (APEX), Oracle’s rapid development tool for the Web developer. APEX is an entirely Web-based framework that comes built into every edition of Oracle Database—its backbone is Oracle’s powerful PL/SQL language, alongside the most advanced Web development technologies like HTML5, mobile development, and full support of CSS and JavaScript. APEX enables anyone—from novice user to seasoned developer—to easily create Web applications that are powerful, reliable, and highly scalable. Oracle Application Express: Build Powerful Data‐Centric Web Apps lays out basic information about APEX concepts before delving into the unparalleled power of the platform and describing the new features in version 5.0. You will discover how to install and configure APEX, work with the Application Builder and Page Designer, use built-in wizards, and design custom Web apps. Teaches the cleanest and fastest builds for high-performance, secure web applications Shows how to effectively migrate legacy applications into a modern Web-based environment Authored by early adopters of APEX 5.0 who have been active in the APEX community for years

RMAN Recipes for Oracle Database 12c

A Problem-Solution Approach

Author: Darl Kuhn,Sam Alapati,Arup Nanda

Publisher: Apress

ISBN: 143024836X

Category: Computers

Page: 730

View: 1445

RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 job responsibility: Be able to recover the database. Of all the things you are responsible for as database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: Lose that data and your company could fail. Lose that data and you could be out of a job. Oracle's flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c delivers. It’ll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It’ll be the book that lets you sleep at night knowing that no matter what transpires, that you've done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence. What you’ll learn Reliably back up and recover your database using Oracle's Recovery Manager Let Oracle Database manage your backup files via the Fast Recovery Area Automate backup and recovery tasks by writing scripts Troubleshoot RMAN problems and optimize RMAN performance Recover from the loss of a control file, loss of an online redo log, and from other unusual situations Who this book is for RMAN Recipes for Oracle Database 12c is aimed squarely at Oracle database administrators responsible for database backup and recovery operations. Table of Contents Backup and Recovery 101 Jump-Starting RMAN Using the Fast Recovery Area Using RMAN Configuring the RMAN Environment Using the Recovery Catalog Making Backups with RMAN Maintaining RMAN Backups and the Repository Scripting RMAN Restoring the Control File Performing Complete Recovery Performing Incomplete Recovery Performing Flashback Recovery Handling Online Redo Log Failures Duplicating Databases and Transporting Data Tuning RMAN Troubleshooting RMAN Implementing Oracle Secure Backup Performing Backup and Recovery with Enterprise Manager Using the Data Recovery Advisor Using RMAN on Windows DataGuard RMAN and RAC RMAN and ASM RMAN and Exadata

Oracle Database 12c Oracle RMAN Backup and Recovery

Author: Robert G. Freeman,Matthew Hart

Publisher: McGraw Hill Professional

ISBN: 0071847448

Category: Computers

Page: 768

View: 8504

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