Skip to content

Programming Fundamentals

PgSQL

Programming Fundamentals

Computer Networking
Computer Networking
- Basics
  Basics
- Physical Layer
  Physical Layer
- Datalink Layer
  Datalink Layer
- Network Layer
  Network Layer
- Transport Layer
  Transport Layer
  - Introduction
  - TCP / UDP
- Session Layer
  Session Layer
  - Introduction
- Presentation Layer
  Presentation Layer
  - Introduction
- Application Layer
  Application Layer
- Other Concepts
  Other Concepts
  - DNS
  - DHCP
  - Routers / Gateways
  - URL / URI
  - SSH / SSL
  - HTTP
  - URI
  - Important Questions
DBMS
DBMS
- Postgres
  Postgres
  - Commands
  - User / Roles
  - Database
  - Schemas
  - Data Types
  - Tables
  - Querying Data
  - Filtering Data
  - Joins
  - Grouping Data
  - Set Operations
  - Sub Querying
  - Modifying Data
  - Transactions
  - Constraints
  - PgSQL
  - Views
  - Trigger
  - Indexes
- Theory
  Theory
- Mongodb
  Mongodb
Operating System
Operating System
AWS
AWS
- Cloud Computing
  Cloud Computing
- Global Infrastructure
  Global Infrastructure
- Cloud Economics & Billing
  Cloud Economics & Billing
- Cloud Security
  Cloud Security
- Network Environment
  Network Environment
- Compute
  Compute
- Storage
  Storage
  - AWS EBS
  - AWS S3
  - AWS EFS
- Database
  Database
  - Amazon RDS
  - Amazon DynamoDB
- Scaling and Monitoring
  Scaling and Monitoring
- Caching Content
  Caching Content
  - Edge Caching
  - Elastic Cache
- Application Architecture
  Application Architecture
  - Decoupled Architecture
  - Serverless Architecture
DevOps
DevOps
- Nginx
  Nginx
- Docker
  Docker
- Deployment
  Deployment
  - Django EC2 Deploy
- Kubernetes
  Kubernetes
  - Introduction
  - Kubectl
  - Deployments
  - Yaml
Python
Python
- Basics
  Basics
  - About Python
- Variables
  Variables
- Functions
  Functions
  - Function
- Data Type
  Data Type
  - Numbers
  - String
  - List
  - Tuple
  - Dictionary
  - Sets
  - Difference
- Operators
  Operators
  - Operators
- Control Flow
  Control Flow
  - Decision Making
  - Loops
- OOPS
  OOPS
  - OOPS
- Exception Handling
  Exception Handling
  - Exception Handling
- Multithreading
  Multithreading
  - Multithreading
- Multiprocessing
  Multiprocessing
  - Multiprocessing
- AsyncIO
  AsyncIO
  - AsyncIO
- Type Hints
  Type Hints
  - Type Hints
- Decorator
  Decorator
  - Decorator
- Generator
  Generator
  - Generator
JavaScript
JavaScript
React
React
- Introduction
- Component LifeCycle
- Virual DOM
- Hooks
- HOC
- LazyLoading
- Redux
DSA
DSA
- Arrays

PL/pgSQL

PL/pgSQL is a procedural programming language for the PostgreSQL database system.
PL/pgSQL allows you to extend the functionality of the PostgreSQL database server by creating server objects with complex logic.
PL/pgSQL was designed to :
Create user-defined functions, stored procedures, and triggers.
Extend standard SQL by adding control structures such as if, case, and loop statements.
Inherit all user-defined functions, operators, and types.
PL/pgSQL wraps multiple statements in an object and store it on the PostgreSQL database server.
Instead of sending multiple statements to the server one by one, you can send one statement to execute the object stored in the server.