Computer certification: Microsoft Books

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

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