PostgreSQL Server and Database Training at Futurepointtech

1. Installing PostgreSQL Server and Database
• Introduction
• PostgreSQL Server Minimum Requirements
• Download PostgreSQL
• Installing PostgreSQL on Windows
• Verify PostgreSQL installation
• Connecting to PostgreSQL Database
• Installing PostgreSQL on Macs
• What is PostgreSQL
• Who is Using PostgreSQL
• Load sample database
• Installing PostgreSQL
• Verify postgresql installation
postgresql INSERT Statement
Postgres UNIQUE Constraints
Postgres Truncate statement
Postgres UPDATE
Postgresql INNER JOIN
Removing Duplicate Records
Postgres LIKE Operator
Postgresql OR Operator
Sorting Data
Server service
Sequences
Schema
Retrieving all Data from Table
Query Data fro specific column
Loading sample database
Postgresql DELETE Statement
Postgresql DATA Types
Postgresql CREATE Table Statement
PostgresqlSubQuery
Postgresql UNION Operator
PostgreSQL ORDER BY clause
PostgreSQL UNION ALL Operator
PostgreSQL GROUP BY clause
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL combining AND | OR Operator
PostgreSQL AND Operator
PostgreSQL BETWEEN Operator
PostgreSQL NATURAL JOIN Operator
PostgreSQL SELECT statement
CRUD Operations
PostgreSQL EXCEPT Operator
Create a Database with PG4ADMIN
Create a Table with PG4ADMIN
PostgreSQL NOT Operator
PostgreSQL NOT BETWEEN Operator
PostgreSQL LIMIT Operator
PostgreSQL INTERSECT Operator
PostgreSQL Left Join
PostgreSQL IN Operator
PostgreSQL HAVING clause
Comparison operators
Cast and Operators
Filtering Data with WHERE clause
• Hands-on with Practical’s
• Q&A


2. PostgreSQL Server and Database Objects
Introduction
Server service
Database
Table
Schema
Tablespace
views
Functions
Cast and Operators
Sequences
Extensions
Section Summary
Hands-on with Practical’s
Q&A


3. PostgreSQL Fundamentals
PostgreSQL Data Types
PostgreSQL UNIQUE Constraint

http://www.futurepointtech.com/postgresql-training.html
Drop a mail [email protected] we will