Introduction to PostgreSQL
PostgreSQL can be pronounced as Post-Gress-Q-L. PostgreSQL is an object-relational database management system (ORDBMS), which was developed by the PostgreSQL Global Development Group and is popular because it is powerful and open source. PostgreSQL Global Development Group is a worldwide team of volunteers, and thus PostgreSQL is not controlled by any corporation or any other private entity. Thus making it open source and free to use.
Importance of PostgreSQL:
- Stores data securely.
- Supports best practices,
- Allows retrieving the data when the request is processed.
- Is cross-platform and can run on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.
PostgreSQL tutorial
- History of PostgreSQL
- Features of PostgreSQL
- Syntax of PostgreSQL
- Data Types
- Install PostgreSQL
- CREATE DATABASE
- DROP DATABASE
- CREATE TABLE
- DROP TABLE
- CREATE SCHEMA
- INSERT Query
- SELECT Query
- UPDATE Query
- DELETE Query
- WHERE clause
- ORDER BY
- GROUP BY
- HAVING clause
- PostgreSQL Conditions
- AND condition
- OR condition
- AND OR condition
- NOT condition
- LIKE condition
- IN condition
- NOT IN condition
- BETWEEN condition
- VIEW
- JOINS
- RIGHT OUTER JOIN
- Left Outer Join
- Full Outer Join
- CROSS Join
- Functions