Skip to content
Tutorials
Python Tutorial
Taking Input in Python
Python Operators
Python Data Types
Python Numbers
Python String
Python Lists
Python Tuples
Sets in Python
Python Dictionary
Python Loops and Control Flow
Python If Else
Python For Loops
Python While Loops
Python Breaks
Python Continue Statement
Python Pass Statement
Python Functions
Python OOPS Concept
Python Data Structures
Python DSA
Linked List
Stack
Queue
Tree
Heap
Hashing
Graph
Sets
Map
Advance Data Structure
Sorting Algorithms
Searching Algorithms
Python Exception Handling
Python File Handling
Python Exercises
Python List Exercise
Python String Exercise
Python Tuple Exercise
Python Dictionary Exercise
Python Set Exercise
Python Design Patterns
Python Programming Examples
Python Practice Questions
Java
Java Programming Language
Java Tutorial
Data Types
Variables
Operators
Operators in Java
Arithmetic Operators
Unary Operators
Assignment Operators
Relational Operators
Logical Operators
Ternary Operators
Flow Control in Java
Flow Control
if Statement
if-else Statement
if-else-if Ladder
Continue Statement
Break Statement
Return Statement
Loops in Java
Loops
do-while Loop
For Loop
For-each Loop
Methods
Strings
Arrays
OOPs Concepts
OOPs Concepts
Classes and Objects
Access Modifiers
Inheritance
Abstraction
Encapsulation
Polymorphism
Interface
Packages
Multithreading
File Handling
Regular Expression
Java Collections
Java Collections
Collection Class
List Interface
ArrayList
Vector Class
Stack Class
LinkedList Class
Queue Interface
Set Interface
HashSet Class
TreeSet
Map Interface
HashMap Class
HashTable Class
Iterator
Comparator
Collection Interview Questions
Java 8 Tutorial
Java Programs
Java Programming Examples
Java Array Programs
Java String Programs
Java Date-Time Programs
Java File Handling Programs
Java Collection Programs
Java JDBC Programs
Java Apache POI Programs
Java OpenCV Programs
Java Interview Questions
Java Interview Questions
Core Java Interview Questions-Freshers
Java Multithreading Interview Questions
OOPs Interview Questions and Answers
Java Exercises
Java Quiz
Java Quiz
Core Java MCQ
Java Projects
Advance Java
Spring Tutorial
Spring Boot Tutorial
Spring Boot Interview Questions
Spring MVC Tutorial
Spring MVC Interview Questions
Hibernate Tutorial
Hibernate Interview Questions
Programming Languages
C
C++
JavaScript
PHP
R Tutorial
C#
SQL
Scala
Perl
Go Language
Kotlin
System Design
System Design Tutorial
What is System Design
Key Terminologies in System Design
Analysis and Architecture of Systems
Scalability in System Design
Databases in System Design
High Level Design or HLD
Low Level Design or LLD
Communication Protocols
Web Servers and Proxies
Case Studies in Designing Systems
Complete System Design Tutorial
Software Design Patterns
Factory Pattern
Observer Pattern
Singleton Design Pattern
Decorator Pattern
Strategy Pattern
Adapter Pattern
Command Pattern
Iterator Pattern
Prototype Design Pattern
All Design Patterns
System Design Roadmap
Top 10 System Design Interview Questions and Answers
Interview Corner
Company Preparation
Top Topics
Practice Company Questions
Interview Experiences
Experienced Interviews
Internship Interviews
Competitive Programming
Multiple Choice Quizzes
Aptitude for Placements
Computer Science Subjects
Mathematics
Operating System
DBMS
Computer Networks
Computer Organization and Architecture
Theory of Computation
Compiler Design
Digital Logic
Software Engineering
DevOps
GIT
AWS
Docker
Kubernetes
Microsoft Azure Tutorial
Google Cloud Platform
Linux
Linux Tutorial
Linux Commands A-Z
Linux Commands Cheatsheet
25 Basic Linux Commands
File Mangement in Linux
File Permission Commands
chmod Command
chown Command
chgrp Command
unmask Command
Linux System Administration
Linux File System
Linux Shell Scripting
Linux Networking
Linux Firewall
Linux Interview Questions
Software Testing
Software Testing Tutorial
Software Testing Tutorial
What is Software Testing
Principles of Software Testing
Types of Software Testing
Levels of Software Testing
Automation Testing
Manual Testing
Testing Tools
Software Testing Tools
Defect Testing Tools
Cross-Browser Testing Tools
Integration Testing Tool
Unit Testing Tools
Mobile Testing Tools
GUI Testing Tool
Security Testing Tools
Penetration Testing Tools
Selenium
Selenium Tutorial
Selenium Basics
Selenium Python
Jira
Jira Tutorial
JIRA Installation
JIRA Login
JIRA Dashboard
Software Engineering
Software Engineering Tutorial
Software Development Life Cycle (SDLC)
Software Characteristics
Software Quality
Waterfall Model
Iterative Waterfall Model
Spiral Model
Prototyping Model
Incremental Process Model
Interview Questions
Software Testing Interview Questions
Automation Testing Interview Questions
Manual Testing Interview Questions
Software Engineering Interview Questions
Penetration Testing Interview Questions
API Testing Interview Questions
Postman
Postman Tutorial
Postman for API Development
Download and Install Postman
API Testing Using Postman
Generate HTML Report for Postman
Databases
DBMS Tutorial
SQL Tutorial
PostgreSQL Tutorial
MongoDB Tutorial
SQL Interview Questions
MySQL Interview Questions
PL/SQL Interview Questions
Android
Android Tutorial
Android Studio Tutorial
Kotlin For Android
Android Projects
Android Interview Questions
6 Weeks of Android App Development
Excel
MS Excel Tutorial
Introduction to MS Excel
Data Analysis in Excel
Basic Excel Formulas & Functions
Data Analysis in Advanced Excel
Workbooks
Statistical Functions
Data Visualization in Excel
Pivot Tables in Excel
Excel Spreadsheets in Python
Basic Excel Shortcuts
Mathematics
Number System
Algebra
Linear Algebra
Trigonometry
Set Theory
Statistics
Probability
Geometry
Mensuration
Logarithms
Calculus
Commerce
Business Studies
Accountancy
Microeconomics
Statistics for Economics
Macroeconomics
Human Resource Management (HRM)
Management
Income Tax
Finance
Commerce Complete Guide
SEO-Search Engine Optimization
What is SEO
Search Engine Optimization Basics
Types of SEO
Keyword Optimization in SEO
Backlinks in SEO
SEO Blogs
Mobile SEO
SEO Complete Reference
Aptitude
Aptitude Question and Answers
Quantitative Aptitude
Logical Reasoning
Verbal Ability
DSA
Data Structures
Arrays
Matrix
Strings
Linked List
Singly Linked List
Doubly Linked List
Circular Linked List
Doubly Circular Linked List
Linked List Tutorial
Stack
Queue
Tree
Generic Tree
Binary Tree
Binary Search Tree
AVL Tree
B Tree
B+ Tree
Red Black Tree
Tree Data Structure Tutorial
Heap
Hashing
Graph
Set Data Structure
Map Data Structure
Advanced Data Structure
Data Structures Tutorial
Algorithms
Analysis of Algorithms
Design and Analysis of Algorithms
Asymptotic Analysis
Asymptotic Notations
Worst, Average and Best Cases
Searching Algorithms
Linear Search
Binary Search
Searching Algorithms Tutorial
Sorting Algorithms
Selection Sort
Bubble Sort
Insertion Sort
Merge Sort
Quick Sort
Heap Sort
Counting Sort
Radix Sort
Bucket Sort
Sorting Algorithms Tutorial
Greedy Algorithms
Dynamic Programming
Graph Algorithms
Pattern Searching
Recursion
Backtracking
Divide and Conquer
Mathematical Algorithms
Geometric Algorithms
Bitwise Algorithms
Randomized Algorithms
Branch and Bound
Algorithms Tutorial
DSA Tutorial
Practice
All DSA Problems
Problem of the Day
Company Wise Coding Practice
Amazon
Microsoft
Flipkart
Explore All
GfG SDE Sheet
Practice Problems Difficulty Wise
School
Basic
Easy
Medium
Hard
Language Wise Coding Practice
CPP
Java
Python
Curated DSA Lists
Beginner's DSA Sheet
Top 50 Array Problems
Top 50 String Problems
Top 50 DP Problems
Top 50 Graph Problems
Top 50 Tree Problems
Competitive Programming
Company Wise SDE Sheets
Facebook SDE Sheet
Amazon SDE Sheet
Apple SDE Sheet
Netflix SDE Sheet
Google SDE Sheet
DSA Cheat Sheets
SDE Sheet
DSA Sheet for Beginners
FAANG Coding Sheet
Product-Based Coding Sheet
Company-Wise Preparation Sheet
Top Interview Questions
Top 100 DSA Interview Questions Topic-wise
Puzzles
All Puzzles
Top 100 Puzzles Asked In Interviews
Top 20 Puzzles Commonly Asked During SDE Interviews
Data Science
Python Tutorial
R Tutorial
Machine Learning
Data Science using Python
Data Science using R
Data Science Packages
Pandas Tutorial
NumPy Tutorial
Data Visualization
Python Data Visualization Tutorial
Data Visualization with R
Data Analysis
Data Analysis with Python
Data Analysis with R
Deep Learning
NLP Tutorial
Web Tech
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
PHP Tutorial
ReactJS Tutorial
NodeJS Tutorial
AngularJS Tutorial
Bootstrap Tutorial
Web Development Using Python
Django
Getting started with Django
Create an App in Django
Views In Django
Django Templates
Django URL patterns
Django Admin Interface
Django Models
MySQL Databased with Django
Django CRUD
Django Forms
Django Static File
Projects for Beginners
Django Tutorial
Flask
Web Development Using Flask
Flask App Routing
URL building in Flask
Flask Templates
Templating With Jinja2 in Flask
Flask Model
Database with Flask SQL Alchemy
Authentication with Flask
WTForms in Flask
Static files in Flask
Python Flask Projects
Flask Interview Questions
Frontend Projects
Building a Survey Form using HTML and CSS
Food delivery system using HTML and CSS
ToDo webapp using Django
Building Blog CMS
Add Pagination in Django
Tailwind CSS with Django
Django with Reactjs
Postman
Github
JSON Tutorial
TypeScript Tutorial
Wordpress Tutorial
Web Design
Web Browsers
Google Chrome
Mozilla Firefox
Apple Safari
Microsoft Edge
Tor
Cheat Sheets
HTML Cheat Sheet
CSS Cheat Sheet
JavaScript Cheat Sheet
React Cheat Sheet
Angular Cheat Sheet
jQuery Cheat Sheet
Bootstrap Cheat Sheet
JavaScript Projects
Learn Complete Web Development
File Formats
Courses
Coding for Everyone
DSA to Development
Machine Learning and Data Science
DSA Courses
Data Structure & Algorithm(C++/JAVA)
Data Structure & Algorithm(Python)
Data Structure & Algorithm(JavaScript)
Programming Languages
CPP
Java
Python
JavaScript
C
Trending Now
DSA
Web Tech
Foundational Courses
Data Science
Practice Problem
Python
Machine Learning
JavaScript
System Design
Django
DevOps Tutorial
Java
C
C++
ReactJS
NodeJS
CP Live
Aptitude
Puzzles
Projects
▲
Similar Topics
Web Technologies
37.9k+ articles
DSA
21.9k+ articles
Python
20k+ articles
Experiences
13.4k+ articles
Interview Experiences
11.8k+ articles
JavaScript
10.6k+ articles
DBMS
1.4k+ articles
PostgreSQL
300+ articles
postgreSQL-managing-table
38 articles
postgreSQL-managing-database
13 articles
postgreSQL-administration
19 posts
Popular Articles
Recent Articles
PostgreSQL - Restore Database
Last Updated: 28 July 2021
Restoring a database, is the action of copying the backed up data and restoring it at its original or new place. We perform restore action o
...read more
Picked
PostgreSQL
postgreSQL-administration
PostgreSQL - Autovacuum
Last Updated: 29 June 2021
Sometime in the 2000s the developers of PostgreSQL found a major loophole in the design of their relational database management system with
...read more
DBMS
Picked
PostgreSQL
postgreSQL-administration
PostgreSQL - Cursor
Last Updated: 01 May 2021
A Cursor in PostgreSQL is used to process large tables. Suppose if a table has 10 million or billion rows. While performing a SELECT operati
...read more
Picked
PostgreSQL
postgreSQL-administration
Similar Topics
Web Technologies
37.9k+ articles
DSA
21.9k+ articles
Python
20k+ articles
Experiences
13.4k+ articles
Interview Experiences
11.8k+ articles
JavaScript
10.6k+ articles
DBMS
1.4k+ articles
PostgreSQL
300+ articles
postgreSQL-managing-table
38+ articles
postgreSQL-managing-database
13+ articles
PostgreSQL - Installing PostgreSQL Without Admin Rights on Windows
Last Updated: 21 June 2021
If you are a part of a corporation, it is highly unlikely that you have the admin privileges to install any external software. But the curio
...read more
Picked
PostgreSQL
postgreSQL-administration
PostgreSQL - Assert
Last Updated: 24 January 2021
PostgreSQL provides the ASSERT statement for inserting important debugging checks in the PL/pgSQL code.It is an important tool for checking
...read more
Technical Scripter
Picked
PostgreSQL
postgreSQL-administration
Technical Scripter 2020
PostgreSQL - Connecting to the database using Python
Last Updated: 30 August 2020
PostgreSQL API for Python allows user to interact with the PostgreSQL database using the psycopg2 module. In this article we will look into
...read more
Python
PostgreSQL
postgreSQL-administration
postgreSQL-managing-database
PostgreSQL - Reset Password For Postgres
Last Updated: 22 April 2022
In this article, we will look into the step-by-step process of resetting the Postgres user password in case the user forgets it.PostgreSQL u
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - CREATE ROLE
Last Updated: 28 August 2020
PostgreSQL uses roles to represent user accounts. It doesn’t use the user concept like other database systems. Typically, roles can log in
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - GRANT
Last Updated: 09 January 2023
In PostgreSQL, the GRANT statement is used to grant privileges to a role to alter on database objects like tables, views, functions, etc.The
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - REVOKE
Last Updated: 17 August 2021
In PostgreSQL, the REVOKE statement is used to revoke previously granted privileges on database objects through a role.The following shows t
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - ALTER ROLE
Last Updated: 10 February 2021
In PostgreSQL, the ALTER ROLE statement is used to manage and modify roles. It can be used to modify the name of a role, the attributes of a
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - Block Structure
Last Updated: 28 August 2020
PL/pgSQL is a block-structured language, therefore, a PL/pgSQL function or store procedure is organized into blocks.Syntax:[ label ][ DECLAR
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - CTE
Last Updated: 28 August 2020
In PostgreSQL, the CTE(Common Table Expression) is used as a temporary result set that the user can reference within another SQL statement l
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - Recursive Query
Last Updated: 28 August 2020
PostgreSQL provides the WITH statement that supports the designing of auxiliary queries also known as CTEs (Common Table Expressions). A rec
...read more
PostgreSQL
postgreSQL-administration
PostgreSQL - Loading a Database
Last Updated: 20 September 2021
In this article we will look into the process of loading a PostgreSQL database into the PostgreSQL database server.Before moving forward we
...read more
PostgreSQL
postgreSQL-administration
postgreSQL-managing-database
1
2
>>
Last
1
2
>>
Last
1
2
>>
Last
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our
Cookie Policy
&
Privacy Policy
Got It !