PostgreSQL: Advanced SQL Queries and Data Analysis (Udemy.com)

Learn Practical Hands-on Advanced PostgreSQL Queries and Data Analysis

Created by: Bluelime Learning Solutions

Produced in 2021

icon
What you will learn

  • Setup PostgreSQL
  • Create Tables
  • Create Views
  • Update Views
  • Create Stored Procedures
  • Create Triggers
  • Manage Triggers
  • Create Analytic Functions
  • Create Aggregate Functions
  • Create Row number functions
  • Join Tables
  • Use various Operators

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 58 / 100

icon
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 and data science tasks, including writing advanced queries,data analysis , finding, exploration, and extraction within relational databases.
What you will learn includes:
Introduction PostgreSQL Triggers
Creating Triggers
Managing Triggers
Introduction to Views
How to create views
Modifying and Removing Views
Introduction to Updatable Views
Creating Updatable Views
Introduction to Materialized Views
Creating Materialized Views
Introduction to Stored Procedures
Introduction to Aggregate Functions
Illustrating various types of Aggregate functions
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
Installing PostgreSQL
Verify postgresql installation
Postgresql INNER JOIN
Postgres LIKE Operator
Postgresql OR Operator
Server service
Sequences
Schema
Retrieving all Data from Table
Loading sample database
Postgresql UNION Operator
PostgreSQL UNION ALL Operator
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL combining AND | OR Operator
PostgreSQL AND Operator
PostgreSQL NATURAL JOIN Operator
PostgreSQL EXCEPT Operator
PostgreSQL INTERSECT Operator
PostgreSQL Left Join
PostgreSQL IN Operator
Cast and Operators
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 SQL Developer
  • Beginner PostgreSQL Developer
  • Data Analyst
  • Anyone who wants to learn about PostgreSQL

icon
Instructor Details

placeholder

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.

icon
More courses by Bluelime Learning Solutions

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

$11.99

17 Beginner C# Walkthrough Projects step by step

$11.99

Coding for beginners

$11.99

PostgreSQL Database Administration (DBA) for Beginners

$11.99

Python and Django Full-Stack Web Development for beginners

$11.99

Learn Java by building 17 projects step by step

$11.99

icon
More postgresql courses

Rock the JVM! Akka Persistence with Scala

$11.99

SQL and PostgreSQL: The Complete Developer's Guide

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

$11.99

Python 3 Complete Masterclass - Make Your Job Tasks Easier!

$11.99

REST APIs with Flask and Python

$11.99

Python Django Dev To Deployment

$11.99

icon
Reviews

2.9

34 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Alexander da Franca Fernandes

The english speaking should be a little bit more fluid.

By Anonymized User

This is for beginners.

By Enric Bayés i Martín

Muy lento, y enfocado a la "venta" del producto, poca utilidad técnica.

Además los subtítulos en ingles, son absolutamente incorrectos y dan lugar a confusión.

By Idrissa Kamara

The starting of this course is very impressive. The tutor is very skilled and knows well the domain of database in general and more particularly PostgreSQL Database. Thanks

By David Reedy

This listed as a more advanced coarse. Why is there intro material on how client /server connections happen? Why would we need to no who uses this database type? I purchase this coarse to get more understanding of the types of actions that can happen in the view,trigger,stored procedures. Maybe this will happen further into the material?

By Deniz Boysan

I am a veteran digital marketer and have been managing large sums of spend, keywords, etc. in Google AdWords and others. I'm a beginner PostgreSQL learner. I've spent a few hours learning the basic language and how to navigate. My end goal is to become a significantly stronger data analyst by leveraging the ability to create custom databases and sophisticated functions to derive insights for my clients.

By Pete Burkindine

Many of the lectures are just slides or just show where in the admin tool to find the item (e.g. Casts) but no information about how to actually define one, the syntax and parts, real-world examples of use, etc. Not useful unless your only goal is to understand what the parts of ecosystem are.

By Andrey Gursky

I didn't expect that author will be showing queryes in pg_admin.

I thoght that advanced level is about linux termital without native GUI functionality.

By Justin

A bit slow at first, gets better towards the end.

By Walid

This course provides almost no information that you can't get just by gleaming over the UI of pgAdmin. The instructor just clicks on different parts of the UI, making obvious statements about what is very clearly the stated objective of the inputs in the tool - for example, "the comment field is for putting notes for yourself". When giving an example of UNION, he provides the UNION of two sets where one is a subset of the other, thereby rendering the UNION useless!

I would not recommend this course for anyone and consider a waste of the 1 hour I spent zipping through the material at 2x speed and clicking the forward button. The titles of the chapters in the course are completely deceptive as none of the material is actually covered in the instructions.

By Everett Griffiths

Oiy. I hate leaving bad reviews, but this course was just towing the line: it was uninspired. My review would be higher if it at least the title were changed to something like "PostgreSQL with PgAdmin" because _everything_ was done through PgAdmin. Learning the raw command-line commands would have been far more useful because rarely does a production server have GUI tools installed and there are lots of better GUIs available, so why bother to learn PgAdmin?

Specifically missing were any discussions about WHY PostgreSQL does things the way it does. HOW is it different? WHY is it better? HOW is one solution different from some other solution? Rote learning various commands isn't very valuable, or worse, just talking through the outline of topics _without providing examples or explanations_ does not educate the student very well.

The course at least attempted to be coherent, but unfortunately, I feel like I would have learned more had I spent the same amount of time experimenting on my own.

By Gilberto

Just ok. I thought it was a little to shallow.