Posts

Showing posts with the label Skills Need Every Employee By 2020

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

Skills Need Every Employee By 2020

Image
With all the  predictions about the future of work , we are constantly painting a picture of how the future workplace will look. But, what most of us should focus on is what the workforce will  need   to look like – meaning, what skills employees need to have to ensure continued success into the next decade? The  Top 10 Online Colleges website  has the answer. They’ve done the research and compiled a list of skills that all employees will need by 2020 (which is only six years away!) and the drivers of the new skill set. First, we must understand what is driving change and molding the future of work. The six key drivers of change include: Extreme longevity:  People are living longer. The rise of smart machines and systems:  Tech will augment and extend our own capabilities. Computational world:  There will be an increase in sensors and processing that will make the world a programmable system. New media ecology:  There will be new communication tools that will require med