PostgreSQL

How to Install PostgreSQL on Mac
All Data Types in PostgreSQL 14.0
How to do Date/Time operations in PostgreSQL
PostgreSQL Date/Time Functions with examples
PostgreSQL Formatting Functions like to_char, to_date etc.
PostgreSQL Mathematical Functions and Operators with examples
PostgreSQL String Functions and Operators with examples
PostgreSQL bytea or BLOB data type and related Functions and Operators
PostgreSQL Pattern Matching (like, regexp) with examples
PostgreSQL to_char (numeric) with practical examples
PostgreSQL to_char (date/time) with practical examples
How do I Create a basic Table in PostgreSQL
PostgreSQL XML Functions and Operators
PostgreSQL Json Functions and Operators
How to create a Sequence in PostgreSQL
PostgreSQL Sequence Manipulation Functions
How to write CASE query in PostgreSQL
PostgreSQL Conditional expression
PostgreSQL Array Functions and Operators
PostgreSQL Range Functions and Operators
PostgreSQL Aggregate Functions
PostgreSQL Window Functions
PostgreSQL Subquery Expressions
How to generate time series data in PostgreSQL
PostgreSQL Insert Query
How to limit query result in PostgreSQL
How to convert one data type to another in PostgreSQL

Oracle PL/SQL

What is Oracle Database ?
Select statement Oracle
What is DUAL table in Oracle
Oracle MAX function
Oracle MIN function
Oracle AVG function
Oracle COUNT function
Oracle IN clause
Oracle ANY operator
Oracle SOME operator
Oracle Subquery
Oracle ABS function
Oracle MOD function
Oracle REMAINDER function
Oracle SUM function
Oracle RANK function
Oracle DENSE_RANK function
How to find Nth highest salary Oracle
Oracle DECODE function
What is NULL in Oracle
Oracle NVL function
Oracle SUBSTR function
Install oracle 11g on windows 7
Oracle INSTR function
Oracle CASE statement
Difference between DECODE and CASE in Oracle
ALTER table oracle
Oracle interview questions and answers
Oracle COALESCE function
Oracle Sequence
Oracle NVL2 function
Autonomous Transaction in Oracle
Difference between UNION and UNION ALL clause in Oracle
How to find Oracle Database
Ascii Chart Oracle
For loop Oracle
While loop Oracle
Goto statement Oracle
Oracle loop
Ceil function Oracle
Floor function Oracle
Trunc Function (Number) Oracle
Sign function Oracle
Round function (Number) Oracle
Difference between Trunc and Round functions Oracle
Power function Oracle
Numeric Functions Oracle
SQRT function Oracle
Greatest and Least function Oracle
dbms_output Oracle
Simple debugging tool Oracle
Difference between DELETE and TRUNCATE in Oracle
Truncate command Oracle
Latest version of Oracle database – Oracle 12c
Replace function Oracle
Merge Oracle
Translate function Oracle
Difference between replace and translate
Single quote manipulation Oracle
FIRST_VALUE and LAST_VALUE Oracle
TO_CHAR function Oracle
SOUNDEX function Oracle
BITAND function Oracle
Oracle 12c new features
Polymorphism in Oracle
LEAD function Oracle
LAG function Oracle
Julian date Oracle
5 ways to delete duplicate records Oracle
Oracle Cursor basics
Oracle Cursor examples
PRAGMA RESTRICT_REFERENCES Oracle
Oracle Constraints
Oracle Constraints Examples
Joins Oracle
Triggers in Oracle
Bind variables Oracle
Ref Cursors Oracle
Ref Cursors Examples
5 different ways to test Oracle Ref Cursor results
Change password Oracle
What is High Water Mark in Oracle
DDL Triggers Oracle
PLJSON – JSON extension for PL/SQL
5 different ways to load flat file into Oracle table
10 must-know Oracle Interview questions
TO_DATE Oracle
sys_context Function Oracle and its usage
Difference between rank and dense_rank Oracle
What is the use of ROW_NUMBER in SQL
Rownum and order by in oracle
5 different ways to find TOP N queries Oracle
How to reset password for a locked or expired User Account
5 common mistakes Java Developers make when writing SQL
Call Oracle Stored procedure from Shell Script (OUT)
Call Oracle Stored procedure from Shell Script (IN)
How to design a database table

General Articles

Why should I learn SQL
What is ANSI SQL
Introduction – DBMS and RDBMS
Difference between DBMS and RDBMS
Database transaction and ACID properties
TIOBE Index for May 2012
TIOBE index for August 2022
32 bit or 64 bit
Notepad++ – Tips and Tricks
How to design a database table

Python

Analog Clock in Python
Daily backup script in Python

Ubuntu

Install R on Ubuntu
Installing Oracle 11g on Ubuntu
Install Notepad++ in Ubuntu 12.04
Ubuntu 12.10 New Features
Install Google Earth in Ubuntu 12.04 – 3 Steps
Memory test for Browsers in Ubuntu 12.04
Notepad++ tips and tricks

MySQL

Install LAMP on Ubuntu Desktop
MySQL SUBSTR function
Login mysql command line