Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book ? Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease ? Master query optimization, replication, and high availability with PostgreSQL ? Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. What You Will Learn ? Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL ? Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries ? Work with the stored procedures and manage backup and recovery ? Master the replication and failover techniques ? Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems ? Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently. We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.

Explore the new and improved Jira 8 features such as agile board and advanced search for efficient project management Key Features * Work on agile projects in Jira from both the administrator and end user's perspective * Explore the improved Scrum and Kanban board and backlog * Work through exercises at the end of each chapter to reinforce your skills Book Description Atlassian Jira enables effective bug tracking for your software and mobile applications and provides tools to track and manage tasks for your projects. Jira Essentials is a comprehensive guide, now updated to Jira 8 to include enhanced features such as updates to Scrum and Kanban UI, additional search capabilities, and changes to Jira Service Desk. The book starts by explaining how to plan and set up a new Jira 8 instance from scratch before getting you acquainted with key features such as emails, workflows, business processes, and much more. You'll then understand Jira's data hierarchy and how to design and work with projects. Since Jira is used for issue management, this book delves into the different issues that can arise in your projects. You’ll explore fields, including custom fields, and learn to use them for more effective data collection. You’ll create new screens from scratch and customize them to suit your requirements. The book also covers workflows and business processes, and guides you in setting up incoming and outgoing mail servers. Toward the end, you’ll study Jira's security model and Jira Service Desk, which allows you to run Jira as a support portal. By the end of this Jira book, you will be able to implement Jira 8 in your projects with ease. What you will learn * Understand Jira's data hierarchy and how to design and work with projects in Jira * Use Jira for agile software projects, business process management, customer service support, and more * Understand issues and work with them * Design both system and custom fields to behave differently under different contexts * Create and design your own screens and apply them to different project and issue types * Gain an understanding of the workflow and its various components * Set up both incoming and outgoing mail servers to work with e-mails Who this book is for This book will be especially useful for project managers but it's also intended for other Jira users, including developers, and any other industry besides software development, who would like to leverage Jira's powerful task management and workflow features to better manage their business processes.

Your all-in-one guide to exploring and implementing Microsoft Dynamics AX About This Book From project kick-off to go live and upgrade, learn what to expect in each phase of the project This book guides you through the entire journey of a Dynamics AX implementation project, helping you to avoid the common pitfalls and adapt industry knowledge and best practices for your own project This one-stop guide is packed with key tools and techniques to aid your Dynamics AX implementation Who This Book Is For This book is for IT project managers, solution architects, and consultants who are planning to implement or are in the process of implementing or upgrading Dynamics AX. To use this book, you must have a working Dynamics AX system in place and must be familiar with the basics of Dynamics AX. What You Will Learn Prepare for a great start with effective project management and planning from the beginning Gather details early using effective requirement-gathering tools and techniques Gain tools and techniques for effective infrastructure planning and hardware sizing Get to grips with integration and data migration through planning and strategy Familiarize yourself with the reporting and BI tools Master functional and technical design to customize existing features and designs in your own projects Manage your configuration and you’re your configuration from one environment to another Learn industry’s best practices and recommendations on customization development and performance tuning In Detail Microsoft Dynamics AX is Enterprise Resource Planning (ERP) software that supports multi-site operations across various countries, providing international processing within the company. It is an ERP solution with a lot of features and functionality, and it provides support across the fields of financial, distribution, supply chain, project, customer relationship, HR, and field service management. This book is all about simplifying the overall implementation process of Dynamics AX. The purpose of this book is to help IT managers and solution architects implement Dynamics AX to increase the success rate of Dynamics AX projects. This all-in-one guide will take you through an entire journey of a Dynamics AX implementation, ensuring you avoid commonly-made mistakes during implementation. You’ll begin with the installation of Dynamics AX and the basic requirements. Then, you’ll move onto data migration, reporting, functional and technical design, configuration, and performance tuning. By the end of the book, you will know how to plan and execute Dynamics AX right, on your first attempt, using insider industry knowledge and best practices. Style and approach This is a progressive, easy-to-follow book that summarizes numerous aspects you need to know to make your Dynamics AX implementations successful using code examples to get you hands-on.

This book is for those with a basic knowledge of Clojure, who are looking to push the language to excel with data analysis.

Microsoft Visio 2013 Business Process Diagramming and Validation provides a comprehensive and practical tutorial including example code and demonstrations for creating validation rules, writing ShapeSheet formulae, and much more.If you are a Microsoft Visio 2013 Professional Edition power user or developer who wants to get to grips with both the essential features of Visio 2013 and the validation rules in this edition, then this book is for you. A working knowledge of Microsoft Visio and optionally .NET for the add-on code is required, though previous knowledge of business process diagramming is not necessary. More experienced Visio users will gain valuable knowledge regarding building add-ons and creating and publishing rules. If you want to achieve results from Visio 2013 beyond the ordinary out-of-the-box features, then this book is ideal for you. Microsoft Visio 2013 Business Process Diagramming and Validation provides a comprehensive and practical tutorial including example code and demonstrations for creating validation rules, writing ShapeSheet formulae, and much more.

Over 88 recipes for effective use of Infusionsoft to mitigate your CRM needs, marketing automation, conducting online business optimallyAbout This BookMaximize client engagement by automating lead capture and follow-upCollect information and set up lead scoring in Infusionsoft to enhance your marketing interactions to build more clientsSet up online shopping carts, manage your online store, and enhance user experience Who This Book Is For If you want to excel in the use of Infusionsoft to develop a set of common applications or project types and solutions effectively, this book is perfect for you. This book will empower you to provide better results for your clients, faster! It is assumed that you are familiar with and use Infusionsoft.What You Will LearnSet up and configure features that will enhance new user creation using InfusionsoftAttract leads and build your list efficientlyUnderstand the different strategies to sell and get paidCreate amazing customer experiences by following up and automating messagesMaster techniques to use Infusionsoft for internal administrative functionsMake better business decisions by mastering the reporting functionalitySave time and simplifying day-to-day usage using InfusionsoftGet to know the Ninja hacks while working with Infusionsoft efficiently. In Detail Infusionsoft is an all-in-one software-as-a-service (SaaS) for small business sales and marketing. It empowers businesses with the same level of automation and personalization that were previously only available to large corporate enterprises with deep pockets. You can easily manage customer relationships, target communications in an automated manner, and sell their products/services online effectively. Starting with recipes on the general setup and core competencies related to Infusionsoft, you will then learn about tools to enhance user experience. Further on, you'll dive deep into different strategies to attract, sell, and wow your customers. You’ll also explore different ways to manage administrative tasks and reporting, which are crucial to perform better workflow management. Later, you will become proficient in lead generation and lead management, referral management, report generation, and working with the campaign builder. Finally, the book closes with unsupported ninja hacks to take your business strategies into the stratosphere!Style and approach A recipe-based guide that covers real-life scenarios on optimising marketing automation, lifecycle management, lead generation, inventory management, and adding ecommerce functionality

This book is for newcomer and intermediate Java developers who want to work with XML documents using JDeveloper 11g. No previous knowledge of JDeveloper is assumed but the reader will need to be comfortable in XML and Java environments. Employing a comprehensive tutorial-based approach, this easy-to-follow book shows the reader various means of processing XML documents using the power of Oracle's JDeveloper 11g. In next to no time, the reader will be able to create, format, transform, compare, and schema validate XML documents with Oracle's IDE.

Comprehensive tasks covering Odoo 10 in the right way About This Book ? Reduce implementation costs and improve major benchmarks relating to storage space and speed. ? Implement the approval hierarchy and user and access rights, configure the company and language, and so on. ? Cover all platforms such as mobile, web, content management, and e-commerce. Who This Book Is For This book is targeted towards Odoo functional users and project managers who would like to use it for their organization. No expertise in Odoo is required. What You Will Learn ? Learn the modern way of doing sales and managing sales contracts. ? Create and configure your products and manage your sales quotations ? Set up an online shop and start selling online with Odoo eCommerce ? Manage multi-currency transactions and create a deferred revenue plan and link it with products ? Administer vendors and products and request quotations, confirm orders, and get them delivered ? Manage quality control in the warehouse and manual and real-time inventory stock valuations. ? Manage projects and project forecasting via grid and Gantt views ? Implement Human Resource apps and manage the employee appraisal process ? Manage Workcenters and the product lifecycle ? Track worker activity with tablets and launch new changes in production In Detail Odoo is a Python-based ERP system and is completely open source. Odoo is a comprehensive suite of business applications offering a wealth of functionalities that can be deployed to meet your business needs. This book will help you manage the different functionalities of your business and optimize it. You will learn in detail about the various facets of the business process such as sales, accounting, purchases, manufacturing, and inventory. We will cover each of these topics in detail and learn how Odoo handles all these tasks with much ease. With its modular approach, you will be able to build customized solutions, take advantage of the Odoo 10 system in your organization, and master basic administration. We will cover modules and applications in Odoo that will help optimize quality checks. You will also be able to customize major reporting functions for your teams and set up forms and documents for sales, purchase, inventory, and so on. By the end of the book, you will be able to use the major functionalities of Odoo 10 and fully implement them into your business. Style and approach The book follows a recipe-based format; the recipes are filled with real-world use cases and various functional topics.

Become a full-fledged Qlik Sense Consultant with the help of this unique guide About This Book ? Become a successful Qlik consultant with the help of this insightful guide ? Build what is in line as well as exceeding your customer’s expectations from your Qlik Sense solutions using this highly practical guide ? Build result-driven optimized BI solutions using Qlik with the help of industry examples Who This Book Is For If you have basic familiarity with Qlik Sense and want to upgrade your skills to become a full-fledged Qlik Consultant, this book is for you. With this book, you will be able to create efficient business intelligence solutions that would fetch client satisfaction, and in turn, more projects. What You Will Learn ? Understand the importance and expectations of a consultant’s role ? Engage with the customer to understand the ir goals and future objectives ? Design the optimum architecture, using the best practices for the development and implementation of your projects ? Ensure successful adoption using real-life examples to make your learning complete ? Learn about the important stages of a Qlik project’s life cycle In Detail Qlik Sense is a leading platform for business intelligence (BI) solutions. Qlik Sense helps organizations in making informed decisions based on the data they have. This book will teach you how to effectively use Qlik for optimum customer satisfaction. You will undergo a metamorphosis from a developer to a consultant who is capable of building the most suitable BI solutions for your clients. The book will take you through several business cases – this will give you enough insight to understand the needs of the client clearly and build a BI solution that meets or exceeds their expectations. Starting from the pre-project activities, you will go to the actual execution of the project, the implementation, and even maintenance. This book will give you all the information you need - from the strategy to requirement gathering to implementing BI solutions using Qlik Sense. The book will empower you to take the right decisions in tricky and diffi cult situations while developing analytics and dashboards. Style and approach This book will be a hands-on guide that will teach you all the what-to-do’s, when-to-do’s, and how-to-do’s for becoming a successful Qlik Sense Consultant. With the help of various business scenarios, the book will cover real-world problems that you can relate to. Various solutions in the book will be backed up by the thought process of why are these solutions used and how you can implement them in your own business environment.

Have the best tools at your fingertips to extend and maximize the efficiency of your business management About This Book ? Follow practical and easy-to-grasp examples, illustrations and coding to make the most out of Dynamics 365 for Operations in your business scenario ? Extend Dynamics 365 for Operations in a cost-effective manner by using tools you already have ? Solve common business problems with the valuable features of Dynamics 365 for Operations Who This Book Is For This book is for those who are getting to grips with Dynamics 365 for Operations developers or those migrating from C# development. The guide includes information essential for new and experienced Dynamics 365 for Operations developers. What You Will Learn ? Create enumerated and extended data types ? Understand the importance of using patterns and frameworks while creating a unique concept for your solution ? Service and deploy your code and packages to improve performance ? Write and perform unit tests to automate the testing process ? Design your security model and policies to provide code access privileges ? Construct the UI and business logic to add Power BI to dashboards In Detail Dynamics 365 for Operations is the ERP element of Microsoft’s new Dynamics 365 Enterprise Edition. Operations delivers the infrastructure to allow businesses to achieve growth and make better decisions using scalable and contemporary ERP system tools. This book provides a collection of “recipes” to instruct you on how to create—and extend—a real-world solution using Operations. All key aspects of the new release are covered, and insights into the development language, structure, and tools are discussed in detail. New concepts and patterns that are pivotal to elegant solution designs are introduced and explained, and readers will learn how to extend various aspects of the system to enhance both the usability and capabilities of Operations. Together, this gives the reader important context regarding the new concepts and the confidence to reuse in their own solution designs. This “cookbook” provides the ingredients and methods needed to maximize the efficiency of your business management using the latest in ERP software—Dynamics 365 for Operations. Style and approach The book takes a practical recipe-based approach, focusing on real-world scenarios and giving you all the information you need to build a strong Dynamics 365 for Operations implementation.

This book is written in practical tutorial style and it offers learning through vivid examples and. Each chapter contains step-by-step instructions about everything necessary to execute a particular task. The book is designed so that you can read it from start to end for beginners or just open up any chapter and start following the recipes as a reference for advanced users,This book will be useful to developers, System admins and consultants who want to install and manage a virtualized app environment using VMware ThinApp 4.7.

This is a step-by-step tutorial packed with examples and tips to learn Ext.NET from scratch. This book is written for .NET Web Application Developers who are familiar with ASP.NET looking to build .NET based Rich Internet Applications. Whether you are new to Ext JS or you are looking to use your existing Ext JS skills in a .NET environment, this book will be useful for you.

A cookbook full of practical and immediately useable recipes for real world business implementation of EnterpriseOne Supply Chain Management. If you are a functional consultant, technical consultant/developer, or project manager and want to improve your business perspective of EnterpriseOne SCM, this book is for you. You should have basic knowledge of navigating EnterpriseOne and general supply chain familiarity. Knowledge of the Common Foundation JDE 9.0 module is advantageous; the supply chain business domain knowledge will be an add-on to this.

Written in cookbook style, this book offers many recipes to learn game design with UDK. Each recipe contains step-by-step instructions followed by analysis of what was done in each task and other useful information. The book is designed so that you can read it chapter by chapter, or you can look at the list of recipes and refer to them in no particular order. This book is meant for game artists who are getting used to UDK but may feel the need for guidance on matters of implementation. It also targets brave beginners who are struggling to find an all in one package for getting started with UDK, and want a ready to hand reference. Level designers can use this book to gauge their understanding of the editor, check for specific problems, and discover gems they may not have come across before.

In this book you will find both examples and theoretical concepts covered. Every recipe is based on a */procedure explained step-by-step, with screenshots, while theoretical concepts are explained in the context of the recipe, to explain why a solution performs better than another. This book is aimed at software developers, software and data architects, and DBAs who are using or are planning to use the Oracle Database, who have some experience and want to solve performance problems faster and in a rigorous way. If you are an architect who wants to design better applications, a DBA who is keen to dig into the causes of performance issues, or a developer who wants to learn why and where the application is running slow, this is the book for you. Basic knowledge of SQL language is required and general knowledge of the Oracle Database architecture is preferable.

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 book is broken into two distinct parts. The first is a general introduction to BizTalk Server 2010 as well as the patterns commonly used in solutions built on the platform. It also includes explanations and motivations for these core patterns and practices. The second part is a hands-on real world example presented in a step-by-step manner that takes the reader through a multiphase solution and builds this simple project into a robust and complex middleware integration solution. This book is targeted at the professional developer or architect tasked with creating solutions that leverage BizTalk Server 2010. It assumes experience with Visual Studio and at least a minimal exposure to any version of BizTalk Server from 2004 to the present. Development managers with a technical background will also find this book useful in guiding their implementation teams. Cursory knowledge of XML, although useful, is not required; the text does include an XML primer in the appendix. Advanced BizTalk developers will learn many tips and techniques to improve the solutions they develop on the BizTalk 2010 platform.

This enormously practical guide, interspersed with numerous real-life case studies and actual business scenarios, shows readers when, where, and how to use Oracle's wide range of data integration products. If you are a DBA, application or data architect, or data integration specialist who is running an Oracle database or middleware and you want to learn about the latest on Oracle's information integration platform, then this book is for you. You can also benefit from this book if you are an application developer or technical and project lead with a focus on master data management, data warehousing, and data consolidation. You should have working experience with Oracle Database, data integration, consolidation, and migration, as well as some familiarity with integration middleware products and information service buses.

This easy-to-understand tutorial covers Oracle Warehouse Builder from the ground up, and taps into the author's wide experience as a software and database engineer. Written in a relaxed style with step-by-step explanations, lots of screenshots are provided throughout the book. There are numerous tips and helpful hints throughout that are not found in the original documentation. By following this book, you can use Oracle Warehouse Builder in the best possible way and maximize your learning potential. This book is an update of Oracle Warehouse Builder 11g: Getting Started. This book is a good starting point for database engineers, administrators, and architects who are responsible for data warehouse projects and need to design them and load data into them. If you are someone who wants to learn Oracle Warehouse Builder and expand your knowledge of the tool and data warehousing, this is an ideal book for you. No prior data warehouse or database experience is presumed. All new database and data warehouse technical terms and concepts explained in clear easy-to-understand language.

A practical approach with hands on recipes to learn more about HTML5 Data and Services, its features and techniques when building websites or web applications.This book is for programmers and developers who work with a lot of backend code and want to get fast tracked into the world of HTML5 and Java*. It is also for JavaScript developers who would like to update their knowledge with new techniques and capabilities made possible with HTML5.Some experience in HTML and jQuery is assumed.

This hands-on, example-driven guide is a practical getting started tutorial with plenty of step-by-step instructions for beginner to intermediate level readers working with BPEL PM in Oracle SOA SuiteWritten for SOA developers, administrators, architects, and engineers who want to get started with Oracle BPEL PM 11g. No previous experience with BPEL PM is required, but an understanding of SOA and web services is assumed