Sample chapters
Installing and configuring SQL Server instances and features
- By Sven Aelterman, William Assaf, Joseph D'Antoni, Louis Davidson, Randolph West, Melody ZachariasApr 16, 2020
In this sample chapter from SQL Server 2019 Administration Inside Out, the authors review the process of installing and configuring a Microsoft SQL Server instance as well as the creation or migration of databases.
Objective group 2. Manage data cells and ranges
- By Joan LambertApr 16, 2020
In this sample chapter from the MOS Study Guide for Microsoft Excel Exam MO-200, author Joan Lambert explains the skills tested in the section of the Microsoft Office Specialist exam for Microsoft Excel 2019 related to managing cells and cell content in worksheets. This includes manipulating data in worksheets, formatting cells and ranges, defining and referencing named ranges, and summarizing data visually.
Azure Sentinel - An Introduction
- By Yuri Diogenes, Nicholas DiCola, Jonathan TrullMar 17, 2020
- In this chapter from Microsoft Azure Sentinel, Yuri Diogenes, Nicholas DiCola, and Jonathan Trull explain the architecture, design considerations, and initial configuration of Azure Sentinel.
Manage and Format Data in Excel
- By Paul McFedriesMar 10, 2020
- In this excerpt from MOS Study Guide for Microsoft Excel Expert Exam MO-201 Microsoft Office expert Paul McFedries illustrates methods for filling cells based on existing data, formatting and validating data, and applying advanced conditional formatting and filtering.
Understand Cloud Services and Computing Concepts
- By Craig ZackerFeb 8, 2020
- In this sample chapter from Exam Ref MS-900 Microsoft 365 Fundamentals, Craig Zacker details the benefits and considerations of using cloud services and different types of cloud services available.
Mapping Problems and Algorithms with Machine Learning
- By Dino Esposito, Francesco EspositoFeb 2, 2020
- In this excerpt from Introducing Machine Learning, Dino and Francesco Esposito identify the classes of problems that machine learning can realistically address and the algorithms known to be appropriate for each class. They also introduce an automated machine learning approach that can automate the selection of the best machine learning pipeline for a given problem and a given dataset.
Implement workloads and security
- By Mike Pfeiffer, Derek Schauland, Nicole Stevens, Timothy L. WarnerNov 20, 2019
In this sample chapter from Exam Ref AZ-300 Microsoft Azure Architect Technologies, the authors help you understand how you can bring your existing workloads to Azure by allowing the use of some familiar resources (IaaS Virtual Machines) and others that may be new (serverless computing) to your environment. In addition, the use of Multi-Factor Authentication (MFA) is covered here to ensure your cloud environment is as secure as possible.
Develop Azure Infrastructure as a Service Compute Solution
- By Santiago Fernández MuñozNov 12, 2019
In this sample chapter from Exam Ref AZ-203 Developing Solutions for Microsoft Azure, author Santiago Fernández Muñoz reviews how to work with the options that Azure makes available to you for developing your solutions based on the Infrastructure as a Service model.
- By Itzik Ben-GanNov 4, 2019
In this sample chapter from T-SQL Window Functions: For data analysis and beyond, 2nd Edition, author Itzik Ben-Gan provides extensive coverage of window functions, their optimization, and querying solutions implementing them. This chapter starts by explaining the concept, and it provides a background of window functions, a glimpse of solutions using windows functions, coverage of the elements involved in window specifications, an account of the query elements supporting window functions, and a description of the standard’s solution for reusing window definitions.
- By Yuri Diogenes, Tom ShinderOct 5, 2019
In this sample chapter from Microsoft Azure Security Center, 2nd Edition, authors Yuri Diogenes and Tom Shinder discuss cybercrime, the motivation of hackers, and how you can detect and prevent attacks.
Deploy and Update Operating Systems
- By Andrew Bettany, Andrew WarrenAug 13, 2019
In this sample chapter from Exam Ref MD-101 Managing Modern Desktops, authors Bettany and Warren help you learn to plan and implement Windows 10 using dynamic deployment and Windows Autopilot.
Introduction: This book is for you…
- By John McCabe, Ward RalstonAug 13, 2019
In this sample chapter from Modernizing the Datacenter with Windows Server and Hybrid Cloud, authors McCabe and Ralston help you embrace change as an IT professional. This book talks about various concepts and ideologies, all of which are designed to help you build a toolkit of thought. This is a reference book to help you structure your approach by giving you scenarios to see where you can attach to and implement or iterate on what makes sense for the positions you are in.
Design and implement Microsoft 365 services
- By Orin ThomasJul 23, 2019
In this sample chapter from Exam Ref MS-100 Microsoft 365 Identity and Services, author Orin Thomas teaches the skills of how to manage domains, plan a Microsoft 365 implementation, set up Microsoft 365 tenancy and subscription, manage Microsoft 365 subscription and tenant health, and plan migration of users and data.
- By Alberto Ferrari, Marco RussoJul 20, 2019
In this sample chapter from The Definitive Guide to DAX, authors Russo and Ferrari start talking about the DAX language. Here you learn the syntax of the language, the difference between a calculated column and a measure (also called calculated field, in certain old Excel versions), and the most commonly used functions in DAX.
- By Andrew Bettany, Andrew WarrenJul 9, 2019
In this sample chapter from Exam Ref MD-100 Windows 10, authors Andrew Bettany and Andrew Warren explain how to deploy Windows 10 and how to perform post-installation configuration. The MD-100 Windows 10 exam focuses on how to install Windows 10 efficiently and with the least amount of administrative effort.
- By Jim CheshireJun 21, 2019
In this sample chapter from Exam Ref AZ-900 Microsoft Azure Fundamentals, author Jim Cheshire covers the benefits of using the cloud, the different cloud services that are available, and cloud models that enable a variety of cloud configurations.
Implement modern device services
- By Robert Clements, Brian SvidergolJun 14, 2019
In this sample chapter from Exam Ref MS-101 Microsoft 365 Mobility and Security, we are working with cloud-based services within Microsoft 365 that are designed to deploy, secure, and manage devices in the enterprise. Throughout this book we will be working with various Microsoft technologies such as Azure, Microsoft Intune, Office 365, and System Center Configuration Manager (ConfigMgr). Along the way there will be several walkthroughs and examples that illustrate how to manage these tools. For these demonstrations we do recommend that you follow along in your own lab.
- By Cindy M. Lewis, Carl Chatfield, Timothy JohnsonMay 25, 2019
In this sample chapter from Microsoft Project 2019 Step by Step, you'll learn to create a new plan using Project A project’s schedule or plan is essentially a model that you construct for some project aspects that you are anticipating—what you expect will happen, or what you want to happen. This model focuses on certain key aspects of a project, such as tasks, resources, time frames, and possible associated costs.
- By Wayne WinstonApr 15, 2019
In this sample chapter from Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition, author Wayne Winston covers the INDEX function. The INDEX function allows you to return the entry in any row and column within an array of numbers.
Sign up now
Microsoft Press Store newsletter and special offers
Subscribe