Computer certification: Microsoft Books

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 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

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

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 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 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 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 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 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 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

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 Synopsis

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 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 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 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 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 Synopsis

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 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 SynopsisAn administrator's guide to deploying, configuring, securing, managing, and monitoring devices and client applications in an enterprise environment and passing Exam MD-100: Windows 10 easilyKey Features Equip yourself to earn the Microsoft 365 Certified: Modern Desktop Administrator Associate certification Develop the skills needed to pass the Exam MD-100 and advance in your organization Learn to install Windows 10 operating systems and deploy and manage modern desktops and devices Book DescriptionMicrosoft Exam MD-100 Windows 10 Certification Guide offers complete, up-to-date coverage of the MD-100 exam, helping you take the exam with confidence, fully equipped to pass on the first attempt.Complete with a clear, succinct explanation of key concepts, self-assessment questions, tips, and mock exams with detailed answers, this MD-100 study guide covers different facets of upgrading and deploying Windows 10. You’ll learn how to manage devices and data, configure connectivity, troubleshoot OS and app problems, and secure and maintain Windows 10 with updates and recovery. You’ll also explore different Windows 10 editions and learn how to choose the best fit for your organization. This book will guide you in installing and configuring Windows 10 using different approaches. As you advance, you’ll get to grips with managing local users and groups in Windows 10 and learn how to establish connections via different networks, such as a LAN and WLAN/Wi-Fi.By the end of this book, you'll have covered everything you need to pass the MD-100 certification exam and become a Microsoft 365 Certified: Modern Desktop Administrator Associate.What you will learn Deploy Windows 10 in a variety of ways Manage local users, groups, and devices Configure networking and remote connectivity Gain insights into Windows 10 maintenance Customize different Windows 10 features Become an expert at troubleshooting and recovery Get to grips with managing log files Monitor and manage Windows security Who this book is forThis book is for both experienced and novice IT administrators who work with deploying, configuring, securing, and monitoring devices. Anyone with a working knowledge of managing identity, access, policies, updates, and apps can take this exam. Although not necessary, experience with Microsoft 365 workloads, Windows 10 devices, and non-Windows devices will be helpful.Table of ContentsTable of Contents Deploying Windows 10 Upgrading Windows 10 Customizing and Configuring Windows 10 Managing Local Users, Groups and Devices Configuring Permissions and File access Configuring and Implementing Local Policies Securing Data and Applications Configuring Various Networks Configuring Remote Connectivity Understanding Troubleshooting and Recovery Managing Updates Managing Log Files Mock Exam (A and B)

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 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 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 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-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 SynopsisGain the knowledge and skills needed to become a certified Microsoft Power BI data analyst and get the most out of Power BIKey Features Get the skills you need to pass the PL-300 certification exam with confidence Create and maintain robust reports and dashboards to enable a data-driven enterprise Test your new BI skills with the help of practice questions Book DescriptionMicrosoft Power BI enables organizations to create a data-driven culture with business intelligence for all. This guide to achieving the Microsoft Power BI Data Analyst Associate certification will help you take control of your organization's data and pass the exam with confidence.From getting started with Power BI to connecting to data sources, including files, databases, cloud services, and SaaS providers, to using Power BI's built-in tools to build data models and produce visualizations, this book will walk you through everything from setup to preparing for the certification exam. Throughout the chapters, you'll get detailed explanations and learn how to analyze your data, prepare it for consumption by business users, and maintain an enterprise environment in a secure and efficient way.By the end of this book, you'll be able to create and maintain robust reports and dashboards, enabling you to manage a data-driven enterprise, and be ready to take the PL-300 exam with confidence.What you will learn Connect to and prepare data from a variety of sources Clean, transform, and shape your data for analysis Create data models that enable insight creation Analyze data using Microsoft Power BI's capabilities Create visualizations to make analysis easier Discover how to deploy and manage Microsoft Power BI assets Who this book is forThis book is for data analysts and BI professionals who want to become more competent in Microsoft Power BI. Although the content in this book will help you pass the PL-300 exam, there are plenty of other practical applications beyond exam preparation in the chapters. No prior experience with Power BI is needed.Table of ContentsTable of Contents Overview of Power BI and the PL-300 Exam Connecting to Data Sources Profiling the Data Cleansing, Transforming, and Shaping Data Designing a Data Model Using Data Model Advanced Features Creating Measures Using DAX Optimizing Model Performance Creating Reports Creating Dashboards Enhancing Reports Exposing Insights from Data Performing Advanced Analytics Managing Workspaces Managing Datasets Practice Exams

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 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