New Skills

New Training: Working with Data in Powershell

by Team Nuggets
New Training: Advanced OSPF Configurations and Use Cases picture: A
Follow us
Published on February 23, 2021

In this 6-video skill, CBT Nuggets trainer Knox Hutchinson teaches you how to connect to, retrieve, and manipulate data from CSVs, Excel files, SQL Server, and JSON content. Watch this new Windows Server training.

Watch the full course: Programming Foundations with PowerShell 7

This training includes:

  • 6 videos

  • 27 minutes of training

You’ll learn these topics in this skill:

  • Introducing Data Interaction with PowerShell

  • Working with CSVs

  • Working with Excel Files

  • Querying SQL Server

  • Working with JSON

  • Summarizing PowerShell Data Automation Tasks

How to Pipe Structured Data with PowerShell

All shell environments can be used to automate tasks. That is one of the best reasons to use a command-line environment. One of the powerful features all command-line environments offer is the ability to pipe data between applications. That means system administrators can automate a way for one application to process data and pass its results to another application for additional processing. PowerShell takes this a step further, though.

Traditionally, shell environments will pipe information as a blob of data. It is not 'organized' per se. It's simply a string of stuff. PowerShell, on the other hand, can handle and pipe structured data.

Structured data is extremely important in the programming world. It is the core of object-oriented programming. Structured data is what is used to create 'objects'. Likewise, structured data is the fundamental idea in which JSON is designed to be used.

By utilizing structured data, PowerShell can not only communicate and pipe data through various applications but other scripts created by powerful programming languages like Python. That makes PowerShell more extensible and powerful than other command-line environments. If you utilize PowerShell, you need to understand how it handles structured data.


Download

By submitting this form you agree to receive marketing emails from CBT Nuggets and that you have read, understood and are able to consent to our privacy policy.


Don't miss out!Get great content
delivered to your inbox.

By submitting this form you agree to receive marketing emails from CBT Nuggets and that you have read, understood and are able to consent to our privacy policy.

Recommended Articles

Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2024 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522