Posts

Showing posts with the label Services

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

9 Top AWS Services a Quick List

Image
In this post, I have explained the top AWS services list . These services are useful to read before your next interview. knowing this list is a must for all cloud-computing engineers. AWS provides various services. This post gives a clear understanding of AWS's top services.  AWS Books AWS in action AWS Cookbook Not only for traditional services, but it also offers services for Mobile IoS and Android Os.  Aws Service catalog  helps organizations to manage their IT services. AWS List of Top AWS Services Quick List These 9 Services of AWS are popular. I have explained each service to understand quickly. EC2 Lambda S3 DynamoDB IAM Amazon Cognito Device Farm Mobile analytics SNS 1. AWS EC2 Instance EC2: Amazon Elastic Compute Cloud (EC2) provides secure, scalable, on-demand hardware virtualization in the cloud. Using Amazon EC2 eliminates the need to invest in server hardware upfront so that users can focus on, develop, and deploy applications faster.  EC2 instances com