Course

Advanced Data Manipulation with Studio

This course provides a comprehensive introduction of how to use the more advanced data manipulation techniques: DateTime variables and LINQ.
  • 17273 enrolled students
  • October 25, 2023
Not Started

Watch a preview

Advanced Data Manipulation with Studio

  • 001:20:00
  • Downloadable resources available
  • Diploma of Completion included
Start Learning Now

Course details

Difficulty Level

Advanced

Language

English

Completion time

001:20:00

Product covered

Studio

About the Advance Data Manipulation with Studio course

In this course, we'll cover some more advanced data manipulation techniques in UiPath Studio. More specifically, we'll perform a wide range of data manipulation operations using the DateTime variables. What’s more, we’ll use LINQ to filter DataTables and Lists.

Product Alignment: This course was built using the 2022.10 product version of UiPath Studio and is applicable to newer versions as well.

Prerequisites for Advance Data Manipulation with Studio course

  • Automation Developer Associate Training: This learning plan will teach you how to use data in Studio and create better user interface automation projects. You'll also learn how to make things like Excel, PDF, and email work automatically. Specifically, you'll learn about these topics: 
  • Variables, Constants and Arguments in Studio. 
  • Control Flow in Studio. 
  • Excel Automation with Modern Experience in Studio. 
  • Data Manipulation with Strings in Studio. 
  • Data Manipulation with Lists and Dictionaries in Studio. 
  • Basic Programming Knowledge. 
  • Import the System.LINQ Namespace in UiPath Studio. 

Course Audience

This is a one hour and twenty-minute course aimed primarily at Automation Developers.   

Advance Data Manipulation with Studio Course Agenda

  • Introduction to LINQ. 
  • Filtering Data in Collection. 
  • LINQ for Lists. 
  • LINQ for DataTables. 
  • Exercise: Analyzing Sales Data using LINQ 
  • Working with DateTime Variable. 
  • Exercise: Calculate a Date Time Difference.

Advance Data Manipulation with Studio Course Objectives

At the end of this course, you should be able to: 

  • Analyze and evaluate the core concepts, principles, and practical benefits of LINQ queries for data manipulation and retrieval tasks.  
  • Interpret LINQ lambda expressions and their programming significance, along with demonstrating effective application of LINQ techniques. 
  • Identify the potential benefits of using LINQ for data manipulation. 
  • Implement LINQ techniques to manipulate and extract data as needed.  
  • Apply principles of LINQ to manipulate a given list of numbers through a series of operations. 
  • Apply LINQ techniques to effectively filter and analyze employee data within a DataTable. 
  • Implement the LINQ operations on sales data using UiPath Studio. 
  • Use specific methods to perform data manipulation operations using DateTime variables. 
  • Develop a workflow to calculate the DateTime difference between two events.