Computer certification: Microsoft Books

Book SynopsisCRAIG ZACKER is the author or co-author of dozens of books, manuals, articles, and websites on computing and networking, including Exam Ref 70-740 Installation, Storage and Compute with Windows Server 2016, and Exam Ref 70-744 Securing Windows Server 2016. He has also been an English professor, editor, network administrator, webmaster, corporate trainer, technical support engineer, minicomputer operator, literature and philosophy student, library clerk, darkroom technician, shipping clerk, and newspaper boy.Table of ContentsCHAPTER 1 Describe cloud concepts CHAPTER 2 Describe Microsoft 365 apps and services CHAPTER 3 Describe security, compliance, privacy, and trust in Microsoft 365 CHAPTER 4 Understand Microsoft 365 pricing and support CHAPTER 5 MS-900 Microsoft 365 Fundamentals, Second Edition exam updates

Read more less

Book SynopsisTable of ContentsChapter 1: Deploy and configure M365 tenants Chapter 2: Managing M365 users, groups, and identity synchronization Chapter 3: Managing Microsoft 365 Roles Chapter 4: Manage secure access and authentication Chapter 5: Manage security and threats using Microsoft 365 Defender Chapter 6: Manage Microsoft Purview compliance Chapter 7: MS-102 Microsoft 365 Administrator exam updates

Read more less

Book SynopsisTable of ContentsCHAPTER 1 Prepare the data CHAPTER 2 Model the data CHAPTER 3 Visualize and analyze the data CHAPTER 4 Deploy and maintain assets

Read more less

Book SynopsisCraig Zacker is the author or coauthor of dozens of books, manuals, articles, and websites on computer and networking topics. He has also been an English professor, a technical and copy editor, a network administrator, a webmaster, a corporate trainer, a technical support engineer, a minicomputer operator, a literature and philosophy student, a library clerk, a photographic darkroom technician, a shipping clerk, and a newspaper boy. He lives in a little house with his beautiful wife and a neurotic cat.Table of Contents1. Understand Cloud Concepts 2. Understand Core Microsoft 365 Services and Concepts 3. Understand Security, Compliance, Privacy, and Trust in Microsoft 365 4. Understand Microsoft 365 Pricing and Support

Read more less

Book SynopsisTable of Contents CHAPTER 1 Describe Artificial Intelligence workloads and considerations CHAPTER 2 Describe fundamental principles of machine learning on Azure CHAPTER 3 Describe features of computer vision workloads on Azure CHAPTER 4 Describe features of Natural Language Processing (NLP) workloads on Azure CHAPTER 5 Describe features of conversational AI workloads on Azure

Read more less

Book SynopsisCHARLES PLUTA is a technical consultant and Microsoft Certified Trainer who has authored several certification exams, lab guides, and learner guides for various technology vendors. As a technical consultant, Charles has assisted small, medium, and large organizations in deploying and maintaining their IT infrastructure. He is also a speaker, staff member, or trainer at several large industry conferences every year. Charles has a degree in Computer Networking and holds over 25 industry certifications. He makes a point to leave the United States to travel to a different country once every year. When not working on training or traveling, he plays pool in Augusta, Georgia.Table of ContentsCHAPTER 1 Design, implement, and manage hybrid networking CHAPTER 2 Design and implement core networking infrastructure CHAPTER 3 Design and implement routing CHAPTER 4 Secure and monitor networks CHAPTER 5 Design and implement private access to Azure services

Read more less

Book SynopsisASHISH AGRAWAL is a qualified technocrat, offering over two decades of multifaceted experience as a Cloud Engineering and transformation leader, trusted advisor, developer, consultant, and Enterprise Cloud Architect. He drives a profound influence in the cloud technology landscape with provocative thought leadership and communicates his ideas with clarity and passion. He has deep, hands-on technical expertise, having spearheaded numerous successful cloud engagements for global Fortune 500 companies in advisory, presales, consulting, architecture, leadership, and delivery execution, and he has played technology leadership roles in large, complex, cross-functional, and multi-enterprise project teams. GURVINDER SINGH is a Microsoft Certified Azure Solutions Architect with 15 years of diversified IT experience working with the Microsoft Technology stack. In the past several years, Gurvinder has been guiding large enterprises in the transformation of legacy applications into cloudTable of ContentsCHAPTER 1 Design identity, governance, and monitoring solutions CHAPTER 2 Design data storage solutions CHAPTER 3 Design business continuity solutions CHAPTER 4 Design infrastructure solutions

Read more less

Book SynopsisDayne Sorvisto is a seasoned data engineer and technical author (MLOps Lifecycle Toolkit). Dayne has held senior technical positions including Staff Data Engineer, Software Developer, and Senior Machine Learning Engineer, and has a Master's degree in Pure Mathematics. You can connect with Dayne on LinkedIn at linkedin.com/in/daynesorvisto or visit his website wyattsolutions.co to learn more.

Read more less

Book Synopsis Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft DyTable of Contents 1 Manage worksheets and workbooks Objective 1.1: Import data into workbooks Objective 1.2: Navigate within workbooks Objective 1.3: Format worksheets and workbooks Objective 1.4: Customize options and views Objective 1.5: Configure content for collaboration 2 Manage data cells and ranges Objective 2.1: Manipulate data in worksheets Objective 2.2: Format cells and ranges Objective 2.3: Define and reference named ranges Objective 2.4: Summarize data visually 3 Manage tables and table data Objective 3.1: Create and format tables Objective 3.2: Modify tables Objective 3.3: Filter and sort table data 4 Perform operations by using formulas and functions Objective 4.1: Insert references in formulas Objective 4.2: Calculate and transform data by using functions Objective 4.3: Format and modify text by using functions 5 Manage charts Objective 5.1: Create charts Objective 5.2: Modify charts Objective 5.3: Format charts

Read more less

Book Synopsis

Read more less

Book SynopsisYURI DIOGENES, MSC Yuri holds a Master of Science in cybersecurity intelligence and forensics investigation (UTICA College) and is the principal PM manager for the Microsoft CxE Microsoft Defender for Cloud Team, where he manages a team of PMs who are responsible for improving the product and helping customers deploy it. Yuri has been working for Microsoft since 2006 in different positions, including five years as a senior support escalation engineer for the CSS Forefront Edge Team. From 2011 to 2017, he was a member of Microsoft's content development team, where he also helped create the Azure Security Center content experience since its launch in 2016. Yuri has published 26 books, mostly about information security and Microsoft technologies. Yuri also holds an MBA and many IT/Security industry certifications, such as CISSP, ECND, ECEH, ECSA, ECHFI, CompTIA Security+, CySA+, Cloud Essentials Certified, Mobility+, Network+, CASP, CyberSec First Responder, MCSE, and Table of Contents1. Manage identity and access 2. Implement platform protection 3. Manage security operations 4. Secure data and applications

Read more less

Book SynopsisPaul McFedries is a Word expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.Table of Contents Chapter 1: Manage document options and settings Objective 1.1: Manage documents and templates Objective 1.2: Prepare documents for collaboration Objective 1.3: Use and configure language options Chapter 2: Use advanced editing and formatting features Objective 2.1: Perform advanced editing and formatting Objective 2.2: Configure paragraph layout options Objective 2.3: Create and manage styles Chapter 3: Create custom document elements Objective 3.1: Create and modify building blocks Objective 3.2: Create custom design elements Objective 3.3: Create and manage indexes Objective 3.4: Create and manage tables of figures Chapter 4: Use advanced Word features Objective 4.1: Manage forms, fields, and controls Objective 4.2: Create and modify macros Objective 4.3: Perform mail merges

Read more less

Book SynopsisPrepare for Microsoft Exam AZ-103-and help demonstrate your real-world mastery of deploying and managing infrastructure in Microsoft Azure cloud environments. Designed for experienced cloud professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level. Focus on the expertise measured by these objectives: Manage Azure subscriptions and resources Implement and manage storage Deploy and manage virtual machines (VMs) Configure and manage virtual networks Manage identities This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an experienced Azure administrator who understands and manages diverse storage, security, networking and/or compute cloud services About the Exam Exam AZ-103 focuses on skills and knowledge needed to manage Azure subscriptioTable of Contents1. Manage Azure subscriptions and resources 2. Implement and manage storage 101 3. Deploy and manage virtual machines (VMs) 4. Configure and manage virtual networks 5. Manage identities

Read more less

Book Synopsis Tim Warner is a Microsoft Certified Azure Solutions Architect with more than 20 years of experience working with the Microsoft technology stack. Tim teaches Microsoft Azure courses for Pluralsight and O'Reilly Live Online Training, and he's based in Nashville, Tennessee. Contact Tim via Twitter (@TechTrainerTim) or his website, TechTrainerTim.com.   Derek Schauland is an IT professional with 20 years' experience. He currently specializes in cloud technologies. He spent 10 years of his career as a Microsoft MVP, first in file system storage and then in cloud and datacenter management. In addition to writing about cloud technologies, he has co-authored two other books and countless articles and blogs. Outside of the technology space, he enjoys barbecuing with family and friends.   Mike Pfeiffer is a 20-year tech industry veteraTable of Contents1. Deploy and Configure Infrastructure 2. Implement Workloads and Security 3. Create and Deploy Apps 4. Implement Authentication and Secure Data 5. Develop for the Cloud and for Azure Storage

Read more less

Book SynopsisEd Fisher, Security & Compliance Architect at Microsoft, focuses on all aspects of security and compliance within Office 365, especially Microsoft Threat Protection. He has spent nearly a decade helping Microsoft customers and partners succeed with Microsoft cloud and productivity solutions. You can learn more at https://aka.ms/edfisher. Nate Chamberlain is a Microsoft 365 Certified Enterprise Administrator Expert. He has been an Office Apps and Services MVP since 2019, frequently blogging at NateChamberlain.com and speaking at Microsoft-focused events and user groups.Table of Contents Introduction 1. Implement and Manage Identity and Access 2. Implement and Manage Threat Protection 3. Implement and Manage Information Protection 4. Manage Governance and Compliance Features in Microsoft 365

Read more less

Book SynopsisPaul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.Table of Contents 1 Manage databases Objective 1.1: Modify database structure Objective 1.2: Manage table relationships and keys Objective 1.3: Print and export data 2 Create and modify tables Objective 2.1: Create tables. Objective 2.2: Manage tables Objective 2.3: Manage table records Objective 2.4: Create and modify fields 3 Create and modify queries Objective 3.1: Create and run queries Objective 3.2: Modify queries 4 Modify forms in Layout view Objective 4.1: Configure form controls Objective 4.2: Format forms 5 Modify reports in Layout view Objective 5.1: Configure report controls Objective 5.2: Format reports

Read more less

Book Synopsis JOAN LAMBERT has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified TechnologyTable of ContentsIntroduction Chapter 1 Manage Outlook settings and processes Objective 1.1: Customize Outlook settings Objective 1.2: Configure mail settings Objective 1.3: Perform search operations Objective 1.4: Print and save information Chapter 2 Manage messages Objective 2.1: Create messages Objective 2.2: Insert message content Objective 2.3: Organize and manage messages 3 Manage schedules Objective 3.1: Create and manage calendars Objective 3.2: Create appointments, meetings, and events Objective 3.3: Organize and manage appointments, meetings, and events 4 Manage contacts and tasks Objective 4.1: Create and manage contact records Objective 4.2: Create and manage contact groups Objective 4.3: Create and manage tasks

Read more less

Book SynopsisDANIIL MASLYUK is an independent business intelligence consultant, trainer, and speaker who specializes in Microsoft Power BI. Daniil blogs at xxlbi.com and tweets as @DMaslyuk.Table of Contents1. Prepare the Data 2. Model the Data 3. Visualize the Data 4. Analyze the Data 5. Deploy and Maintain Deliverables

Read more less

Book SynopsisOrin Thomas is a Principal Hybrid Cloud Advocate at Microsoft and has written more than 40 books for Microsoft Press on topics including Windows Server, Windows Client, Azure, Hybrid Cloud, Microsoft 365, Office 365, System Center, Exchange Server, Security, and SQL Server. You can connect with him at https://aka.ms/orin.Table of ContentsChapter 1: Design and implement Microsoft 365 services Chapter 2: Manage user identity and roles Chapter 3: Manage access and authentication Chapter 4: Plan Office 365 workloads and applications

Read more less

Book SynopsisBRIAN SVIDERGOL designs and builds infrastructure, cloud, and hybrid solutions. He holds many industry certifications, including Microsoft Certified Solutions Expert (MCSE) Cloud Platform and Infrastructure. Brian is the author of several books covering everything from on-premises infrastructure technologies to hybrid cloud environments. He has extensive real-world experience from startup organizations to large Fortune 500 companies on design, implementation, and migration projects. BOB CLEMENTS specializes in enterprise device management. He holds industry certifications relating to client manageability and administration for Windows, Mac, and Linux. Bob has an extensive background in designing, implementing, and supporting device-management solutions for private- and public-sector companies. In his free time, he enjoys spending time with his family, writing, and exploring new technologies. CHARLES PLUTA is a technicTable of ContentsChapter 1 – Implement Modern Device Services Chapter 2 – Implement Microsoft 365 Security and Threat Management Chapter 3 – Manage Microsoft 365 Governance and Compliance

Read more less

Book SynopsisANDREW BETTANY was awarded the Microsoft Most Valuable Professional (Windows and Devices for IT) for 8 years before joining Microsoft. He is a loving dad, IT geek, training mentor and consultant, entrepreneur, and author. Andrew is recognized for his Windows expertise, and he is the author of many publications, including several Windows exam certification prep guides and Microsoft official training materials. He is the author of video training materials for LinkedIn Learning and Pluralsight. As a Microsoft Certified Trainer for 16 years, Andrew delivers learning and consultancy to businesses in many technical areas, including Microsoft 365, Azure, and Windows 10. He has co-founded the IT Masterclasses series of short, intensive technical courses (seewww.itmasterclasses.com), and he is passionate about helping others learn technology. He is a frequent speaker at Microsoft Ignite and other technical conferences worldwide. Andrew is active on social media and can be foTable of ContentsChapter 1: Deploy windows Chapter 2: Manage devices and data Chapter 3: Configure storage and connectivity Chapter 4: Maintain windows

Read more less

Book SynopsisANDREW BETTANY, MCT was awarded the Microsoft Most Valuable Professional (Windows and Devices for IT) for eight years before joining Microsoft. He is a loving dad, IT geek, training mentor and consultant, entrepreneur, and author. Andrew is recognized for his Windows expertise, and he is the author of many publications, including several Windows exam certification prep guides and Microsoft official training materials. He is the author of video training materials for LinkedIn Learning and Pluralsight. As a Microsoft Certified Trainer for 16 years, Andrew delivers learning and consultancy to businesses in many technical areas, including Azure, Windows 10, and Microsoft 365. He has co-founded the IT Masterclasses series of short, intensive technical courses (see www.itmasterclasses.com), and he is passionate about helping others learn technology. He is a frequent speaker at Microsoft Ignite and other technical conferences worldwide. Andrew is active on social media andTable of ContentsChapter 1: Deploy and update operating systems Chapter 2: Manage policies and profiles Chapter 3: Manage and protect devices Chapter 4: Manage apps and data

Read more less

Book SynopsisORIN THOMAS is a Principal Hybrid Cloud Advocate at Microsoft and has written more than 3 dozen books for Microsoft Press on topics including Windows Server, Windows Client, Azure, Office 365, System Center, Exchange Server, Security, and SQL Server. He holds a Master's degree in Computing Research, has authored Azure Architecture courses at Pluralsight, and has authored multiple Microsoft Official Curriculum courses on a variety of IT Pro topics. You can follow him on Twitter at http://twitter.com/orinthomas or find out more at https://aka.ms/orin.Table of ContentsIntroduction CHAPTER 1 Secure Windows Server on-premises and hybrid infrastructure CHAPTER 2 Implement and manage Windows Server High Availability CHAPTER 3 Implement disaster recovery CHAPTER 4 Migrate servers and workloads CHAPTER 5 Monitor and troubleshoot Windows Server environments

Read more less

Book SynopsisYURI DIOGENES, MSC has a Master of Science in cybersecurity intelligence and forensics investigation from UTICA College and is currently working on his PhD in Cybersecurity Leadership from Capitol Technology University. Yuri has been working at Microsoft since 2006; currently, he is a Principal PM Manager for the Customer Experience Engineering Defender for Cloud Team, where he manages a global team of product managers focusing on cloud security posture management and workload protection. Yuri has published more than 30 books, mostly about information security and Microsoft technologies. Yuri is also a professor at EC-Council University, teaching in the Bachelor in Cybersecurity Program. Yuri has an MBA and many IT/security industry certifications, such as CISSP, MITRE ATT&CK Cyber Threat Intelligence Certified, ECND, ECEH, ECTI, ECSA, ECHFI, CompTIA Security+, CySA+, Network+, CASP, and CyberSec First Responder. You can follow Yuri on Twitter at @yuridiogenes. NICHOLAS DICOL

Read more less

Book SynopsisDemonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams covering Word, Excel, PowerPoint, and Outlook.

Read more less

Book SynopsisPrepare for Microsoft Exam 70-742-and help demonstrate your real-world mastery of Windows Server 2016 identity features and functionality. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Install and configure Active Directory Domain Services (AD DS) * Manage and maintain AD DS * Create and manage Group Policy * Implement Active Directory Certificate Services (AD CS) * Implement identity federation and access solutions This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have experience working with Windows Server, Windows clients, and virtualization; are familiar with core networking technologies, and are aware of basic security best practicesTable of ContentsChapter 1 Install and configure Active Directory Domain Services Chapter 2 Manage and maintain AD DS Chapter 3 Create and manage Group Policy Chapter 4 Implement Active Directory Certificate Services Chapter 5 Implement identity federation and access solutions

Read more less

Book SynopsisPaul McFedries is a full-time technical author who has worked with computers in one form or another since 1975. He is the author of more than 90 computer books that have sold more than 4 million copies worldwide. His recent Office-related titles include My Office 2016, My Office 2016 for Mac, and Formulas and Functions for Microsoft Excel 2016. His other titles include Windows 10 In Depth, (with Brian Knittel), PCs for Grownups, and Fixing Your Computer Absolute Beginner's Guide. Table of ContentsChapter 1 — Manage and share workbooks 1.1 Manage workbooks 1.2 Manage workbook review Chapter 2 — Apply custom formats and layouts 2.1 Apply custom data formats 2.2 Apply advanced conditional formatting and filtering 2.3 Apply custom styles and templates 2.4 Prepare workbooks for internationalization and accessibility Chapter 3 — Create advanced formulas 3.1 Apply functions in formulas 3.2 Look up data by using functions 3.3 Apply advanced date and time functions 3.4 Perform data analysis and business intelligence 3.5 Troubleshoot formulas 3.6 Define named ranges and objects Chapter 4 — Create advanced charts and tables 4.1 Create advanced chart elements 4.2 Create and manage PivotTables 4.3 Create and manage PivotCharts

Read more less

Book SynopsisSharpen your knowledge of C# C# know-how is a must if you want to be a professional Microsoft developer. It''s also good to know a little C# if you''re building tools for the web, mobile apps, or other development tasks. C# 7.0 All-in-One For Dummies offers a deep dive into C# for coders still learning the nuances of the valuable programming language. Pop it open to get an intro into coding with C#, how to design secure apps and databases, and even pointers on building web and mobile apps with C#. C# remains one of the most in-demand programming language skills. The language regularly ranks in the top five among most in-demand languages, typically along with Java/JavaScript, C++, and Python. A December 2016 ZDNet article noted ''If your employer is a Microsoft developer, you better know C#. Lucky for you, this approachable, all-in-one guide is here to help you do just thatwithout ever breaking a sweat! Includes coverage of the latest changes to C# Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 4 Book 1: The Basics of C# Programming 5 Chapter 1: Creating Your First C# Console Application 7 Getting a Handle on Computer Languages, C#, and .NET 7 Creating Your First Console Application 11 Making Your Console App Do Something 17 Reviewing Your Console Application 18 Introducing the Toolbox Trick 21 Chapter 2: Living with Variability — Declaring Value-Type Variables 23 Declaring a Variable 24 What’s an int? 25 Representing Fractions 27 Handling Floating-Point Variables 28 Using the Decimal Type: Is it an Integer or a Float? 31 Examining the bool Type: Is it Logical? 33 Checking Out Character Types 33 What’s a Value Type? 36 Comparing string and char 37 Calculating Leap Years: DateTime 38 Declaring Numeric Constants 40 Changing Types: The Cast 41 Letting the C# Compiler Infer Data Types 42 Chapter 3: Pulling Strings 45 The Union is Indivisible, and So are Strings 46 Performing Common Operations on a String 48 Comparing Strings 48 What If I Want to Switch Case? 53 Looping through a String 54 Searching Strings 55 Getting Input from the Command Line 57 Controlling Output Manually 62 Formatting Your Strings Precisely 68 StringBuilder: Manipulating Strings More Efficiently 73 Chapter 4: Smooth Operators 75 Performing Arithmetic 75 Performing Logical Comparisons — Is That Logical? 79 Matching Expression Types at TrackDownAMate.com 83 Chapter 5: Getting into the Program Flow 89 Branching Out with if and switch 90 Here We Go Loop-the-Loop 101 Looping a Specified Number of Times with for 112 Nesting Loops 115 Don’t goto Pieces 116 Chapter 6: Lining Up Your Ducks with Collections 119 The C# Array 120 Processing Arrays by Using foreach 126 Sorting Arrays of Data 128 Using var for Arrays 132 Loosening Up with C# Collections 133 Understanding Collection Syntax 134 Using Lists 136 Using Dictionaries 139 Array and Collection Initializers 141 Using Sets 142 On Not Using Old-Fashioned Collections 147 Chapter 7: Stepping through Collections 149 Iterating through a Directory of Files 149 Iterating foreach Collections: Iterators 157 Accessing Collections the Array Way: Indexers 160 Looping Around the Iterator Block 165 Chapter 8: Buying Generic 177 Writing a New Prescription: Generics 178 Classy Generics: Writing Your Own 179 Revising Generics 197 Chapter 9: Some Exceptional Exceptions 201 Using an Exceptional Error-Reporting Mechanism 202 Throwing Exceptions Yourself 207 Knowing What Exceptions are for 207 Can I Get an Exceptional Example? 208 Assigning Multiple catch Blocks 211 Planning Your Exception-Handling Strategy 214 Grabbing Your Last Chance to Catch an Exception 219 Throwing Expressions 220 Chapter 10: Creating Lists of Items with Enumerations 223 Seeing Enumerations in the Real World 224 Working with Enumerations 225 Creating Enumerated Flags 228 Defining Enumerated Switches 230 Book 2: Object-Oriented C# Programming 233 Chapter 1: Object-Oriented Programming — What’s it All About? 235 Object-Oriented Concept #1: Abstraction 235 Object-Oriented Concept #2: Classification 238 Why Classify? 238 Object-Oriented Concept #3: Usable Interfaces 239 Object-Oriented Concept #4: Access Control 240 How C# Supports Object-Oriented Concepts 241 Chapter 2: Showing Some Class 243 Defining a Class and an Object 244 Accessing the Members of an Object 246 An Object-Based Program Example 247 Discriminating between Objects 249 Can You Give Me References? 249 Classes That Contain Classes are the Happiest Classes in the World 252 Generating Static in Class Members 253 Defining const and readonly Data Members 255 Chapter 3: We Have Our Methods 257 Defining and Using a Method 257 A Method Example for Your Files 259 Having Arguments with Methods 267 Returning Values after Christmas 275 Returning Multiple Values Using Tuples 279 Chapter 4: Let Me Say This about this 283 Passing an Object to a Method 283 Defining Methods 285 Accessing the Current Object 290 Using Local Functions 298 Chapter 5: Holding a Class Responsible 301 Restricting Access to Class Members 301 Why You Should Worry about Access Control 306 Defining Class Properties 312 Getting Your Objects Off to a Good Start — Constructors 315 The C#-Provided Constructor 316 Replacing the Default Constructor 317 Using Expression-Bodied Members 324 Chapter 6: Inheritance: Is That All I Get? 329 Class Inheritance 330 Why You Need Inheritance 332 Inheriting from a BankAccount Class (a More Complex Example) 333 IS_A versus HAS_A — I’m So Confused_A 336 When to IS_A and When to HAS_A 340 Other Features That Support Inheritance 340 The object Class 344 Inheritance and the Constructor 345 The Updated BankAccount Class 350 Chapter 7: Poly-what-ism? 357 Overloading an Inherited Method 358 Polymorphism 366 The Class Business Card: ToString() 374 C# During Its Abstract Period 374 Sealing a Class 383 Chapter 8: Interfacing with the Interface 385 Introducing CAN_BE_USED_AS 385 Knowing What an Interface is 387 Using an Interface 391 Using the C# Predefined Interface Types 392 Looking at a Program That CAN_BE_USED_AS an Example 393 Unifying Class Hierarchies 401 Hiding Behind an Interface 403 Inheriting an Interface 406 Using Interfaces to Manage Change in Object-Oriented Programs 407 Chapter 9: Delegating Those Important Events 411 E.T., Phone Home — The Callback Problem 412 Defining a Delegate 412 Pass Me the Code, Please — Examples 414 A More Real-World Example 417 Shh! Keep it Quiet — Anonymous Methods 426 Stuff Happens — C# Events 427 Chapter 10: Can I Use Your Namespace in the Library? 435 Dividing a Single Program into Multiple Source Files 436 Dividing a Single Program into Multiple Assemblies 437 Putting Your Classes into Class Libraries 440 Going Beyond Public and Private: More Access Keywords 446 Putting Classes into Namespaces 452 Chapter 11: Improving Productivity with Named and Optional Parameters 459 Exploring Optional Parameters 460 Looking at Named Parameters 464 Dealing with Overload Resolution 465 Using Alternative Methods to Return Values 466 Chapter 12: Interacting with Structures 469 Comparing Structures to Classes 470 Creating Structures 472 Using Structures as Records 479 Book 3: Designing for C# 483 Chapter 1: Writing Secure Code 485 Designing Secure Software 486 Building Secure Windows Applications 488 Building Secure Web Forms Applications 493 Using System.Security 498 Chapter 2: Accessing Data 499 Getting to Know System.Data 500 How the Data Classes Fit into the Framework 502 Getting to Your Data 502 Using the System.Data Namespace 503 Chapter 3: Fishing the File Stream 521 Going Where the Fish are: The File Stream 521 StreamWriting for Old Walter 524 Pulling Them Out of the Stream: Using StreamReader 536 More Readers and Writers 540 Exploring More Streams than Lewis and Clark 542 Chapter 4: Accessing the Internet 543 Getting to Know System.Net 544 How Net Classes Fit into the Framework 545 Using the System.Net Namespace 547 Chapter 5: Creating Images 559 Getting to Know System.Drawing 560 How the Drawing Classes Fit into the Framework 563 Using the System.Drawing Namespace 564 Chapter 6: Programming Dynamically! 571 Shifting C# Toward Dynamic Typing 572 Employing Dynamic Programming Techniques 574 Putting Dynamic to Use 576 Running with the Dynamic Language Runtime 579 Book 4: A Tour of Visual Studio 583 Chapter 1: Getting Started with Visual Studio 585 Versioning the Versions 586 Installing Visual Studio 590 Breaking Down the Projects 592 Chapter 2: Using the Interface 597 Designing in the Designer 597 Paneling the Studio 605 Coding in the Code Editor 612 Using the Tools of the Trade 616 Using the Debugger as an Aid to Learning 618 Chapter 3: Customizing Visual Studio 623 Setting Options 624 Using Snippets 628 Hacking the Project Types 634 Book 5: Windows Development with WPF 641 Chapter 1: Introducing WPF 643 Understanding What WPF Can Do 643 Introducing XAML 645 Diving In! Creating Your First WPF Application 646 Chapter 2: Understanding the Basics of WPF 653 Using WPF to Lay Out Your Application 654 Arranging Elements with Layout Panels 655 Exploring Common XAML Controls 671 Chapter 3: Data Binding in WPF 681 Getting to Know Dependency Properties 681 Exploring the Binding Modes 682 Investigating the Binding Object 683 Editing, Validating, Converting, and Visualizing Your Data 687 Finding Out More about WPF Data Binding 704 Chapter 4: Practical WPF 705 Commanding Attention 705 Using Built-In Commands 708 Using Custom Commands 711 Using Routed Commands 716 Book 6: Web Development with ASP.NET 721 Chapter 1: Looking at How ASP.NET Works with C# 723 Breaking Down Web Applications 724 Questioning the Client 726 Dealing with Web Servers 730 Chapter 2: Building Web Applications 735 Working in Visual Studio 736 Developing with Style 749 Chapter 3: Controlling Your Development Experience 753 Showing Stuff to the User 754 Getting Some Input from the User 760 Data Binding 767 Styling Your Controls 775 Making Sure the Site is Accessible 777 Constructing User Controls 779 Chapter 4: Leveraging the .NET Framework 783 Surfing Web Streams 784 Securing ASP.NET 789 Managing Files 791 Baking Cookies 792 Tracing with TraceContext 796 Navigating with Site Maps 798 Index 801

Read more less

Book SynopsisTable of ContentsIntroduction xxi Assessment Test xxviii Answers to Assessment Test xl Part I Word Exam MO-100 1 Chapter 1 Working with Documents 3 Navigating Within Documents 4 Searching for Text 4 Linking to Locations Within Documents 8 Moving to Specific Locations and Objects in Documents 9 Showing and Hiding Formatting Symbols and Hidden Text 10 Formatting Documents 13 Setting Up Document Pages 14 Applying Style Settings 15 Inserting and Modifying Headers and Footers 17 Configuring Page Background Elements 18 Saving and Sharing Documents 20 Saving Documents in Alternative File Formatting 20 Changing Basic Document Properties 21 Modifying Print Settings 23 Sharing Documents Electronically 24 Inspecting Documents for Issues 26 Locating and Removing Hidden Properties and Personal Information 26 Finding and Fixing Accessibility Issues 28 Locating and Correcting Compatibility Issues 29 Summary 30 Key Terms 31 Exam Essentials 31 Review Questions 33 Chapter 2 Inserting and Formatting Text 35 Adding and Replacing Text 36 Finding and Replacing Text 36 Inserting Symbols and Special Characters 40 Formatting Text and Paragraphs 42 Adding Text Effects 42 Applying Formatting by Using Format Painter 43 Setting Line and Paragraph Spacing and Indentation 43 Applying Built-In Styles to Text 46 Clearing Formatting 47 Creating and Configuring Document Sections 50 Formatting Text in Multiple Columns 50 Inserting Page, Section, and Column Breaks 52 Changing Page Setting Options for a Section 53 Summary 56 Key Terms 57 Exam Essentials 57 Review Questions 58 Chapter 3 Managing Tables and Lists 61 Creating Tables 62 Converting Text to Tables 64 Switching Tables to Text 65 Creating Tables by Specifying Rows and Columns 66 Modifying Tables 68 Sorting Table Data 68 Configuring Cell Margins and Spacing 70 Merging and Splitting Cells 73 Resizing Tables, Rows, and Columns 75 Splitting Tables 80 Configuring a Repeating Row Header 82 Creating and Formatting Lists 85 Structuring Paragraphs as Numbered and Bulleted Lists 85 Changing Bullet Characters and Number Formatting 86 Defining Custom Bullet Characters and Number Formatting 88 Increasing and Decreasing List Levels 91 Restarting and Continuing List Numbering 92 Setting Starting Number Values 94 Summary 95 Key Terms 96 Exam Essentials 96 Review Questions 97 Chapter 4 Building References 99 Creating and Managing Referencing Elements 100 Inserting Footnotes and Endnotes 100 Modifying Footnote and Endnote Properties 103 Creating and Modifying Bibliography Citation Sources 104 Inserting Citations for Bibliographies 107 Working with Referencing Tables 109 Inserting Tables of Contents 109 Customizing Tables of Contents 110 Adding Bibliographies 112 Summary 113 Key Terms 113 Exam Essentials 114 Review Questions 115 Chapter 5 Adding and Formatting Graphic Elements 117 Inserting Illustrations and Text Boxes 118 Adding Shapes 118 Including Pictures 120 Inserting 3D Models 121 Adding SmartArt Graphics 122 Placing Screenshots and Screen Clippings 123 Inserting Text Boxes 125 Formatting Illustrations and Text Boxes 127 Applying Artistic Effects 127 Adding Picture Effects and Picture Styles 128 Removing Picture Backgrounds 131 Formatting Graphic Elements 132 Setting Up SmartArt Graphics 134 Working with 3D Models 136 Adding and Organizing Text 137 Formatting Text in Text Boxes 137 Adding Text in Shapes 139 Changing SmartArt Graphic Content 141 Modifying Graphic Elements 142 Positioning Objects 142 Wrapping Text Around Objects 143 Adding Alt Text to Objects 146 Summary 148 Key Terms 148 Exam Essentials 148 Review Questions 149 Chapter 6 Working with Other Users on Your Document 151 Adding Comments 152 Inserting Comments 152 Reviewing and Replying to Comments 153 Resolving Comments 154 Deleting Comments 155 Tracking Your Changes 157 Turning On Track Changes 157 Reviewing Tracked Changes 158 Accepting and Rejecting Tracked Changes 159 Locking and Unlocking Change Tracking 162 Summary 165 Key Terms 165 Exam Essentials 165 Review Questions 166 Part II Excel Exam MO-200 169 Chapter 7 Managing Worksheets and Workbooks 171 Importing Data into Workbooks 172 Bringing in Data from TXT Files 173 Importing Data from CSV Files 174 Navigating Within Workbooks 178 Searching for Data Within a Workbook 178 Navigating to Named Cells, Ranges, or Workbook Elements 180 Inserting and Removing Hyperlinks 182 Formatting Worksheets and Workbooks 190 Modifying Page Settings 190 Adjusting Row Height and Column Width 192 Customizing Headers and Footers 200 Customizing Options and Views 206 Customizing the Quick Access Toolbar 207 Displaying and Modifying Workbook Content in Different Views 211 Freezing Worksheet Rows and Columns 214 Changing Window Views 216 Modifying Basic Workbook Properties 218 Displaying Formulas 219 Configuring Content for Collaboration 222 Setting a Print Area 222 Saving Workbooks in Other File Formats 224 Configuring Print Settings 224 Inspecting Workbooks for Issues 225 Summary 229 Key Terms 229 Exam Essentials 229 Review Questions 231 Chapter 8 Using Data Cells and Ranges 233 Manipulating Data in Worksheets 234 Pasting Data by Using Special Paste Options 234 Filling Cells by Using Auto Filling 238 Inserting and Deleting Multiple Columns or Rows 240 Adding and Removing Cells 242 Formatting Cells and Ranges 245 Merging and Unmerging Cells 245 Modifying Cell Alignment, Orientation, and Indentation 246 Formatting Cells by Using Format Painter 249 Wrapping Text Within Cells 250 Using Number Formatting 252 Applying Cell Formatting from the Format Cells Dialog Box 253 Working with Cell Styles 254 Clearing Cell Formatting 256 Defining and Referencing Named Ranges 258 Defining a Named Range 258 Naming a Table 263 Summarizing Data Visually 265 Inserting Sparklines 265 Applying Built-In Conditional Formatting 269 Removing Conditional Formatting 271 Summary 275 Key Terms 275 Exam Essentials 275 Review Questions 277 Chapter 9 Working with Tables and Table Data 279 Creating and Formatting Tables 280 Creating Excel Tables from Cell Ranges 280 Applying Table Styles 282 Converting Tables to Cell Ranges 283 Modifying Tables 285 Adding or Remove Table Rows and Columns 285 Configuring Table Style Options 288 Inserting and Configuring Total Rows 289 Filtering and Sorting Table Data 292 Filtering Records 292 Sorting Data by Multiple Columns 296 Summary 298 Key Terms 299 Exam Essentials 299 Review Questions 300 Chapter 10 Performing Operations by Using Formulas and Functions 303 Inserting References 304 Inserting Relative, Absolute, and Mixed References 305 Referencing Named Ranges and Named Tables in Formulas 307 Calculating and Transforming Datas 310 Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions 310 Perform Conditional Operations by Using the IF() Function 321 Formatting and Modifying Text 325 Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 325 Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 329 Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333 Summary 336 Key Terms 337 Exam Essentials 337 Review Questions 338 Chapter 11 Managing Charts 341 Creating Charts 342 Building Charts 342 Working with Chart Sheets 344 Modifying Charts 348 Adding Data Series to Charts 348 Switching Between Rows and Columns in Source Data 351 Adding and Modifying Chart Elements 352 Formatting Charts 355 Using Chart Layouts 356 Applying Chart Styles 364 Adding Alternative Text to Charts for Accessibility 366 Summary 368 Key Terms 368 Exam Essentials 369 Review Questions 370 Part III PowerPoint Exam MO-300 373 Chapter 12 Creating Presentations 375 Modifying Slide Masters, Handout Masters, and Note Masters 377 Changing the Slide Master Theme or Background 378 Modifying Slide Master Content 383 Creating Slide Layouts 384 Modify Slide Layouts 389 Modifying the Handout Master 393 Modifying the Notes Master 400 Changing Presentation Options and Views 406 Changing the Slide Size 406 Displaying Presentations in Different Views 408 Setting Basic File Properties 410 Configuring Print Settings for Presentations 411 Printing All or Part of a Presentation 411 Printing Notes Pages 413 Printing Handouts 414 Printing in Color, Grayscale, or Black and White 415 Configuring and Presenting Slideshows 417 Creating Custom Slideshows 417 Configuring Slideshow Options 422 Rehearsing Slideshow Timing 423 Setting Up Slideshow Recording Options 427 Presenting Slideshows by Using Presenter View 430 Preparing Presentations for Collaboration 436 Mark Presentations as Final 437 Protecting Presentations by Using Passwords 438 Inspecting Presentations for Issues 439 Adding and Managing Comments 441 Preserving Presentation Content 446 Exporting Presentations to Other Formats 447 Summary 456 Key Terms 457 Exam Essentials 457 Review Questions 459 Chapter 13 Managing Slides 461 Inserting Slides 462 Importing Word Document Outlines 462 Inserting Slides from Another Presentation 465 Inserting Slides and Selecting Slide Layouts 467 Inserting Summary Zoom Slides 469 Duplicating Slides 474 Modifying Slides 475 Hiding and Unhiding Slides 476 Modifying Individual Slide Backgrounds 477 Inserting Slide Headers, Footers, and Page Numbers 480 Ordering and Grouping Slides 484 Creating Sections 484 Modifying the Slide Order 486 Renaming Sections 488 Summary 489 Key Terms 490 Exam Essentials 490 Review Questions 491 Chapter 14 Inserting and Formatting Text, Shapes, and Images 493 Formatting Text 495 Applying Formatting and Styles to Text 495 Formatting Text in Multiple Columns 501 Creating Bulleted and Numbered Lists 502 Inserting Links 504 Inserting Hyperlinks 504 Inserting Section Zoom Links and Slide Zoom Links 505 Inserting and Formatting Images 509 Resizing and Cropping Images 511 Applying Built-In Styles and Effects to Images 513 Inserting Screenshots and Screen Clippings 515 Inserting and Formatting Graphic Elements 518 Inserting and Changing Shapes 518 Drawing by Using Digital Ink 520 Adding Text to Shapes and Text Boxes 523 Resizing Shapes and Text Boxes 525 Formatting Shapes and Text Boxes 527 Applying Built-In Styles to Shapes and Text Boxes 529 Adding Alt Text to Graphic Elements for Accessibility 532 Ordering and Grouping Objects on Slides 534 Ordering Shapes, Images, and Text Boxes 534 Aligning Shapes, Images, and Text Boxes 535 Grouping Shapes and Images 537 Displaying Alignment Tools 538 Summary 539 Key Terms 540 Exam Essentials 540 Review Questions 541 Chapter 15 Inserting Tables, Charts, SmartArt, 3D Models, and Media 543 Inserting and Formatting Tables 544 Creating and Inserting Tables 544 Inserting and Deleting Table Rows and Columns 545 Applying Built-In Table Styles 548 Inserting and Modifying Charts 551 Creating and Inserting Charts 551 Modifying Charts 554 Inserting and Formatting SmartArt Graphics 560 Inserting SmartArt Graphics 560 Converting Lists to SmartArt Graphics 560 Adding and Modifying SmartArt Graphic Content 563 Inserting and Modifying 3D Models 565 Inserting 3D Models 565 Modifying 3D Models 567 Inserting and Managing Media 568 Inserting Audio and Video Clips 568 Creating and Inserting Screen Recordings 576 Configuring Media Playback Options 581 Summary 584 Key Terms 585 Exam Essentials 585 Review Questions 587 Chapter 16 Applying Transitions and Animations 589 Applying and Configuring Slide Transitions 590 Applying Basic and 3D Slide Transitions 590 Configuring Transition Effects 592 Animating Slide Content 596 Animating Text and Graphic Elements 596 Animating 3D Models 606 Configuring Animation Effects 609 Configuring Animation Paths 612 Reordering Animations on a Slide 617 Setting Timing for Transitions 619 Setting Transition Effect Duration 619 Configuring Transition Start and Finish Options 620 Summary 622 Key Terms 622 Exam Essentials 623 Review Questions 624 Appendix Answers to Review Questions 627 Part I: Word Exam MO-100 628 Chapter 1: Working with Documents 628 Chapter 2: Inserting and Formatting Text 628 Chapter 3: Managing Tables and Lists 629 Chapter 4: Building References 630 Chapter 5: Adding and Formatting Graphic Elements 630 Chapter 6: Working with Other Users on Your Document 631 Part II: Excel Exam MO-200 632 Chapter 7: Managing Worksheets and Workbooks 632 Chapter 8: Using Data Cells and Ranges 632 Chapter 9: Working with Tables and Table Data 633 Chapter 10: Performing Operations by Using Formulas and Functions 634 Chapter 11: Managing Charts 634 Part III: PowerPoint Exam MO-300 635 Chapter 12: Creating Presentations 635 Chapter 13: Managing Slides 636 Chapter 14: Inserting and Formatting Text, Shapes, and Images 636 Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media 637 Chapter 16: Applying Transitions and Animations 638 Index 639

Read more less

Book SynopsisThis Study Guide helps you understand the job role and responsibilities of a Microsoft 365 Teams Administrator. It's your one-stop resource for learning new skills, preparing to take the exam, and boosting your career! Cloud technology has become a major component of how services are delivered to customers. It's creating new roles and expanding others in all areas of technology. The Microsoft 365 Certified Associate Teams Administrator certification shows you're keeping pace with today's technology. MCA Microsoft 365 Certified Teams Administrator Study Guide is your best resource for understanding the job roles and responsibilities of a Teams Administrator and preparing to take the certification Exam MS-700. Microsoft 365 Teams Administrators focus on efficient and effective collaboration and communication in an enterprise environment. This Study Guide can help you understand best practices for configuring, deploying, and managing Office 365 workloads for Microsoft Teams that focus on efficient and effective collaboration and communication in an enterprise environment. Test your knowledge of all key exam objectives, including planning, deploying, and managing Teams chat, apps, channels, meetings, audio conferencing, live events, and calling. This Sybex Study Guide also covers upgrading from Skype for Business to Teams, managing Teams settings by using PowerShell, and understanding integration points with other apps and services. Review everything you need to know to pass the Exam MS-700 and you're your Microsoft 365 Certified Associate Teams Administrator certificationUse Sybex's exclusive online test bank to improve your ability to plan and configure a Microsoft Teams EnvironmentMaster the process of managing Chat, Calling, and Meetings within Microsoft TeamsBecome an expert at configuring Teams and App Policies, including integrating third-party apps and services Readers will also have access to Sybex's online test bank, including hundreds of practice questions, flashcards, and a glossary. Take your career to a new level with this Study Guide!Table of ContentsIntroduction xxi Assessment Test xxix Answers to Assessment Test xxxviii Chapter 1 Introducing Teams 1 Using Teams: The Basics 3 Accessing Teams 9 O365 E3 Trial 10 Customer Immersion Experience 10 Fully Paid E3 10 Using Teams as Part of O365 10 Home User Plans 12 Small/Medium Business Plans 12 Enterprise Plans 13 Managing Teams 15 Management Tools 15 Policy Management 24 Summary 26 Exam Essentials 27 Exercises 28 Review Questions 30 Chapter 2 Getting Teams Up and Running 33 Migrating from Skype for Business 34 Coexistence Modes 36 Interoperability 42 Coexistence Modes and Migration/Upgrade Paths 46 Meeting Migration Service 48 Managing Skype for Business to Teams Migrations 51 Preparing Your Network for Teams 57 Internet Breakout 58 Networking Best Practices 59 Network Quality 64 Network Capacity 73 Deploying Clients Required for Teams 84 Clients 84 Devices 88 Summary 99 Exam Essentials 99 Review Questions 106 Chapter 3 Teams Core Functionality 111 Creating Teams 112 Teams Memberships 114 Types of Teams and Discoverability 116 Making a Team from Scratch 118 Upgrading an Existing Resource to a Team 127 Org-Wide Teams 134 Managing Features Inside Teams 139 Messaging Policies 139 Managing Channels 148 Managing Settings in a Team 152 Manage Settings for Teams 156 Managing Guests and External Access 162 External Access vs. Guest Access 162 Managing External Access 165 Managing Access for Guest Users 166 Reviewing Guest Access 173 Meetings with Teams 173 Teams Meetings 174 Teams Live Events 188 Summary 196 Exam Essentials 197 Exercises 199 Review Questions 207 Chapter 4 Advanced Teams Functionality and Management 213 Admin and User Management 214 Teams Admin Roles 215 Manual Team Membership 223 Dynamic Membership 225 Access Reviews 231 Lifecycle and Governance 236 Team Templates 236 Group Creation Policies 242 M365 Group Naming Policy 247 M365 Group Expiration 252 Archiving, Deleting, and Restoring Teams 255 Data Security and Compliance 260 Sensitivity Labels 260 Retention Policies 267 Data Loss Prevention Policies 272 Segmentation and Information Barriers 279 eDiscovery 286 Security and Compliance Alerts 297 Teams Apps 302 App Policies 304 Using Custom Apps 311 Summary 315 Exam Essentials 316 Review Questions 326 Chapter 5 Adding Telephony 331 Phone System Overview 333 Delivery Method 333 Licensing 336 Number Types 339 Device Types 339 Emergency Calling 341 Phone System Delivery 351 Calling Plans 351 Direct Routing 365 Controlling Phone System Features 380 Calling Features 380 Calling Workflows/Voice Apps 389 Summary 407 Exam Essentials 408 Exercises 410 Review Questions 417 Chapter 6 Review Usage and Maintain Quality 421 Adoption and Deployment Approach 422 Deployment Planning 423 User Adoption 425 Monitoring Collaboration 427 Teams Usage Reports 428 Microsoft 365 Usage Reports 433 Monitoring Telephony 434 Call Analytics 437 Call Quality Dashboard 441 Summary 451 Exam Essentials 452 Exercises 453 Review Questions 456 Appendix Answers to Review Questions 459 Chapter 1: Introducing Teams 460 Chapter 2: Getting Teams Up and Running 460 Chapter 3: Teams Core Functionality 463 Chapter 4: Advanced Teams Functionality and Management 465 Chapter 5: Adding Telephony 467 Chapter 6: Review Usage and Maintain Quality 470 Index 471

Read more less

Book SynopsisPrepare for the MCA Azure Security Engineer certification exam faster and smarter with help from Sybex In the MCA Microsoft Certified Associate Azure Security Engineer Study Guide: Exam AZ-500, cybersecurity veteran Shimon Brathwaite walks you through every step you need to take to prepare for the MCA Azure Security Engineer certification exam and a career in Azure cybersecurity. You'll find coverage of every domain competency tested by the exam, including identity management and access, platform protection implementation, security operations management, and data and application security. You'll learn to maintain the security posture of an Azure environment, implement threat protection, and respond to security incident escalations. Readers will also find: Efficient and accurate coverage of every topic necessary to succeed on the MCA Azure Security Engineer examRobust discussions of all the skills you need to hit the ground running at your firstor nextAzure cybersecurity jobComplementary access to online study tools, including hundreds of bonus practice exam questions, electronic flashcards, and a searchable glossaryThe MCA Azure Security Engineer AZ-500 exam is a challenging barrier to certification. But you can prepare confidently and quickly with this latest expert resource from Sybex. It's ideal for anyone preparing for the AZ-500 exam or seeking to step into their next role as an Azure security engineer.Table of ContentsIntroduction xix Assessment Test xxv Chapter 1 Introduction to Microsoft Azure 1 What Is Microsoft Azure? 3 Cloud Environment Security Objectives 4 Confidentiality 4 Integrity 4 Availability 5 Nonrepudiation 5 Common Security Issues 5 Principle of Least Privilege 5 Zero- Trust Model 6 Defense in Depth 6 Avoid Security through Obscurity 9 The AAAs of Access Management 9 Encryption 10 End- to- End Encryption 11 Symmetric Key Encryption 11 Asymmetric Key Encryption 11 Network Segmentation 13 Basic Network Configuration 13 Unsegmented Network Example 14 Internal and External Compliance 15 Cybersecurity Considerations for the Cloud Environment 16 Configuration Management 17 Unauthorized Access 17 Insecure Interfaces/APIs 17 Hijacking of Accounts 17 Compliance 18 Lack of Visibility 18 Accurate Logging 18 Cloud Storage 18 Vendor Contracts 19 Link Sharing 19 Major Cybersecurity Threats 19 DDoS 19 Social Engineering 20 Password Attacks 21 Malware 21 Summary 24 Exam Essentials 24 Review Questions 26 Chapter 2 Managing Identity and Access in Microsoft Azure 29 Identity and Access Management 31 Identifying Individuals in a System 31 Identifying and Assigning Roles in a System and to an Individual 32 Assigning Access Levels to Individuals or Groups 33 Adding, Removing, and Updating Individuals and Their Roles in a System 33 Protecting a System’s Sensitive Data and Securing the System 33 Enforcing Accountability 34 IAM in the Microsoft Azure Platform 34 Creating and Managing Azure AD Identities 34 Managing Azure AD Groups 37 Managing Azure Users 39 Adding Users to Your Azure AD 39 Managing External Identities Using Azure AD 40 Managing Secure Access Using Azure Active Directory 42 Implementing Conditional Access Policies, Including MFA 44 Implementing Azure AD Identity Protection 45 Enabling the Policies 47 Implement Passwordless Authentication 50 Configuring an Access Review 52 Managing Application Access 57 Integrating Single Sign- On and Identity Providers for Authentication 57 Creating an App Registration 58 Configuring App Registration Permission Scopes 58 Managing App Registration Permission Consent 59 Managing API Permission to Azure Subscriptions 60 Configuring an Authentication Method for a Service Principal 61 Managing Access Control 62 Interpret Role and Resource Permissions 62 Configuring Azure Role Permissions for Management Groups, Subscriptions, Resource Groups, and Resources 63 Assigning Built- In Azure AD Roles 64 Creating and Assigning Custom Roles, Including Azure Roles and Azure AD Roles 65 Summary 66 Exam Essentials 67 Review Questions 70 Chapter 3 Implementing Platform Protections 73 Implementing Advanced Network Security 75 Securing Connectivity of Hybrid Networks 75 Securing Connectivity of Virtual Networks 77 Creating and Configuring Azure Firewalls 78 Azure Firewall Premium 79 Creating and Configuring Azure Firewall Manager 82 Creating and Configuring Azure Application Gateway 82 Creating and Configuring Azure Front Door 87 Creating and Configuring a Web Application Firewall 91 Configuring Network Isolation for Web Apps and Azure Functions 93 Implementing Azure Service Endpoints 94 Implementing Azure Private Endpoints, Including Integrating with Other Services 97 Implementing Azure Private Link 98 Implementing Azure DDoS Protection 101 Configuring Enhanced Security for Compute 102 Configuring Azure Endpoint Protection for VMs 102 Enabling Update Management in Azure Portal 104 Configuring Security for Container Services 108 Managing Access to the Azure Container Registry 109 Configuring Security for Serverless Compute 109 Microsoft Recommendations 111 Configuring Security for an Azure App Service 112 Exam Essentials 118 Review Questions 122 Chapter 4 Managing Security Operations 125 Configure Centralized Policy Management 126 Configure a Custom Security Policy 126 Create Custom Security Policies 127 Creating a Policy Initiative 128 Configuring Security Settings and Auditing by Using Azure Policy 129 Configuring and Managing Threat Protection 130 Configuring Microsoft Defender for Cloud for Servers (Not Including Microsoft Defender for Endpoint) 131 Configuring Microsoft Defender for SQL 134 Using the Microsoft Threat Modeling Tool 139 Azure Monitor 147 Visualizations in Azure Monitor 148 Configuring and Managing Security Monitoring Solutions 149 Creating and Customizing Alert Rules by Using Azure Monitor 149 Configuring Diagnostic Logging and Retention Using Azure Monitor 157 Monitoring Security Logs Using Azure Monitor 159 Microsoft Sentinel 167 Configuring Connectors in Microsoft Sentinel 170 Evaluating Alerts and Incidents in Microsoft Sentinel 175 Summary 176 Exam Essentials 177 Review Questions 179 Chapter 5 Securing Data and Applications 183 Configuring Security for Storage in Azure 184 Storage Account Access Keys 185 Configuring Access Control for Storage Accounts 185 Configuring Storage Account Access Keys 189 Configuring Azure AD Authentication for Azure Storage and Azure Files 191 Configuring Delegated Access for Storage Accounts 202 Configuring Security for Databases 220 Summary 254 Exam Essentials 255 Review Questions 257 Appendix A An Azure Security Tools Overview 261 Chapter 2, “Managing Identity and Access on Microsoft Azure” 262 Azure Active Directory (AD) 262 Microsoft Authenticator App 265 Azure API Management 265 Chapter 3, “Implementing Platform Protections” 266 Azure Firewall 266 Azure Firewall Manager 267 Azure Application Gateway 269 Azure Front Door 273 Web Application Firewall 273 Azure Service Endpoints 274 Azure Private Links 274 Azure DDoS Protection 275 Microsoft Defender for Cloud 276 Azure Container Registry 277 Azure App Service 278 Chapter 4, “Managing Security Operations” 279 Azure Policy 279 Microsoft Threat Modeling Tool 281 Microsoft Sentinel 287 How Does Microsoft Sentinel Work? 289 Automation 290 Chapter 5, “Securing Data and Applications” 290 Azure Key Vault 299 Appendix B Answers to Review Questions 301 Chapter 1: Introduction to Microsoft Azure 302 Chapter 2: Managing Identity and Access in Microsoft Azure 303 Chapter 3: Implementing Platform Protections 304 Chapter 4: Managing Security Operations 305 Chapter 5: Securing Data and Applications 306 Index 309

Read more less

Book SynopsisYour complete guide to passing the MCA Microsoft Certified Associate Azure Administrator Exam, Now with 11 Online Lab Modules! Achieving Microsoft Certified Associate Azure Administrator certification shows that you are adept at deploying and managing infrastructure in Microsoft Azure cloud environments. This Sybex Study Guide with Online Labs covers everything you need to master in order to pass the challenging AZ-104 exam. It leads you through the skills and knowledge you must demonstrate in all the essential exam domains, including managing Azure subscriptions and resources, implementing and managing storage, configuring and managing virtual networks, and managing identities. Add access to the Sybex interactive online learning environment and test bank and take your test preparation to the next level. Coverage of 100% of all exam objectives in this Study Guide with Online Labs means you'll be ready for: Table of ContentsIntroduction xxiii Assessment Test xxx Chapter 1 Identity: Azure Active Directory 1 Azure Active Directory 2 Benefits 2 Concepts 4 Azure AD vs. Active Directory Domain Services 4 Azure AD: Licensing 5 Custom Domains in Azure AD 7 Users and Groups 8 User Accounts 8 Group Accounts 26 Azure AD Roles 36 Azure AD Join 37 Benefits 37 Connection Options 38 Self-Service Password Reset 39 Enabling SSPR 39 Authentication Methods 40 Managing Multiple Directories 42 Summary 43 Exam Essentials 44 Review Questions 45 Chapter 2 Compliance and Cloud Governance 49 Azure Regions 50 Facts 51 Regional Pairs 52 Azure Accounts and Subscriptions 53 Azure Accounts 54 Azure Subscriptions 54 Azure Cost Management 57 Plan and Control Expenses 58 Cost Saving Techniques 59 Resource Groups 60 Management Groups 65 Azure Policy 68 Implementing Azure Policy 69 Implementing Initiatives 77 Role-Based Access Control 79 Concepts 80 Azure RBAC Roles 82 Custom RBAC Roles 84 Role Assignment 91 Resource Locks 95 Configuring Locks 97 Resource Tags 99 Use Cases 99 Applying Tags 100 Summary 102 Exam Essentials 102 Review Questions 104 Chapter 3 Virtual Networking 109 Virtual Networks 110 VNet Concepts 111 Address Space 111 Subnets 111 Regions 111 Subscription 112 IP Addressing 113 Static and Dynamic Addressing 113 Private IP Addresses 113 Public IP Address 116 Network Routes 118 System Routes 119 User-Defined Routes 119 Service Endpoints 125 Supported Services 127 Private Endpoint 127 Azure DNS 129 Record Management 131 Private DNS Zones 133 Network Security Groups 137 NSG Concepts 137 NSG Effective Rules 141 Azure Firewall 142 Azure Firewall Rules 142 Implementing Azure Firewall 144 Summary 145 Exam Essentials 146 Review Questions 148 Chapter 4 Intersite Connectivity 153 Azure-to-Azure Connectivity 154 Internet 155 Virtual Network Peering 156 VPN Gateway 165 Virtual Network Peering vs. VPN Gateway 177 Azure to On-Premises Connectivity 178 VPN Gateways 178 ExpressRoute Connections 189 Intersite Connectivity Architecture 193 Virtual WAN 196 Summary 197 Exam Essentials 198 Review Questions 199 Chapter 5 Network Traffic Management 203 Availability Options 204 Availability Sets 205 Availability Zones 207 Service Level Agreement 208 Azure Load Balancer 208 Types of Load Balancers 209 Load Balancer SKUs 212 Configuring Load Balancer 212 Implementing Azure Load Balancer 214 Azure Application Gateway 221 Request Handling Process 222 Routing Methods 223 Configuring Application Gateway 224 Implementing Application Gateway 226 Azure Front Door 235 Azure Traffic Manager 237 Comparing the Load Balancing Solutions 239 Summary 239 Exam Essentials 240 Review Questions 241 Chapter 6 Azure Storage 245 Azure Storage Account 246 Azure Storage Services 247 Azure Blob Storage 247 Azure Files 248 Azure Queues 249 Azure Tables 249 Azure Disks 249 Storage Replication 250 Locally Redundant Storage 250 Zone Redundant Storage 251 Georedundant Storage 252 Geo-zone-Redundant Storage 253 Storage Account Types 255 Storage Account Endpoints 256 Accessing Storage 256 Custom Domain Configuration 256 Securing Storage Endpoints 257 Azure Blob Storage 258 Blob Containers 259 Blob Access Tiers 259 Blob Lifecycle Management 260 Uploading Blobs 261 Storage Security 268 Authorization Options 268 Shared Access Signatures 269 Storage Service Encryption 275 Azure Files and File Sync 276 Azure Files vs. Azure Blobs 276 Managing File Shares 277 Mapping File Shares 279 File Share Snapshots 282 Azure File Sync 285 Managing Storage 288 Azure Storage Explorer 289 AzCopy 291 Import/Export Service 297 Summary 299 Exam Essentials 300 Review Questions 302 Chapter 7 Azure Virtual Machines 307 Virtual Machine Planning 309 Virtual Network 309 Name 309 Location and Pricing 310 Size 311 Storage 312 Operating System 315 Deploying Virtual Machines 315 Connecting to Virtual Machines 320 Windows Connections 320 Linux Connections 324 Azure Bastion 329 Availability of Virtual Machines 334 Scaling Concepts 335 Vertical Scaling 335 Horizontal Scaling 336 Virtual Machine Scale Sets 336 Implementing a Scale Set 337 Autoscaling 340 Summary 342 Exam Essentials 342 Review Questions 343 Chapter 8 Automation, Deployment, and Configuration of Resources 349 Azure Resource Manager 350 ARM Templates 352 Template Design 352 Template Modes 354 Template Sections 355 Composing Templates 361 Exporting Templates 370 Configuring Virtual Hard Disk Templates 374 Create a VM from a VHD 375 Virtual Machine Extensions 376 Custom Script Extension 378 Desired State Configuration 379 Summary 380 Exam Essentials 381 Review Questions 382 Chapter 9 PaaS Compute Options 387 Azure App Service Plans 388 Pricing Tiers 389 Scaling 391 Azure App Services 396 Continuous Deployment 400 Deployment Slots 402 Securing App Service 405 Custom Domains 408 Backup 409 Container Instances 411 Docker 412 Azure Container Instances 415 Container Groups 421 Azure Kubernetes Service 422 Terminology 424 Cluster Components 425 Networking 426 Storage 429 Cluster Upgrade 431 Scaling 432 Summary 438 Exam Essentials 439 Review Questions 440 Chapter 10 Data Protection 445 File and Folder Backups 446 Azure Backup 446 Creating Recovery Services Vault 447 Configuring a Recovery Services Vault 448 Virtual Machine Data Protection 451 Virtual Machine Snapshots 452 Azure Backup 453 Azure Backup Server 463 Azure Site Recovery 466 Summary 469 Exam Essentials 470 Review Questions 471 Chapter 11 Monitoring Resources 475 Azure Monitor 476 Metrics 477 Logs 478 Data Sources 479 Activity Log 480 Azure Alerts 482 Creating Alert Rules 483 Alert States 484 Action Groups 484 Log Analytics 492 Workspace 493 Data Sources 493 Agents Configuration 496 Query Language 497 Network Watcher 502 IP Flow Verify 503 Next Hop 503 Effective Security Rules 505 VPN Troubleshoot 505 Packet Capture 506 Connection Troubleshoot 506 NSG Flow Logs 507 Topology 509 Summary 509 Exam Essentials 510 Review Questions 511 Appendix Answers to the Review Questions 515 Chapter 1: Identity: Azure Active Directory 516 Chapter 2: Compliance and Cloud Governance 517 Chapter 3: Virtual Networking 519 Chapter 4: Intersite Connectivity 520 Chapter 5: Network Traffic Management 521 Chapter 6: Azure Storage 522 Chapter 7: Azure Virtual Machines 524 Chapter 8: Automation, Deployment, and Configuration of Resources 526 Chapter 9: PaaS Compute Options 528 Chapter 10: Data Protection 529 Chapter 11: Monitoring Resources 530 Index 533

Read more less

Book SynopsisPrepare for Microsoft Exam 70-345—and help demonstrate your real-world mastery of Exchange Server 2016 planning, deployment, migration, management, and troubleshooting. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the skills measured on the exam: Plan, deploy, manage, and troubleshoot mailbox databases Plan, deploy, manage, and troubleshoot client access services Plan, deploy, manage, and troubleshoot transport services Plan, deploy, and manage an Exchange infrastructure, recipients, and security Plan, deploy, and manage compliance, archiving, eDiscovery, and auditing Implement and manage coexistence, hybrid scenarios, migration, and federation This Microsoft Exam Ref: Organizes its coverage by the “Skills measured” posted on the exam webpage Features strategic, what-if scenarios to challenge you Provides exam preparation tips by top trainers Points to in-depth material by topic for exam candidates needing additional review Assumes you have experience designing and managing Exchange Server, and have responsibilities for Exchange Server 2016 messaging in an enterprise environment Table of ContentsIntroduction Chapter 1 Plan, deploy, manage, and troubleshoot mailbox databases Skill 1.1: Plan, deploy, and manage mailbox databases Skill 1.2: Plan, deploy, and manage high availability solutions for mailbox databases Skill 1.3: Plan, deploy, and manage a site-resilient Database Availability Group (DAG) Skill 1.4: Monitor and troubleshoot mailbox databases Skill 1.5: Plan, deploy, and manage backup and recovery solutions for mailbox databases. Chapter 2 Plan, deploy, manage, and troubleshoot client access services Skill 2.1: Plan, deploy, and manage Client Access services Skill 2.2: Plan, deploy, and manage mobility solutions Skill 2.3: Plan, deploy, and manage load balancing Skill 2.4: Monitor and troubleshoot client connectivity Skill 2.5: Plan, deploy, and manage a site-resilient client access services solution Chapter 3 Plan, deploy, manage, and troubleshoot transport services Skill 3.1: Plan, deploy, and manage transport services Skill 3.2: Troubleshoot and monitor transport services Skill 3.3: Plan, deploy, and manage message hygiene Skill 3.4: Plan, deploy, and manage site resilient transport services Chapter 4 Plan, deploy, and manage Exchange infrastructure, recipients, and security Skill 4.1: Plan and configure Active Directory Domain Services for Exchange and Organizational settings Skill 4.2: Create and configure mail-enabled objects Skill 4.3: Manage mail-enabled object permissions Skill 4.4: Plan, deploy, manage, and troubleshoot Role Based Access Control Skill 4.5: Plan an appropriate security strategy Skill 4.6: Plan, deploy, manage, and troubleshoot Chapter 5 Plan, deploy, and manage compliance, archiving, eDiscovery, and auditing 245 Skill 5.1: Plan and configure Data Loss Prevention (DLP) solutions Skill 5.2: Plan, configure, and manage Archiving and Message Records Management (MRM) Skill 5.3: Plan, configure, and perform eDiscovery Skill 5.4: Plan, configure, and manage a compliance solution Skill 5.5: Plan, manage, and use mailbox and administrative auditing Chapter 6 Implement and manage coexistence, hybrid scenarios, migration, and federation 295 Skill 6.1: Plan, deploy and troubleshoot coexistence with Office 365 (Exchange Online Skill 6.2: Plan, deploy, manage, and troubleshoot Exchange federation Skill 6.3: Plan, deploy, and troubleshoot on-premises coexistence with earlier supported versions of Exchange Skill 6.4: Migrate from earlier supported versions of Exchange

Read more less

Book SynopsisPrepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement SQL in Azure • Manage databases and instances • Manage storage This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning Table of ContentsIntroduction Chapter 1 Implement SQL in Azure Skill 1:1: Deploy a Microsoft Azure SQL Database Skill 1:2: Plan for SQL Server installation Skill 1:3: Deploy SQL Server instances Skill 1:4: Deploy SQL Server databases to Azure virtual machines Chapter 2 Manage databases and instances Skill 2.1: Configure secure access to Microsoft Azure SQL databases Skill 2.2: Configure SQL Server performance settings Skill 2.3: Manage SQL Server instances Chapter 3 Manage Storage Skill 3.1: Manage SQL Storage Skill 3.2: Perform database maintenance

Read more less

Book SynopsisPrepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. Focus on the expertise measured by these objectives: • Configure data access and auditing • Manage backup and restore of databases • Manage and monitor SQL Server instances • Manage high availability and disaster recovery This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access. About the Exam Exam 70-764 focuses on skills and knowledge required for database administration. About Microsoft Certification Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning Table of Contents 1. Configure Data Access and Auditing 2. Manage Backup and Restore of Databases 3. Manage and Monitor SQL Server Instances 4. Manage High Availability and Disaster Recovery

Read more less

Book SynopsisPrepare for Microsoft Exam 70-744–and help demonstrate your real-world mastery of securing Windows Server 2016 environments. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the expertise measured by these objectives: • Implement server hardening solutions • Secure a virtualization infrastructure • Secure a network infrastructure • Manage privileged identities • Implement threat detection solutions • Implement workload-specific security This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience as a Windows Server administrator and an understanding of basic networking and Hyper-V virtualization fundamentals, Active Directory Domain Services principles, and Windows Server security principlesTable of ContentsChapter 1: Implement server hardening solutions 1.1 Configure disk and file encryption 1.2 Implement server patching and updating solutions 1.3 Implement malware protection 1.4 Protect credentials 1.5 Create security baselines Chapter 2: Secure a virtualization infrastructure 2.1 Implement a Guarded Fabric solution 2.2 Implement Shielded and encryption-supported VMs Chapter 3: Secure a network infrastructure 3.1 Configure Windows Firewall 3.2 Implement a Software Defined Distributed Firewall 3.3 Secure network traffic Chapter 4: Manage privileged identities 4.1 Implement an Enhanced Security Administrative Environment (ESAE) administrative forest design approach 4.2 Implement Just-In-Time (JIT) Administration 4.3 Implement Just-Enough-Administration (JEA) 4.4 Implement Privileged Access Workstations (PAWs) and User Rights Assignments 4.5 Implement Local Administrator Password Solution (LAPS) Chapter 5: Implement threat detection solutions 5.1 Configure advanced audit policies 5.2 Install and configure Microsoft Advanced Threat Analytics (ATA) 5.3. Determine threat detection solutions using Operations Management Suite (OMS) Chapter 6: Implement workload-specific security 6.1 Secure application development and server workload infrastructure 6.2 Implement a secure file services infrastructure and Dynamic Access Control (DAC)

Read more less

Book SynopsisPrepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Filter, sort, join, aggregate, and modify data • Use subqueries, table expressions, grouping sets, and pivoting • Query temporal and non-relational data, and output XML or JSON • Create views, user-defined functions, and stored procedures • Implement error handling, transactions, data types, and nulls This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer • Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database Querying Data with Transact-SQL About the Exam Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases with Transact-SQL in SQL Server 2016. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification. See full details at: microsoft.com/learningTable of ContentsCHAPTER 1 Manage data with Transact-SQL CHAPTER 2 Query data with advanced Transact-SQL components CHAPTER 3 Program databases by using Transact-SQL

Read more less

Book SynopsisPrepare for Microsoft Exam 70-347--and help demonstrate your real-world mastery of the skills needed to help securely and efficiently provide Microsoft Office 365 services in any environment. Designed for experienced IT pros ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Manage clients and end-user devices Provision Microsoft SharePoint Online site collections Configure Microsoft Exchange Online and Skype for Business for end users Plan for Exchange Online and Skype for Business This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Provides exam preparation tips written by a top trainer, consultant, and sysadmin Assumes you have experience with the Office 365 Admin Center and an understanding of Exchange Online, Skype for Business, SharePoint Online, Office 365 ProPlus, and Microsoft Azure Active Directory Table of ContentsChapter 1:Manage clients and end-user devices• Manage user-driven client deployments• Manage IT deployments of Office 365 ProPlus• Set up telemetry and reporting• Plan for Office clients Chapter 2: Provision SharePoint Online site collections• Configure external user sharing• Create SharePoint site collection• Plan a collaboration solution Chapter 3:Configure Exchange Online and Skype Online for end users• Configure additional e-mail addresses for users• Create and manage external contacts, resources and groups• Configure personal archive policies• Configure Skype for Business Online end-user communication settings Chapter 4:Plan for Exchange Online and Skype for Business Online• Manage anti-malware and anti-spam policies• Recommend a mailbox migration strategy• Plan for Exchange Online• Manage Skype for Business

Read more less

Book SynopsisPrepare for Microsoft Exam 70-346, and demonstrate your real-world mastery of the skills needed to provision, manage, monitor, and troubleshoot Microsoft Office 365 identities and cloud services. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. The new Second Edition reflects all updated exam topics released by Microsoft through mid-2017. It covers the expertise measured by the following objectives: Provision Office 365 Plan and implement networking and security in Office 365 Manage cloud identities Implement and manage identities by using DirSync Implement and manage Federated Identities single sign on Monitor and troubleshoot Office 365 availability and usage Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all content Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro’s job role See full details about Exam 70-346 at: microsoft.com/learningTable of ContentsChapter 1 Provision Office 365 Skill 1.1: Provision tenants Skill 1.2: Add and configure custom domains Skill 1.3: Plan a pilot Chapter 2 Plan and Implement Networking and Security in Office 365 Skill 2.1: Configure DNS records for services Skill 2.2: Enable client connectivity to Office 365 Skill 2.3: Administer Microsoft Azure Rights Management Skill 2.4: Manage administrator roles in Office Chapter 3 Manage cloud identities Skill 3.1: Configure password management Skill 3.2: Manage user and security groups Skill 3.3: Manage cloud identities with Windows PowerShell Chapter 4 Implement and manage identities by using Azure AD Connect Skill 4.1: Prepare on-premises Active Directory for Azure AD Connect Skill 4.2: Set up Azure AD Connect Skill 4.3: Manage Active Directory users and groups with Azure AD Connect in place Chapter 5 Implement and manage federated identities single sign on Skill 5.1: Plan requirements for Active Directory Federation Services Skill 5.2: Install and manage AD FS Servers Skill 5.3: Install and manage AD FS Proxy Servers Chapter 6 Monitor and troubleshoot Office 365 availability and usage Skill 6.1: Analyze reports Skill 6.2: Monitor service health Skill 6.3: Isolate service interruption

Read more less

Book SynopsisPrepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI Table of Contents Chapter 1 Consuming and transforming data by using Power BI Desktop Skill 1.1: Connect to data sources Skill 1.2: Perform transformations Skill 1.3: Cleanse data Chapter 2 Modeling and visualizing data Skill 2.1: Create and optimize data models Skill 2.2: Create calculated columns, calculated tables, and measures Skill 2.3: Measure performance by using KPIs, gauges, and cards Skill 2.4: Create hierarchies Skill 2.5: Create and format interactive visualizations Skill 2.6: Manage custom reporting solutions Chapter 3 Configure dashboards, reports, and apps in the Power BI Service Skill 3.1: Access on-premises data Skill 3.2: Configure a dashboard Skill 3.3: Publish and embed reports Skill 3.4: Configure security for dashboards, reports, and apps Skill 3.5 Configure apps and apps workspaces

Read more less

Book SynopsisPrepare for Microsoft Exam 70-698—and help demonstrate your real-world mastery of installing, configuring, managing, and maintaining Windows 10 core services. Designed for experienced IT professionals ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement Windows • Configure and support core services • Manage and maintain Windows This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience with installing, configuring, and locally managing and maintaining Windows 10 core servicesTable of ContentsChapter 1:Implement Windows Skill 1.1 Prepare for installation requirementsSkill 1.2 Install Windows 10Skill 1.3 Configure devices and device driversSkill 1.4 Post-installation configurationSkill 1.5 Implement Windows in an enterprise environment Chapter 2 Configure and Support Core ServicesSkill 2.1 Configure networkingSkill 2.2 Configure storageSkill 2.3 Configure data access and usageSkill 2.4 Implement AppsSkill 2.5 Configure remote management Chapter 3 Manage and Maintain WindowsSkill 3.1 Configure updatesSkill 3.2 Monitor WindowsSkill 3.3 Configure system and data recoverySkill 3.4 Configure authorization and authenticationSkill 3.5 Configure advanced management tools

Read more less

Book SynopsisPrepare for Microsoft Exam 70-697–and help demonstrate your real-world mastery of configuring Windows 10 devices in the enterprise. Designed for experienced IT professionals ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Manage identity • Plan desktop and device deployment • Plan and implement a Microsoft 365 Solution • Configure networking • Configure storage • Manage data access and protection • Manage remote access • Manage apps • Manage updates and recovery This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience with Windows desktop administration, maintenance, and troubleshooting; Windows 10 security, and integrated Azure features; as well as a basic understanding of Windows networking, Active Directory, and Microsoft Intune For details on requirements for taking Exam 70-697, go to https://www.microsoft.com/en-us/learning/exam-70-697.aspx Table of ContentsChapter 1 Manage Identity Skill 1.1: Support Microsoft Store, Microsoft Store for Education, Microsoft Store for Business, and cloud apps Skill 1.2: Support authentication and authorization Chapter 2 Plan desktop and device deployment Skill 2.1: Migrate and configure user data Skill 2.2: Configure Hyper-V Skill 2.3: Configure mobility options Skill 2.4: Configure security for mobile devices Chapter 3 Plan and implement a Microsoft 365 solution Skill 3.1: Support mobile devices Skill 3.2: Deploy software by using Microsoft Intune Skill 3.3: Manage devices with Microsoft 365 Solution Skill 3.4: Configure information protection Chapter 4 Configure networking Skill 4.1: Configure IP settings Skill 4.2: Configure network settings Skill 4.3: Configure and maintain network security Chapter 5 Configure storage Skill 5.1: Support data storage Skill 5.2: Support data security Chapter 6 Manage data access and protection Skill 6.1: Configure shared resources. Skill 6.2: Configure file and folder access Chapter 7 Manage remote access Skill 7.1: Configure remote Skill 7.2: Configure mobility options Chapter 8 Manage apps Skill 8.1: Deploy and manage RemoteApp apps Skill 8.2: Support desktop apps Chapter 9 Manage updates and recovery Skill 9.1: Configure system recovery Skill 9.2: Configure file recovery Skill 9.3: Configure and manage updates

Read more less

Book SynopsisBecome well-versed with data engineering concepts and exam objectives to achieve Azure Data Engineer Associate certificationKey Features Understand and apply data engineering concepts to real-world problems and prepare for the DP-203 certification exam Explore the various Azure services for building end-to-end data solutions Gain a solid understanding of building secure and sustainable data solutions using Azure services Book DescriptionAzure is one of the leading cloud providers in the world, providing numerous services for data hosting and data processing. Most of the companies today are either cloud-native or are migrating to the cloud much faster than ever. This has led to an explosion of data engineering jobs, with aspiring and experienced data engineers trying to outshine each other.Gaining the DP-203: Azure Data Engineer Associate certification is a sure-fire way of showing future employers that you have what it takes to become an Azure Data Engineer. This book will help you prepare for the DP-203 examination in a structured way, covering all the topics specified in the syllabus with detailed explanations and exam tips. The book starts by covering the fundamentals of Azure, and then takes the example of a hypothetical company and walks you through the various stages of building data engineering solutions. Throughout the chapters, you'll learn about the various Azure components involved in building the data systems and will explore them using a wide range of real-world use cases. Finally, you'll work on sample questions and answers to familiarize yourself with the pattern of the exam.By the end of this Azure book, you'll have gained the confidence you need to pass the DP-203 exam with ease and land your dream job in data engineering.What you will learn Gain intermediate-level knowledge of Azure the data infrastructure Design and implement data lake solutions with batch and stream pipelines Identify the partition strategies available in Azure storage technologies Implement different table geometries in Azure Synapse Analytics Use the transformations available in T-SQL, Spark, and Azure Data Factory Use Azure Databricks or Synapse Spark to process data using Notebooks Design security using RBAC, ACL, encryption, data masking, and more Monitor and optimize data pipelines with debugging tips Who this book is forThis book is for data engineers who want to take the DP-203: Azure Data Engineer Associate exam and are looking to gain in-depth knowledge of the Azure cloud stack.The book will also help engineers and product managers who are new to Azure or interviewing with companies working on Azure technologies, to get hands-on experience of Azure data technologies. A basic understanding of cloud technologies, extract, transform, and load (ETL), and databases will help you get the most out of this book.Table of ContentsTable of Contents Introducing Azure Basics Designing a Data Storage Structure Designing a Partition Strategy Designing the Serving Layer Implementing Physical Data Storage Structures Implementing Logical Data Structures Implementing the Serving Layer Ingesting and Transforming Data Designing and Developing a Batch Processing Solution Designing and Developing a Stream Processing Solution Managing Batches and Pipelines Designing Security for Data Policies and Standards Monitoring Data Storage and Data Processing Optimizing and Troubleshooting Data Storage and Data Processing Sample Questions with Solutions

Read more less