55318A is the updated version of the retired legacy Microsoft Official Curriculum (MOC) course 10962 - Advanced Automated Administration with Windows PowerShell. This 3-day instructor-led class helps individuals who use PowerShell scripting for domain, network, and application administration. New content has been added to help administrators use Machine Learning features in SQL Server by running Python and R queries. Optional exercises to install and configure SQL Server Machine Learning Services are included. The primary focus of the exercises and labs is Windows PowerShell but much of the material may also be used with PowerShell Core. The examples and demonstrations cover a wide range of services that PowerShell can be used with. Students will be able to practice using PowerShell with Active Directory, IIS, .NET resources, SMTP, SQL Server, and various file formats used for input / output operations such as JSON, XML and CSV. The virtual machines used for the class are built with PowerShell and the scripts are made available to students so they can build their own lab environment in Microsoft Azure or Hyper-V using the skills they learn in class. Audience This course is intended for IT professionals who are experienced in general Windows administration. Students should have a foundational knowledge of Windows PowerShell. At Course Completion After completing this instructor-led course, students will be able to: Create advanced functions. Use Microsoft .NET Framework and REST API in Windows PowerShell. Handle script errors. Use XML, JSON, and custom formatted data. Manage Microsoft Azure resources Analyze and debug scripts Understand Windows PowerShell workflow. Course Details Module 1: Creating advanced functions Module 2: Using Microsoft .NET Framework and REST API in Windows PowerShell Module 3: Writing controller scripts Module 4: Handling script errors Module 5: Using XML, JSON, and custom-formatted data Module 6: Enhancing server management with DSC and JEA Module 7: Analyzing and debugging scripts Module 8: Understanding Windows PowerShell Workflow
