SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
Introduction to Windows Containers
With the introduction of container support in Windows Server 2016, we open a world of opportunities that takes traditional monolithic applications on a journey to modernize them for better agility. Containers are a stepping stone that can help IT organizations understand what key items in modern IT environments, such as DevOps, Agile, Scrum, Infrastructure as Code, Continuous Integration, and Continuous Deployment, to name just a few, can do and how these organizations can adopt all of these elements and more to their enterprises. As a result of Microsoft's strong strategic partnership with Docker - the de facto standard in container management software - enterprises can minimize the time required to onboard and run Windows Containers. Docker presents a single API surface and standardizes tooling for working across public and private container solutions as well as Linux and Windows Container deployments. This is the next phase in IT evolution in which a direct replatform of code ...
With the introduction of container support in Windows Server 2016, we open a world of opportunities that takes traditional monolithic applications on a journey to modernize them for better agility. Containers are a stepping stone that can help IT organizations understand what key items in modern IT environments, such as DevOps, Agile, Scrum, Infrastructure as Code, Continuous Integration, and Continuous Deployment, to name just a few, can do and how these organizations can adopt all of these elements and more to their enterprises. As a result of Microsoft's strong strategic partnership with Docker - the de facto standard in container management software - enterprises can minimize the time required to onboard and run Windows Containers. Docker presents a single API surface and standardizes tooling for working across public and private container solutions as well as Linux and Windows Container deployments. This is the next phase in IT evolution in which a direct replatform of code ...
Automated Deep Learning Using Neural Network Intelligence
Optimize, develop, and design PyTorch and TensorFlow models for a specific problem using the Microsoft Neural Network Intelligence (NNI) toolkit. This book includes practical examples illustrating automated deep learning approaches and provides techniques to facilitate your deep learning model development. The first chapters of this book cover the basics of NNI toolkit usage and methods for solving hyper-parameter optimization tasks. You will understand the black-box function maximization problem using NNI, and know how to prepare a TensorFlow or PyTorch model for hyper-parameter tuning, launch an experiment, and interpret the results. The book dives into optimization tuners and the search algorithms they are based on: Evolution search, Annealing search, and the Bayesian Optimization approach. The Neural Architecture Search is covered and you will learn how to develop deep learning models from scratch. Multi-trial and one-shot searching approaches of automatic neural network design ...
Optimize, develop, and design PyTorch and TensorFlow models for a specific problem using the Microsoft Neural Network Intelligence (NNI) toolkit. This book includes practical examples illustrating automated deep learning approaches and provides techniques to facilitate your deep learning model development. The first chapters of this book cover the basics of NNI toolkit usage and methods for solving hyper-parameter optimization tasks. You will understand the black-box function maximization problem using NNI, and know how to prepare a TensorFlow or PyTorch model for hyper-parameter tuning, launch an experiment, and interpret the results. The book dives into optimization tuners and the search algorithms they are based on: Evolution search, Annealing search, and the Bayesian Optimization approach. The Neural Architecture Search is covered and you will learn how to develop deep learning models from scratch. Multi-trial and one-shot searching approaches of automatic neural network design ...
A Network Architect's Guide to 5G
As 5G transforms mobile usage and services, network professionals will need to significantly evolve their transport network architectures towards greater sophistication and stronger integration with radio networks, and facilitate transition towards cloud-native 5G mobile core. Until now, however, most 5G guides have foregrounded RF/radio and mobile core innovations, not its implications for data networks. A Network Architects Guide to 5G fills the gap, giving network architects, designers, and engineers essential knowledge for designing and planning their own 5G networks. Drawing on decades of experience with global service providers and enterprise networks, the authors illuminate new and evolving network technologies necessary for building 5G-capable networks, such as segment routing, network slicing, timing and synchronization, edge computing, distributed data centers, integration with public cloud, and more. They explain how 5G blurs boundaries between mobile core, radio access, ...
As 5G transforms mobile usage and services, network professionals will need to significantly evolve their transport network architectures towards greater sophistication and stronger integration with radio networks, and facilitate transition towards cloud-native 5G mobile core. Until now, however, most 5G guides have foregrounded RF/radio and mobile core innovations, not its implications for data networks. A Network Architects Guide to 5G fills the gap, giving network architects, designers, and engineers essential knowledge for designing and planning their own 5G networks. Drawing on decades of experience with global service providers and enterprise networks, the authors illuminate new and evolving network technologies necessary for building 5G-capable networks, such as segment routing, network slicing, timing and synchronization, edge computing, distributed data centers, integration with public cloud, and more. They explain how 5G blurs boundaries between mobile core, radio access, ...
Even You Can Learn Statistics and Analytics, 4th Edition
This book discusses statistics and analytics using plain language and avoiding mathematical jargon. If you thought you couldnt learn these data analysis subjects because they were too technical or too mathematical, this book is for you! This edition delivers more everyday examples and end-of-chapter exercises and contains updated instructions for using Microsoft Excel. Youll use downloadable data sets and spreadsheet solutions, template-based solutions you can put right to work. Using this book, you will understand the important concepts of statistics and analytics, including learning the basic vocabulary of these subjects. Create tabular and visual summaries and learn to avoid common charting errors; Gain experience working with common descriptive statistics measures including the mean, median, and mode; and standard deviation and variance, among others; Understand the probability concepts that underlie inferential statistics; Learn how to apply hypothesis tests, using Z, t, chi ...
This book discusses statistics and analytics using plain language and avoiding mathematical jargon. If you thought you couldnt learn these data analysis subjects because they were too technical or too mathematical, this book is for you! This edition delivers more everyday examples and end-of-chapter exercises and contains updated instructions for using Microsoft Excel. Youll use downloadable data sets and spreadsheet solutions, template-based solutions you can put right to work. Using this book, you will understand the important concepts of statistics and analytics, including learning the basic vocabulary of these subjects. Create tabular and visual summaries and learn to avoid common charting errors; Gain experience working with common descriptive statistics measures including the mean, median, and mode; and standard deviation and variance, among others; Understand the probability concepts that underlie inferential statistics; Learn how to apply hypothesis tests, using Z, t, chi ...
Asynchronous Programming Succinctly
Unresponsive or sluggish applications can give the impression of a broken or low-quality app. Using asynchronous programming methods, apps can be made to function well even when performing other tasks. In Asynchronous Programming Succinctly, Dirk Strauss shows readers how to use Microsoft Visual Studio to create apps that function well even when performing tasks. ...
Unresponsive or sluggish applications can give the impression of a broken or low-quality app. Using asynchronous programming methods, apps can be made to function well even when performing other tasks. In Asynchronous Programming Succinctly, Dirk Strauss shows readers how to use Microsoft Visual Studio to create apps that function well even when performing tasks. ...
Deploying Windows 10
Get a head start deploying Windows 10 - with tips and best practices from experts in the field. This guide shows you how to deploy Windows 10 in an automated way without impacting end users by leveraging System Center Configuration Manager, which is the most used product to deploy Microsoft operating systems in the industry today. Windows 10 represents a major paradigm shift for Microsoft and the Windows ecosystem in general as we modernize the platform by introducing "as a service" capabilities. Hundreds of millions of devices are already running Windows 10 today. Businesses are beginning to evaluate the new capabilities of Windows 10, including Windows as a service, as part of their deployment plans. With Windows 7 recently transitioning into extended support, businesses need to begin planning for the future of their Windows operating system environment. Although there are many aspects to consider in managing a Windows device, one of the essential early stages of the lifecycle ...
Get a head start deploying Windows 10 - with tips and best practices from experts in the field. This guide shows you how to deploy Windows 10 in an automated way without impacting end users by leveraging System Center Configuration Manager, which is the most used product to deploy Microsoft operating systems in the industry today. Windows 10 represents a major paradigm shift for Microsoft and the Windows ecosystem in general as we modernize the platform by introducing "as a service" capabilities. Hundreds of millions of devices are already running Windows 10 today. Businesses are beginning to evaluate the new capabilities of Windows 10, including Windows as a service, as part of their deployment plans. With Windows 7 recently transitioning into extended support, businesses need to begin planning for the future of their Windows operating system environment. Although there are many aspects to consider in managing a Windows device, one of the essential early stages of the lifecycle ...
Data Engineering with Alteryx
Alteryx is a GUI-based development platform for data analytic applications. Data Engineering with Alteryx will help you leverage Alteryx's code-free aspects which increase development speed while still enabling you to make the most of the code-based skills you have. This book will teach you the principles of DataOps and how they can be used with the Alteryx software stack. You'll build data pipelines with Alteryx Designer and incorporate the error handling and data validation needed for reliable datasets. Next, you'll take the data pipeline from raw data, transform it into a robust dataset, and publish it to Alteryx Server following a continuous integration process. By the end of this Alteryx book, you'll be able to build systems for validating datasets, monitoring workflow performance, managing access, and promoting the use of your data sources. ...
Alteryx is a GUI-based development platform for data analytic applications. Data Engineering with Alteryx will help you leverage Alteryx's code-free aspects which increase development speed while still enabling you to make the most of the code-based skills you have. This book will teach you the principles of DataOps and how they can be used with the Alteryx software stack. You'll build data pipelines with Alteryx Designer and incorporate the error handling and data validation needed for reliable datasets. Next, you'll take the data pipeline from raw data, transform it into a robust dataset, and publish it to Alteryx Server following a continuous integration process. By the end of this Alteryx book, you'll be able to build systems for validating datasets, monitoring workflow performance, managing access, and promoting the use of your data sources. ...
Introducing Charticulator for Power BI
Create stunning and complex visualizations using the amazing new Charticulator custom visuals in Power BI. Charticulator offers users immense power to generate visuals and graphics. To a beginner, there are myriad settings and options that can be combined in what feels like an unlimited number of combinations, giving it the unfair label, "the DAX of the charting world". This is not true. This book is your start-to-finish guide to using Charticulator, a custom visual software that Microsoft integrated into Power BI Desktop so that Power BI users can create incredibly powerful, customized charts and graphs. You will learn the concepts that underpin the software, journeying through every building block of chart design, enabling you to combine these parts to create spectacular visuals that represent the story of your data. Unlike other custom Power BI visuals, Charticulator runs in a separate application window within Power BI with its own interface and requires a different set of ...
Create stunning and complex visualizations using the amazing new Charticulator custom visuals in Power BI. Charticulator offers users immense power to generate visuals and graphics. To a beginner, there are myriad settings and options that can be combined in what feels like an unlimited number of combinations, giving it the unfair label, "the DAX of the charting world". This is not true. This book is your start-to-finish guide to using Charticulator, a custom visual software that Microsoft integrated into Power BI Desktop so that Power BI users can create incredibly powerful, customized charts and graphs. You will learn the concepts that underpin the software, journeying through every building block of chart design, enabling you to combine these parts to create spectacular visuals that represent the story of your data. Unlike other custom Power BI visuals, Charticulator runs in a separate application window within Power BI with its own interface and requires a different set of ...
Learning Modern Linux
If you use Linux in development or operations and need a structured approach to help you dive deeper, this book is for you. Author Michael Hausenblas also provides tips and tricks for improving your workflow with this open source operating system. Whether you're a developer, software architect, or site reliability engineer, this hands-on guide focuses on ways to use Linux for your everyday needs, from development to office-related tasks. Along the way, you'll gain hands-on experience with modern Linux terminals and shells, and learn how to manage your workloads. You'll understand how to run Linux applications by using containers, systemd, modern filesystems, and immutable distros such as Flatcar and Bottlerocket. Use Linux as a modern work environment, rather than just from an admin perspective; Learn critical components such as the Linux kernel, terminal multiplexer, human-friendly shells, and portable shell scripting; Become familiar with access control, from file permissions t ...
If you use Linux in development or operations and need a structured approach to help you dive deeper, this book is for you. Author Michael Hausenblas also provides tips and tricks for improving your workflow with this open source operating system. Whether you're a developer, software architect, or site reliability engineer, this hands-on guide focuses on ways to use Linux for your everyday needs, from development to office-related tasks. Along the way, you'll gain hands-on experience with modern Linux terminals and shells, and learn how to manage your workloads. You'll understand how to run Linux applications by using containers, systemd, modern filesystems, and immutable distros such as Flatcar and Bottlerocket. Use Linux as a modern work environment, rather than just from an admin perspective; Learn critical components such as the Linux kernel, terminal multiplexer, human-friendly shells, and portable shell scripting; Become familiar with access control, from file permissions t ...