Develop programmatic functions to create powerful database applications About This Book Write complex SQL queries and design a robust database design that fits your application's need Improve database performance by indexing, partitioning tables, and query optimizing A comprehensive guide covering the advanced PostgreSQL concepts without any hassle Who This Book Is For If you are a PostgreSQL developer with a basic knowledge of PostgreSQL development and you’re want deeper knowledge to develop applications, then this book is for you. As this book does not cover basic installation and configurations, you should have PostgreSQL installed on your machine as a prerequisite. What You Will Learn Write more complex queries with advanced SQL queries Design a database that works with the application exactly the way you want Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing Develop applications in other programming languages such as Java and PHP Use extensions to get extra benefits in terms of functionality and performance Build an application that does not get locked by data manipulation Explore in-built db functions and data type conversions In Detail PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it’s difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database. The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts Style and approach Every chapter follows a step by step approach that first explains the concept , then shows you how to execute it practically so that you can implement them in your application.

Learn how to build physical computing systems using BeagleBone Black and Python About This Book Get to grips with the fundamentals of BeagleBone Leverage Python *s to program BeagleBone for your requirements Build four exciting projects, from home automation to a tele-controlled robot Who This Book Is For This book is intended for hobbyists and consumers who wish to create impressive projects using BeagleBone. You must be familiar with Python programming. What You Will Learn Program on BeagleBone Black using Python Interface sensors and actuators to BeagleBone Black Build your own real-time physical computing systems Connect physical computing systems to cloud servers Build your own home automation and home security system Build your own tele-controlled robot with real-time video streaming In Detail BeagleBone is a low cost, community-supported development platform to develop a variety of electronic projects. This book will introduce you to BeagleBone and get you building fun, cool, and innovative projects with it. Start with the specifications of BeagleBone Black and its operating systems, then get to grips with the GPIOs available in BeagleBone Black. Work through four types of exciting projects: building real-time physical computing systems, home automation, image processing for a security system, and building your own tele-controlled robot and learn the fundamentals of a variety of projects in a single book. By the end of this book, you will be able to write code for BeagleBone in order to operate hardware and impart decision-making capabilities with the help of efficient coding in Python. Style and approach This book is a step by step guide that will walk you through the fundamentals of building different projects using BeagleBone Black.

Combine the power of ASP.NET Core with Bootstrap 4 to build elegant, responsive web apps About This Book Updated for Bootstrap 4 and ASP.Net MVC 6, this book shows how to take advantage of the latest new features introduced in both of these industry-leading frameworks Build responsive, mobile-ready apps by combining the power of ASP.NET MVC with Bootstrap Grasp the intricacies of Bootstrap and how to use it with ASP.NET MVC Build your own tools and helpers to assist you in creating ASP.NET MVC Bootstrap sites easily and quickly Master the use of Bootstrap components and plugins with ASP.NET MVC Who This Book Is For If you are an ASP.NET MVC developer and would like to know how to incorporate Bootstrap into your projects, then this book is invaluable to you. Developers with entry-level experience of ASP.NET MVC development and limited experience with Bootstrap will also benefit from this book. What You Will Learn Create a new ASP.NET MVC project that uses Bootstrap for its styling and learn how to include external libraries using the new package managers Learn to use the various Bootstrap CSS and HTML elements, and how to use the new Bootstrap 4 grid layout system Explore the different input groups and implement alerts, progress bars, and badges Explore JavaScript components by illustrating and walking through the process of using JavaScript/jQuery to add interactivity to Twitter Bootstrap components Build your own ASP.NET MVC helpers and tag helpers to reduce the amount of HTML needed to generate Bootstrap elements Convert a Bootstrap HTML template into a usable ASP.NET MVC project Use the jQuery DataTables plugin with Bootstrap and ASP.NET MVC In Detail One of the leading open source frontend frameworks, Bootstrap has undergone a significant change and introduced several features that make designing compelling, next-generation UIs much simpler. Integrating Bootstrap with ASP.NET's powerful components can further enhance its capabilities. This book guides you through the process of creating an ASP.NET MVC website from scratch using Bootstrap. After a primer on the fundamentals of Bootstrap, you will learn your way around and create a new ASP.NET MVC project in Visual Studio. You will move on to learn about the various Bootstrap components as well as techniques to include them in your own projects. The book includes practical examples to show you how to use open-source plugins with Bootstrap and ASP.NET MVC and guides you through building an ASP.NET MVC website using Bootstrap, utilizing layout and user-interface components. At the end of this book, you will find some valuable tips and tricks to help you get the most out of your Bootstrap-integrated and ASP.NET MVC-integrated website. Style and approach This is a compact, step-by-step guide that focuses on combining the power of Bootstrap with ASP.Net MVC to build next-generation web apps. With clear instructions, this book will show how to build a complete ASP.Net MVC-integrated web app from scratch using Bootstrap. It will also cover several tricks for integrating Bootstrap and ASP.Net MVC, and getting the most out of both frameworks.

Explore the features of Unity 5 for 2D game development by building three amazing game projects About This Book Explore the 2D architecture of Unity 5, and the tools and techniques for developing 2D games Discover how to use Unity’s 2D tools, including Sprites, physics, and maps, to create different genres of games Practical tutorial on the intermediate and advanced development concepts in Unity 5 to create three interesting and fully functional games Who This Book Is For If you've got the basics of 2D development down, push your skills with the projects in this hands-on guide.Diversify your portfolio and learn the skills needed to build a range of awesome 2D game genres. What You Will Learn Explore and understand the vital role of sprites in 2D games Move, animate, and integrate sprites into a 2D platform game Set up User Interfaces (UIs) to keep track of the progress through the games Apply 2D Physics to improve gameplay believability Learn the foundation of Level Design and how to quickly create 2D Maps Discover NPC design, event triggers, and AI programming Create an epic strategy game, challenging all the skills acquired in the book In Detail Flexible, powerful, and full of rich features, Unity 5 is the engine of choice for AAA 2D and 3D game development. With comprehensive support for over 20 different platforms, Unity boasts a host of great new functions for making 2D games. Learn how to leverage these new options into awesome 2D games by building three complete game projects with the Unity game tutorials in this hands-on book. Get started with a quick overview of the principle concepts and techniques needed for making 2D games with Unity, then dive straight in to practical development. Build your own version of Super Mario Brothers as you learn how to animate sprites, work with physics, and construct brilliant UIs in order to create a platformer game. Go on a quest to create a RPG game discovering NPC design, event triggers, and AI programming. Finally, put your skills to the test against a real challenge - designing and constructing a complex strategy game that will draw on and develop all your previously learned skills. Style and approach This is a practical and easy-to-follow guide that starts with the basics and gradually delves into the process of creating 2D games. With step-by-step instructions on how to build three games, followed by a detailed explanation of each example, you will understand the concepts not just in theory, but also by applying the knowledge you gain in practice.

Discover how to build your own smart Internet of Things projects and bring a new degree of interconnectivity to your world About This Book Learn how to extract and analyse data from physical devices and build smart IoT projects Master the skills of building enticing projects such as a neural network autonomous car, computer vision through a camera, and cloud-based IoT applications This project-based guide leverages revolutionary computing chips such as Raspberry Pi, Arduino, and so on Who This Book Is For If you are hobbyist who is keen on making smart IoT projects, then this book is for you. You should have a basic knowledge of Python. What You Will Learn Implement data science in your IoT projects and build a smart temperature controller Create a simple machine learning application and implement decision system concepts Develop a vision machine using OpenCV Build a robot car with manual and automatic control Implement speech modules with your own voice commands for IoT projects Connect IoT to a cloud-based server In Detail Internet of Things (IoT) is a groundbreaking technology that involves connecting numerous physical devices to the Internet and controlling them. Creating basic IoT projects is common, but imagine building smart IoT projects that can extract data from physical devices, thereby making decisions by themselves. Our book overcomes the challenge of analyzing data from physical devices and accomplishes all that your imagination can dream up by teaching you how to build smart IoT projects. Basic statistics and various applied algorithms in data science and machine learning are introduced to accelerate your knowledge of how to integrate a decision system into a physical device. This book contains IoT projects such as building a smart temperature controller, creating your own vision machine project, building an autonomous mobile robot car, controlling IoT projects through voice commands, building IoT applications utilizing cloud technology and data science, and many more. We will also leverage a small yet powerful IoT chip, Raspberry Pi with Arduino, in order to integrate a smart decision-making system in the IoT projects. Style and approach The book follows a project-based approach to building smart IoT projects using powerful boards such as the Raspberry Pi, Arduino, and the IoT chip.

Learn a modern approach to data analysis using Python to harness the power of programming and AI across your data. Detailed case studies bring this modern approach to life across visual data, social media, graph algorithms, and time series analysis. Key Features *Bridge your data analysis with the power of programming, complex algorithms, and AI *Use Python and its extensive libraries to power your way to new levels of data insight *Work with AI algorithms, TensorFlow, graph algorithms, NLP, and financial time series *Explore this modern approach across with key industry case studies and hands-on projects Book Description Data Analysis with Python offers a modern approach to data analysis so that you can work with the latest and most powerful Python tools, AI techniques, and open source libraries. Industry expert David Taieb shows you how to bridge data science with the power of programming and algorithms in Python. You'll be working with complex algorithms, and cutting-edge AI in your data analysis. Learn how to analyze data with hands-on examples using Python-based tools and Jupyter Notebook. You'll find the right balance of theory and practice, with extensive code files that you can integrate right into your own data projects. Explore the power of this approach to data analysis by then working with it across key industry case studies. Four fascinating and full projects connect you to the most critical data analysis challenges you’re likely to meet in today. The first of these is an image recognition application with TensorFlow – embracing the importance today of AI in your data analysis. The second industry project analyses social media trends, exploring big data issues and AI approaches to natural language processing. The third case study is a financial portfolio analysis application that engages you with time series analysis - pivotal to many data science applications today. The fourth industry use case dives you into graph algorithms and the power of programming in modern data science. You'll wrap up with a thoughtful look at the future of data science and how it will harness the power of algorithms and artificial intelligence. What you will learn *A new toolset that has been carefully crafted to meet for your data analysis challenges *Full and detailed case studies of the toolset across several of today’s key industry contexts *Become super productive with a new toolset across Python and Jupyter Notebook *Look into the future of data science and which directions to develop your skills next Who this book is for This book is for developers wanting to bridge the gap between them and data scientists. Introducing PixieDust from its creator, the book is a great desk companion for the accomplished Data Scientist. Some fluency in data interpretation and visualization is assumed. It will be helpful to have some knowledge of Python, using Python libraries, and some proficiency in web development.

Explore a diverse set of meta-learning algorithms and techniques to enable human-like cognition for your machine learning models using various Python frameworks Key Features *Understand the foundations of meta learning algorithms *Explore practical examples to explore various one-shot learning algorithms with its applications in TensorFlow *Master state of the art meta learning algorithms like MAML, reptile, meta SGD Book Description Meta learning is an exciting research trend in machine learning, which enables a model to understand the learning process. Unlike other ML paradigms, with meta learning you can learn from small datasets faster. Hands-On Meta Learning with Python starts by explaining the fundamentals of meta learning and helps you understand the concept of learning to learn. You will delve into various one-shot learning algorithms, like siamese, prototypical, relation and memory-augmented networks by implementing them in TensorFlow and Keras. As you make your way through the book, you will dive into state-of-the-art meta learning algorithms such as MAML, Reptile, and CAML. You will then explore how to learn quickly with Meta-SGD and discover how you can perform unsupervised learning using meta learning with CACTUs. In the concluding chapters, you will work through recent trends in meta learning such as adversarial meta learning, task agnostic meta learning, and meta imitation learning. By the end of this book, you will be familiar with state-of-the-art meta learning algorithms and able to enable human-like cognition for your machine learning models. What you will learn *Understand the basics of meta learning methods, algorithms, and types *Build voice and face recognition models using a siamese network *Learn the prototypical network along with its variants *Build relation networks and matching networks from scratch *Implement MAML and Reptile algorithms from scratch in Python *Work through imitation learning and adversarial meta learning *Explore task agnostic meta learning and deep meta learning Who this book is for Hands-On Meta Learning with Python is for machine learning enthusiasts, AI researchers, and data scientists who want to explore meta learning as an advanced approach for training machine learning models. Working knowledge of machine learning concepts and Python programming is necessary.

Create and maintain powerful Bash scripts for automation and administration. Key Features *Get up and running with Linux shell scripting using real-world examples *Leverage command-line techniques and methodologies to automate common yet complex administration tasks *A practical guide with exposure to scripting constructs and common scripting patterns Book Description Shell scripts allow us to program commands in chains and have the system execute them as a scripted event, just like batch files. This book will start with an overview of Linux and Bash shell scripting, and then quickly deep dive into helping you set up your local environment, before introducing you to tools that are used to write shell scripts. The next set of chapters will focus on helping you understand Linux under the hood and what Bash provides the user. Soon, you will have embarked on your journey along the command line. You will now begin writing actual scripts instead of commands, and will be introduced to practical applications for scripts. The final set of chapters will deep dive into the more advanced topics in shell scripting. These advanced topics will take you from simple scripts to reusable, valuable programs that exist in the real world. The final chapter will leave you with some handy tips and tricks and, as regards the most frequently used commands, a cheat sheet containing the most interesting flags and options will also be provided. After completing this book, you should feel confident about starting your own shell scripting projects, no matter how simple or complex the task previously seemed. We aim to teach you how to script and what to consider, to complement the clear-cut patterns that you can use in your daily scripting challenges. What you will learn *Understand Linux and Bash basics as well as shell scripting fundamentals *Learn to write simple shell scripts that interact with Linux operating system *Build, maintain, and deploy scripts in a Linux environment *Learn best practices for writing shell scripts *Avoid common pitfalls associated with Bash scripting *Gain experience and the right toolset to write your own complex shell scripts Who this book is for This book targets new and existing Linux system administrators, Windows system administrators or developers who are interested in automating administrative tasks. No prior shell scripting experience is needed but in case you do this book will make a pro quickly. Readers should have a basic understanding of the command line.

The book requires no prior knowledge of JavaScript and works from the ground up to give you a thorough grounding in this powerful language. If you do already know some JavaScript, you will find plenty of eye-openers as you discover just what the language can do. This book takes a do-it-yourself approach when it comes to writing code, because the best way to really learn a programming language is by writing code. You are encouraged to type code into Firebug's console, see how it works and then tweak it and play around with it. There are practice questions at the end of each chapter to help review what you have learned.

This book is written for PHP developers who want to add custom features to Drupal. You will need to know the basics of PHP and MySQL programming, but no experience of programming Drupal is required, although you will be expected to be familiar with the basic operation of Drupal.

This book is for those who want to build sophisticated Java web applications quickly and easily. It assumes that the reader is reasonably comfortable with the Java programming language, but no knowledge of web technologies is needed. For experienced Servlet, JSP, or Struts developers, the book will show an alternative way that will allow them to raise their productivity to an incomparable level. With this book you will see that a contemporary component-based framework can be easy to learn and a pleasure to work with.

This book is the ideal introduction to theming with Drupal 5. If you want to create a striking new look for your Drupal website, this book is for you. Starting from the basics of theme setup and configuration, you will learn about the Drupal theming architecture and the PHPTemplate engine, and then move on to modifying existing themes and building new themes from scratch. Included is a complete guide to the various style sheets and themeable functions in Drupal 5, making this book a valuable resource even to experienced theme developers. It covers: Creating custom templates Basics of theming in pure PHP Modifying an existing PHPTemplate theme" a step-by-step guide Creating a new PHPTemplate theme" a step-by-step guide Working with forms The main requirements to make use of this book are knowledge of HTML, CSS, and a touch of creativity! Although this book aims to make Drupal theming accessible to designers, theming in Drupal 5 involves writing some PHP code, and a basic knowledge of PHP will be helpful.

This book is a practical tutorial with five detailed and carefully explained case studies to build new and effective mashup applications. If you feel confident with your PHP programming, familiar with the basics of HTML and CSS, unafraid of XML, and interested in mashing things up, this is the book for you! There are a lot of formats and protocols, web services and web APIs encountered in this book ” you do not need to know anything about them or about AJAX; you will find all you need in the book.

This book is a practical tutorial to get you confident and comfortable working with the Microsoft AJAX suite. Packed with step-by-step examples and detailed explanations of how the examples work, this book is the ideal first step into the exciting world of AJAX in ASP.NET This book has been written for ASP.NET developers entering the world of the ASP.NET AJAX Framework, and for existing ASP.NET AJAX developers looking for a more detailed tutorial on the client-side of the framework: the Microsoft AJAX Library.

This book is hands-on. As you work through the small business/e-commerce enabled example web site, you will learn how to install, upgrade, configure, and use the various basic features of the e107 Content Management System. The book contains a number of screen shots to reinforce that each step that you perform is correct. This book is primarily for entrepreneurs, small office/home office, small businesses and non-profit agencies who would like to have interactive, business and/or e-commerce web sites at a low cost without sacrificing power or usability. No knowledge of PHP programming, Apache, or MySQL is required.

Anyone interested in securing their networks with IPCop ” from those new to networking and firewalls, to networking and IT Professionals with previous experience of IPCop. No knowledge of Linux or IPCop is required.

This book is a step-by-step tutorial that guides you through the key steps in implementing best solutions for high availability and performance tuning. It is split into two distinct approaches: client and site side HA and optimization.Microsoft SCCM High Availability and Performance Tuning is for IT professionals and consultants working with Configuration Manager who wish to learn the skills to deploy a redundant and scalable solution.

An easy-to-follow guide to reveal the new features of Java EE 7 and how to efficiently utilize them.Given the main objectives pursued, this book targets three groups of people with a knowledge of the Java language. They are:Beginners in the Java EE platform who would like to have an idea about the main specifications of Java EE 7.Developers who have experimented with previous versions of Java EE and who would like to explore the new features of Java EE 7.Building architects who want to learn how to put together the various Java EE 7 specifications for building robust and secure enterprise applications

VMware vCloud Security provides the reader with in depth knowledge and practical exercises sufficient to implement a secured private cloud using VMware vCloud Director and vCloud Networking and Security.This book is primarily for technical professionals with system administration and security administration skills with significant VMware vCloud experience who want to learn about advanced concepts of vCloud security and compliance.

This book is a guide to building a rich web application using Grails. The approach taken for building the application is incremental and iterative; each chapter will produce a working addition to the application, or iterate over existing features, as well as introduce and carefully explain the new part of the Grails framework used. The book does not go into exhaustive de*ions of every detail of Grails. While there is a lot of code in the book, there are very few large code listings. As you will find, it is not necessary to write reams of code to get results using Groovy and Grails. This book is aimed at Java web developers looking for ways to build web applications quickly, and wanting to find out how it's done quickly. If you are frustrated with integrating the many different frameworks that are available for web development and want to get on with building slick web applications for your users, then this book is for you. Grails is built on the Groovy language, but experience in Groovy is not required, as you will learn enough about Groovy to understand how to use Grails.

This book is designed for readers who learn by doing and employs many examples and screenshots to let the reader dig in and start coding. This book isn't designed to be a reference; instead it has a practical, example-driven approach that teaches you by following along with the examples in the chapters. When you have completed this book, you will fully understand how the template system works, how to extend it when you have specialized needs, and how to optimize the performance and usability of your content. This book is for web developers and template authors who want to fully understand and utilize the Django template system. The reader should have completed the introductory tutorials on the Django project's website and some experience with the framework will be very helpful. Basic knowledge of Python and HTML is assumed.