Oracle Database 12c New Features

Author: Robert G. Freeman

Publisher: McGraw Hill Professional

ISBN: 0071799311

Category: Computers

Page: 450

View: 1649

DOWNLOAD NOW »
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

Oracle Database 12c PL/SQL Programming

Author: Michael McLaughlin

Publisher: McGraw Hill Professional

ISBN: 007181244X

Category: Computers

Page: 1192

View: 3370

DOWNLOAD NOW »
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 12c: SQL

Author: Joan Casteel

Publisher: Cengage Learning

ISBN: 130546530X

Category: Computers

Page: 608

View: 8036

DOWNLOAD NOW »
Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Learners gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help readers transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Oracle Database 12c DBA Handbook

Author: Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 007179879X

Category: Computers

Page: 704

View: 7605

DOWNLOAD NOW »
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 Business Intelligence 11g Developers Guide

Author: Mark Rittman

Publisher: McGraw Hill Professional

ISBN: 0071798749

Category: Computers

Page: 1088

View: 5406

DOWNLOAD NOW »
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

Oracle Enterprise Manager Cloud Control 12c Deep Dive

Author: Michael New,Edward Whalen,Matthew Burke

Publisher: McGraw Hill Professional

ISBN: 0071790586

Category: Computers

Page: 640

View: 2751

DOWNLOAD NOW »
Master Oracle Enterprise Manager Cloud Control 12c Achieve peak database efficiency and derive unprecedented value from your corporate assets by implementing an end-to-end cloud computing solution. Oracle Enterprise Manager Cloud Control 12c Deep Dive thoroughly explains best practices for deployment, administration, and monitoring. Learn how to prepare and install Oracle Enterprise Manager Cloud Control 12c, use agents, apply system-wide patches, perform real-time diagnostics, and discover, monitor, and administer hosts, databases, and middleware. Security and select plug-ins are also fully covered in this Oracle Press guide. Install and configure Oracle Enterprise Manager Cloud Control 12c Deploy management agents in one of six available ways Handle security with Cloud Control administrators, roles, and credentials Track performance with SQL monitoring and Active Session History (ASH) analytics Dynamically provision middleware and enterprise applications Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Force policy compliance and employ global change detection Manage and monitor hosts, virtual machines, and server pools

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

DOWNLOAD NOW »
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

Oracle Database 12c Release 2 New Features

Author: Bob Bryla,Robert G. Freeman

Publisher: McGraw Hill Professional

ISBN: 1259837203

Category: Computers

Page: 480

View: 4511

DOWNLOAD NOW »
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 Database 12c Oracle RMAN Backup and Recovery

Author: Robert G. Freeman,Matthew Hart

Publisher: McGraw Hill Professional

ISBN: 0071847448

Category: Computers

Page: 768

View: 4819

DOWNLOAD NOW »
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

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

Author: Steve O'Hearn

Publisher: McGraw Hill Professional

ISBN: 1259584615

Category: Computers

Page: 832

View: 3002

DOWNLOAD NOW »
A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test. Get complete coverage every topic on Exam 1Z0-071, including: • DDL and SQL SELECT statements • Manipulating, restricting, and sorting data • Single-row and group functions • Displaying data from multiple tables • Subqueries • Schema objects • Set operators • Grouping related data • Report creation • Data dictionary views • Large data sets • Hierarchical retrieval • Regular expression support • User access control The electronic includes: • Two full practice exams • Detailed answers and explanations

Oracle Warehouse Builder 11g

Getting Started

Author: Bob Griesemer

Publisher: Packt Publishing Ltd

ISBN: 184719575X

Category: Computers

Page: 353

View: 5955

DOWNLOAD NOW »
Extract, Transform, and Load data to build a dynamic, operational data warehouse.

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques

Author: Richard Niemiec

Publisher: McGraw-Hill Education

ISBN: 9781259589683

Category: Computers

Page: 1136

View: 4512

DOWNLOAD NOW »
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

Learning Spring 5.0

Author: Tejaswini Mandar Jog

Publisher: Packt Publishing Ltd

ISBN: 1787126242

Category: Computers

Page: 422

View: 5256

DOWNLOAD NOW »
Build, test, and secure robust enterprise-grade applications using the Spring Framework About This Book Build an enterprise application throughout the book that communicates with a microservice Define and inject dependencies into your objects using the IoC container Make use of Spring's reactive features including tools and implement a reactive Spring MVC application Who This Book Is For This book is for Java developers who want to make use of the Spring framework to simplify their programming needs. What You Will Learn Get to know the basics of Spring development and gain fundamental knowledge about why and where to use Spring Framework Explore the power of Beans using Dependency Injection, wiring, and Spring Expression Language Implement and integrate a persistent layer in your application and also integrate an ORM such as Hibernate Understand how to manage cross-cutting with logging mechanism, transaction management, and more using Aspect-oriented programming Explore Spring MVC and know how to handle requesting data and presenting the response back to the user Get to grips with the integration of RESTful APIs and Messaging with WebSocket and STOMP Master Reactive Programming using Spring MVC to handle non-blocking streams In Detail Spring is the most widely used framework for Java programming and with its latest update to 5.0, the framework is undergoing massive changes. Built to work with both Java 8 and Java 9, Spring 5.0 promises to simplify the way developers write code, while still being able to create robust, enterprise applications. If you want to learn how to get around the Spring framework and use it to build your own amazing applications, then this book is for you. Beginning with an introduction to Spring and setting up the environment, the book will teach you in detail about the Bean life cycle and help you discover the power of wiring for dependency injection. Gradually, you will learn the core elements of Aspect-Oriented Programming and how to work with Spring MVC and then understand how to link to the database and persist data configuring ORM, using Hibernate. You will then learn how to secure and test your applications using the Spring-test and Spring-Security modules. At the end, you will enhance your development skills by getting to grips with the integration of RESTful APIs, building microservices, and doing reactive programming using Spring, as well as messaging with WebSocket and STOMP. Style and approach Filled with examples, this tutorial-based book will help you gain all the knowledge you need to start producing enterprise-grade applications with Spring.

SQL Server 2017 Developer’s Guide

A professional guide to designing and developing enterprise database applications

Author: William Durkin,Miloš Radivojević,Dejan Sarka

Publisher: Packt Publishing Ltd

ISBN: 1788479939

Category: Computers

Page: 816

View: 7658

DOWNLOAD NOW »
Build smarter and efficient database application systems for your organization with SQL Server 2017 Key Features Build database applications by using the development features of SQL Server 2017 Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queries Book Description Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. What you will learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017 Who this book is for Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book.

Oracle SOA Suite 11g Handbook

Author: Lucas Jellema

Publisher: McGraw Hill Professional

ISBN: 0071608982

Category: Computers

Page: 656

View: 2085

DOWNLOAD NOW »
Master Oracle SOA Suite 11g Design and implement an agile service-oriented enterprise computing infrastructure using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 11g Handbook uses a hands-on case study to illustrate each programming, management, and governance concept. Get expert techniques for modeling and implementing complex business processes and deploying and securing Web services, while maximizing decoupling and code reuse. Install Oracle SOA Suite 11g or migrate from a previous version Design and develop composite applications using SCA and SDO Model processes using BPEL, BPMN, and human task components Connect components through mapping and filtering with Oracle Mediator Apply the principles of event-driven architecture through complex event processing, the event delivery network, and Oracle Business Activity Monitoring server Benefit from the power of Java through the Spring component and the interaction with Oracle Validate, enrich, transform, route, and operate on data using the Oracle Service Bus Deploy, test, and manage composite applications from the Oracle Enterprise Manager control console

Oracle Database 12c SQL

Author: Jason Price

Publisher: McGraw Hill Professional

ISBN: 0071799362

Category: Computers

Page: 688

View: 8286

DOWNLOAD NOW »
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.

Oracle Database 12c PL/SQL Advanced Programming Techniques

Author: Michael McLaughlin,John Harper

Publisher: McGraw Hill Professional

ISBN: 0071835156

Category: Computers

Page: 448

View: 6793

DOWNLOAD NOW »
Take Your PL/SQL Programming Skills to the Next Level Build robust database-centric PL/SQL applications quickly and effectively. Oracle Database 12c PL/SQL Advanced Programming Techniques shows you how to write and deploy Java libraries inside Oracle Database 12c, use the utl_file and DBMS_SCHEDULER packages, and create external tables and external procedures. Application security, performance tuning, and Oracle Database In-Memory are also covered in this Oracle Press guide. Configure, deploy, and troubleshoot Java libraries for Oracle object types Use the utl_file package to manage unstructured and structured data Develop and deploy Java I/O libraries and wrap them with PL/SQL Create and use external tables Implement high-speed data transfer Harden database systems and develop secure applications Manage complex schedules and jobs with the DBMS_SCHEDULER package Optimize PL/SQL for use in performance tuning Create and deploy external procedures Implement the Oracle Database In-Memory column store feature

Hands-On Data Warehousing with Azure Data Factory

ETL techniques to load and transform data from various sources, both on-premises and on cloud

Author: Michelle Kamrat Gutzait,Giuseppe Ciaburro,Christian Coté

Publisher: Packt Publishing Ltd

ISBN: 1789130093

Category: Computers

Page: 284

View: 3708

DOWNLOAD NOW »
Leverage the power of Microsoft Azure Data Factory v2 to build hybrid data solutions Key Features Combine the power of Azure Data Factory v2 and SQL Server Integration Services Design and enhance performance and scalability of a modern ETL hybrid solution Interact with the loaded data in data warehouse and data lake using Power BI Book Description ETL is one of the essential techniques in data processing. Given data is everywhere, ETL will always be the vital process to handle data from different sources. Hands-On Data Warehousing with Azure Data Factory starts with the basic concepts of data warehousing and ETL process. You will learn how Azure Data Factory and SSIS can be used to understand the key components of an ETL solution. You will go through different services offered by Azure that can be used by ADF and SSIS, such as Azure Data Lake Analytics, Machine Learning and Databrick’s Spark with the help of practical examples. You will explore how to design and implement ETL hybrid solutions using different integration services with a step-by-step approach. Once you get to grips with all this, you will use Power BI to interact with data coming from different sources in order to reveal valuable insights. By the end of this book, you will not only learn how to build your own ETL solutions but also address the key challenges that are faced while building them. What you will learn Understand the key components of an ETL solution using Azure Data Factory and Integration Services Design the architecture of a modern ETL hybrid solution Implement ETL solutions for both on-premises and Azure data Improve the performance and scalability of your ETL solution Gain thorough knowledge of new capabilities and features added to Azure Data Factory and Integration Services Who this book is for This book is for you if you are a software professional who develops and implements ETL solutions using Microsoft SQL Server or Azure cloud. It will be an added advantage if you are a software engineer, DW/ETL architect, or ETL developer, and know how to create a new ETL implementation or enhance an existing one with ADF or SSIS.

Oracle Database 11g New Features

Author: Robert G. Freeman

Publisher: McGraw Hill Professional

ISBN: 0071595783

Category: Computers

Page: 362

View: 5362

DOWNLOAD NOW »
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11g Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components Improved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compression New Database Advisors for data recovery and repair, partitioning, and streams performance New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization Improved auditing and security capabilities Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements