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.

Creating and Sharing Maps and Data using ArcGIS Pro About This Book ? Leverage the power of ArcGIS to build beautiful 2D and 3D maps. ? Work with ArcGIS to analyze and process data. ? Extend the power of ArcGIS to ArcGIS Online to create and edit content. Who This Book Is For GIS developers who are comfortable using ArcGIS, and are looking to increase their capabilities and skills, will find this book useful. What You Will Learn ? Edit data using standard tools and topology ? Convert and link data together using joins and relates ? Create and share data using Projections and Coordinate Systems ? Access and collect data in the field using ArcGIS Collector ? Perform proximity analysis and map clusters with hotspot analysis ? Use the 3D Analyst Extension and perform advanced 3D analysis ? Share maps and data using ArcGIS Online via web and mobile apps In Detail ArcGIS is Esri's catalog of GIS applications with powerful tools for visualizing, maintaining, and analyzing data. ArcGIS makes use of the modern ribbon interface and 64-bit processing to increase the speed and efficiency of using GIS. It allows users to create amazing maps in both 2D and 3D quickly and easily. If you want to gain a thorough understanding of the various data formats that can be used in ArcGIS Pro and shared via ArcGIS Online, then this book is for you. Beginning with a refresher on ArcGIS Pro and how to work with projects, this book will quickly take you through recipes about using various data formats supported by the tool. You will learn the limits of each format, such as Shapefiles, Geodatabase, and CAD files, and learn how to link tables from outside sources to existing GIS data to expand the amount of data that can be used in ArcGIS. You'll learn methods for editing 2D and 3D data using ArcGIS Pro and how topology can be used to ensure data integrity. Lastly the book will show you how data and maps can be shared via ArcGIS Online and used with web and mobile applications. Style and approach This book takes a recipe-based approach, teaching you how to create and share maps and data using ArcGIS Pro.

A practical tutorial containing clear, step-by-step explanations of all the concepts required to understand the technology involved in virtualizing your application infrastructure. Each chapter uses real-world scenarios so that the readers can put into practice what they learn immediately and with the right guidance. Each topic is written defining a common need and developing the process to solve it using Microsoft App-V. This book is for system administrators or consultants who want to master and dominate App-V, and gain a deeper understanding of the technology in order to optimize App V implementations. Even though the book does not include basic steps like installing App-V components or sequencing simple applications; application virtualization beginners will receive a comprehensive look into App-V before jumping into the technical process of each chapter.

This book is written in a clear conversational style, which emphasizes a practical learn-by-doing approach. This step by step guide has illustrative examples to implement Ext JS library features in your Oracle APEX applications If you are an Oracle APEX application developer who wants to take APEX applications to the next level by taking advantage of Ext JS features, this book is for you. Prior knowledge of Oracle APEX is required, however, no prior knowledge of Ext JS is required.

If you are a developer who implements ElasticSearch in your web applications and want to sharpen your understanding of the core elements and applications, this is the book for you. It is assumed that you’ve got working knowledge of JSON and, if you want to extend ElasticSearch, of Java and related technologies.

This book is written in a practical and friendly style with practical tutorials, exercises, and detailed images which will help you master the third dimension. This book is intended for everyone who wants to create accurate 3D models in AutoCAD, like architecture, engineering, or design professionals, and students. Only basic understanding of 2D AutoCAD is needed.

Targeted at those with an existing familiarity with R programming, this practical guide will appeal directly to programmers interested in learning effective data visualization techniques with R and a wide-range of its associated libraries.

This book is aimed at both new developers as well as experienced developers. If you are a new SAP BusinessObjects Universe developer who is looking for a step-by-step guide supported with real-life examples and illustrated diagrams, then this book is for you. If you are a seasoned BusinessObjects Universe developer who is looking for a fast way to map your old experience in Universe designer to the newer Information Design Tool, then this book is for you as well.

If you are a Visual Studio 2013 or .NET developer who would like to sharpen your existing skill set and adapt to new .NET technologies, this is the book for you. A basic understanding of .NET and C# is required.

If you are a business analyst, BI developer, or an IT professional who wants to learn the A to Z of how to work with Web Intelligence reporting tools and different types of data, then this book is for you. The only thing you need is a basic understanding of what Business Intelligence is and data concepts.

If you have C# knowledge but now want to become truly confident in creating fully functional 2D RPG games with Unity, then this book will show you everything you need to know.

Step-by-step recipes filled with practical code samples and engaging examples demonstrate Haskell in practice, and then the concepts behind the code. This book shows functional developers and analysts how to leverage their existing knowledge of Haskell specifically for high-quality data analysis. A good understanding of data sets and functional programming is assumed.

This book is built on recipes written in an easy-to-follow manner accompanied by diagrams and crucial insights and knowledge on what they mean in the real world. This book is ideal for musicians and producers who want to take their music creation skills to the next level, learn tips and tricks, and understand the key elements and nuances in building inspirational music. It’s good to have some knowledge about music production, but if you have creativity and a good pair of ears, you are already ahead of the curve and well on your way.

This book provides an overview of the kill chain approach to penetration testing, and then focuses on using Kali Linux to provide examples of how this methodology is applied in the real world. After describing the underlying concepts, step-by-step examples are provided that use selected tools to demonstrate the techniques.If you are an IT professional or a security consultant who wants to maximize the success of your network testing using some of the advanced features of Kali Linux, then this book is for you. This book will teach you how to become an expert in the pre-engagement, management, and documentation of penetration testing by building on your understanding of Kali Linux and wireless concepts.

If you are a desktop architect, solution provider, end-user consultant, virtualization engineer, or anyone who wants to learn how to plan and design the implementation of a virtual desktop solution based on Horizon 6, then this book is for you. An understanding of VMware vSphere fundamentals coupled with experience in the installation or administration of a VMware environment would be a plus during reading.

Generate effective results in a variety of visually appealing charts using the plotting packages in PythonAbout This BookExplore various tools and their strengths while building meaningful representations that can make it easier to understand dataPacked with computational methods and algorithms in diverse fields of scienceWritten in an easy-to-follow categorical style, this book discusses some niche techniques that will make your code easier to work with and reuse Who This Book Is For If you are a Python developer who performs data visualization and wants to develop existing knowledge about Python to build analytical results and produce some amazing visual display, then this book is for you. A basic knowledge level and understanding of Python libraries is assumed.What You Will LearnGather, cleanse, access, and map data to a visual frameworkRecognize which visualization method is applicable and learn best practices for data visualizationGet acquainted with reader-driven narratives and author-driven narratives and the principles of perceptionUnderstand why Python is an effective tool to be used for numerical computation much like MATLAB, and explore some interesting data structures that come with itExplore with various visualization choices how Python can be very useful in computation in the field of finance and statisticsGet to know why Python is the second choice after Java, and is used frequently in the field of machine learningCompare Python with other visualization approaches using Julia and a JavaScript-based framework such as D3.jsDiscover how Python can be used in conjunction with NoSQL such as Hive to produce results efficiently in a distributed environment In Detail Python has a handful of open source libraries for numerical computations involving optimization, linear algebra, integration, interpolation, and other special functions using array objects, machine learning, data mining, and plotting. Pandas have a productive environment for data analysis. These libraries have a specific purpose and play an important role in the research into diverse domains including economics, finance, biological sciences, social science, health care, and many more. The variety of tools and approaches available within Python community is stunning, and can bolster and enhance visual story experiences. This book offers practical guidance to help you on the journey to effective data visualization. Commencing with a chapter on the data framework, which explains the transformation of data into information and eventually knowledge, this book subsequently covers the complete visualization process using the most popular Python libraries with working examples. You will learn the usage of Numpy, Scipy, IPython, MatPlotLib, Pandas, Patsy, and Scikit-Learn with a focus on generating results that can be visualized in many different ways. Further chapters are aimed at not only showing advanced techniques such as interactive plotting; numerical, graphical linear, and non-linear regression; clustering and classification, but also in helping you understand the aesthetics and best practices of data visualization. The book concludes with interesting examples such as social networks, directed graph examples in real-life, data structures appropriate for these problems, and network analysis. By the end of this book, you will be able to effectively solve a broad set of data analysis problems.Style and approach The approach of this book is not step by step, but rather categorical. The categories are based on fields such as bioinformatics, statistical and machine learning, financial computation, and linear algebra. This approach is beneficial for the community in many different fields of work and also helps you learn how one approach can make sense across many fields

Design, build and simulate complex robots using Robot Operating System and master its out-of-the-box functionalities About This Book Develop complex robotic applications using ROS for interfacing robot manipulators and mobile robots with the help of high end robotic sensors Gain insights into autonomous navigation in mobile robot and motion planning in robot manipulators Discover the best practices and troubleshooting solutions everyone needs when working on ROS Who This Book Is For If you are a robotics enthusiast or researcher who wants to learn more about building robot applications using ROS, this book is for you. In order to learn from this book, you should have a basic knowledge of ROS, GNU/Linux, and C++ programming concepts. The book will also be good for programmers who want to explore the advanced features of ROS. What You Will Learn Create a robot model of a Seven-DOF robotic arm and a differential wheeled mobile robot Work with motion planning of a Seven-DOF arm using MoveIt! Implement autonomous navigation in differential drive robots using SLAM and AMCL packages in ROS Dig deep into the ROS Pluginlib, ROS nodelets, and Gazebo plugins Interface I/O boards such as Arduino, Robot sensors, and High end actuators with ROS Simulation and motion planning of ABB and Universal arm using ROS Industrial Explore the ROS framework using its latest version In Detail The area of robotics is gaining huge momentum among corporate people, researchers, hobbyists, and students. The major challenge in robotics is its controlling software. The Robot Operating System (ROS) is a modular software platform to develop generic robotic applications.This book discusses the advanced concepts in robotics and how to program using ROS. It starts with deep overview of the ROS framework, which will give you a clear idea of how ROS really works. During the course of the book, you will learn how to build models of complex robots, and simulate and interface the robot using the ROS MoveIt motion planning library and ROS navigation stacks.After discussing robot manipulation and navigation in robots, you will get to grips with the interfacing I/O boards, sensors, and actuators of ROS. One of the essential ingredients of robots are vision sensors, and an entire chapter is dedicated to the vision sensor, its interfacing in ROS, and its programming.You will discuss the hardware interfacing and simulation of complex robot to ROS and ROS Industrial (Package used for interfacing industrial robots).Finally, you will get to know the best practices to follow when programming using ROS.Style and approach This is a simplified guide to help you learn and master advanced topics in ROS using hands-on examples.

Load, wrangle, and analyze your data using the world's most powerful statistical programming language About This Book Load, manipulate and analyze data from different sources Gain a deeper understanding of fundamentals of applied statistics A practical guide to performing data analysis in practice Who This Book Is For Whether you are learning data analysis for the first time, or you want to deepen the understanding you already have, this book will prove to an invaluable resource. If you are looking for a book to bring you all the way through the fundamentals to the application of advanced and effective analytics methodologies, and have some prior programming experience and a mathematical background, then this is for you. What You Will Learn Navigate the R environment Describe and visualize the behavior of data and relationships between data Gain a thorough understanding of statistical reasoning and sampling Employ hypothesis tests to draw inferences from your data Learn Bayesian methods for estimating parameters Perform regression to predict continuous variables Apply powerful classification methods to predict categorical data Handle missing data gracefully using multiple imputation Identify and manage problematic data points Employ parallelization and Rcpp to scale your analyses to larger data Put best practices into effect to make your job easier and facilitate reproducibility In Detail Frequently the tool of choice for academics, R has spread deep into the private sector and can be found in the production pipelines at some of the most advanced and successful enterprises. The power and domain-specificity of R allows the user to express complex analytics easily, quickly, and succinctly. With over 7,000 user contributed packages, it’s easy to find support for the latest and greatest algorithms and techniques. Starting with the basics of R and statistical reasoning, Data Analysis with R dives into advanced predictive analytics, showing how to apply those techniques to real-world data though with real-world examples. Packed with engaging problems and exercises, this book begins with a review of R and its syntax. From there, get to grips with the fundamentals of applied statistics and build on this knowledge to perform sophisticated and powerful analytics. Solve the difficulties relating to performing data analysis in practice and find solutions to working with “messy data”, large data, communicating results, and facilitating reproducibility. This book is engineered to be an invaluable resource through many stages of anyone’s career as a data analyst. Style and approach Learn data analysis using engaging examples and fun exercises, and with a gentle and friendly but comprehensive "learn-by-doing" approach.

Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interfaceAbout This BookExplore all the SQL Developer 4.1 features useful for Oracle database developers, architects, and administratorsUnderstand how this free tool from Oracle has evolved over the years and has become a complete tool that makes life easy for Oracle and third-party database usersThe author, Ajith Narayanan, has a total of 10+ years of work experience as an Oracle [APPS] DBAWho This Book Is ForThis book is intended for Oracle developers who are responsible for database management. You are expected to have programming knowledge of SQL and PL/SQL, and must be familiar with basic Oracle database concepts.What You Will LearnInstall and navigate through all the advanced features of SQL Developer that were introduced in version 4.1Browse, create, edit, and delete (drop) database objectsUse the SQL worksheet to run SQL statements and *s, edit and debug PL/SQL code, manipulate and export (unload) dataCarry out all DBA-related activities such as exporting/importing, tuning, and analyzing database performance issuesQuickly analyze, create, and edit the data model using data modelerExtend the SQL developer capabilities by exploring the APEX related pages, enabling and working with RESTful servicesUse the available reports and create new custom reports with custom *sGrasp how to connect to third-party databases and work smoothly with themIn DetailAt times, DBAs support 100s of databases at work. In such scenarios, using a command-line tool like putty adds to the difficulty, while SQL Developer makes the life of a developer, DBA, or DB architect easier by providing a graphical user interface equipped with features that can bolster and enhance the user experience and boost efficiency. Features such as DBA panel, Reports, Data Modeler, and Data Miner are just a few examples of its rich features, and its support for APEX, REST Services, timesten, and third-party database drivers demonstrate its extensibility.You may be a newbie to databases or a seasoned database expert, either way this book will help you understand the database structure and the different types of objects that organize enterprise data in an efficient manner. This book introduces the features of the SQL Developer 4.1 tool in an incremental fashion, starting with installing them, making the database connections, and using the different panels. By sequentially walking through the steps in each chapter, you will quickly master SQL Developer 4.1.Style and approachThis book follows a step-by-step approach and is in a conversational and easy-to-follow style. Screenshots , and detailed explanations of the basic and advanced features of SQL Developer 4.1 that will make your work and life easy.

Master the principles and techniques of multithreaded programming with the Java 8 Concurrency APIAbout This BookImplement concurrent applications using the Java 8 Concurrency API and its new componentsImprove the performance of your applications or process more data at the same time, taking advantage of all of your resources.Construct real-world examples related to machine learning, data mining, image processing, and client/server environmentsWho This Book Is ForIf you are a competent Java developer with a good understanding of concurrency but have no knowledge of how to effectively implement concurrent programs or use streams to make processes more efficient, then this book is for you.What You Will LearnDesign concurrent applications by converting a sequential algorithm into a concurrent oneDiscover how to avoid all the possible problems you can get in concurrent algorithmsUse the Executor framework to manage concurrent tasks without creating threadsExtend and modify Executors to adapt their behavior to your needsSolve problems using the divide and conquer technique and the Fork/Join frameworkProcess massive data sets with parallel streams and Map/Reduce implementationControl data-race conditions using concurrent data structures and synchronization mechanismsTest and monitor concurrent applicationsIn DetailConcurrency programming allows several large tasks to be divided into smaller sub-tasks, which are further processed as individual tasks that run in parallel. All the sub-tasks are combined together once the required results are achieved; they are then merged to get the final output. The whole process is very complex. This process goes from the design of concurrent algorithms to the testing phase where concurrent applications need extra attention. Java includes a comprehensive API with a lot of ready-to-use components to implement powerful concurrency applications in an easy way, but with a high flexibility to adapt these components to your needs.The book starts with a full de*ion of design principles of concurrent applications and how to parallelize a sequential algorithm. We'll show you how to use all the components of the Java Concurrency API from basics to the most advanced techniques to implement them in powerful concurrency applications in Java.You will be using real-world examples of complex algorithms related to machine learning, data mining, natural language processing, image processing in client / server environments. Next, you will learn how to use the most important components of the Java 8 Concurrency API: the Executor framework to execute multiple tasks in your applications, the phaser class to implement concurrent tasks divided into phases, and the Fork/Join framework to implement concurrent tasks that can be split into smaller problems (using the divide and conquer technique). Toward the end, we will cover the new inclusions in Java 8 API, the Map and Reduce model, and the Map and Collect model. The book will also teach you about the data structures and synchronization utilities to avoid data-race conditions and other critical problems. Finally, the book ends with a detailed de*ion of the tools and techniques that you can use to test a Java concurrent application.Style and approach A complete guide implementing real-world examples with algorithms related to machine learning, data mining, and natural language processing in client/server environments. All the examples are explained in a step-by-step approach.

Master the art of developing message-based applications with RabbitMQAbout This BookLearn how to administer, manage, and extend your own message broker, RabbitMQDevelop clients to make a message bridge between your software systems using RabbitMQDiscover how to achieve proficiency with RabbitMQ with the well-defined de*ions of the topicsWho This Book Is ForIf you are an intermediate-level RabbitMQ developer, who wants to achieve professional-level expertise in the subject, this book is for you. You’ll also need to have a decent understanding of message queuing.What You Will LearnAdminister RabbitMQ using different toolsUnderstand the roots and details of messaging, message brokers, and AMQP protocolScale the RabbitMQ server using the clusters and high availability techniquesExtend RabbitMQ by developing the Erlang OTP-based applications that use the RabbitMQ APIManage the RabbitMQ server using its powerful toolsMonitor the RabbitMQ Server using different open source tools such as Nagios, Munin, and ZabbixEnsure your RabbitMQ’s security using SSL, SASL, and access controlDevelop RabbitMQ clients using Java, Python, and C# with an industry exampleIn DetailRabbitMQ is one of the most powerful Open Source message broker software, which is widely used in tech companies such as Mozilla, VMware, Google, AT&T, and so on. RabbitMQ gives you lots of fantastic and easy-to-manage functionalities to control and manage the messaging facility with lots of community support. As scalability is one of our major modern problems, messaging with RabbitMQ is the main part of the solution to this problem.This book explains and demonstrates the RabbitMQ server in a detailed way. It provides you with lots of real-world examples and advanced solutions to tackle the scalability issues.You’ll begin your journey with the installation and configuration of the RabbitMQ server, while also being given specific details pertaining to the subject. Next, you’ll study the major problems that our server faces, including scalability and high availability, and try to get the solutions for both of these issues by using the RabbitMQ mechanisms. Following on from this, you’ll get to design and develop your own plugins using the Erlang language and RabbitMQ’s internal API. This knowledge will help you to start with the management and monitoring of the messages, tools, and applications. You’ll also gain an understanding of the security and integrity of the messaging facilities that RabbitMQ provides. In the last few chapters, you will build and keep track of your clients (senders and receivers) using Java, Python, and C#.Style and approach An easy-to-follow guide, full of hands-on examples based around managing, monitoring, extending, and securing RabbitMQ and its internal tools. You will learn how to develop your own clients using Java, Python, and C#.