"This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general."

This book is written for web designers who want to add attractive visual elements to their website. It assumes no previous knowledge of Inkscape. General familiarity with vector graphics programming is recommended but not required. It will also be a useful guide for experienced Inkscape users who want to learn how to apply their skills to website design.

If you are a developer wanting to get to grips with a primer into SimpleDB, then this book is for you. You do not need to know anything about SimpleDB to read and learn from this book, and no basic knowledge is strictly necessary.

This is a beginner's guide with clear step-by-step instructions, explanations, and advice. Each concept is illustrated with a complete example that you can use as a starting point for your own work. If you are an engineer, scientist, mathematician, or student, this book is for you. To get the most from Sage by using the Python programming language, we'll give you the basics of the language to get you started. For this, it will be helpful if you have some experience with basic programming concepts.

Concoct dynamic business intelligence dashboards for financial analysis with QlikView About This Book Get accustomed to QlikView features for effective data analysis and visualization in Finance Employ the Memory data store, which refreshes data in real time, providing a faster response to business financial information A step-by step guide to using Qlikview features such as key performance indicators, interactive charts, and tables for financial analysis Who This Book Is For If you are a finance professional with basic knowledge of QlikView functions and wish to increase your knowledge of QlikView to apply it in the field of finance, then this book is for you. A good knowledge of financial aspects is an must-have. What You Will Learn Design Key Performance Indicators and extend your revenue ratio reporting Set up actions within a Text Object and create variables to make a chart toggle between visible and not visible Merge data from multiple sources to get more asset management options Examine good and bad practices in dashboard design and create a Group button to make more data available in less space Analyse the sales dashboard by adding tending lines and forecasting Create input boxes and use the input in formulas to perform “What If” analysis Examine the Key Performance Indicator (KPI) and Inventory Turnover, and investigate the usefulness of Pivot Create a QlikView analysis document and add data to it to gain deep insights In Detail This book is an effective step-by-step tutoring guide for financial analysis using Qlikview. It begins by teaching you the crucial concepts of Qlikview Finance to help you develop an effective understanding of financial data analysis and finance. The book then goes on to cover real-world, practical examples on the use of Qlikview for financial planning and analysis, expense management, risk management, and more. Moving on, topics such as Asset Management QlikView Dashboard and Retail Sales Analysis are covered in a strategic way. We then shift the focus to deal with the concepts of Inventory, Supply Chain, and Plant Coverage Dashboards. The book then reaches its conclusion by dealing with ways to share your QlikView insights. By the end of this book, you will have a good understanding of how to use Qlikview for numerous applications in finance. Style and approach This book is designed to explore what can be done in QlikView to facilitate Financial Analysis. It follows a step-by-step approach and each chapter has easy-to-follow, hands-on examples of important concepts.

Master the skills you need to develop portable, highly-functional Android applications using NDK About This Book Develop portable games using Android NDK and debug them on your desktop Familiarise yourself with different popular C++ libraries on Android and use them in your games Write multi-threaded code with graphics, sound, networking, and resource storage Who This Book Is For If you want to leverage your C++ skills in mobile development and increase the performance of your Android applications, then this is the book for you. Knowledge of C or C++ is assumed, including pointer manipulation, multi-threading, object-oriented programming concepts, and the basics of C++11. It would be an added advantage if you know how to develop applications without any IDE. What You Will Learn Explore popular C++ libraries and use them on Android Write portable, multithreaded native networking code Create portable audio framework using OpenAL Implement portable rendering framework using OpenGL ES 3 Debug mobile applications on your desktop machine Access resources from APK archives Render text with FreeType In Detail Android NDK is used for multimedia applications that require direct access to system resources. NDK is also the key for portability, which in turn allows a reasonably comfortable development and debugging process using familiar tools such as GCC and Clang toolchains. This is a hands-on guide to extending your game development skills with Android NDK. The book takes you through many clear, step-by-step example applications to help you further explore the features of Android NDK and some popular C++ libraries and boost your productivity by debugging the development process. Through the course of this book, you will learn how to write portable multi-threaded native code, use HTTP networking in C++, play audio files, use OpenGL ES 3, and render high-quality text. Each chapter aims to take you one step closer to building your application. By the end of this book, you will be able to create an engaging, complete gaming application. Style and approach This book adopts a step-by-step approach and each chapter is based on the material from the previous ones. The book focuses on putting to your knowledge of C++ use while you develop Android applications of your own.

Adobe Edge Quickstart Guide is a practical guide on creating engaging content for the Web with Adobe's newest HTML5 tool. By taking a chapter-by-chapter look at each major aspect of Adobe Edge, the book lets you digest the available features in small, easily understandable chunks, allowing you to start using Adobe Edge for your web design needs immediately. If you are interested in creating engaging motion and interactive compositions using web standards with professional tooling, then this book is for you. Those with a background in Flash Professional wanting to get started quickly with Adobe Edge will also find this book useful.

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.

Build dynamic, data-driven websites and modern web applications with Flask About This Book Discover the most popular Flask resources on the web with ease Familiarize yourself with third-party libraries commonly used with Flask Create a fast, interactive, and secure web app with this hands-on guide Who This Book Is For This book is for anyone who wants to develop their knowledge of Python into something that can be used on the web. Flask follows the Python design principles and can be easily understood by anyone who knows Python, and even by those who do not. What You Will Learn Create your web pages to add modularity and flexibility to your web app using templates Store and retrieve relational data using SQLAlchemy Develop schema migrations with Alembic Produce an admin section using flask-admin Build RESTful APIs using Flask-Restless Simulate requests and sessions using the Flask test client Make Ajax requests from Jinja2 templates In Detail Flask is a small and powerful web development framework for Python. It does not presume or force a developer to use a particular tool or library. Flask supports extensions that can add application features as if they were implemented in Flask itself. Flask’s main task is to build web applications quickly and with less code. With its lightweight and efficient web development framework, Flask combines rapid development and clean, simple design. This book will take you through the basics of learning how to apply your knowledge of Python to the web. Starting with the creation of a “Hello world” Flask app, you will be introduced to the most common Flask APIs and Flask’s interactive debugger. You will learn how to store and retrieve blog posts from a relational database using an ORM and also to map URLs to views. Furthermore, you will walk through template blocks, inheritance, file uploads, and static assets. You will learn to authenticate users, build log in/log out functionality, and add an administrative dashboard for the blog. Moving on, you will discover how to make Ajax requests from the template and see how the Mock library can simplify testing complex interactions. Finally, you will learn to deploy Flask applications securely and in an automated, repeatable manner, and explore some of the most popular Flask resources on the web. Style and approach A comprehensive guide packed with real-world examples and popular use cases; starting with basic overviews and diving into the practical aspects of Flask Framework.

This is a cookbook, with practical recipes providing tips and tricks to the most common problems and scenarios faced with CMS Made Simple Development. If you are a CMS Made Simple user wanting to expand your skill set, or a programmer who wants to develop for CMS Made Simple, this book is for you. You will need working knowledge of PHP, HTML, and SQL. Some experience with CMS Made Simple is recommended.

This book uses a real-life case study to provide easy-to-follow examples that are radically practical and can be easily adapted to similar situations in Siebel CRM implementation projects. The book ensures that you know what you are doing and why you are doing it by providing useful insight along with detailed practical instructions. It contains a multitude of explanatory tables, screenshots, and precise diagrams to illustrate the topics. When you have finished the book you will feel prepared to participate in Siebel CRM implementation projects. In addition you will be able to teach the "old dogs" some new tricks. This book is written for developers who want to develop their Siebel Tools skill set. While the book is intended for beginners, even experienced developers will benefit from the topics presented in this book. Preliminary exposure to or training on technical Siebel topics would be beneficial but is not mandatory before you start reading this book.

Part tutorial, part reference guide, this book will show you how to create and manage reports as well as identify the most appropriate reporting tool for any reporting challenge. In addition, you will learn 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 GP 2010, many of the topics discussed also apply to older versions of GP. If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and manage reports, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Services is highly recommended.

This is a cookbook with over 80 recipes offering solutions to common game development problems with Panda3D with explained sample code and screenshots added in. If you are a developer with experience in Python, Panda3D, and optionally C++ and shading languages and you are looking for quick and easy to integrate solutions to common game development problems with Panda3D, this book is for you.

All the concepts in the book are explained in a simple, easy to understand, step-by-step manner. There are plenty of examples and images used in this book, with the images properly explained. Written with a friendly and engaging approach, this Packt Beginner's guide is designed to be placed alongside the computer as your guide and mentor to create attractive web page animations using jQuery.This book is written for web designers and front-end developers who already have good knowledge of HTML and CSS, and some experience with jQuery. If you want to learn how to animate the user interface of your web applications with jQuery, then this book is for you.

Create and customize your own website with the Concrete5 Beginner's Guide

This book is a step-by-step guide for an absolute beginner. It covers everything, from installing to configuring, to get you started quickly. It has numerous code examples that the reader can try on their own and learn while doing so. It has two full-fledged applications as examples that readers can follow. This book is specifically focused on the Search feature of web applications. This book is for developers who are new to Sphinx Search. All code examples use PHP but the logic is same for any other web *ing languages as well.

Create powerful applications to interact with popular service providers such as Facebook, Google, Twitter, and more by leveraging the OAuth 2.0 Authorization Framework About This Book Learn how to use the OAuth 2.0 protocol to interact with the world's most popular service providers, such as Facebook, Google, Instagram, Slack, Box, and more Master the finer details of this complex protocol to maximize the potential of your application while maintaining the utmost of security Step through the construction of a real-world working application that logs you in with your Facebook account to create a compelling infographic about the most important person in the world—you! Who This Book Is Fo If you are an application developer, software architect, security engineer, or even a casual programmer looking to leverage the power of OAuth, Mastering OAuth 2.0 is for you. Covering basic topics such as registering your application and choosing an appropriate workflow, to advanced topics such as security considerations and extensions to the specification, this book has something for everyone. A basic knowledge of programming and OAuth is recommended. What You Will Learn Discover the power and prevalence of OAuth 2.0 and use it to improve your application's capabilities Step through the process of creating a real-world application that interacts with Facebook using OAuth 2.0 Examine the various workflows described by the specification, looking at what they are and when to use them Learn about the many security considerations involved with creating an application that interacts with other service providers Develop your debugging skills with dedicated pages for tooling and troubleshooting Build your own rich, powerful applications by leveraging world-class technologies from companies around the world In Detail OAuth 2.0 is a powerful authentication and authorization framework that has been adopted as a standard in the technical community. Proper use of this protocol will enable your application to interact with the world's most popular service providers, allowing you to leverage their world-class technologies in your own application. Want to log your user in to your application with their Facebook accountWant to display an interactive Google Map in your applicationHow about posting an update to your user's LinkedIn feedThis is all achievable through the power of OAuth. With a focus on practicality and security, this book takes a detailed and hands-on approach to explaining the protocol, highlighting important pieces of information along the way. At the beginning, you will learn what OAuth is, how it works at a high level, and the steps involved in creating an application. After obtaining an overview of OAuth, you will move on to the second part of the book where you will learn the need for and importance of registering your application and types of supported workflows. You will discover more about the access token, how you can use it with your application, and how to refresh it after expiration. By the end of the book, you will know how to make your application architecture robust. You will explore the security considerations and effective methods to debug your applications using appropriate tools. You will also have a look at special considerations to integrate with OAuth service providers via native mobile applications. In addition, you will also come across support resources for OAuth and credentials grant. Style and approach With a focus on practicality and security, Mastering OAuth 2.0 takes a top-down approach at exploring the protocol. Discussed first at a high level, examining the importance and overall structure of the protocol, the book then dives into each subject, adding more depth as we proceed. This all culminates in an example application that will be built, step by step, using the valuable and practical knowledge you have gained.

Unleash the power of Apache Oozie to create and manage your big data and machine learning pipelines in one go About This Book Teaches you everything you need to know to get started with Apache Oozie from scratch and manage your data pipelines effortlessly Learn to write data ingestion workflows with the help of real-life examples from the author’s own personal experience Embed Spark jobs to run your machine learning models on top of Hadoop Who This Book Is For If you are an expert Hadoop user who wants to use Apache Oozie to handle workflows efficiently, this book is for you. This book will be handy to anyone who is familiar with the basics of Hadoop and wants to automate data and machine learning pipelines. What You Will Learn Install and configure Oozie from source code on your Hadoop cluster Dive into the world of Oozie with Java MapReduce jobs Schedule Hive ETL and data ingestion jobs >Import data from a database through Sqoop jobs in HDFS Create and process data pipelines with Pig, hive *s as per business requirements. Run machine learning Spark jobs on Hadoop Create quick Oozie jobs using Hue Make the most of Oozie’s security capabilities by configuring Oozie’s security In Detail As more and more organizations are discovering the use of big data analytics, interest in platforms that provide storage, computation, and analytic capabilities is booming exponentially. This calls for data management. Hadoop caters to this need. Oozie fulfils this necessity for a scheduler for a Hadoop job by acting as a cron to better analyze data. Apache Oozie Essentials starts off with the basics right from installing and configuring Oozie from source code on your Hadoop cluster to managing your complex clusters. You will learn how to create data ingestion and machine learning workflows. This book is sprinkled with the examples and exercises to help you take your big data learning to the next level. You will discover how to write workflows to run your MapReduce, Pig ,Hive, and Sqoop *s and schedule them to run at a specific time or for a specific business requirement using a coordinator. This book has engaging real-life exercises and examples to get you in the thick of things. Lastly, you’ll get a grip of how to embed Spark jobs, which can be used to run your machine learning models on Hadoop. By the end of the book, you will have a good knowledge of Apache Oozie. You will be capable of using Oozie to handle large Hadoop workflows and even improve the availability of your Hadoop environment. Style and approach This book is a hands-on guide that explains Oozie using real-world examples. Each chapter is blended beautifully with fundamental concepts sprinkled in-between case study solution algorithms and topped off with self-learning exercises.

Explore the robust features of Python to create real-world ArcGIS applications through exciting, hands-on projects About This Book Get to grips with the big world of Python add-ins and wxPython in GUI development to implement their features in your application Integrate advanced Python libraries, ArcPy mapping, and data access module techniques to develop a mapping application Construct a top-notch intermediate-to-advanced project by accessing ArcGIS Server and ArcGIS Online resources through the ArcGIS REST API using a project-based approach Who This Book Is For If you have prior experience building simple apps with ArcGIS and now have a fancy for developing a more challenging and complex desktop application in ArcGIS, then this book is ideal for you. What You Will Learn Automate the creation of creative output data visualizations including maps, charts, and graphs Explore ways to use the ArcPy Mapping module and Data-driven Pages to automate the creation of map books in your own project Develop applications that use the Plotly platform and library to create stunning charts and graphs that can be integrated into ArcGIS Desktop Build tools that access REST services and download data to a local geodatabase Design, build, and integrate advanced GUIs with wxPython and ArcGIS Desktop in ArcGIS Get clued up about constructing applications that export data to Google Earth Pro to automate time-consuming complex processes Maximize the access of ArcGIS Server and ArcGIS Online using the ArcGIS REST API with Python In Detail This book is an immersive guide to take your ArcGIS Desktop application development skills to the next level It starts off by providing detailed de*ion and examples of how to create ArcGIS Desktop Python toolboxes that will serve as containers for many of the applications that you will build. We provide several practical projects that involve building a local area/community map and extracting wildfire data. You will then learn how to build tools that can access data from ArcGIS Server using the ArcGIS REST API. Furthermore, we deal with the integration of additional open source Python libraries into your applications, which will help you chart and graph advanced GUI development; read and write JSON, CSV, and XML format data sources; write outputs to Google Earth Pro, and more. Along the way, you will be introduced to advanced ArcPy Mapping and ArcPy Data Access module techniques and use data-driven Pages to automate the creation of map books. Finally, you will learn advanced techniques to work with video and social media feeds. By the end of the book, you will have your own desktop application without having spent too much time learning sophisticated theory. Style and approach This is an easy-to-follow, project-based guide that guides you through the whole ArcGIS theme with practical, real-world examples and a systematic approach.

Create, analyze, maintain, and share 2D and 3D maps with the powerful tools of ArcGIS Pro About This Book Visualize GIS data in 2D and 3D maps Create GIS projects for quick and easy access to data, maps, and analysis tools A practical guide that helps to import maps, globes, and scenes from ArcMap, ArcScene, or ArcGlobe Who This Book Is For This book is for anyone wishing to learn how ArcGIS Pro can be used to create maps and perform geospatial analysis. It will be especially helpful for those that have used ArcMap and ArcCatalog in the past and are looking to migrate to Esri’s newest desktop GIS solution. Though previous GIS experience is not required, you must have a solid foundation using Microsoft Windows. It is also helpful if you understand how to manage folders and files within the Microsoft Windows environment. What You Will Learn Install ArcGIS Pro and assign Licenses to users in your organization Navigate and use the ArcGIS Pro ribbon interface to create maps and perform analysis Create and manage ArcGIS Pro GIS Projects Create 2D and 3D maps to visualize and analyze data Author map layouts using cartographic tools and best practices to show off the results of your analysis and maps Import existing map documents, scenes, and globes into your new ArcGIS Pro projects quickly Create standardized workflows using Tasks Automate analysis and processes using ModelBuilder and Python In Detail ArcGIS Pro is Esri’s newest desktop GIS application with powerful tools for visualizing, maintaining, and analyzing data. ArcGIS Pro 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.This book will take you from software installation to performing geospatial analysis. It is packed with how-to’s for a host of commonly-performed tasks. You will start by learning how to download and install the software including hardware limitations and recommendations. Then you are exposed to the new Ribbon interface and how its smart design can make finding tools easier.After you are exposed to the new interface, you are walked through the steps to create a new GIS Project to provide quick access to project resources. With a project created, you will learn how to construct 2D and 3D maps including how to add layers, adjust symbology, and control labeling. Next you will learn how to access and use analysis tools to help you answer real-world questions.Lastly, you will learn how processes can be automated and standardized in ArcGIS Pro using Tasks, Models, and Python Scripts.This book will provide an invaluable resource for all those seeking to use ArcGIS Pro as their primary GIS application or for those looking to migrate from ArcMap and ArcCatalog. Style and approach This book includes detailed explanations of the GIS functionality and workflows in ArcGIS Pro. These are supported by easy-to-follow exercises that will help you gain an understanding of how to use ArcGIS Pro to perform a range of tasks.

Design, build, and create your own applications using the full range of features available in Android 6 About This Book Learn how to utilize the robust features of Android 6 to design, develop, and publish better Android applications Get useful guidance on creating new apps or migrating existing apps to support features such as app permissions, app links, fingerprint authentication, etc A fast paced guide, packed with hands-on examples that ties all the features such as API, audio, video, camera, tab customization together under a single cover Who This Book Is For This book is for Android developers who are looking to move their applications into the next Android version with ease. What You Will Learn Familiarize yourself with the features of Android 6 Code with the new Android permissions model Use apps auto backup and restore lost data automatically Increase user engagement with apps through an assistant using triggers and providing contextual assistance Assess and handle proper usage of the API Work with Audio, Video,Camera in Android 6 Utilize the new features in Android for professional purposes Understand and code Chrome’s custom tabs In Detail Android 6 is the latest and greatest version of the Android operating system, and comes packed with cutting edge new features for you to harness for the benefit of building better applications. This step-by-step guide will take you through the basics of the Android Marshmallow permissions model and beyond into other crucial areas such as the Audio,Video,Camera API and Android’s at work features. Learn how to create, deploy, and manage Android applications with Marshmallow’s API and the latest functionalities. The combination of instructions and real-world examples will make your application deployment and testing a breeze. Style and approach This easy-to-follow, step-by-step tutorial provides explanations and examples to add the new Android 6 features to your skill set. Each chapter provides sequential steps and detailed information about the API, as well as best practices and testing options.