Oracle Database 12c Security

Author: Scott Gaetjen,David Knox,William Maroulis

Publisher: McGraw Hill Professional

ISBN: 0071822968

Category: Computers

Page: 552

View: 2937

Best Practices for Comprehensive Oracle Database Security Written by renowned experts from Oracle's National Security Group, Oracle Database 12c Security provides proven techniques for designing, implementing, and certifying secure Oracle Database systems in a multitenant architecture. The strategies are also applicable to standalone databases. This Oracle Press guide addresses everything from infrastructure to audit lifecycle and describes how to apply security measures in a holistic manner. The latest security features of Oracle Database 12c are explored in detail with practical and easy-to-understand examples. Connect users to databases in a secure manner Manage identity, authentication, and access control Implement database application security Provide security policies across enterprise applications using Real Application Security Control data access with Oracle Virtual Private Database Control sensitive data using data redaction and transparent sensitive data protection Control data access with Oracle Label Security Use Oracle Database Vault and Transparent Data Encryption for compliance, cybersecurity, and insider threats Implement auditing technologies, including Unified Audit Trail Manage security policies and monitor a secure database environment with Oracle Enterprise Manager Cloud Control
Release

Securing Oracle Database 12c: A Technical Primer eBook

Author: Michelle Malcher,Scott Rotondo,Paul Needham

Publisher: McGraw Hill Professional

ISBN: 0071826173

Category: Computers

Page: N.A

View: 4310

This Oracle Press eBook is filled with cutting-edge security techniques for Oracle Database 12c. It covers authentication, access control, encryption, auditing, controlling SQL input, data masking, validating configuration compliance, and more. Each chapter covers a single threat area, and each security mechanism reinforces the others.
Release

Oracle Database 12c New Features

Author: Robert G. Freeman

Publisher: McGraw Hill Professional

ISBN: 0071799311

Category: Computers

Page: 450

View: 5976

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
Release

Oracle Database 12c PL/SQL Programming

Author: Michael McLaughlin

Publisher: McGraw Hill Professional

ISBN: 007181244X

Category: Computers

Page: 1192

View: 9624

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
Release

Oracle Enterprise Manager Cloud Control 12c Deep Dive

Author: Michael New,Edward Whalen,Matthew Burke

Publisher: McGraw Hill Professional

ISBN: 0071790578

Category: Computers

Page: 640

View: 6251

This Oracle Press guide shows how to implement a cloud-based management system and maintain on-demand access to critical services with Oracle Enterprise Manager Cloud Control 12c.
Release

Oracle Database 12c DBA Handbook

Author: Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 007179879X

Category: Computers

Page: 704

View: 1076

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
Release

Oracle Business Intelligence 11g Developers Guide

Author: Mark Rittman

Publisher: McGraw Hill Professional

ISBN: 0071798749

Category: Computers

Page: 1088

View: 3070

Master Oracle Business Intelligence 11g Reports and Dashboards Deliver meaningful business information to users anytime, anywhere, on any device, using Oracle Business Intelligence 11g. Written by Oracle ACE Director Mark Rittman, Oracle Business Intelligence 11g Developers Guide fully covers the latest BI report design and distribution techniques. Find out how to execute effective queries, build accurate models, use scorecards and KPIs, create dynamic reports, set up dashboards, and publish to smartphones and wireless devices. This Oracle Press guide contains comprehensive details on Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform. Install or upgrade to Oracle Business Intelligence 11g Develop and manage custom Oracle Business Intelligence repositories Access relational, file, and multidimensional data sources Design print-quality reports with Oracle Business Intelligence Publisher Create web-enabled analyses, dashboards, and visualizations Integrate with other applications using Oracle Business Intelligence 11g Action Framework Employ authentication, authorization, and row-level security Configure and deploy Oracle Exalytics In-Memory Machine
Release

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: 4811

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
Release

Building and Managing a Cloud Using Oracle Enterprise Manager 12c

Author: Madhup Gulati,Adeesh Fulay,Sudip Datta

Publisher: McGraw Hill Professional

ISBN: 007176321X

Category: Computers

Page: 352

View: 8131

Master Cloud Computing with Oracle Enterprise Manager 12c Gain organizational agility, foster innovation, and lower TCO by adopting a service-oriented, cloud-based IT solution. Building and Managing a Cloud Using Oracle Enterprise Manager 12c thoroughly explains how to architect, configure, and manage components of a public or private cloud lifecycle. Discover how to choose the right architecture, deploy applications, govern self-service provisioning, monitor users, and implement security. This Oracle Press guide features best practices and case studies from the authors’ experiences as Oracle product managers. Plan and deploy a flexible cloud infrastructure Configure Oracle Enterprise Manager 12c Self Service Portal Bundle applications using Oracle Virtual Assembly Builder Set up, manage, and monitor IaaS, PaaS, and DBaaS Meter usage and establish chargeback policies Work with large-scale clouds and enforce compliance Manage cloud service levels Diagnose and repair bottlenecks and faults
Release

Oracle Database 12c Release 2 Oracle Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting

Author: K. Gopalakrishnan,Sam R. Alapati

Publisher: McGraw Hill Professional

ISBN: 0071830472

Category: Computers

Page: 448

View: 7048

This comprehensive guide has been fully updated to cover the latest features and tools of Oracle Real Application Clusters 12c Through clear instruction and detailed examples, Oracle Database 12c Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting teaches how to build, configure, and maintain a dynamic enterprise computing infrastructure. This thoroughly revised edition covers best uses for the latest tools and features—all from the practical standpoint of a working DBA. You will discover how to prepare hardware, configure the software, optimize data integrity, and integrate seamless failover protection. Brand-new flex and large cluster technologies are explained in full detail, and readers will get complete solutions for securing data and continuing business operations in the event of hardware failure. Presents all the new information needed to effectively use Oracle Real Application Clusters 12c -considered the most radical overhaul ever Offers detailed coverage of troubleshooting, performance tuning, and application development
Release

Oracle SOA Suite 12c Handbook

Author: Lucas Jellema

Publisher: McGraw Hill Professional

ISBN: 007182460X

Category: Computers

Page: 928

View: 1739

Master Oracle SOA Suite 12c Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this practical resource. Get started with the Oracle SOA Suite 12c development and run time environment Deploy and manage SOA composite applications Expose SOAP/XML REST/JSON through Oracle Service Bus Establish interactions through adapters for Database, JMS, File/FTP, UMS, LDAP, and Coherence Embed custom logic using Java and the Spring component Perform fast data analysis in real time with Oracle Event Processor Implement Event Drive Architecture based on the Event Delivery Network (EDN) Use Oracle Business Rules to encapsulate logic and automate decisions Model complex processes using BPEL, BPMN, and human task components Establish KPIs and evaluate performance using Oracle Business Activity Monitoring Control traffic, audit system activity, and encrypt sensitive data
Release

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: 6980

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
Release

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: 5328

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
Release

Oracle Database 12c SQL

Author: Jason Price

Publisher: McGraw Hill Professional

ISBN: 0071799362

Category: Computers

Page: 688

View: 2628

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.
Release

Enterprise Architecture A to Z

Frameworks, Business Process Modeling, SOA, and Infrastructure Technology

Author: Daniel Minoli

Publisher: CRC Press

ISBN: 9781420013702

Category: Business & Economics

Page: 504

View: 3142

Driven by the need and desire to reduce costs, organizations are faced with a set of decisions that require analytical scrutiny. Enterprise Architecture A to Z: Frameworks, Business Process Modeling, SOA, and Infrastructure Technology examines cost-saving trends in architecture planning, administration, and management. To establish a framework for discussion, this book begins by evaluating the role of Enterprise Architecture Planning and Service-Oriented Architecture (SOA) modeling. It provides an extensive review of the most widely deployed architecture framework models. In particular, the book discusses The Open Group Architecture Framework (TOGAF) and the Zachman Architectural Framework (ZAF) in detail, as well as formal architecture standards and all four layers of these models: the business architecture, the information architecture, the solution architecture, and the technology architecture. The first part of the text focuses on the upper layers of the architecture framework, while the second part focuses on the technology architecture. In this second section, the author presents an assessment of storage technologies and networking and addresses regulatory and security issues. Additional coverage includes high-speed communication mechanisms such as Ethernet, WAN and Internet communication technologies, broadband communications, and chargeback models. Daniel Minoli has written a number of columns and books on the high-tech industry and has many years of technical hands-on and managerial experience at top financial companies and telecom/networking providers. He brings a wealth of knowledge and practical experience to these pages. By reviewing the strategies in this book, CIOs, CTOs, and senior managers are empowered by a set of progressive approaches to designing state-of-the-art IT data centers.
Release

Wireshark Certified Network Analyst Exam Prep Guide (Second Edition)

Author: Laura Chappell

Publisher: Laura Chappell University

ISBN: 9781893939905

Category: Computers

Page: 186

View: 2189

This book is intended to provide practice quiz questions based on the thirty-three areas of study defined for the Wireshark Certified Network AnalystT Exam. This Official Exam Prep Guide offers a companion to Wireshark Network Analysis: The Official Wireshark Certified Network Analyst Study Guide (Second Edition).
Release

Oracle Database Upgrade, Migration & Transformation Tips & Techniques

Author: Edward Whalen,Jim Czuprynski

Publisher: McGraw Hill Professional

ISBN: 0071846069

Category: Computers

Page: 512

View: 3902

A practical roadmap for database upgrade, migration, and transformation This Oracle Press guide provides best practices for migrating between different operating systems and platforms, transforming existing databases to use different storage or enterprise systems, and upgrading databases from one release to the next. Based on the expert authors’ real-world experience, Oracle Database Upgrade, Migration & Transformation Tips & Techniques will help you choose the best migration path for your project and develop an effective methodology. Code examples and detailed checklists are included in this comprehensive resource. Leverage the features of Oracle Data Guard to migrate an Oracle Database Use Oracle Recovery Manager, transportable tablespace sets, and transportable database toolsets to migrate between platforms Migrate databases with export/import Use Oracle GoldenGate for zero or near-zero downtime migrations Take advantage of the Cross-Platform Transportable Tablespace Set utility Migrate to new storage platforms using the features of Oracle Automatic Storage Management Upgrade to Oracle Database 12c with the Database Upgrade Assistant tool Move seamlessly to Oracle's engineered systems Migrate to the cloud
Release

Data Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 0471463892

Category: Computers

Page: 544

View: 3573

Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants.
Release

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques

Author: Richard Niemiec

Publisher: McGraw-Hill Education

ISBN: 9781259589683

Category: Computers

Page: 1136

View: 2576

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
Release

SQL Server 2017 Integration Services Cookbook

Author: Christian Cote,Matija Lah,Dejan Sarka

Publisher: Packt Publishing Ltd

ISBN: 1786460874

Category: Computers

Page: 558

View: 6995

Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease About This Book Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality This detailed, step-by-step guide covers everything you need to develop efficient data integration and data transformation solutions for your organization Who This Book Is For This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017. What You Will Learn Understand the key components of an ETL solution using SQL Server 2016-2017 Integration Services Design the architecture of a modern ETL solution Have a good knowledge of the new capabilities and features added to Integration Services Implement ETL solutions using Integration Services for both on-premises and Azure data Improve the performance and scalability of an ETL solution Enhance the ETL solution using a custom framework Be able to work on the ETL solution with many other developers and have common design paradigms or techniques Effectively use scripting to solve complex data issues In Detail SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain complete hands-on experience of SSIS 2017 as well as the 2016 new features, design and development improvements including SCD, Tuning, and Customizations. At the start, you'll learn to install and set up SSIS as well other SQL Server resources to make optimal use of this Business Intelligence tools. We'll begin by taking you through the new features in SSIS 2016/2017 and implementing the necessary features to get a modern scalable ETL solution that fits the modern data warehouse. Through the course of chapters, you will learn how to design and build SSIS data warehouses packages using SQL Server Data Tools. Additionally, you'll learn to develop SSIS packages designed to maintain a data warehouse using the Data Flow and other control flow tasks. You'll also be demonstrated many recipes on cleansing data and how to get the end result after applying different transformations. Some real-world scenarios that you might face are also covered and how to handle various issues that you might face when designing your packages. At the end of this book, you'll get to know all the key concepts to perform data integration and transformation. You'll have explored on-premises Big Data integration processes to create a classic data warehouse, and will know how to extend the toolbox with custom tasks and transforms. Style and approach This cookbook follows a problem-solution approach and tackles all kinds of data integration scenarios by using the capabilities of SQL Server 2016 Integration Services. This book is well supplemented with screenshots, tips, and tricks. Each recipe focuses on a particular task and is written in a very easy-to-follow manner.
Release