Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features * Discover T-SQL functionalities and services that help you interact with relational databases * Understand the roles, tasks and responsibilities of a T-SQL developer * Explore solutions for carrying out database querying tasks, database administration, and troubleshooting Book Description Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language that is used with Microsoft SQL Server and Azure SQL Database. This book will be a useful guide to learning the art of writing efficient T-SQL code in modern SQL Server versions, as well as the Azure SQL Database. The book will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting. In the later chapters, you will learn how to identify various T-SQL patterns and anti-patterns. This will help you analyze execution plans to gain insights into current performance, and determine whether or not a query is scalable. You will also learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will study how to leverage the built-in tools of SQL Server to shorten the time taken to address query performance and scalability issues. In the concluding chapters, the book will guide you through implementing various features, such as Extended Events, Query Store, and Query Tuning Assistant using hands-on examples. By the end of this book, you will have the skills to determine query performance bottlenecks, avoid pitfalls, and discover the anti-patterns in use. Foreword by Conor Cunningham, Partner Architect – SQL Server and Azure SQL – Microsoft What you will learn * Use Query Store to understand and easily change query performance * Recognize and eliminate bottlenecks that lead to slow performance * Deploy quick fixes and long-term solutions to improve query performance * Implement best practices to minimize performance risk using T-SQL * Achieve optimal performance by ensuring careful query and index design * Use the latest performance optimization features in SQL Server 2017 and SQL Server 2019 * Protect query performance during upgrades to newer versions of SQL Server Who this book is for This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues, through the help of practical examples. Previous knowledge of T-SQL querying is not required to get started on this book.

Master machine learning techniques with real-world projects that interface TensorFlow with R, H2O, MXNet, and other languages Key Features * Gain expertise in machine learning, deep learning and other techniques * Build intelligent end-to-end projects for finance, social media, and a variety of domains * Implement multi-class classification, regression, and clustering Book Description R is one of the most popular languages when it comes to exploring the mathematical side of machine learning and easily performing computational statistics. This Learning Path shows you how to leverage the R ecosystem to build efficient machine learning applications that carry out intelligent tasks within your organization. You'll tackle realistic projects such as building powerful machine learning models with ensembles to predict employee attrition. You'll explore different clustering techniques to segment customers using wholesale data and use TensorFlow and Keras-R for performing advanced computations. You’ll also be introduced to reinforcement learning along with its various use cases and models. Additionally, it shows you how some of these black-box models can be diagnosed and understood. By the end of this Learning Path, you’ll be equipped with the skills you need to deploy machine learning techniques in your own projects. This Learning Path includes content from the following Packt products: * R Machine Learning Projects by Dr. Sunil Kumar Chinnamgari * Mastering Machine Learning with R - Third Edition by Cory Lesmeister What you will learn * Develop a joke recommendation engine to recommend jokes that match users’ tastes * Build autoencoders for credit card fraud detection * Work with image recognition and convolutional neural networks * Make predictions for casino slot machine using reinforcement learning * Implement NLP techniques for sentiment analysis and customer segmentation * Produce simple and effective data visualizations for improved insights * Use NLP to extract insights for text * Implement tree-based classifiers including random forest and boosted tree Who this book is for If you are a data analyst, data scientist, or machine learning developer this is an ideal Learning Path for you. Each project will help you test your skills in implementing machine learning algorithms and techniques. A basic understanding of machine learning and working knowledge of R programming is necessary to get the most out of this Learning Path.

Create responsive eLearning content, including quizzes, demonstrations, simulations and Virtual Reality projects that fit on any device with Adobe Captivate 2019 Key Features * Build responsive, interactive and highly engaging eLearning content with Adobe Captivate 2019 * Build Virtual Reality eLearning experiences with Adobe Captivate 2019 * Assess your student knowledge with interactive and random quizzes * Seamlessly integrate your eLearning content with any SCORM or xAPI compliant LMS Book Description Adobe Captivate is used to create highly engaging, interactive, and responsive eLearning content. This book takes you through the production of a few pieces of eLearning content, covering all the project types and workflows of Adobe Captivate. First, you will learn how to create a typical interactive Captivate project. This will give you the opportunity to review all Captivate objects and uncover the application's main tools. Then, you will use the built-in capture engine of Captivate to create an interactive software simulation and a Video Demo that can be published as an MP4 video. Then, you will approach the advanced responsive features of Captivate to create a project that can be viewed on any device. And finally, you will immerse your learners in a 360o environment by creating Virtual Reality projects of Adobe Captivate. At the end of the book, you will empower your workflow and projects with the newer and most advanced features of the application, including variables, advanced actions, JavaScript, and using Captivate 2019 with other applications. If you want to produce high quality eLearning content using a wide variety of techniques, implement eLearning in your company, enable eLearning on any device, assess the effectiveness of the learning by using extensive Quizzing features, or are simply interested in eLearning, this book has you covered! What you will learn * Learn how to use the objects in Captivate to build professional eLearning content * Enhance your projects by adding interactivity, animations, and more * Add multimedia elements, such as audio and video, to create engaging learning experiences * Use themes to craft a unique visual experience * Use question slides to create SCORM-compliant quizzes that integrate seamlessly with your LMS * Make your content fit any device with responsive features of Captivate * Create immersive 360° experiences with Virtual Reality projects of Captivate 2019 * Integrate Captivate with other applications (such as PowerPoint and Photoshop) to establish a professional eLearning production workflow * Publish your project in a wide variety of formats including HTML5 and Flash Who this book is for If you are a teacher, instructional designer, eLearning developer, or human resources manager who wants to implement eLearning, then this book is for you. A basic knowledge of your OS is all it takes to create the next generation of responsive eLearning content.

Master a range of machine learning domains with real-world projects using TensorFlow for R, H2O, MXNet, and more Key Features *Master machine learning, deep learning, and predictive modeling concepts in R 3.5 *Build intelligent end-to-end projects for finance, retail, social media, and a variety of domains *Implement smart cognitive models with helpful tips and best practices Book Description R is one of the most popular languages when it comes to performing computational statistics (statistical computing) easily and exploring the mathematical side of machine learning. With this book, you will leverage the R ecosystem to build efficient machine learning applications that carry out intelligent tasks within your organization. This book will help you test your knowledge and skills, guiding you on how to build easily through to complex machine learning projects. You will first learn how to build powerful machine learning models with ensembles to predict employee attrition. Next, you’ll implement a joke recommendation engine and learn how to perform sentiment analysis on Amazon reviews. You’ll also explore different clustering techniques to segment customers using wholesale data. In addition to this, the book will get you acquainted with credit card fraud detection using autoencoders, and reinforcement learning to make predictions and win on a casino slot machine. By the end of the book, you will be equipped to confidently perform complex tasks to build research and commercial projects for automated operations. What you will learn *Explore deep neural networks and various frameworks that can be used in R *Develop a joke recommendation engine to recommend jokes that match users’ tastes *Create powerful ML models with ensembles to predict employee attrition *Build autoencoders for credit card fraud detection *Work with image recognition and convolutional neural networks *Make predictions for casino slot machine using reinforcement learning *Implement NLP techniques for sentiment analysis and customer segmentation Who this book is for If you’re a data analyst, data scientist, or machine learning developer who wants to master machine learning concepts using R by building real-world projects, this is the book for you. Each project will help you test your skills in implementing machine learning algorithms and techniques. A basic understanding of machine learning and working knowledge of R programming is necessary to get the most out of this book.

Learn advanced state-of-the-art deep learning techniques and their applications using popular Python libraries Key Features *Build a strong foundation in neural networks and deep learning with Python libraries *Explore advanced deep learning techniques and their applications across computer vision and NLP *Learn how a computer can navigate in complex environments with reinforcement learning Book Description With the surge in artificial intelligence in applications catering to both business and consumer needs, deep learning is more important than ever for meeting current and future market demands. With this book, you’ll explore deep learning, and learn how to put machine learning to use in your projects. This second edition of Python Deep Learning will get you up to speed with deep learning, deep neural networks, and how to train them with high-performance algorithms and popular Python frameworks. You’ll uncover different neural network architectures, such as convolutional networks, recurrent neural networks, long short-term memory (LSTM) networks, and capsule networks. You’ll also learn how to solve problems in the fields of computer vision, natural language processing (NLP), and speech recognition. You'll study generative model approaches such as variational autoencoders and Generative Adversarial Networks (GANs) to generate images. As you delve into newly evolved areas of reinforcement learning, you’ll gain an understanding of state-of-the-art algorithms that are the main components behind popular games Go, Atari, and Dota. By the end of the book, you will be well-versed with the theory of deep learning along with its real-world applications. What you will learn *Grasp the mathematical theory behind neural networks and deep learning processes *Investigate and resolve computer vision challenges using convolutional networks and capsule networks *Solve generative tasks using variational autoencoders and Generative Adversarial Networks *Implement complex NLP tasks using recurrent networks (LSTM and GRU) and attention models *Explore reinforcement learning and understand how agents behave in a complex environment *Get up to date with applications of deep learning in autonomous vehicles Who this book is for This book is for data science practitioners, machine learning engineers, and those interested in deep learning who have a basic foundation in machine learning and some Python programming experience. A background in mathematics and conceptual understanding of calculus and statistics will help you gain maximum benefit from this book.

Convert Android to a powerful pentesting platform. Key Features * Get up and running with Kali Linux NetHunter * Connect your Android device and gain full control over Windows, OSX, or Linux devices * Crack Wi-Fi passwords and gain access to devices connected over the same network collecting intellectual data Book Description Kali NetHunter is a version of the popular and powerful Kali Linux pentesting platform, designed to be installed on mobile devices. Hands-On Penetration Testing with Kali NetHunter will teach you the components of NetHunter and how to install the software. You’ll also learn about the different tools included and how to optimize and use a package, obtain desired results, perform tests, and make your environment more secure. Starting with an introduction to Kali NetHunter, you will delve into different phases of the pentesting process. This book will show you how to build your penetration testing environment and set up your lab. You will gain insight into gathering intellectual data, exploiting vulnerable areas, and gaining control over target systems. As you progress through the book, you will explore the NetHunter tools available for exploiting wired and wireless devices. You will work through new ways to deploy existing tools designed to reduce the chances of detection. In the concluding chapters, you will discover tips and best practices for integrating security hardening into your Android ecosystem. By the end of this book, you will have learned to successfully use a mobile penetration testing device based on Kali NetHunter and Android to accomplish the same tasks you would traditionally, but in a smaller and more mobile form factor. What you will learn * Choose and configure a hardware device to use Kali NetHunter * Use various tools during pentests * Understand NetHunter suite components * Discover tips to effectively use a compact mobile platform * Create your own Kali NetHunter-enabled device and configure it for optimal results * Learn to scan and gather information from a target * Explore hardware adapters for testing and auditing wireless networks and Bluetooth devices Who this book is for Hands-On Penetration Testing with Kali NetHunter is for pentesters, ethical hackers, and security professionals who want to learn to use Kali NetHunter for complete mobile penetration testing and are interested in venturing into the mobile domain. Some prior understanding of networking assessment and Kali Linux will be helpful.

Begin writing graphical user interface(GUI) applications for building human machine interfaces with a clear understanding of key concepts of the Qt framework Key Features * Learn how to write, assemble, and build Qt application from the command line * Understand key concepts like Signals and Slots in Qt * Best practices and effective techniques for designing graphical user interfaces using Qt 5 Book Description Qt is a cross-platform application framework and widget toolkit that is used to create GUI applications that can run on different hardware and operating systems. The main aim of this book is to introduce Qt to the reader. Through the use of simple examples, we will walk you through building blocks without focusing too much on theory. Qt is a popular tool that can be used for building a variety of applications, such as web browsers, media players such as VLC, and Adobe Photoshop. Following Qt installation and setup, the book dives straight into helping you create your first application. You will be introduced to Widgets, Qt's interface building block, and the many varieties that are available for creating GUIs. Next, Qt's core concept of signals and slots are well illustrated with sufficient examples. The book further teaches you how to create custom widgets, signals and slots, and how to communicate useful information via dialog boxes. To cap everything off, you will be taken through writing applications that can connect to databases in order to persist data. By the end of the book, you should be well equipped to start creating your own Qt applications and confident enough to pick up more advanced Qt techniques and materials to hone your skills. What you will learn * Set up and configure your machine to begin developing Qt applications * Discover different widgets and layouts for constructing UIs * Understand the key concept of signals and slots * Understand how signals and slots help animate a GUI * Explore how to create customized widgets along with signals and slots * Understand how to subclass and create a custom windows application * Understand how to write applications that can talk to databases. Who this book is for Anyone trying to start development of graphical user interface application will find this book useful. One does not need prior exposure to other toolkits to understand this book. In order to learn from this book you should have basic knowledge of C++ and a good grasp of Object Oriented Programming. Familiarity with GNU/Linux will be very useful though it's not a mandatory skill.

Build complex, observable, and fault-tolerant serverless systems easily on Microsoft Azure. Key Features * Use serverless systems to help you fulfill complex requirements * Develop your knowledge of Azure Microsoft Serverless * Understand concepts with a hands-on approach and helpful examples Book Description Advanced Serverless Architectures with Microsoft Azure redefines your experience of designing serverless systems. It shows you how to tackle challenges of varying levels, not just the straightforward ones. You'll be learning how to deliver features quickly by building systems, which retain the scalability and benefits of serverless. You'll begin your journey by learning how to build a simple, completely serverless application. Then, you'll build a highly scalable solution using a queue, load messages onto the queue, and read them asynchronously. To boost your knowledge further, the book also features durable functions and ways to use them to solve errors in a complex system. You'll then learn about security by building a security solution from serverless components. Next, you’ll gain an understanding of observability and ways to leverage application insights to bring you performance benefits. As you approach the concluding chapters, you’ll explore chaos engineering and the benefits of resilience, by actively switching off a few of the functions within a complex system, submitting a request, and observing the resulting behavior. By the end of this book, you will have developed the skills you need to build and maintain increasingly complex systems that match evolving platform requirements. What you will learn * Understand what true serverless architecture is * Study how to extend and scale architectures until they become ‘complex' * Implement durable functions in your design * Improve the observability of your serverless architecture * Implement security solutions using serverless services * Learn how to ‘practise' chaos engineering in production Who this book is for Advanced Serverless Architectures with Microsoft Azure is is ideal if you want to build serverless systems with fewer outages and high performance using Azure. Familiarity with the C# syntax and Azure Functions and ARM templates will help you to benefit more from this book. Prior knowledge of basic front-end development, HTML JS, and CSS is beneficial but not essential. Some DevOps knowledge is also beneficial but not essential.

Understand and solve complex computational problems and write efficient code with Kotlin Key Features * Learn about important data structures such as lists, arrays, queues, and stacks * Design custom algorithms for real-life implementations * Identify suitable tools for different scenarios and deliver immediate results Book Description Data structures and algorithms are more than just theoretical concepts. They help you become familiar with computational methods for solving problems and writing logical code. Equipped with this knowledge, you can write efficient programs that run faster and use less memory. Hands-On Data Structures and Algorithms with Kotlin book starts with the basics of algorithms and data structures, helping you get to grips with the fundamentals and measure complexity. You'll then move on to exploring the basics of functional programming while getting used to thinking recursively. Packed with plenty of examples along the way, this book will help you grasp each concept easily. In addition to this, you'll get a clear understanding of how the data structures in Kotlin's collection framework work internally. By the end of this book, you will be able to apply the theory of data structures and algorithms to work out real-world problems. What you will learn * Understand the basic principles of algorithms and data structures * Explore general-purpose data structures with arrays and linked lists * Get to grips with the basics of stacks, queues, and double-ended queues * Understand functional programming and related data structures * Use performant searching and efficient sorting * Uncover how Kotlin's collection framework functions * Become adept at implementing different types of maps Who this book is for If you're a Kotlin developer who wants to learn the intricacies of implementing data structures and algorithms for scalable application development, this book is for you.

A comprehensive guide for MCSA Exam 70-740, that will help you prepare from day one to earn the valuable Microsoft Certificate Key Features * Leverage practice questions and mock tests to pass this certification with confidence * Learn to Install Windows Servers,implement high availability, and monitor server environments * Gain necessary skills to implement and configure storage and compute features Book Description MCSA: Windows Server 2016 certification is one of the most sought-after certifications for IT professionals, which includes working with Windows Server and performing administrative tasks around it. This book is aimed at the 70-740 certification and is part of Packt's three-book series on MCSA Windows Server 2016 certification, which covers Exam 70-740, Exam 70-741, and Exam 70-742. This book will cover exam objectives for the 70-740 exam, and starting from installing and configuring Windows Server 2016, Windows Server imaging and deployment to configuring and managing disks and volumes, implementing and configuring server storage and implementing Hyper-V. At the end of each chapter you will be provided test questions to revise your learnings which will boost your confidence in preparing for the actual certifications. By the end of this book, you will learn everything needed to pass the, MCSA Exam 70-740: Installation, Storage, and Compute with Windows Server 2016, certification. What you will learn * Install Windows Server 2016 * Upgrade and Migrate servers and workloads * Implement and configure server storage * Install and configure Hyper-V * Configure the virtual machine (VM) settings * Configure Hyper-V storage * Configure Hyper-V networking Who this book is for This book is ideal for system administrators interested in installing and configuring storage and compute features with Windows Sever 2016 and aiming to pass the 70-740 certification. Some experience with Windows Server in an enterprise environment is assumed.

Create dynamic dashboards to bring interactive data visualization to your enterprise using Qlik Sense Key Features * Implement various Qlik Sense features to create interactive dashboards * Analyze data easily and make business decisions faster using Qlik Sense * Perform self-service data analytics and geospatial analytics using an example-based approach Book Description Qlik Sense allows you to explore simple-to-complex data to reveal hidden insights and data relationships to make business-driven decisions. Hands-On Business Intelligence with Qlik Sense begins by helping you get to grips with underlying Qlik concepts and gives you an overview of all Qlik Sense’s features. You will learn advanced modeling techniques and learn how to analyze the data loaded using a variety of visualization objects. You’ll also be trained on how to share apps through Qlik Sense Enterprise and Qlik Sense Cloud and how to perform aggregation with AGGR. As you progress through the chapters, you’ll explore the stories feature to create data-driven presentations and update an existing story. This book will guide you through the GeoAnalytics feature with the geo-mapping object and GeoAnalytics connector. Furthermore, you’ll learn about the self-service analytics features and perform data forecasting using advanced analytics. Lastly, you’ll deploy Qlik Sense apps for mobile and tablet. By the end of this book, you will be well-equipped to run successful business intelligence applications using Qlik Sense's functionality, data modeling techniques, and visualization best practices. What you will learn * Discover how to load, reshape, and model data for analysis * Apply data visualization practices to create stunning dashboards * Make use of Python and R for advanced analytics * Perform geo-analysis to create visualizations using native objects * Learn how to work with AGGR and data stories Who this book is for If you’re a data analyst, BI developer, or interested in business intelligence and want to gain practical experience of working on Qlik Sense, this book is for you. You’ll also find it useful if you want to explore Qlik Sense’s next-generation applications for self-service business intelligence. No prior experience of working with Qlik Sense is required.

Build fast, robust, and maintainable modern full-stack web applications using MongoDB, Express, Angular, and Node.js. Key Features * Build highly scalable, asynchronous, and event-driven APIs * Develop a user authentication system with MEAN * Build a full-fledged application using the MEAN stack Book Description MongoDB, Express, Angular and Node.js Fundamentals is a practical guide to the tried-and-true production-ready MEAN stack, with tips and best practices. The book begins by demystifying the MEAN architecture. You’ll take a look at the features of the JavaScript libraries, technologies, and frameworks that make up a MEAN stack. With this book, you'll not only learn how to develop highly scalable, asynchronous, and event-driven APIs quickly with Express and Node.js, but you'll also be able put your full-stack skills to use by building two full-fledged MEAN applications from scratch. You’ll understand how to build a blogging application using the MEAN stack and get to grips with user authentication using MEAN. As you progress through the chapters, you’ll explore some old and new features of Angular, such as pipes, reactive forms, modules and optimizing apps, animations and unit testing, and much more. By the end of the book, you’ll get ready to take control of the MEAN stack and transform into a full-stack JavaScript developer, developing efficient web applications using Javascript technologies. What you will learn * Understand the MEAN architecture * Create RESTful APIs to complete CRUD tasks * Build a blogging application with basic features * Describe best practices to secure node applications * Implement authentication and authorization * Creating simple animations using Angular * Perform unit testing on Angular applications Who this book is for If you are a beginner or intermediate frontend developer who wants to become full-stack JavaScript developer, this book is ideal for you. You'll need some prior exposure to MongoDB as we skim over its basics before getting straight to work.