Posts

Showing posts with the label Automation

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

Best Testing Practices You need for DevOps Projects

Image
Testing is the critical phase in DevOps. The process of DevOps is to speed up the deployment process. That means there are no shortcuts in testing. Covering most relevant test cases is the main thing the tester has to focus. Requirements  Good maintainable code Exhaustive coverage of cases Training documents to Operations team Fewer bugs in the bug tracker Less complex and no redundant code Testing Activities   The team to use Tools to check the quality of code Style checker helps to correct code style Good design avoids bugs in production Code performance depends on the code-quality Bugs in production say poor testing  Tester Roles  Good quality means zero bugs in production . Design requirements a base to validate testing results. Automated test scripts give quick feedback on the quality of code. Right test cases cover all the functional changes. The Bottom Line The DevOps approach is seamless integration between Development and Operations without

Top Skills You need for Automation Career

Image
According to KPMG -Process automation provides a means to integrate people in a software development organization with the development process and the tools supporting that development.  Successful career you need these Skills. What you will achieve by Automation By automating processes, you can boost your efficiency and help ensure standardized handling of repetitive workflow steps. Organiz ation’s benefits are translation projects that can be realized in a shorter time for less money. Skill set you need: Programming Languages (C++/Java/Scala), OOPs Concepts - MUST Unix/Linux - MUST Automation INDIA Jobs  |  USA Automation developer Jobs Automation Development/Scripting Experience - MUST XML/Xpath - Optional Perl/Python/Shell Scripting - Optional SQL/Sybase/Mongo DB - Optional Web Services - SOAP or REST API - Optional Additional Skills: Puppet/Chef/CFEngine experience  Experience with system packaging tools; e.g. RPM  SQL database programmi