Writing Advanced SQL Queries on PostgreSQL (Udemy.com)

Learn to create more complex SQL Queries

( 2 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2021

What you will learn

Query tables
Write queries using various aggregate functions
Write queries using various analytic functions
Download and install PostgreSQL
Load sample database
Connect o database
Extract data from multiple tables

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 50 / 100

Course Description

PostgreSQL is commonly known as Postgres and it is also open source database. There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common relational database advanced queries using various analytic and aggregate functions.
What you will learn includes:
Downloading and installing PostgreSQL
Querying tables
Introduction to Aggregate Functions
Writing queries to perform various aggregate functions like: AVG, COUNT, SUM, MIN,MAX
Introduction to Analytic Functions
Illustrating various Analytic functions
Row Number Functions
Using various types of Operators
Introduction to Table Joins
Using various types of joins
Windowing functions for working with ordered data sets
Postgresql INNER JOIN
Retrieving all Data from Table
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL NATURAL JOIN
PostgreSQL Left Join
The course will teach you how to aggregate data,analyse data ,retrieve data from multiple tables using table joins and write more advanced queries.Who this course is for:

Beginner DBA's
Anyone who wants to learn something new

Time: 3.5h

Instructor Details

Bluelime Learning Solutions

2.5 Rating
2 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.

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) (2021)
3.7 (260 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

17 Beginner C# Walkthrough Projects step by step

17 Beginner C# Walkthrough Projects step by step (2021)
3.9 (189 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Coding for beginners (2021)
4.0 (117 Reviews)

- Provider: Udemy
- Time: 22h

$11.99

PostgreSQL Database Administration (DBA) for Beginners

PostgreSQL Database Administration (DBA) for Beginners (2018)
3.2 (93 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

Python and Django Full-Stack Web Development for beginners

Python and Django Full-Stack Web Development for beginners (2021)
4.3 (58 Reviews)

- Provider: Udemy
- Time: 34.5h

$11.99

Learn Java by building 17 projects step by step

Learn Java by building 17 projects step by step (2018)
3.6 (52 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

All courses by Bluelime Learning Solutions

Reviews

2.5

2 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Vlad Savchyn

It would be helpful to explain declare and other pull/ingest type queries in "advanced" course. Count, avg, min, max are imho very beginner level commands

By John Siladie

The videographer / speaker takes a long time to explain rather simple concepts, in such a way that it almost doesnt seem like he fully knows the subject matter. The cadence of these videos (both in speech and in speed-of-material-acquisition) is undeniably slow.