Posts

Showing posts with the label RPA tools

Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

Automation Career Top Skills You need

Image
Robotic process  automation  is an upcoming IT skill. Three tools are popular. It is difficult to learn all three tools. So, learn anyone's tool to start your career in automation. To get a job in this line, I found in my research that some programming skills and Hand-on training on any one of the tools are required. Also, try to know  the differences between popular RPA tools . Skills Companies Looking in Automation Engineers All big companies looking for candidates having experience in Automation Anywhere , Blue Prism, and UIPath. It is not possible to learn all tools. Learn anyone's tool and do practice well. Ok. You may ask a question about how to do it. Join in a good training institute and learn one tool.  Take online classes to learn faster. To  learn Uipath  try here. Also, you can enroll in online courses to learn UiPath. UiPath GO The list of IT skills you need Automation anywhere/Blue Prism/Uipath  .Net/C#/Java/SQL skills  MS-Visio  Powe

Three Top RPA tools functional differences

Image
Robotic process automation is a grown-up area. Many IT developers across the board started up-skill in this popular area. This post is useful for Software developers who are interested in RPA (Robotic Process Automation). In my previous post , I have shared twelve RPA tools. Out of those, three tools are the most popular. Those are Automation Anywhere, BluePrism, and Uipath. This post covers differences in these tools. Blue Prism Blue Prism has taken a simple concept, replicating user activity on the desktop, and made it enterprise strength. The technology is scalable, secure, resilient, and flexible. It is has a comprehensive methodology, operational framework, and provided as packaged software. The technology is developed and deployed within a corridor of IT governance. It has sophisticated error handling and process modeling capabilities to ensure it can perform at scale within demanding, highly sophisticated operating environments. The combination of SOA/BPMS and Blue Prism pl