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

Three top big data trainings useful to get deep insights

training programs

I have selected 3 top professional training programs for all working engineers.
  1. ISB- Indian School of Business: started a course in "Certificate Program" in Analytics:The use of Business Analytics is widespread across all industries and functions, including Information Technology, Web/E-commerce, Healthcare, Law Enforcement, Banking and Insurance, Biotechnology, Human Resource Management.
  2. WIPRO-Started deepening: its Analytical Business with " OPERA SOLUTIONS":Opera Solutions will allow Wipro engineers to offer solutions for customers based on the predictive analytics company's technology platform, according to a senior executive of the New Jersey based company. 
  3. SAAS - Software as a service changed INDIA IT indutsry: Empowering non-tech employees.The SaaS revolution in India is also bringing about another important change in organizations. "The CMO today is even more empowered than before," said Gartner's Padmanabhan. "Previously, there was extensive dependency on IT, but now the technology department is more and more relegated to a support role for integration, data mining, overseeing contractual terms with vendors, and so on. They focus more on keeping the lights on," he added.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers