Privacy Policy | Contact Us | About Us
Technobytz – Technology, Programming, DBMS, SEO

Technobytz – Technology, Programming, DBMS, SEO

Seo, Technology, Programming, DBMS, Blogging, Wordpress, Plugins, Gadgets, Social Networking

  • PROGRAMMING
    • DBMS
    • Flex
    • JavaScript
  • SEO
  • GADGETS
  • BLOGGER
  • INTERESTING STUFFS
    • INFOGRAPHICS
  • TUTORIALS
    • PostgreSQL Tutorial
    • Number Theory Tutorial

DBMS

SQL, PGPLSQL

LIMIT-OFFSET-ORDER BY-Pagination in PostgreSQL
DBMS PROGRAMMING 

LIMIT, OFFSET, ORDER BY and Pagination in PostgreSQL

January 17, 2016January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

LIMIT and OFFSET are particularly useful clauses in PostgreSQL. LIMIT, as it’s name suggests, limits the number of rows returned

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

LIKE and ILIKE for Pattern Matching in PostgreSQL

January 12, 2016January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

LIKE and ILIKE are used for pattern matching in PostgreSQL. LIKE is the SQL standard while ILIKE is a useful

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

PostgreSQL GROUP BY and Aggregate Functions – Explained

January 11, 2016January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

In this post we will discuss about the usage of GROUP BY clause and Aggregate Functions in PostgreSQL. PostgreSQL is

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

PostgreSQL SELECT Query Basics – Tutorial

January 10, 2016January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

In this post we will discuss about the usage of SELECT query in PostgreSQL. SELECT Query form the very basic

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
install postgresql 9.4 in Ubuntu / Linux Mint
DBMS 

How to Install PostgreSQL 9.4 in Ubuntu / Linux Mint

November 8, 2015January 27, 2016 Vipin Raj 1 Comment PostgreSQL Tutorial

This post aims at documenting the complete installation and basic configuration of PostgreSQL 9.4 on an Ubuntu or Linux Mint

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

Install & Configure PgBouncer | Pooling in PostgreSQL #1

October 11, 2015January 27, 2016 Vipin Raj 5 Comments PostgreSQL Tutorial

This is the first post among the series of posts which demonstrates various tools to set up database pooling in

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

PostgreSQL 9 High Availability Cookbook [Review]

September 3, 2014January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

The PostgreSQL 9 High Availability Cookbook written by Shaun M. Thomas, unlike any other PostgreSQL references which concentrate on Postgres

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
install postgresql 9.4 in Ubuntu / Linux Mint
DBMS PROGRAMMING 

How to Install PostgreSQL 9.2 + PostGIS 2.0 in Ubuntu

August 26, 2014January 27, 2016 Vipin Raj 1 Comment PostgreSQL Tutorial

Though PostgreSQL 9.3 has released, there are people who still uses PostgreSQL 9.2 in combination with PostGIS 2.0. It is

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
DBMS PROGRAMMING 

IP Address Concepts & Postgres Network Address Data types

July 7, 2014January 27, 2016 Vipin Raj 0 Comment PostgreSQL Tutorial

Table of Contents Introduction What is IP Address? IPv4 Address Representation IPv6 Address Representation Supernet, Subnet & Sub-subnet Host Address

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
Raster Rendered in Map - Close up
DBMS PROGRAMMING 

How to: Create a Heatmap Raster in PostGIS and Render in GeoServer

June 20, 2014January 27, 2016 Vipin Raj 2 Comments PostgreSQL Tutorial

In this post, we are going to explore a little of the the raster processing capabilities of the powerful PostgreSQL

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter
Read more
  • ← Previous

Popular Posts

  • How to: Install PostgreSQL 9.3 on Ubuntu – Complete Guide
  • 10 Most Useful PostgreSQL Commands with Examples | Postgres Tutorials
  • SQL Trigger – A complete Example in PostgreSQL
  • LIKE and ILIKE for Pattern Matching in PostgreSQL
  • How to Install Network Simulator (NS2) & nam in Ubuntu 14.04
  • Closure Table – Store Hierarchical Data Seamlessly | PostgreSQL
  • How to take Automatic SQL Database Backup using pgAgent | PostgreSQL
  • How to: Install PostGIS 2 for PostgreSQL 9.3 on Ubuntu [Guide]
  • Flex – preinitialize, initialize and creationcomplete | Adobe Flex Tutorial #6
  • Recursive WITH Query Evaluation In PostgreSQL – Explained
Copyright © 2021 Technobytz – Technology, Programming, DBMS, SEO. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.

 

 

 

 

 

 

 

 

Share this:

  • Facebook
  • Google
  • LinkedIn
  • Reddit
  • More
  • Pinterest
  • Twitter