Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12cAbout This BookLearn advanced application development features of Oracle Database 12c and prepare for the 1Z0-146 examinationBuild robust and secure applications in Oracle PL/SQL using the best practicesPacked with feature demonstrations and illustrations that will help you learn and understand the enhanced capabilities of Oracle Database 12cWho This Book Is ForThis book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL.What You Will LearnLearn and understand the key SQL and PL/SQL features of Oracle Database 12cUnderstand the new Multitenant architecture and Database In-Memory option of Oracle Database 12cKnow more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profilingImplement Virtual Private Databases to prevent unauthorized data accessTrace, analyze, profile, and debug PL/SQL code while developing database applicationsIntegrate the new application development features of Oracle Database 12c with the current conceptsDiscover techniques to analyze and maintain PL/SQL codeGet acquainted with the best practices of writing PL/SQL code and develop secure applicationsIn DetailOracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience.Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database.Style and approach The book follows the structure of the Oracle Certification examination but doesn't restrict itself to the exam objectives. Advanced concepts have been explained in an easy-to-understand style, supported with feature demonstrations and case illustrations.

Design and code your own 2D and 3D games efficiently using OpenGL and C++ About This Book Create 2D and 3D games completely, through a series of end-to-end game projects Learn to render high performance 2D and 3D graphics using OpenGL Implement a rudimentary game engine using step-by-step code Who This Book Is For If you are a prospective game developer with some experience using C++, then this book is for you. Both prospective and experienced game programmers will find nuggets of wisdom and practical advice as they learn to code two full games using OpenGL, C++, and a host of related tools. What You Will Learn Set up your development environment in Visual Studio using OpenGL Use 2D and 3D coordinate systems Implement an input system to handle the mouse and the keyboard Create a state machine to handle complex changes in the game Load, display, and manipulate both 2D and 3D graphics Implement collision detection and basic physics Discover the key components needed to complete a polished game Handle audio files and implement sound effects and music In Detail OpenGL is one of the most popular rendering SDKs used to develop games. OpenGL has been used to create everything from 3D masterpieces running on desktop computers to 2D puzzles running on mobile devices. You will learn to apply both 2D and 3D technologies to bring your game idea to life. There is a lot more to making a game than just drawing pictures and that is where this book is unique! It provides a complete tutorial on designing and coding games from the setup of the development environment to final credits screen, through the creation of a 2D and 3D game. The book starts off by showing you how to set up a development environment using Visual Studio, and create a code framework for your game. It then walks you through creation of two games–a 2D platform game called Roboracer 2D and a 3D first-person space shooter game–using OpenGL to render both 2D and 3D graphics using a 2D coordinate system. You'll create sprite classes, render sprites and animation, and navigate and control the characters. You will also learn how to implement input, use audio, and code basic collision and physics systems. From setting up the development environment to creating the final credits screen, the book will take you through the complete journey of creating a game engine that you can extend to create your own games. Style and approach An easy-to-follow guide full of code examples to illustrate every concept and help you build a 2D and 3D game from scratch, while learning the key tools that surround a typical OpenGL project.

Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book ?Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently ?Monitor, tune, secure and protect your database ?A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease Who This Book Is For This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience. What You Will Learn ?Implement PostgreSQL features for performance and reliability ?Harness the power of the latest PostgreSQL 9.6 features ?Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms ?Discover advanced technical tips for experienced users ?Explore best practices for planning and designing live databases ?Select and implement robust backup and recovery techniques ?Explore concise and clear guidance on replication and high availability ?See the latest details on Logical Replication and Bi-Directional Replication In Detail PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and

Written in a clear, easy-to-read style, the book provides step-by-step instructions on using TypoScript for TYPO3 website development, template and extension development, and back-end and front-end administration. Each topic is tackled in a clear and practical way with many examples to develop your skills. This book is suitable for TYPO3 developers, administrators, and designers who want to develop fully featured TYPO3 websites using the power of TypoScript. A basic knowledge of TYPO3 is expected, and PHP and MySQL programming experience is useful, though not essential for using this book.

Los ejercicios de este libro tienen un enfoque de tutorial paso a paso y en los que al mismo tiempo se van presentando mejores prácticas de desarrollo. El libro está estructurado de forma que puede ser leído de inicio a fin o leer solamente partes del mismo.Este libro va dirigido a desarrolladores y usuarios que quieren aprender a crear aplicaciones de Inteligencia de Negocios con QlikView. Desarrolladores que ya hayan usado QlikView por un tiempo podrán encontrar recomendaciones útiles y mejores prácticas para hacer uso más efectivo de QlikView. Este libro solamente cubre QlikView Desktop. Implementaciones en QlikView Server y Publisher est?an fuera del alcance de este libro. Este libro no va enfocado a administradores de servidores QlikView.

This book is written in a friendly and practical style with numerous tutorials centred on common as well as atypical Hyper-V cluster designs. This book also features a sample cluster design throughout to help you learn how to design a Hyper-V in a real-world scenario.Microsoft Hyper-V Cluster Design is perfect for the systems administrator who has a good understanding of Windows Server in an Active Directory domain and is ready to expand into a highly available virtualized environment. It only expects that you will be familiar with basic hypervisor terminology.

A comprehensive tutorial packed with examples, which is divided into small subtopics that follows a clear and logical outline to help you get to grips with Adobe Captivate 7. Readers are also encouraged to develop their understanding of the tool through practical exercises and experimentations in every chapter. A lot of external references and tips and tricks from established eLearning professionals are also included. If you are a designer, eLearning developer, or webmaster who wants to construct an interactive and funfilled eLearning project using Adobe Captivate 7, this book is ideal for you. Just a basic knowledge of operating system is expected from the developers interested in this book.

This Certification guide will follow a step-by-step approach to instruct the reader what they need to know to be able to become certified with Microsoft Dynamics CRM 2011. If you will implement Microsoft Dynamics CRM 2011, this book is for you. You should have a working knowledge of Microsoft Windows, Microsoft Internet Explorer, and Microsoft Office.

It will be a step-by-step tutorial that will discuss best practices. The book is structured in such a way that it can be read both from start to end or can be dipped into. If you are a developer who is looking to learn a fast and easy way to learn to develop your business intelligence apps with QlikView, then this book is for you. If you are a power-user in a QlikView environment, then you will find quicker ways of working with QlikView. You should know the basics of business intelligence before you pick up this book. This book covers QlikView Desktop Personal Edition. Deployments to QlikView Server/Publisher are out of scope for this book.

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is for you. You should have some experience with databases, SQL and ETL technologies.

This is a practical, hands-on book providing in depth tutorials on each topic. It is full of step by step examples of the key points for each subject to give a core understanding. The examples are designed to be worked through, and start right from scratch. Each topic will cover the development, configuration and testing of working examples. The book provides clear illustrations and tips each step of the way. It also comes with fully tested, complete, working code - if ever you get stuck. Each chapter introduces the topic and what you need to do to get ready to start the exercises. It will tell you what tools you need to use and when to use them. This book is written for individuals who want to learn how to develop extensions in Oracle E-Business suite. If you are involved in development or supporting an e-business suite implementation you should find this book very useful. The book is detailed so minimal technical expertise is required. It is suitable for beginners who have little experience or developers who may want to use the book to brush up on their skills.

This book is a step-by-step tutorial that shows you how to obtain the necessary toolset to create and run Silverlight Enterprise Applications on Azure. The book also covers techniques, practical tips, hints, and tricks for Silverlight interactions with Azure. Each topic is written in an easy-to-read style, with a detailed explanation given and then practical step-by-step exercises with a strong emphasis on real-world relevance. If you are an application developer who wants to build and run Silverlight Enterprise applications using Azure storage, WCF Services, and ASP providers, then this book is for you. You should have a working knowledge of Silverlight and Expression Blend. However, knowledge of Azure is not required since the book covers how to integrate the two technologies in detail.

This highly practical, expert level tutorial teaches you to build a Line of Business application with the aid of a case study which gradually builds throughout the book. It also includes a jumpstart chapter for developers coming from other technologies. If you already have a firm grasp of Silverlight development and are keen to advance your specialist knowledge of Line of Business (LOB) application development, then Expert Line of Business Application Development for Silverlight 5: Quick Start Guide is for you. If you are a developer with experience of other technologies, you may also find this book useful.

This cookbook is full of immediately useable recipes showing you the advanced development techniques when building Essbase Applications and how to take these applications further. This cookbook offers practical, task-based, and immediately usable recipes covering a wide range of advanced development techniques to build Essbase Applications and take them further. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in Essbase and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order. If you are an experienced Essbase developer, Essbase Database Designer or Database Administrator, then this book is for you. This book assumes that you have good knowledge of Oracle Essbase.

This book combines case studies with practical examples of how to implement modernization techniques using Oracle (and partner) products to modernize to the Oracle Platform. The book also weighs the pros and cons of specific modernization use cases. Finally, we explore some of the emerging trends in technology and how they apply to legacy modernization. Legacy system architects, project managers, program managers, developers, database architects and decision makers who own mainframe and heterogeneous systems, and are tasked with modernization will all find this book useful. The book assumes some knowledge of mainframes, J2EE, SOA, and Oracle technologies. The reader should have some background in programming and database design.

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.

Professional Plone 4 Development is written in a clear conversational easy-to-understand style. This book cuts short the preamble and gets straight to the point - building robust, content-rich web applications with Plone 4. Detailed real world examples are provided for each chapter. This book assumes that the reader is familiar with Plone from the point of view of an administrator or power user, has a basic understanding of web application development, and is comfortable with the Python programming language.

Chapters present principles and techniques in an order that roughly mirrors the application development process itself, from gathering requirements through final testing. The focus is on understanding and enhancing applications using classic techniques, in circumstances where it is impractical to rewrite applications using XPages. Each chapter focuses upon a particular aspect of Domino Web applications and provides guidance, recommendations, illustrations, and sample code. This book is for novice to moderately experienced Domino developers who are new to the task of Web-enabling traditional Domino applications. Readers should be familiar with using Domino Designer to develop applications for the Lotus Notes client. It is also assumed that readers have, or can acquire, at least rudimentary knowledge of HTML, CSS, and JavaScript.

The book follows a tutorial-based approach, covering all the best practices for backup and recovery. The book starts by introducing readers to the world of backup and recovery, then moves on to teach them the new features offered by Oracle 12c. The book is full of useful tips and best practices that are essential for any DBA to perform backup and recovery operations in an organization.This book is designed for Oracle DBAs and system administrators. The reader will have a basic working experience of administering Oracle databases. This book is designed for Oracle DBAs and system administrators.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the solution to some of the most well-known problems you could encounter as DBAs.

If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics.

As a cookbook, this book enables you to solve real-world Dynamics GP problems with immediately useable recipes that unleash the powerful functionality of Dynamics GP. The book provides tips, techniques, and solutions designed to show users how to improve their use of Dynamics GP, not simply perform basic tasks. If you are a Dynamics GP user or Dynamics GP partner primarily focused on delivering time-proven application optimizations, then this book is for you. This book assumes that you have a basic understanding of business management systems, with basic knowledge of Microsoft Dynamics GP. All the recipes are real-world tested and designed to be used immediately.