Robotic Process Automation: Tech Primer

Course details

Robotic process automation (RPA) is a powerful way to develop software-based robots to automate repetitive and manual tasks. To get started in RPA, it's important to master a broad base of business and technical skills. In this course, instructor Bryan Lamb reviews these core skills, including flowchart fundamentals, file system basics, and important programming concepts. Learn how to build detailed flowcharts to document enterprise processes spanning multiple technologies, including email, documents, databases, websites, mainframes, and APIs. Discover how to navigate the Windows file system from top to bottom, in order to read and write data from text, PDF, spreadsheet, database, and other files. Explore the structure and programming behind websites and learn how to select and manipulate individual web elements. Explore programming concepts and database basics, and test your learning with a challenge at the end of the course.

Learning objectives
Summarize flowchart fundamentals.
Describe Windows file system concepts.
Outline the Visual Studio installation process.
Create a simple webpage.
Name three common web technologies.
Explain web and UiPath selector basics.
Develop a simple computer program.

Concepts

0. Introduction

01 - About the course
02 - About me
03 - Why do you need a tech primer
04 - System awareness and understanding

1. Setup and Preview Tools

05 - Overview
06 - Install local Microsoft apps
07 - Switch Windows login from PIN to password
08 - Install PyCharm IDE
09 - Install Visual Studio IDE
10 - Install UiPath Studio

2. Windows File System Basics

11 - Overview
12 - Best file system and view settings
13 - Disk basics
14 - Folder basics
15 - File basics
16 - Screenshots
17 - Command line basics
18 - Absolute vs. relative path
19 - Use a batch file to reduce clicks
20 - RPA tool vs. batch file
21 - Fix the Win 11 Notepad app
22 - Takeaways

3. Flowchart Basics

23 - Overview
24 - Flowchart fundamentals
25 - Flowchart best practices
26 - Flowchart tool demo
27 - RPA tool flowchart features

4. Website Basics

28 - Overview
29 - Intro to HTML web pages
30 - Overview of web technologies
31 - HTML tag and attribute deep dive
32 - Website structure
33 - CSS - Look and feel
34 - Bootstrap
35 - Summary

5. Web Selectors Deep Dive

36 - Overview
37 - Demo website orientation
38 - Selector basics
39 - Selector challenges
40 - Dynamic selectors

6. Desktop App Basics

41 - Create a desktop app
42 - Automate a desktop app

7. Programming Basics

43 - Overview
44 - Create a console app
45 - Programming basics - Visual Studio
46 - Programming basics - UiPath Studio
47 - Intro to functions
48 - Functions demo - Visual Studio
49 - Functions demo - UiPath Studio
50 - Intro to variables
51 - Variables demo - Visual Studio
52 - Variables demo - UiPath Studio
53 - Intro to object-oriented programming
54 - Object-oriented programming demo
55 - The .NET framework

8. Database Basics

56 - Overview
57 - Databases in business systems
58 - What is a database
59 - Set up database tools
60 - Create a database
61 - UiPath database interaction

9. Challenge - Create a Login and Track Value Bot

62 - The challenge
63 - Solution

Conclusion

64 - Wrap up