This book is packed with real world examples that cover all the advanced features of PL/SQL. In turn, each major certification topic is covered in a separate chapter that makes understanding concepts easier. At the end of each chapter, you will find plenty of practice questions to strengthen and test your learning.If you are a PL/SQL developer looking for deeper insight and a move from mid-level programmer to professional database developer, then this is the best guide for you. This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.

Developed as a practical book, "Oracle Database 11g Administration I Certification Guide" will show you all you need to know to effectively excel at being an Oracle DBA, for both examinations and the real world. This book is for anyone who needs the essential skills to become an Oracle DBA, pass the Oracle Database Administration I exam, and use those skills in the real world to manage secure, high performance, and highly available Oracle databases.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Implement the Full Spectrum of Oracle E-Business Suite Financial Applications Maintain an integrated, customer-focused financial computing framework that meets global business requirements while lowering total cost of ownership. Oracle E-Business Suite Financials Handbook, Third Edition offers fully updated coverage of the latest applications and modules. Find out how to enforce robust accounting rules, establish workflow, manage invoices and inventory, create budgets and forecasts, and secure your corporate assets. This Oracle Press guide thoroughly explains how to deploy custom Web applications, automate tax reporting, and incorporate Oracle Fusion Applications. Centralize financial data with Oracle General Ledger and Oracle Subledger Accounting Track invoices and payments through Oracle Receivables and Oracle Payables Forecast cash requirements and manage portfolios with Oracle Treasury Increase liquidity and profitability using Oracle Cash Management Establish asset depreciation schedules and handle leases and warranty information with Oracle Assets Use Oracle Purchasing and Oracle Inventory to optimize supply chain efficiency Handle procurement and billing information using Oracle Projects and Oracle Order Management Employ the all-new Oracle E-Business Tax and Oracle Landed Cost Management Leverage Oracle Fusion Applications in a co-existence strategy with Oracle E-Business Suite Financials Implement an end-to-end disaster recovery strategy

Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g. This book is meant for people who already possess a basic understanding of Oracle Data Integrator and want to take it to the next level by learning how to better leverage advanced ODI features and functionality as they continue to develop and manage their data integration projects.

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This hands-on guide provides a quick and easy way to back up and restore your database using PostgreSQL. Written for database administrators who want to create backups of their critical enterprise data and efficiently restore it using PostgreSQL.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Cloud Computing with Oracle Enterprise Manager 12cGain 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

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle's PeopleSoft PeopleTools Data Administration and Upgrade Toolset Maximize data integrity, maintain peak application performance, and keep your PeopleSoft environment up to date. PeopleSoft PeopleTools Data Management and Upgrade Handbook explains the latest techniques and provides best practices, case studies, and programming examples. Find out how to develop and deploy data mover scripts, audit database health, apply patches, and generate project comparison reports. This Oracle Press guide offers thorough coverage of Oracle's PeopleSoft life cycle management tools. Understand PeopleSoft PeopleTools architecture Manage metadata using PeopleSoft Application Designer Create and execute PeopleSoft Data Mover scripts Learn how to use PeopleSoft Data Archive ManagerRead best practices for applying updates, patches, and fixes Implement PeopleSoft change control features Build automated functional tests Plan and execute application and platform upgrades

There are many ways of configuring and using Oracle EBS R12 Financials. This cookbook demonstrates how to use EBS R12 Financials in a way that will enable you to understand the core functionalities of the main financials modules. Each recipe is presented as part of a scenario-based chapter that details typical business scenarios. This book is for EBS Financials specialists who want a broader understanding of particular areas of the financials modules. Businesses can use this book to identify key functionalities of the financial modules, and very quickly demonstrate a pilot to obtain the core requirements. If you are a Business Analyst, Functional Consultant, Technical Consultant, Project Sponsor, Project Manager, Project Team Member, System Accountant or Solution Designer, Testing Team Member, Training Team Member or Support Team Member, then this book is for you. This book assumes that you have basic navigation skills and you understand the key Oracle EBS terminology, novice EBS professionals will also gain from the expert content of this book.

The duties and responsibilitie:s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. This means that if a database, for whatever reason, gets corrupted, dropped, or otherwise becomes unusable, then it is the DBA's responsibility to restore that database to the state it was in before the problem occurred, or as close as is possible. Of course, this doesn't mean that a DBA is required to restore a database each and every day, just that if disaster does strike the DBA must be prepared to deal with it, regardless of when or why it occurs. If a DBA isn't prepared, and significant data is lost, or databases become unavailable to end users for long periods of time, then that DBA probably won't be in their job for too long. This is why a good, and tested, SQL Server backup and restore plan must be on the top of every administrative DBA's list of tasks. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building your own automated solution will take a lot of work, but we do offer some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Business Intelligence Discoverer 11gProvide secure, immediate access to critical business information from relational and multidimensional data sources across your organization. Oracle Business Intelligence Discoverer 11g Handbook shows you howto optimize this intuitive ad hoc query, reporting, analysis, and web publishing tool for maximum performance. Real-world examples illustrate the powerful analysis, security, and reporting capabilities. Enable businessusers at all levels to make faster, more-informed decisions with help from this Oracle Press guide. Configure and manage Oracle Business Intelligence Discoverer 11g Run functional queries using the Workbook Wizard Add sorts, calculations, percentages, totals, and parameters using Oracle Business Intelligence Discoverer Plus Format queries into well-organized reports with graphs, tables, titles, headers, and footers Perform data analysis--statistical, classification, deviation, trend, and aging Use Oracle Business Intelligence Discoverer Viewer 11g to analyze, format, export, e-mail, and print reports Manage integration with Oracle WebLogic Server Refine existing queries using interactive pivoting, drilling, and hyper-drilling Build effective conditions and refine parameters, calculations, sorting, and percentages Manage access and sharing rights, scheduling privileges, and user preferences Build an end user layer and a business area using Oracle Business Intelligence Discoverer Administrator Use Oracle Enterprise Manager's Fusion Middleware Control feature to manage Oracle Business IntelligenceDiscoverer settings and preferences Implement powerful analytic functions using templates

SQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away,This book is written for the SQL Server database professional (DBA, developer, BI developer) who wants to use PowerShell to automate, integrate, and simplify database tasks. A little bit of scripting background is helpful, but not necessary.

This book is written in simple, easy to understand format with lots of screenshots and step-by-step explanations. If you are an ADF developer looking forward to building healthy and better performing applications using Oracle ADF, then this is the best guide for you. You need to be proficient with Java and ADF before getting started with this book.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Save Time and Money with DB2 10 for LUW Even travel through time and shrink dataHow would you like to compress even more data, store it in a cloud, and analyze it as though you are traveling through time without compromising security? In addition to these enhancements, you will experience lower costs and faster performance with the latest release of DB2. Read this book to understand the power of DB2 10 and get started now! This book provides you with the comprehensive knowledge you need to get started with the latest DB2 release. Try some of the new features by downloading DB2 Express for free, which features Big Data and Cloud technology. Go to ibm.com/db2/express.

This cookbook has recipes written in a simple, easy to understand format, with lots of screenshots and insightful tips and hints. If you are a DB2 Database Administrator who wants to understand and get hands on with the underlying aspects of database administration, then this book is for you. This book assumes that you have a basic understanding of DB2 database concepts.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. The Essential Guide to Protecting Your Business Information Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Backup and Recovery covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations. Learn how different backup strategies affect locking and system availability Identify the importance of static backup options and point-in-time requirements Recognize the important business factors to determine your optimal data protection requirements Understand the benefits of using MySQL replication for leveraging different backup strategies Understand the benefits and risks of implementing solutions with MySQL in the cloud Identify key configuration variables that affect data durability and performance Find out about the types of possible disasters and develop a robust plan to address them Optimize your backup approach with compression, streaming, incremental, and parallel options

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Business Intelligence 11g Reports and DashboardsDeliver 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 tosmartphones 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 Intelligencerepositories 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 BusinessIntelligence 11g Action Framework Employ authentication, authorization, and row-level security Configure and deploy Oracle Exalytics In-Memory Machine

This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their MySQL database through Python. If you are a Python programmer who wants database-support in your Python applications, then this book is for you. This book is a must-read for every focused user of the MySQL for Python library who wants real-world applications using this powerful combination of Python and MySQL.

In clearly written chapters you will be guided through different aspects of Oracle Application Express. Varying from setting up your environment to maximizing SQL and PL/SQL. Examples are given based on a simple but appealing case. This book is filled with best practices on how to make the most of Oracle APEX. Developers beginning with application development as well as those who are experienced will benefit from this book. You will need to have basic knowledge of SQL and PL/SQL to follow the examples in this book.

"Oracle JDeveloper 11gR2 Cookbook" is a practical cookbook which goes beyond the basics with immediately applicable recipes for building ADF applications at an intermediate-to-advanced level. If you are a JavaEE developer who wants to go beyond the basics of building ADF applications with Oracle JDeveloper 11gR2 and get hands on with practical recipes, this book is for you. You should be comfortable with general Java development principles, the JDeveloper IDE, and ADF basics

This book is a comprehensive guide that shows developers how to design and develop business processes in BPEL efficiently. Throughout the book, the authors discuss important concepts and show real-world examples covering Oracle SOA Suite 11g and related products. This book is aimed at SOA architects and developers involved in the design, implementation, and integration of composite applications and end-to-end business processes. The book provides comprehensive coverage of WS-BPEL 2.0 for implementing business processes and developing SCA composite application, dealing with the issues of composition, orchestration, transactions, coordination, and security. This book uses Oracle SOA Suite 11g and related Oracle products. To follow this book you need to have basic knowledge of XML, web services, and Java EE.

This book has individual recipes and you can read it from cover to cover or dip into any recipe and get solution to a specific issue. Every recipe is based on a script/procedure explained with step-by-step instructions and screenshots. Concepts are illustrated for better understanding of why one solution performs better than another. SQL Server 2012 Performance Tuning Cookbook is aimed at SQL Server Database Developers, DBAs, and Database Architects who are working in any capacity to achieve optimal performance. However, basic knowledge of SQL Server is expected, but professionals who want to get hands-on with performance tuning and have not worked on tuning the SQL Server for performance will find this book helpful.

This cookbook is full of immediately useable recipes showing you how to develop service and message-oriented (integration) applications on the Oracle Service Bus. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, the explanations go into great detail, which makes it good learning material for everyone who has experience in OSB and wants to improve. Most of the recipes are designed in such a way that each recipe is presented as a separate, standalone entity and reading of prior recipes is not required. The finished solution of each recipe is also made available electronically. If you are an intermediate SOA developer who is using Oracle Service Bus to develop service and message-orientated applications on the Oracle Service Bus, then this book is for you. This book assumes that you have a working knowledge of fundamental SOA concepts and Oracle Service Bus.

This book is written in a simple, easy to understand format with screenshots, code samples, and step-by-step explanations that will guide you through the advanced techniques used by the experts. If you are an Oracle Hyperion Interactive reporting user or developer looking to become an expert in the product, then this book is for you. You will require a basic knowledge of Interactive Reporting, as this book starts with a brief overview and then dives into advanced techniques, functions, and best practices. Beginner users should consult The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 to gain insight on the software product.

This is a practical, concise step-by-step tutorial with screenshots for carrying out tasks showing you how to manage and administer a XenServer in your business. The author brings his own extensive knowledge of XenServer. The book is full of best practices and tips that will help you benefit from the author's experience in working with XenServer. If you are an administrator working on XenServer, this book is for you. The book assumes that you have a basic understanding of XenServer administration, but need not have working experience with XenServer. You must be well aware of virtualization concepts as the book does not cover that. IT consultants, service providers and architects, who want to approach XenServer as a virtualization platform will also find this book useful.