Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products. Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace. This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are likely to encounter. What You Will Learn Gain competitive advantage from Oracle SQL Know when to step up to PL/SQL versus staying in SQL Become familiar with query transformations and join mechanics Apply the model clause and analytic functions to business intelligence queries Make use of features that are specific to Oracle Database, such as row pattern matching Understand the pros and cons of different SQL approaches to solving common query tasks Traverse hierarchies using CONNECT BY and recursive subquery factoring Who This Book Is For Database programmers with some Oracle Database experience. The book is also for SQL developers who are moving to the Oracle Database platform or want to learn unique features of its query engine. Both audiences will learn to apply the full power of Oracle's own SQL dialect to commonly encountered types of business questions and query challenges.

One advantage of using JIRA for issue tracking, bug tracking, or project management is the ability to extend this tool with hundreds of plugins from the JIRA community. In this concise book, software toolsmith Matt Doar--the author of "Practical JIRA Administration"--shows you how to create and maintain your own JIRA plugins to meet the specific needs of a project.

This book uses detailed examples to clarify some of the more confusing aspects of JIRA plugins, and serves as an ideal supplement to the extensive documentation already available.Use JIRA's Plugin SDK, and learn several aspects common to all plugins Create your own custom field type, using a JIRA plugin Delve into advanced aspects of custom field plugins, and discover how searching for values in custom fields works Create JIRA plugins to use with workflows, and learn about conditions, validators, and post-functions Store data using the PropertySet interface and the Active Objects plugin Upgrade a plugin and upload it to Atlassian Plugin Exchange (PAC)

Explore all the aspects of the Aurelia framework, including routing, templating, data binding, custom elements, event aggregation, HTTP services, features, plugins, etc. You'll see how to tie all the pieces together and walk away with an understanding of how to build applications, end to end. Practical App Development with Aurelia teaches you to write a line of business applications using simple, clean JavaScript harnessing the Aurelia framework. You'll learn the key abstractions of Aurelia and understand the life cycle of components. If you want to understand the key features of the framework and gain a mastery of building Aurelia apps, then this is the book for you. Aurelia is a modern front-end framework for mobile, desktop, and web clients. It is standards-based meaning that it has a very low learning curve. This book highlights the framework's simplicity and its power. What You'll Learn Create routes and implement pipelines Utiliize dependency injection in your classes Communicate loosely-coupled across all views Deploy your solution with minimal effort Who This Book Is For Developers, Practitioners, Programmers, and Managers who want to understand how to fundamentally create Web applications using Aurelia.

Take advantage of Bitcoin's underlying technology, the blockchain, to build massively scalable, decentralized applications known as dapps. In this practical guide, author Siraj Raval explains why dapps will become more widely used-and profitable-than today's most popular web apps. You'll learn how the blockchain's cryptographically stored ledger, scarce-asset model, and peer-to-peer (P2P) technology provide a more flexible, better-incentivized structure than current software models. Once you understand the theory behind dapps and what a thriving dapp ecosystem looks like, Raval shows you how to use existing tools to create a working dapp. You'll then take a deep dive into the OpenBazaar decentralized market, and examine two case studies of successful dapps currently in use. Learn advances in distributed-system technology that make distributed data, wealth, identity, computing, and bandwidth possible Build a Twitter clone with the Go language, distributed architecture, decentralized messaging app, and peer-to-peer data store Learn about OpenBazaar's decentralized market and its structure for supporting transactions Explore Lighthouse, a decentralized crowdfunding project that rivals sites such as Kickstarter and IndieGogo Take an in-depth look at La'Zooz, a P2P ridesharing app that transmits data directly between riders and drivers

Learn to build single page web apps using Angular 5 and TypeScript by working through 70+ mini-projects. With hundreds of code examples you gain a thorough understanding of the Angular 5 ecosystem and how to work within it. You'll begin by understanding the benefits of Angular 5 vs older versions, and how this benefits your applications. You'll then move onto mini-projects that teach you JavaScript, TypeScript, how to use editors, Node, CLI, components, modules, directives, Webpack, dependency injection, widgets, routes and navigation, observers, reactive programming, and RxJS. Complete with a consistently-updated online code repository, this book is a great way to get started with Angular 5. What You'll Learn Develop single page web applications using Angular 5 Understand the web development ecosystem Use Node, JavaScript and TypeScript Who This Book Is For New or experienced developers who wish to develop single page web applications in Angular and the TypeScript language.

Quickly learn how to get the most out of the Visual Studio for Mac integrated development environment (IDE). Microsoft has invested heavily to deliver their very best development tools and platforms to other operating systems. Visual Studio for Mac is a powerful developer tool that reinforces Microsoft's "mobile-first", "cloud-first", and "any developer, any platform, any device" strategy. With the author's guided expertise and extensive code samples, you will understand how to leverage the most useful tools in Visual Studio for Mac, the code editor, and the powerful debugger. You also will appreciate the author's guidance on collaborating with other team members using integrated tooling for the Git source control engine. Whether you are a Mac developer interested in cross-platform development or a Windows developer using a Mac, Beginning Visual Studio for Mac will quickly get you up to speed! What You'll Learn Prepare, configure, and debug in the Mac development environment Create cross-platform mobile apps for Android, iOS, and Windows with Xamarin and C# in Visual Studio for Mac Build cross-platform Web applications with .NET Core using Visual Studio for Mac Customize your productive and collaborative development environment Who This Book Is For Software developers using a Mac computer who want to build mobile or web applications that run on multiple operating systems

Bring the power of functional programming to your PHP applications. From performance optimizations to concurrency, improved testability to code brevity, functional programming has a host of benefits when compared to traditional imperative programming. Part one of Pro Functional PHP Programming takes you through the basics of functional programming, outlining the key concepts and how they translate into standard PHP functions and code. Part two takes this theory and shows you the strategies for implementing it to solve real problems in your new or existing PHP applications. Functional programming is popular in languages such as Lisp, Scheme and Clojure, but PHP also contains all you need to write functional code. This book will show you how to take advantage of functional programming in your own projects, utilizing the PHP programming language that you already know. What You'll Learn Discover functional programming in PHP Work with functional programming functions Design strategies for high-performance applications Manage business logic with functions Use functional programming in object-oriented and procedural applications Employ helper libraries in your application Process big data with functional PHP Who This Book Is For Programmers and web developers with experience of PHP who are looking to get more out of their PHP coding and be able to do more with PHP.

Assess the quality of your prediction and classification models in ways that accurately reflect their real-world performance, and then improve this performance using state-of-the-art algorithms such as committee-based decision making, resampling the dataset, and boosting. This book presents many important techniques for building powerful, robust models and quantifying their expected behavior when put to work in your application. Considerable attention is given to information theory, especially as it relates to discovering and exploiting relationships between variables employed by your models. This presentation of an often confusing subject avoids advanced mathematics, focusing instead on concepts easily understood by those with modest background in mathematics. All algorithms include an intuitive explanation of operation, essential equations, references to more rigorous theory, and commented C++ source code. Many of these techniques are recent developments, still not in widespread use. Others are standard algorithms given a fresh look. In every case, the emphasis is on practical applicability, with all code written in such a way that it can easily be included in any program. What You'll Learn Compute entropy to detect problematic predictors Improve numeric predictions using constrained and unconstrained combinations, variance-weighted interpolation, and kernel-regression smoothing Carry out classification decisions using Borda counts, MinMax and MaxMin rules, union and intersection rules, logistic regression, selection by local accuracy, maximization of the fuzzy integral, and pairwise coupling Harness information-theoretic techniques to rapidly screen large numbers of candidate predictors, identifying those that are especially promising Use Monte-Carlo permutation methods to assess the role of good luck in performance results Compute confidence and tolerance intervals for predictions, as well as confidence levels for classification decisions Who This Book is For Anyone who creates prediction or classification models will find a wealth of useful algorithms in this book. Although all code examples are written in C++, the algorithms are described in sufficient detail that they can easily be programmed in any language.

Learn how to use reactive architectures on the front-end. There are many technologies using a reactive approach on the back end, but this book teaches you how the reactive manifesto can be used to benefit your front-end programming as well. You will discover what reactive programming is, what the current front-end ecosystem looks like, and how to use a range of frameworks and libraries. You will also apply specific reactive architectures in your own projects. Each concept is taught with a mix of technical explanations and real-world code implementations. The future of front-end programming and architecture is reactive - don't get left behind: Add Front-End Reactive Architectures to your library today. What You'll Learn Understand when and why you should use a reactive architecture Apply a specific reactive architecture in a project Manage different reactive architectures Who This Book Is For Mid-senior front-end developers, tech leads, and solutions architects

Learn how to code, package, deploy, and test functional Enterprise JavaBeans with the latest edition of this bestselling guide. Written by the developers of the JBoss EJB 3.1 implementation, this book brings you up to speed on each of the component types and container services in this technology, while the workbook in the second section provides several hands-on examples for putting the concepts into practice. Enterprise JavaBeans 3.0 presented a radical departure from its predecessors with a lightweight alternative that met with enthusiastic response from the Java development community. With version 3.1, EJB's server-side component model for building distributed business applications is simpler yet. And Enterprise JavaBeans 3.1 is the most complete reference you'll find on this specification. * Learn how to encapsulate business logic with Session Beans and Message-Driven Beans * Understand EJB's container services, such as dependency injection, concurrency, and interceptors * Handle persistence through the Entity Bean and EntityManager * Discover how to integrate with other technologies in the Java Enterprise Edition platform

This double volumes LNCS 10573-10574 constitutes the refereed proceedings of the Confederated International Conferences: Cooperative Information Systems, CoopIS 2017, Ontologies, Databases, and Applications of Semantics, ODBASE 2017, and Cloud and Trusted Computing, C&TC, held as part of OTM 2017 in October 2017 in Rhodes, Greece. The 61 full papers presented together with 19 short papers were carefully reviewed and selected from 180 submissions. The OTM program every year covers data and Web semantics, distributed objects, Web services, databases, information systems, enterprise workflow and collaboration, ubiquity, interoperability, mobility, grid and high-performance computing.

This book contains tips, tricks, and techniques to make new and existing PHP applications much faster and less resource-hungry. Author Armando Padilla looks at all major sections of the PHP application stack from server hardware to database and web server performance. PHP program application performance is the center of this book, and Padilla shows you how to improve performance by best practices, proper design, and best-of-breed tools. Padilla starts out by establishing performance testing and benchmarking methodology using common open source and browser-based testing tools. He then discusses best practices for PHP development, and also explains refactoring existing code, both with performance in mind. In addition to best coding practices, this book will teach you how to use and tweak Opcode caches such as APC, XCache, and eAccelerator. Padilla then highlights how to support the efficient running of PHP applications, tweaks and settings by taking advantage of the GNU/Linux and Microsoft Windows operating systems to improve hosting performance and reliability. Additional tips on web server improvements and database administration help round out the picture.Finally, Padilla presents some hardware example configurations tuned for high performance. What you ll learn * How to improve the performance of existing PHP applications * How to maximize the performance of existing operating systems and databases * How to refactor existing PHP code for better performance * How to identify and rectify bottlenecks in PHP code * How to take advantage of variable caching to increase performance * Strategies for selecting server hardware for best performance Who this book is for This book will appeal to established PHP developers who wish to write new, complex applications or want to rearchitect existing ones. Developers of other languages such as Ruby, Python, and VB.NET will also have an interest in the techniques for tuning the performance of web servers, databases, and operating systems.

Explore the features of this innovative open source language in depth, from working with the type system through object-orientation to understanding the runtime and the TypeScript compiler. This fully revised and updated second edition of Steve Fenton's popular book covers everything you need to discover this fascinating language and transform your experience of JavaScript development. What's New in This Edition Coverage of major changes to modules, namespaces, and module loading New guidance on how to use inference to reduce the effort of using TypeScript Recommendations on compiler options A wide range of feature updates from intersections and tuples to async/await and the new approach to mixins What You'll Learn Understand the TypeScript type system, and how to use it effectively Apply object-oriented design using TypeScript Use modules effectively to manage large programs Integrate existing frameworks and libraries into your TypeScript program Who This Book Is For Web developers looking for a modern approach to JavaScript development

Break into the most lucrative platform in the world by adding HTML5 game development to your current skillset. Zarrar Chishti has trained developers from a wide range of programming disciplines to cross over into HTML5 game development. Whatever your vocation, whether it be an Application Databases Systems developer or a Professional Web developer, with this book you will learn to evolve your current coding skills to become eligible for the biggest gaming platform in the world. From the first chapter you will see encouraging results immediately as you power through a challenging and fun project that has been uniquely designed and developed for this book. With the relentless backing of the giants of the industry including Apple and Google, HTML5 is rapidly becoming the leading technology for game development. Furthermore nearly every mobile device, tablet and PC system offer full support to the latest games developed in HTML5. Never before has there been such a widely accepted platform by literally every manufacturer and operating system. This in turn has convinced marketing departments to move away from traditional platforms, such as dedicated mobile apps, for the more widely accepted HTML5 format. There has never been a better time for a seasoned IT programmer to crossover and capitalize in this lucrative market with their much sought after talents and experience. Take the skills you already have and expand your career into HTML5 development with this book. What You'll Learn Quickly identify the core similarities and differences between HTML5 and other coding standards Follow a large scale game development project to experience the full lifecycle of an HTML5 game development project Download graphics and media to use in sample projects throughout the book Who This Book Is For Professional developers working in application and database development. These seasoned coders, having secured a wealth of knowledge, can transfer that expertise to the growing HTML5 game development market. This book will instantly appeal to this audience as it will not attempt to teach the basics of programming; instead it will simply point out the differences in how to develop with HTML5.

Design, develop, and deploy a real-world web application by leveraging modern open source technologies. This book shows you how to use ASP.NET Core to build cross-platform web applications along with SignalR to enrich the application by enabling real-time communication between server and clients. You will use Docker to containerize your application, integrate with GitHub to package the application, and provide continuous deployment to Azure's IaaS platform. Along the way, Real-Time Web Application Development covers topics including designing a Materialize CSS theme, using a test-driven development approach with xUnit.net, and securing your application with the OAuth 2.0 protocol. To further your understanding of the technology, you will learn logging and exception handling; navigation using view components; and how to work with forms and validations. The rich code samples from this book can be used to retrofit or upgrade existing ASP.NET Core applications. What You Will Learn Design and develop a real-world web application Implement security and data storage with OAuth2 and Azure Table Storage Orchestrate real-time notifications through SignalR Use GitHub and Travis CI for continuous integration of code Master Docker containerization and continuous deployment with Docker Cloud to Azure Linux virtual machines Who This Book Is For Developers and software engineers interested in learning an end-to-end approach to application development using Microsoft technologies.

Get introduced to full stack enterprise development. Whether you are new to AngularJS and Spring RESTful web services, or you are a seasoned expert, you will be able to build a full-featured web application from scratch using AngularJS and Spring RESTful web services. Full stack web development is in demand because you can explore the best of different tools and frameworks and yet make your apps solid and reliable in design, scalability, robustness, and security. This book assists you in creating your own full stack development environment that includes the powerful and revamped AngularJS, and Spring REST. The architecture of modern applications is covered to prevent the development of isolated desktop and mobile applications. By the time you reach the end of this book you will have built a full-featured dynamic app. You will start your journey by setting up a Spring Boot development environment and creating your RESTful services to perform CRUD operations. Then you will migrate the front-end tools-AngularJS and Bootstrap-into your Spring Boot application to consume RESTful services. You will secure your REST API using Spring Security and consume your secured REST API using AngularJS. What You'll Learn Build a REST application with Spring Boot Expose CRUD operations using RESTful endpoints Create a single page application by integrating Angular JS and Bootstrap in Spring Boot Secure REST APIs using Spring Security Consume secured RESTful Services using Angular JS Build a REST client using a REST template to consume RESTful services Test RESTful services using the Spring MVC Test Framework Who This Book Is For Web application developers with previous Java programming experience who want to create enterprise-grade, scalable Java apps using powerful front tools such as AngularJS and Bootstrap along with popular back-end frameworks such as Spring Boot

Build .NET apps on Microsoft Azure services that can grow to Internet scale. Learn how you can make smart application architecture decisions and follow best practices so that your website can handle tens of thousands of concurrent users and deliver your content globally. Author Rob Reagan takes you through key Azure technologies targeted toward building web applications, and along the way shares his lessons learned in scaling out a real-world web application. After an overview of web application building blocks, the book dives into relational and NoSQL data storage options on Azure, including Azure Table Storage and CosmosDB. You'll then discover how to make best use of Redis Cache, Web Jobs, Messaging Queues, and more, alongside other tips, tricks, and troubleshooting advice for when things go wrong. The book concludes with a thorough exploration of best practices for deployment at scale. What You'll Learn Develop scalable architecture patterns on Azure with ASP.NET MVC Understand the pros and cons of using SQL Azure vs. NoSQL solutions (Azure Tables, CosmosDB) Perform data migration, backup, and recovery in SQL Azure Use effective caching Troubleshoot your web applications Know best practices for deployment Who This Book Is For Professional developers or serious hobbyists with experience developing web applications with ASP.NET MVC or Web API

Build fast, reliable web applications using the latest web development technologies. This book provides step-by-step learning through the process of transforming a "traditional" web app into a high-performing progressive web app, leveraging principles and lessons taught throughout the book. You will learn to improve the performance, reliability, reach, and user engagement of mobile web applications through the use of specific, practical examples. Because most non-trivial web applications developed today use JavaScript frameworks, you will learn about the most popular frameworks offering a PWA right out of the box, including React, Preact, Vue.js, Angular, and Ionic. You also will learn which tools to enlist to measure your application's performance, such as Google's Lighthouse. Beginning Progressive Web App Development includes best practices to make your app work even when an end user has a poor or no Internet connection, and to send notifications and reminders with the Notification and Push APIs to keep your users engaged. You will come away with an understanding of the technologies-application shells, server push technology, and caching-that will allow you to rapidly deliver content to your users. As important as it is to provide mobile users with a great experience, the principles of PWAs are not limited to smartphones. Most of what you will learn in this book is directly applicable to web applications on all screen sizes. What You'll Learn Achieve nearly instant loading times Implement service workers to make your app load faster and work while users are offline Keep users engaged with web notifications Measure the performance and reach of your web applications Transform your existing web app into a progressive web app Create a progressive web app from scratch Understand what building a truly fast web app entails with Google's PRPL pattern Who This Book Is For Web developers with prior JavaScript experience

Discover all the new features and changes in Java 9, including module systems-JPMS or Project Jigsaw. This book covers the whole Java application development life cycle. You'll review all the important concepts, including module descriptor, unnamed module, automatic module, and command line tools. Exploring Java 9 also serves as a practical guide for migration to module systems. Code samples from real-world scenarios solidify a foundation for learning and development and allow you to apply best practices in actual development. Additionally, you'll learn about concurrency, ECMAScript 6 features in Nashorn and Parser API, stack-walking API, Stream and Optional, utilities classes, and I/O. And it's now possible to build modularized applications in Java. You'll see how JPMS affects not only the JDK itself, but also applications that are developed upon it. What You'll Learn * Build modularized applications in Java * Migrate to module systems * Master enhanced method handles Who This Book Is ForJava developers with basic development skills

Discover how to take your existing web development skills and learn how to create desktop applications for macOS, Windows, and Linux, using GitHub's Electron. Learn how to combine the power of Node.js and Chromium to provide a powerful development platform for creating web applications that break free from the browser. Electron: From Beginner to Pro guides you through the capabilities that you have available to create desktop applications. Learn to use features like file system access, create native menus, OS-specific dialogs and more. The authors will show you how to package your application for distribution for multiple platforms and enable auto-updating. What You Will Learn Leverage your knowledge of HTML, CSS and JavaScript Use current web applications for the desktop Create and use Electron's main process and render process to create effective desktop applications Communicate between processes and between windows Build desktop applications that can be updated and distributed Who This Book Is For Web developers looking to leverage their HTML, CSS and JavaScript skills to create desktop widgets and applications. Developers wanting to leverage existing a Web application to extend functionality with a desktop application.

Plan how to build a better app, grow it into a business, and earn money from your hard work using Firebase. In this book, Laurence Moroney, Staff Developer Advocate at Google, takes you through each of the 15 Firebase technologies, showing you how to use them with concrete examples. You'll see how to build cross-platform apps with the three pillars of the Firebase platform: technologies to help you develop apps with a real-time database, remote configuration, cloud messaging, and more; grow your apps with user sharing, search integration, analytics, and more; and earn from your apps with in-app advertising. After reading The Definitive Guide to Firebase, you'll come away empowered to make the most of this technology that helps you build better cross-platform mobile apps using either native Android or JavaScript-based web apps and effectively deploy them in a cloud environment. What You'll Learn Use the real-time database for a codeless middleware that gives online and offline data for syncing across your users' devices Master Firebase Cloud Messaging, a technology that delivers to connected devices in less than 500ms Grow your app organically with technologies such App Indexing, App Invites, and Dynamic Links Understand problems when they arise with crash reporting Fix user problems without direct access to users' devices Tie it all together with analytics that give you great intelligence about how users interact with your app Who This Book Is For Experienced Android, mobile app developers new to Firebase. This book is also for experienced web developers looking to build and deploy web apps for smartphones and tablets, too, who may be new or less experienced with mobile programming.

This book provides an account of the use of computational tactical metrics in improving sports analysis, in particular the use of Global Positioning System (GPS) data in soccer. As well as offering a practical perspective on collective behavioural analysis, it introduces the computational metrics available in the literature that allow readers to identify collective behaviour and patterns of play in team sports. These metrics only require the bio-dimensional geo-referencing information from GPS or video-tracking systems to provide qualitative and quantitative information about the tactical behaviour of players and the inter-relationships between teammates and their opponents. Exercises, experimental cases and algorithms enable readers to fully comprehend how to compute these metrics, as well as introducing them to the ultimate performance analysis tool, which is the basis to run them on. The script to compute the metrics is presented in Python. The book is a valuable resource for professional analysts as well students and researchers in the field of sports analysis wanting to optimise the use of GPS trackers in soccer.

Embrace machine learning approaches and Python to enable automatic rendering of rich insights and solve business problems. The book uses a hands-on case study-based approach to crack real-world applications to which machine learning concepts can be applied. These smarter machines will enable your business processes to achieve efficiencies on minimal time and resources. Python Machine Learning Case Studies takes you through the steps to improve business processes and determine the pivotal points that frame strategies. You'll see machine learning techniques that you can use to support your products and services. Moreover you'll learn the pros and cons of each of the machine learning concepts to help you decide which one best suits your needs. By taking a step-by-step approach to coding in Python you'll be able to understand the rationale behind model selection and decisions within the machine learning process. The book is equipped with practical examples along with code snippets to ensure that you understand the data science approach to solving real-world problems. What You Will Learn Gain insights into machine learning concepts Work on real-world applications of machine learning Learn concepts of model selection and optimization Get a hands-on overview of Python from a machine learning point of view Who This Book Is For Data scientists, data analysts, artificial intelligence engineers, big data enthusiasts, computer scientists, computer sciences students, and capital market analysts.

Become a better, more productive programmer through a series of projects that will help you deeply understand and master each of the design patterns covered. In this book you will learn to write elegant "Pythonic" code to solve common programming problems. You will also experience design thinking, by identifying design patterns that would be helpful given a specific problem or situation. Python is eating the world. In recent years it has become so much more than a mere object-oriented, scripting language. Design patterns help you think of and solve problems in chunks. They help you to stand on the shoulders of the giants who have come before, instead of having to reinvent the wheel. What You Will Learn Craft cleaner code Increase your effectiveness as a programmer Write more Pythonic code Solve bigger problems Discover optimal solutions to common problems, done in a way that is uniquely Pythonic Who This Book Is For Programmers who are comfortable with Python. It is also guide for people who have mastered other programming languages and who want to make the transition to Python.