Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle including its testing and refactoring Build productive database solutions and use them in Java applications A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL Who This Book Is For If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. Readers should, however, know SQL. What You Will Learn Learn concepts of data modelling and relation algebra Install and set up PostgreSQL database server and client software Implement data structures in PostgreSQL Manipulate data in the database using SQL Implement data processing logic in the database with stored functions, triggers and views Test database solutions and assess the performance Integrate database with Java applications Detailed knowledge of the main PostgreSQL building objects, most used extensions Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework. Style and approach An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

Design, develop, and solve real world automation and orchestration needs by unlocking the automation capabilities of Ansible About This Book Discover how Ansible works in detail Explore use cases for Ansible’s advanced features including task delegation, fast failures, and serial task execution Extend Ansible with custom modules, plugins, and inventory sources Who This Book Is For This book is intended for Ansible developers and operators who have an understanding of the core elements and applications but are now looking to enhance their skills in applying automation using Ansible. What You Will Learn Understand Ansible’s code and logic flow Safeguard sensitive data within Ansible Access and manipulate complex variable data within Ansible playbooks Handle task results to manipulate change and failure definitions Organize Ansible content into a simple structure Craft a multi-tier rollout playbook utilizing load balancers and manipulating your monitoring system Utilize advanced Ansible features to orchestrate rolling updates with almost no service disruptions Troubleshoot Ansible failures to understand and resolve issues Extend Ansible with custom modules, plugins, or inventory sources In Detail Automation is critical to success in the world of DevOps. How quickly and efficiently an application deployment can be automated, or a new infrastructure can be built up, can be the difference between a successful product or a failure. Ansible provides a simple yet powerful automation engine. Beyond the basics of Ansible lie a host of advanced features which are available to help you increase efficiency and accomplish complex orchestrations with ease. This book provides you with the knowledge you need to understand how Ansible works at a fundamental level and leverage its advanced capabilities. You'll learn how to encrypt Ansible content at rest and decrypt data at runtime. You will master the advanced features and capabilities required to tackle the complex automation challenges of today and beyond. You will gain detailed knowledge of Ansible workflows, explore use cases for advanced features, craft well thought out orchestrations, troubleshoot unexpected behaviour, and extend Ansible through customizations. Finally, you will discover the methods used to examine and debug Ansible operations, helping you to understand and resolve issues. Style and approach A clear, practical guide that covers best practise, system architecture and design aspects that will help you master Ansible with ease.

Written in an engaging, easy-to-follow style, this practical guide will teach you to create test suites and automated acceptance Tests with the Robot Framework.If you are an automation engineer, QA engineer, developer or tester who is looking to get started with Robot Framework, as well as find a standardized testing solution, this book is ideal for you. No prior knowledge of Robot Framework or acceptance testing is required, although a basic knowledge of Python is required for few sections of the book.

This is a comprehensive tutorial with step-by-step instructions on how to develop applications with Code::Blocks.This book is for C++ developers who wish to use Code::Blocks to create applications with a consistent look and feel across multiple platforms. This book assumes that you are familiar with the basics of the C++ programming language.

This book is a practical, hands-on guide that will help you learn everything you need to know to administer your environment with VMware vCenter Server. Throughout the book, there are best practices and useful tips and tricks which can be used for day-to-day tasks.If you are an administrator or a technician starting with VMware, with little or no knowledge of virtualization products, this book is ideal for you. Even if you are an IT professional looking to expand your existing environment, you will be able to use this book to help you improve the management of these environments. IT managers will find it helpful in terms of improving cost efficiency, ensuring required levels of service and utilising its excellent reporting abilities.

Packed with practical recipes, this is a step-by-step guide to learning data visualization with D3 with the help of detailed illustrations and code samples.If you are a developer familiar with HTML, CSS, and JavaScript, and you wish to get the most out of D3, then this book is for you. This book can also serve as a desktop quick-reference guide for experienced data visualization developers.

A step-by-step, example-based guide to building immersive 3D games on the Web using the Three.js graphics library.This book is for people interested in programming 3D games for the Web. Readers are expected to have basic knowledge of JavaScript syntax and a basic understanding of HTML and CSS. This book will be useful regardless of prior experience with game programming, whether you intend to build casual side projects or large-scale professional titles.

This is a practical cookbook with intermediate-advanced recipes for SPSS Modeler data analysts. It is loaded with step-by-step examples explaining the process followed by the experts.If you have had some hands-on experience with IBM SPSS Modeler and now want to go deeper and take more control over your data mining process, this is the guide for you. It is ideal for practitioners who want to break into advanced analytics.

Each chapter of the book quickly introduces a key ‘theme’ of Data Analysis, before immersing you in the practical aspects of each theme. You’ll learn quickly how to perform all aspects of Data Analysis.Practical Data Analysis is a book ideal for home and small business users who want to slice & dice the data they have on hand with minimum hassle.

This book is an advanced practical guide to applying and extending Oracle Spatial.This book is for existing users of Oracle and Oracle Spatial who have, at a minimum, basic operational experience of using Oracle or an equivalent database. Advanced skills are not required.

A step-by-step tutorial to help you master computer vision and mobile app development.This book is for Java developers who are new to computer vision and who would like to learn about how it is used in relation to application development. It is assumed that you have previous experience in Java, but not necessarily Android. A basic understanding of image data (for example pixels and color channels) would be helpful too. You are expected to have a mobile device running Android 2.2 (Froyo) or greater and it must have a camera

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. Written in a user friendly style, this guide will get readers up and running with XenMobile MDM.If you want to run your mobile enterprises on XenMobile, or work on a BYOD strategy within your organization, then this is the ideal book for you. XenMobile MDM comprehensively explores how to set up and use XenMobile to provision, secure, and manage mobile devices.

This book uses the learning-by-example approach. It takes simple examples from games to introduce all the main concepts of programming in an easy-to-digest and immediately recognizable way.This book is for the total beginner to any type of programming, focusing on the writing of C# code and *s only. There are many parts that make up the Unity game engine. It is assumed that the reader already knows their way around Unity's user interface. The code editor used in this book is the MonoDevelop editor supplied by Unity.

Microsoft Dynamics AX 2012 Reporting Cookbook is full of practical recipes for creating and managing reports as well as identifying the most appropriate reporting tool for any reporting challenge. In addition, you will learn about universal topics such as how to locate data for any given report. Although some of the reporting tools addressed in this book are exclusive to Dynamics AX 2012, many of the topics discussed also apply to older versions of AX. This book is packed with illustrations and real-time examples that are presented in a task-oriented Cookbook structure. Real-time tips and tricks make the book very interactive and informative at the same time."Microsoft Dynamics AX 2012 Reporting Cookbook" is recommended for Dynamics AX developers and .NET-based SSRS developers looking to familiarize themselves with the AX reporting framework. A basic understanding of Morphx and X++ is assumed but the step-by-step instructions make it easy even for a beginner. Some examples use C# and VB.NET, so experience with Visual Studio is a plus, but not a must.

This book is a standard tutorial, which walks you through the gamification development process, to help you incorporate game elements in an eLearning environment.This book is for jQuery and PHP developers who wish to gamify their educational websites.

The book will help readers discover the various facilities of ImageJ through a tutorial-based approach.This book is targeted at scientists, engineers, technicians, and managers, and anyone who wishes to master ImageJ for image viewing, processing, and analysis. If you are a developer, you will be able to code your own routines after you have finished reading this book. No prior knowledge of ImageJ is expected.

If you are a developer who is new to AngularJS or is experienced with the AngularJS framework, this book is intended for you. If you want to provide a better user experience on your web app, this book is also for you.

This book is intended for those who wish to learn the concepts of game development using LibGDX. An understanding of Java and other programming languages would definitely be helpful, although this is not a must.

This book is intended for those who want to build exciting projects using the Intel Galileo board. It is for people who are already experienced in using more classic Arduino boards and want to extend their knowledge to the Intel Galileo board. It is also for people who want to learn about electronics and programming, and Intel Galileo is the perfect platform for this.

If you are an iOS developer with experience in Objective-C, and wish to develop applications with Swift, then this book is ideal for you. Familiarity with the fundamentals of Swift is an added advantage but not a necessity.

If you are a competent developer who wants to fast-track your application development with the NetBeans IDE, then this book is for you. Reasonable knowledge and an understanding of Java programming and the NetBeans IDE is assumed.