Data Analysis With PostgreSQL: Analytic -Aggregate Functions (Udemy.com)

Practical Beginners Hands-on Data Analysis Using PostgreSQL's Analytic and Aggregate Fnctions

( 0 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2018

What you will learn

Install PostgreSQL
Create and populate a table
Load sample database
Connect to database
Analyse data with AVG aggregate function
Analyse data with SUM aggregate function
Analyse data with COUNT aggregate function
Analyse data with MAX aggregate function
Analyse data with MIN aggregate function
Analyse data with FIRST VALUE analytic function
Analyse data with RANK analytic function
Analyse data with DENSE RANK analytic function
Analyse data with LAST analytic function
Analyse data with LAG analytic function

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

Due to the ever increasing reliance and growth of data there is even a greater demand for professionals who can help analyse these large volume of data that is used daily in applications that we use and rely on daily like Facebook, Instagram,bank apps etc.
Aggregate functions perform a calculation on a set of values and return a single value. Analytic functions compute an aggregate value based on a set of values, and, unlike aggregate functions, can return multiple rows for each set of values.
If you want to run a query using only aggregate functions, the query will return one row with a column for each field. If you want to run a query using an aggregate function in conjunction with the GROUP BY function, the query will return one row for each value found in the grouped field.
If you want to run a query using an analytic function, the query will return one row for each field in the defined range of fields used to perform the calculations.
If you use an aggregate function with any other function in a query, one field in the query must contain the GROUP BY function.
Analytic functions are frequently used in fields such as finance and science to provide trend, outlier, and bucketed analysis for large data sets
Unlike traditional aggregation functions, which return only a single value for each group defined in the query, Analytic functions return a single value for each input row .They increase the efficiency and reduce the complexity of queries that analyse partitions (windows) of a data set.
This course will use aggregate and analytic functions to query and analyse data from a PostgreSQL database.Who this course is for:

Beginner DBA
Anyone who wants to learn something new.

Time: 2.5h

Instructor Details

Bluelime Learning Solutions

0.0 Rating
0 Reviews

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.