PostgreSQL Beginner to Advanced for Data Analytics

Learn Postgres while doing hands-on querying real world datasets specifically designed for data analytics
PostgreSQL Beginner to Advanced for Data Analytics
File Size :
2.00 GB
Total length :
4h 16m



Shakti Jajpura


Last update




PostgreSQL Beginner to Advanced for Data Analytics

What you’ll learn

Ability to solve business problems through data oriented analytical approaches
Postgres SQL best practices
An understanding on how the real world datasets and solutions looks like for data analysts
Focused learning – Top 20% concepts which drives 80% value
Interactive assignments, quizzes and downloadable SQL files

PostgreSQL Beginner to Advanced for Data Analytics


No programming experience needed
Basic understanding of the data analytics field


This course is intended for anyone willing to get a good hands-on experience with PostgreSQL.The aim to have all the concepts clarified, and at the same time, keeping the content very interactive. The datasets we consider for all our hands-on work is very practical in nature. The assignment are designed in such a way to give you an idea of exact problems that the analytics professionals face on day-to-day basis. Therefore, the course will serve as a way to gain problem solving capabilities as an added benefit.After successful completion of this course, you will be able to translate business problem statements into data driven solutions. For example, if there is a requirement to look at past year performance, you know exactly what KPI needs to be looked at using the data available.Tools required – (1) PGAdmin 4, (2) PostgreSQL. There is a dedicated section in this course on setting up the environment.The whole course is majorly divided into 3 sections – Beginners, Intermediate and Expert. Based on the current level of experience you have, you can choose to start from either of these and to also jump between sections as needed. There is negligible dependency between the lectures so you can focus on your specific learning goals rather than focusing on everything.There is no prior coding experience mandatorily required to start this course. Only the motivation to learn is enough :)Make the most use of the available Udemy tools like Q&A, Assignment, Notes, etc. to clarify the doubts and self evaluate.


Section 1: Introduction

Lecture 1 Introduction

Lecture 2 SQL use case in Analytics

Section 2: Setting up the environment

Lecture 3 Installing Postgres for Windows

Lecture 4 PGAdmin 4 walkthrough

Lecture 5 Load the csv files for sample dataset

Section 3: Beginners

Lecture 6 SELECT, FROM and LIMIT keyword

Lecture 7 CREATE and INSERT command

Lecture 8 WHERE keyword

Lecture 9 ORDER BY, LIMIT and FETCH keyword

Lecture 10 GROUP BY and HAVING command

Lecture 11 Use case – Finding the granularity of any table

Lecture 12 JOINS in Postgres

Lecture 13 UNION, UNION ALL, INTERSECT and EXCEPT commands

Lecture 14 Writing sequence and Execution sequence

Section 4: Intermediate

Lecture 15 CASE WHEN statements

Lecture 16 Use case – Careful while using WHERE with OUTER JOINS

Lecture 17 Subqueries in Postgres

Lecture 18 Use case – CROSS JOINS


Lecture 20 GROUPING SETS, CUBE and ROLLUP commands

Lecture 21 Window Functions

Lecture 22 Use case – Finding the Mean, Median and Mode

Lecture 23 Use case – Lag and Lead Window functions

Anyone interested about analytics and urge to get practical hands-on work on Postgres,Separate sections for Beginners, Intermediate, Expert is created for students to choose from

Course Information:

Udemy | English | 4h 16m | 2.00 GB
Created by: Shakti Jajpura

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top