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
- PostgreSQL Syntax
- PostgreSQL Data Types
- Install PostgreSQL
- CREATE DATABASE in PostgreSQL
- PostgreSQL DROP DATABASE
- PostgreSQL CREATE TABLE
- PostgreSQL DROP TABLE
- PostgreSQL CREATE SCHEMA
- INSERT Query in PostgreSQL
- SELECT Query in PostgreSQL
- UPDATE Query in PostgreSQL
- DELETE Query in PostgreSQL
- WHERE clause in PostgreSQL
- ORDER BY in PostgreSQL
- GROUP BY in PostgreSQL
- HAVING clause in PostgreSQL
- PostgreSQL Conditions
- AND condition in PostgreSQL
- OR condition in PostgreSQL
- AND OR condition in PostgreSQL
- NOT condition in PostgreSQL
- LIKE condition in PostgreSQL
- IN condition in PostgreSQL
- NOT IN condition in PostgreSQL
- BETWEEN condition in PostgreSQL
- VIEW in PostgreSQL
- JOINS in PostgreSQL
- RIGHT OUTER JOIN in PostgreSQL
- Left Outer Join in PostgreSQL
- Full Outer Join in PostgreSQL
- CROSS Join in PostgreSQL
- Functions in PostgreSQL
- CockroachDB TIL: Volume 7 – W3scools Database
