•Setting Up PostgreSQL Database Server
•What is SQL
•What is PosgreSQL
•Some Companies using PostgreSQL
•PostgreSQL Installation Requirements
•Please Read
•Installing PostgreSQL Server Version
•Connecting to a PostgreSQL Database
•Download and load Sample PostgreSQL Database
•Download PostgreSQL version
•Install PostgreSQL on windows
•Verify PostgreSQL installation
•Connecting to PostgreSQL database
•Load sample database on PostgreSQL
•Installing PostgreSQL on Mac
•Database Concepts
•What is Schema
•Data Types
•Unique Constraint
•SQL C R U D Operations
•Creating a database
•Create a table with Pgadmin
•Create a table with SQL CREATE Statement
•Reading Data with SELECT Statement
•Extracting and Reading all data from a table
•Extracting and Reading data from a specific Column
•Updating existing data in a table
•Deleting dropping data in a table
•Inserting new data into a table
•Some SQL Fundamentals
•Filtering Data with WHERE clause
•Removing duplicate data with DISTINCT
•Sorting Data with ORDER BY
•Dropping and Truncating a table
•Extracting Data with SQL Operators
•Extracting data with Comparison Operators
•Extracting data with BETWEEN Operator
•Extracting data with LIKE operator
•Extracting data with NOT Operator
•Extracting data with AND Operator
•Extracting data with OR Operator
•Combining AND OR operators
•Extracting data with LIMIT Operator
•Extracting data with IN Operators
•Extracting data with UNION Operator
•Extracting data with UNION ALL Operator
•Extracting data with INTERSECT Operator
•Extracting data with EXCEPT Operator
•Getting Data from Multiple Tables
•What are table joins
•Retrieving data with INNER Join
•Retrieving data with LEFT Join
•Retrieving data with FULL OUTER Join
•Retrieving data with CROSS Join
•Retrieving data with NATURAL Join
•Grouping Data and Aggregate Functions
•Grouping data with GROUP BY clause
•Using HAVING clause
•What are aggregate functions
•Summarizing data with AVG aggregate function
•Summarizing data with COUNT aggregate function
•Summarizing data with MAX aggregate function
•Summarizing data with MIN aggregate function
•Summarizing data with SUM aggregate function
•Data Analysis with Analytic Functions
•What are Analytic Functions
•Lets create sample tables
•Using AVG as window function
•Analysing data with ROW NUMBER function
•Analysing data with RANK function
•Analysing data with DENSE RANK function
•Analysing data with FIRST VALUE function
•Analysing data with LAST function
•Analysing data with LAG function
•Analysing data with LEAD function
•Triggers Subqueries Stored Procedures
•Introduction to Triggers
•Creating a trigger part
•Managing triggers
•Creating and using subqueries
•Creating and using stored procedures
•SQL Views Virtual Tables
•What are views
•Benefits of using views
•How to create a view
•How to modify and delete a view
•How to update views
•What are materialized views
•Installing PostgreSQL Server Version10
•Download PostgreSQL version 9.6
•Install PostgreSQL 9.6 on windows
•Verify PostgreSQL 9.6 installation
•Connecting to PostgreSQL 9.6 database
•Load sample database on PostgreSQL 9.6
•Installing PostgreSQL 9.6 on Mac
•Deleting (dropping) data in a table
•Combining AND & OR operators
•Let’s create sample tables
•Triggers Sub-queries Stored Procedures
•Creating a trigger
•Creating and using sub-queries
•SQL Views ( Virtual Tables )
•