Oracle Database 12c Install, Configure & Maintain Like a Professional

Oracle Database 12c Install, Configure & Maintain Like a Professional
Author: Ian Abramson
Publisher: McGraw Hill Professional
Total Pages: 474
Release: 2013-10-14
Genre: Computers
ISBN: 0071799346

Master the Fundamentals of Oracle Database 12c Filled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install, Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features: Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Ask the Expert--Q&A sections filled with helpful tips Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

Oracle Database 10g: A Beginner's Guide

Oracle Database 10g: A Beginner's Guide
Author: Ian Abramson
Publisher: McGraw-Hill Companies
Total Pages: 430
Release: 2004
Genre: Computers
ISBN:

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

Oracle Database 12c The Complete Reference

Oracle Database 12c The Complete Reference
Author: Bob Bryla
Publisher: McGraw Hill Professional
Total Pages: 1473
Release: 2013-08-05
Genre: Computers
ISBN: 007180174X

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 12c Release 2 Performance Tuning Tips & Techniques

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques
Author: Richard Niemiec
Publisher: McGraw Hill Professional
Total Pages: 1138
Release: 2017-03-22
Genre: Computers
ISBN: 1259589692

Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. • Properly index and partition Oracle Database 12c Release 2 • Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager • Efficiently manage disk drives, ASM, RAID arrays, and memory • Tune queries with Oracle SQL hints and the Trace utility • Troubleshoot databases using V$ views and X$ tables • Create your first cloud database service and prepare for hybrid cloud • Generate reports using Oracle’s Statspack and Automatic Workload Repository tools • Use sar, vmstat, and iostat to monitor operating system statistics

OCA: Oracle Database 12c Administrator Certified Associate Study Guide

OCA: Oracle Database 12c Administrator Certified Associate Study Guide
Author: Biju Thomas
Publisher: John Wiley & Sons
Total Pages: 1238
Release: 2014-05-12
Genre: Computers
ISBN: 111864395X

An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.

Oracle Database 12c Release 2 New Features

Oracle Database 12c Release 2 New Features
Author: Bob Bryla
Publisher: McGraw Hill Professional
Total Pages: 305
Release: 2017-04-24
Genre: Computers
ISBN: 1259837203

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

Oracle DBA Mentor

Oracle DBA Mentor
Author: Brian Peasland
Publisher: Apress
Total Pages: 454
Release: 2019-03-29
Genre: Computers
ISBN: 1484243218

New Oracle database administrators can get off the ground running. This book helps you develop the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues. Along the way, you will see how to create your first database and implement best practices to ensure a well-running database system. What makes Oracle DBA Mentor different is that it also teaches you how to obtain answers that are not found in this or other books. Focus is given to creating a test bed and running test cases to examine hypotheses and prove out solutions so you can be sure they work in production. Attention is given to navigating product documentation and networking in forums and social media to build your skills and a network to draw on when solving problems under pressure. There are chapters of step-by-step technical content as well as coverage of essential skills to succeed as a DBA no matter which database engine you administer. By the time you are done reading this book, you will have confidence to face many of the situations thrown in your direction. You will know where to go for the answers you don’t yet know that you need. You’ll be able to work and troubleshoot under pressure. You’ll know how to create a database, institute backup and recovery procedures, secure the database and its valuable corporate data, and acquire more knowledge as needed so you can run a database to meet the needs of your organization. What You'll LearnInstall Oracle Database with best practices Implement backup and recovery procedures Understand the fundamentals of databases and data security Find answers to technical problems using Oracle documentation, Oracle Support, and other resources Patch and upgrade an Oracle database Who This Book Is For The novice database administrator who wants help getting off the ground with their DBA career, and in building the skills to let that career flourish in the long term. Mid-level DBAs will also find the book helpful as they try to grow their career to the next level. While the book is geared toward the Oracle platform, database administrators from other platforms can benefit from the soft skills covered in this book.

Oracle Database 12c DBA Handbook

Oracle Database 12c DBA Handbook
Author: Bob Bryla
Publisher: McGraw Hill Professional
Total Pages: 745
Release: 2015-07-03
Genre: Computers
ISBN: 007179879X

The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online

Oracle WebLogic Server 12c Administration I Exam 1Z0-133

Oracle WebLogic Server 12c Administration I Exam 1Z0-133
Author: Gustavo Garnica
Publisher: Apress
Total Pages: 300
Release: 2017-12-15
Genre: Computers
ISBN: 1484225627

Use this comprehensive guide to study for the Oracle WebLogic Server 12c Administration I Exam 1Z0-133. This book is a unique introductory resource to the WebLogic Server certification for new Oracle Fusion Middleware administrators and a valuable resource for veteran WebLogic Server administrators seeking to update their skills for the 12c certification topics. It is common sense that passing a certification exam requires a good command of the subject matter, understanding the intricacies surrounding its practice, and having sufficient experience working with the concepts. This book aims to accelerate the process by providing an accurate review of all exam topics, suggesting hands-on practices to gain or reinforce experience working with WebLogic Server, and introducing questions to help candidates become familiar with the format and style of questions found on the actual certification exam. Oracle WebLogic Server 12c Administration I Exam 1Z0-133 covers the associate level certification with Oracle. Although not dedicated to exam 1Z0-599, the guide is also a valuable foundational resource for those preparing for WebLogic Server 12c implementation specialist level certification. This book: Inspects the certification topics in the order that you would likely follow in an on-the-job middleware infrastructure project Is a great resource for candidates preparing for the certification, who are unable to start with live or personally-assisted training Is a great starting point for those pursuing advanced Oracle WebLogic Server certifications What You’ll Learn Cover all topics on the certification exam 1Z0-133 Become familiar with the types and format of questions on the certification exam Understand and properly describe Oracle WebLogic Server domains and clusters Install, configure, maintain, and monitor Oracle WebLogic Server Deploy and manage applications on Oracle WebLogic Server Discover how to use new administration features of Oracle WebLogic Server 12c Who This Book Is For Certified Oracle WebLogic administrators seeking to update their Oracle WebLogic Server credentials, as well as experienced WebLogic Server administrators seeking to earn certification for the first time. Non-Oracle administrators seeking to earn a WebLogic Server certification will also find this book useful.