The Microsoft Official Academic Course (MOAC) Program is the official product for Microsoft Programs in higher education. These learning products are created especially for the academic market and combine the business world focus and market research of Microsoft with 200 years of successful higher education publishing from Wiley. The program is based upon the same curriculum as the Microsoft IT Certifications to build the skills students need to succeed at work and the preparation they need to validate those skills and get the jobs they seek. All the support instructors need to deliver great courses on Microsoft software is in the program. Microsoft Updates will bring you the latest information on new products and curriculums and are a part of the program. MOAC is a great way for instructors to get ready to teach and for students to get ready to learn.

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries You also get an exam discount voucher—making this book an exceptional value and a great career investment.

Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI

Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package. Focus on the expertise measured by these objectives: • Design, and implement, and maintain a data warehouse • Extract, transform, and load data • Build data quality solutionsThis Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse. Implementing a SQL Data Warehouse About the Exam Exam 70-767 focuses on skills and knowledge required for working with relational database technology. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification. See full details at: microsoft.com/learning

Prepare for Microsoft Exam 70-246-and help demonstrate your real-world mastery of monitoring and operating a private cloud based on Microsoft System Centre 2012 R2. 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: Configure data centre process automation Deploy resource monitoring Monitor resources Configure and maintain service management Manage configuration and protection This Microsoft Exam Ref: Organises its coverage by objectives for Exam 70-246 Features strategic, what-if scenarios to challenge you Requires experience with Windows Server, System Centre 2012, security, high availability, fault tolerance, and networking in an enterprise environment, and basic skills with SQL Server, Windows PowerShell, and application configuration

Presents lessons covering exam objectives, practice exercises, real-world scenarios, and practice exams on the accompanying CD-ROM.

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam. Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully consume, transform, model, and visualize data with Excel 2016. Coverage includes: Importing data from external data sources Working with Power Query Designing and implementing transformations Applying business rules Cleansing data Creating performance KPIs And much more 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 For more information on Exam 70-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning.

This 70-411 Administering Windows Server 2012 textbook covers the second of three exams required for Microsoft Certified Solutions Associate (MCSA): Windows Server 2012 certification. This course will help validate the skills and knowledge necessary to administer a Windows Server 2012 Infrastructure in an enterprise environment. The three MCSA exams collectively validate the skills and knowledge necessary for implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment. This Microsoft Official Academic Course is mapped to the 70-411 Administering Windows Server 2012 exam objectives. This textbook focuses on real skills for real jobs and prepares students to prove mastery of core services such as user and group management, network access, and data security. In addition, this book also covers such valuable skills as: • Implementing a Group Policy Infrastructure • Managing User and Service Accounts • Maintaining Active Directory Domain Services • Configuring and Troubleshooting DNS • Configuring and Troubleshooting Remote Access • Installing, Configuring, and Troubleshooting the Network Policy Server Role • Optimizing File Services • Increasing File System Security • Implementing Update Management The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students. MOAC gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas: Instructor readiness, student software, student assessment, instruction resources, and learning validation. With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy. Request your sample materials today.

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

This Microsoft Official Academic Course (MOAC) IT Professional curriculum prepares certification students for success every step of the way. This 70-413 Designing and Implementing a Server Infrastructure exam course is the first of a series of two exams Microsoft Certified Solutions Associates (MCSE) candidates are required to pass to gain the MCSE: Windows Server 2012 and Windows Server 2012 R2 certification. These MCSE exams test the skills and knowledge necessary to design, implement, and maintain a Windows Server 2012 infrastructure in an enterprise scaled, highly virtualized environment. Passing these exams confirms students’ ability to plan, configure, and implement the Windows Server 2012 services, such as server deployment, server virtualization, and network access and infrastructure. This complete ready-to-teach MOAC program is mapped to all of the exam objectives.