PostgreSQL: Advanced SQL Queries and Data Analysis

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 7 Hours | Lec: 66 | 601 MB

Genre: eLearning | Language: English

Learn Practical Hands-on Advanced PostgreSQL Queries and Data Analysis

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.