Book Image

Powershell Core 6.2 Cookbook

By : Jan-Hendrik Peters
Book Image

Powershell Core 6.2 Cookbook

By: Jan-Hendrik Peters

Overview of this book

This book will follow a recipe-based approach and start off with an introduction to the fundamentals of PowerShell, and explaining how to install and run it through simple examples. Next, you will learn how to use PowerShell to access and manipulate data and how to work with different streams as well. You will also explore the object model which will help with regard to PowerShell function deployment. Going forward, you will get familiar with the pipeline in its different use cases. The next set of chapters will deal with the different ways of accessing data in PowerShell. You will also learn to automate various tasks in Windows and Linux using PowerShell Core, as well as explore Windows Server. Later, you will be introduced to Remoting in PowerShell Core and Just Enough Administration concept. The last set of chapters will help you understand the management of a private and public cloud with PowerShell Core. You will also learn how to access web services and explore the high-performance scripting methods. By the end of this book, you will gain the skills to manage complex tasks effectively along with increasing the performance of your environment.
Table of Contents (14 chapters)

Importing, Using, and Exporting Data

Importing, exporting, and using data in PowerShell is another essential skill. Whether you are using simple Comma-Separated Values (CSV) or you interact with RESTful APIs, PowerShell has got you covered. Many tools are able to export CSV and XML data, and management software very often exposes RESTful APIs. The following recipes will show you how to work with different types of data that you will usually encounter.

In this chapter, we will cover the following topics:

  • Working with CSV
  • Making objects transportable with XML
  • Modern data structures – JSON and YAML
  • Interacting with RESTful APIs
  • Interacting with MS SQL
  • Interacting with PostgreSQL and other database engines
  • Encrypting data