postgreSQL Tutorials Get link Facebook X Pinterest Email Other Apps PostgreSQL Tutorials PostgreSQL Tutorials Introduction and Setup Introduction Home Get Started Getting Started Guide Detailed Introduction Features and Future Use Cases, Weaknesses, Tools Install pgAdmin 4 Create Demo Database Table Operations CREATE TABLE INSERT INTO Fetch Data ADD COLUMN UPDATE ALTER COLUMN DROP COLUMN DELETE DROP TABLE Basic Data Manipulation Data Types and Constraints Data Queries SELECT SELECT DISTINCT WHERE ORDER BY LIMIT MIN and MAX COUNT SUM AVG LIKE IN BETWEEN AS Advanced Data Queries Joins and Unions Joins INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN CROSS JOIN UNION Grouping and Aggregation GROUP BY HAVING EXISTS ANY ALL CASE Operators and Exercises Operators Exercises Advanced Features Administration Scaling and High Availability Security and Access Control Advanced Features Backup and Restore Data Import and Export Stored Procedures and Functions Transactions and Concurrency Views and Materialized Views Indexes and Performance Optimization