PostgreSQL

  • What is PostgreSQL?
  • Brief History
  • Key features of PostgreSQL
  • Procedural Languages Support
  • Environment Setup
  • Installing PostgreSQL on Linux/Unix
  • Installing PostgreSQL on Windows
  • Installing PostgreSQL on Mac
  • The SQL Statement
  • PostgreSQL SQL commands
  • ABORT
  • ALTER AGGREGATE
  • ALTER CONVERSION
  • ALTER DATABASE
  • ALTER DOMAIN
  • ALTER FUNCTION
  • ALTER GROUP
  • ALTER INDEX
  • ALTER LANGUAGE
  • ALTER OPERATOR
  • ALTER OPERATOR CLASS
  • ALTER SCHEMA
  • ALTER SEQUENCE
  • ALTER TABLE
  • ALTER
  • TABLESPACE
  • ALTER TRIGGER
  • ALTER TYPE
  • ALTER USER
  • ANALYZE
  • BEGIN
  • CHECKPOINT
  • CLOSE
  • CLUSTER
  • COMMENT
  • COMMIT
  • COPY
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE CONSTRAINT TRIGGER
  • CREATE CONVERSION
  • CREATE DATABASE
  • CREATE DOMAIN
  • CREATE FUNCTION
  • CREATE GROUP
  • CREATE INDEX
  • CREATE LANGUAGE
  • CREATE OPERATOR
  • CREATE OPERATOR CLASS
  • CREATE RULE
  • CREATE SCHEMA
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE TABLE AS
  • CREATE TABLESPACE
  • CREATE TRIGGER
  • CREATE TYPE
  • CREATE USER
  • CREATE VIEW
  • DEALLOCATE
  • DECLARE
  • DELETE
  • DROP AGGREGATE
  • DROP CAST
  • DROP CONVERSION
  • DROP DATABASE
  • DROP DOMAIN
  • DROP FUNCTION
  • DROP GROUP
  • DROP INDEX
  • DROP LANGUAGE
  • DROP OPERATOR
  • DROP OPERATOR CLASS
  • DROP RULE
  • DROP SCHEMA
  • DROP SEQUENCE
  • DROP TABLE
  • DROP TABLESPACE
  • DROP TRIGGER
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • END
  • EXECUTE
  • EXPLAIN
  • FETCH
  • GRANT
  • INSERT
  • LISTEN
  • LOAD
  • LOCK
  • MOVE
  • NOTIFY
  • PREPARE
  • REINDEX
  • RELEASE SAVEPOINT
  • RESET
  • REVOKE
  • ROLLBACK
  • ROLLBACK TO SAVEPOINT
  • SAVEPOINT
  • SELECT
  • SELECT INTO
  • SET
  • SET CONSTRAINTS
  • SET SESSION AUTHORIZATION
  • SET TRANSACTION
  • SHOW
  • START TRANSACTION
  • TRUNCATE
  • UNLISTEN
  • UPDATE
  • VACUUM
  • Data Types
  • Numeric Types
  • Monetary Types
  • Character Types
  • Binary Data Types
  • Date/Time Types
  • Boolean Type
  • Enumerated Type
  • Geometric Type
  • Network Address Type
  • Bit String Type
  • Text Search Type
  • UUID Type
  • XML Type
  • JSON Type
  • Array Type
  • DECLARATION OF ARRAYS
  • INSERTING VALUES
  • ACCESSING ARRAYS
  • MODIFYING ARRAYS
  • SEARCHING ARRAYS
  • Composite Types
  • DECLARATION OF COMPOSITE TYPES
  • COMPOSITE VALUE INPUT
  • ACCESSING COMPOSITE TYPES
  • Range Types
  • Object Identifier Types
  • Pseudo Types
  • CREATE Database
  • Using CREATE DATABASE
  • Using createdb Command
  • PARAMETERS
  • OPTIONS
  • SELECT Database
  • Database SQL Prompt
  • OS Command Prompt
  • DROP Database
  • Using DROP DATABASE
  • PARAMETERS
  • Using dropdb Command
  • PARAMETERS
  • OPTIONS
  • CREATE Table
  • DROP Table
  • Schema
  • Syntax to Create table in Schema
  • Syntax to Drop schema
  • Advantages of using a Schema
  • INSERT Query
  • OUTPUT
  • SELECT Query
  • OPERATORS
  • What is an Operator in PostgreSQL?
  • PostgreSQL Arithmetic Operators:
  • PostgreSQL Comparison Operators:
  • PostgreSQL Logical Operators:
  • PostgreSQL Bit String Operators:
  • Expressions
  • PostgreSQL -Boolean Expressions:
  • PostgreSQL -Numeric Expression:
  • PostgreSQL-Date Expressions:
  • WHERE Clause
  • AND and OR Conjunctive Operators
  • The AND Operator:
  • The OR Operator:
  • UPDATE Query
  • DELETE Query
  • LIKE Clause
  • LIMIT Clause
  • ORDER By
  • GROUP BY
  • WITH Clause
  • Recursive WITH
  • HAVING Clause
  • DISTINCT Keyword
  • Simply Easy Learning
  • CONSTRAINTS
  • NOT NULL Constraint
  • UNIQUE Constraint
  • PRIMARY KEY Constraint
  • FOREIGN KEY Constraint
  • CHECK Constraint
  • EXCLUSION Constraint
  • Dropping Constraints:
  • JOINS
  • The CROSS JOIN
  • The INNER JOIN
  • The LEFT OUTER JOIN
  • The RIGHT OUTER JOIN
  • The FULL OUTER JOIN
  • UNIONS Clause
  • The UNION ALL Clause:
  • NULL Values
  • ALIAS Syntax
  • TRIGGERS
  • Listing TRIGGERS
  • Dropping TRIGGERS
  • Simply Easy Learning
  • INDEXES
  • The CREATE INDEX Command:
  • Index Types
  • Single-Column Indexes:
  • Multicolumn Indexes:
  • Unique Indexes:
  • Partial Indexes:
  • Implicit Indexes:
  • The DROP INDEX Command:
  • When should indexes be avoided?
  • ALTER Table Command
  • TRUNCATE TABLE
  • VIEWS
  • Creating Views:
  • Dropping Views:
  • TRANSACTIONS
  • Properties of Transactions:
  • Transaction Control:
  • The BEGIN TRANSACTION Command:
  • The COMMIT Command:
  • The ROLLBACK Command:
  • LOCKS
  • Syntax for LOCK command
  • DeadLocks
  • Advisory Locks
  • Sub Queries
  • Subqueries with the SELECT Statement:
  • Subqueries with the INSERT Statement:
  • Subqueries with the UPDATE Statement:
  • Subqueries with the DELETE Statement:
  • AUTO INCREMENT
  • PRIVILEGES
  • Syntax for GRANT
  • Syntax for REVOKE
  • DATE/TIME Functions and Operators
  • AGE(timestamp, timestamp), AGE(timestamp)
  • CURRENT DATE/TIME()
  • DATE_PART(text, timestamp),
  • DATE_PART(text, interval),
  • DATE_TRUNC(text, timestamp)
  • EXTRACT(field from timestamp),
  • EXTRACT(field from interval)
  • ISFINITE(date),ISFINITE(timestamp),ISFINITE(interval)JUSTIFY_DAYS(interval),JUSTIFY_HOURS(interval),
  • JUSTIFY_INTERVAL(interval)
  • FUNCTIONS
  • Useful Functions
  • ABS(X)
  • ACOS(X)
  • ASIN(X)
  • ATAN(X)
  • ATAN2(Y,X)
  • CEIL(X)
  • CEILING(X)
  • COS(X)
  • COT(X)
  • DEGREES(X)
  • EXP(X)
  • FLOOR(X)
  • GREATEST(n1,n2,n3,……….)
  • LEAST(N1,N2,N3,N4,……)