Overview Of Databases

Installation of PostGreSQL

Setting Up PgAdmin

Creating the Databases

Select Fundamentals

DISTINCT

WHERE

COUNT

LIMIT

ORDER BY

BETWEEN

IN

LIKE

WHERE VS HAVING

MIN MAX SUM & AVG

GROUP BY

HAVING

Overview of Joins

AS Statement

Join Types

INNER JOIN

OUTER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

UNION

Timestamp and Extract

Mathematical Functions

String Function

Operators

Subquery

Self-Join

Data Types

Primary Key

Foreign Key

Constraints

Real Time -Table Creation Challenges

INSERT

UPDATE

DELETE

ALTER

DROP

CHECK Constraint

NOT NULL Constraint

UNIQUE Constraint

VIEWS

Overview

Psycopg2

Analyzing Customer Behavior

Customer Value Analysis - Case study

LAG Function

Order Status Analysis

Predict Lifetime Value

Identifying - Cross-Selling Pattern

Profit & Loss Analysis Project