PostgreSQL: Advanced SQL Queries and Data Analysis
3.6 (152 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,984 students enrolled

PostgreSQL: Advanced SQL Queries and Data Analysis

Learn Practical Hands-on Advanced PostgreSQL Queries and Data Analysis
3.6 (152 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,984 students enrolled
Last updated 12/2019
English
English [Auto]
Current price: $74.99 Original price: $124.99 Discount: 40% off
4 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 63 lectures 07:07:00
+ Installation and Setup
11 lectures 01:13:20
Minimum Requirements
03:29
Installing PostgreSQL on Windows 10
10:46
Connecting to a PostgreSQL Database
09:35
Installing PostgreSQL MacOS
03:15
Load Sample Database
09:26
Creating a new Table
06:35
Populating a Table
08:32
Query a Table
06:44
+ PostgreSQL Server and Database Objects
9 lectures 46:36
Server Service
05:00
Schema
03:46
Tablespace
03:30
Functions
04:47
Cast and Operators
02:48
Sequence
06:44
Extensions
04:42
Introduction to stored proceedures
04:43
Creating a function
10:36
+ Some PostgreSQL Operators
9 lectures 01:08:18
UNION Operator
04:42
UNION ALL operator
03:30
INTERSECT Operator
06:20
EXCEPT Operator
08:57
IN Operator
10:57
AND Operator
07:07
OR Operator
06:35
Using AND with OR
08:33
LIKE Operator
11:37
+ Table Joins
5 lectures 49:29
Inner Joins
10:35
Left Join
11:17
Full Outer Join
10:21
Cross Join
06:49
Natural Join
10:27
+ Aggregate Functions
6 lectures 51:53
Introduction to Aggregate Functions
02:03
AVG Function
11:56
COUNT Function
11:09
MAX Function
10:59
MIN Function
08:58
SUM Function
06:48
+ Triggers
5 lectures 48:47
Introduction to PostgreSQL Triggers
08:38
Creating your first trigger : Part 1
11:06
Creating your first trigger : Part 2
08:49
Creating your first trigger : Part 3
13:48
Managing Triggers
06:26
+ PostgreSQL Views
8 lectures 45:30
Introduction to Views
02:48
Benefits of using Views
01:56
Creating a View
09:07
Modifying and Removing Views
06:32
Introduction to Updatable Views
04:38
Creating Updatable Views
08:23
Introduction to Materialized Views
02:20
Creating a Materialized View
09:46
+ Analytic Functions
10 lectures 43:07
Introduction to Analytic Functions
05:39
Creating Sample Tables
06:01
Using AVG as a Window Function
04:03
ROW Number Functions
08:53
Rank Functions
03:11
Dense Rank Functions
02:53
First Value Function
02:26
Last Function
03:43
LAG Function
02:59
LEAD Function
03:19
Requirements
  • You should understand basic database concepts
  • You should have a basic understanding of SQL
  • You should have a basic understanding of PostgreSQL
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