top of page

A Comprehensive Training Program: PostgreSQL with PostGIS

Dive into spatial data management with our PostgreSQL & PostGIS Certificate Course. Learn PostgreSQL fundamentals, advanced querying, and seamlessly integrate geographic objects with PostGIS.

After completion you'll be familiar with:

  • PostgreSQL

  • Advance PostgreSQL

  • PostGIS

Online mode with customized class timings

Doubt clearing sessions with personalized assistance

Trainers with 5+ years of hands-on experience in various aspects of Geospatial Technology

Duration- 20 Days/40Hrs.

Monday-Friday (2Hrs. / day)

Training Overview

  • PostgreSQL - Create, select and drop Database

  • PostgreSQL - Insert Query & select Query

  • PostgreSQL - Operators & Expressions

  • PostgreSQL - Alter Table Command. Truncate Table Command

  • PostgreSQL - Views & Sub Queries

  • Date/Time Functions & Operators

  • Import & Export Shapefiles into PostgreSQL database using PostGIS bundle

  • Import Database to QGIS

  • Working with special reference ID and the geometry field

  • Spatial Indexing

Add a heading (5)

Training Module

Introduction to PostgreSQL

  • PostgreSQL - Environment Setup

  • PostgreSQL - Syntax

  • PostgreSQL - Data Types

  • PostgreSQL - Create Database

  • PostgreSQL - Select Database

  • PostgreSQL - Drop Database

  • PostgreSQL - Create Table

  • PostgreSQL - Drop Table

  • PostgreSQL - Schema

  • PostgreSQL - Insert Query

  • PostgreSQL - Select Query

  • PostgreSQL - Operators

  • PostgreSQL - Expressions

  • PostgreSQL - Where Clause

  • PostgreSQL - AND & OR Clauses

  • PostgreSQL - Update Query

  • PostgreSQL - Delete Query

  • PostgreSQL - Like Clause

  • PostgreSQL - Limit Clause

  • PostgreSQL - Order By Clause

  • PostgreSQL - Group By

  • PostgreSQL - With Clause

  • PostgreSQL - Having Clause

  • PostgreSQL - Distinct Keyword

Advanced PostgreSQL

  • PostgreSQL - Constraints

  • PostgreSQL - Joins

  • PostgreSQL - Unions Clause

  • PostgreSQL - NULL Values

  • PostgreSQL - Alias Syntax

  • PostgreSQL - Triggers

  • PostgreSQL - Indexes

  • PostgreSQL - Alter Table Command. Truncate Table Command

  • PostgreSQL - Views

  • PostgreSQL - Subqueries

  • Date/Time Functions & Operators

  • PostgreSQL - Aggregate functions

  • PostgreSQL - Functions

PostGIS

  • Introduction

  • Installing PostgreSQL and PostGIS

  • Import & Export Shapefiles into PostgreSQL database using PostGIS bundle

  • Import Database to QGIS

  • Backup and restoring Spatial Database

  • Working with special reference ID and the geometry field

  • Spatial queries-working with geometries

  • Geometry creation and manipulation

  • Spatial relationship using PostGIS

  • Spatial Indexing

  • Geography vs Geometry

  • Spatial Joins

  • Adding geometry to feature with insert

Prerequisites

  • Basic Knowledge in Programming & GIS

Top Companies who hire GIS Professionals

wipro-company2-removebg-preview-removebg
download-removebg-preview-removebg-previ
1631300595166-removebg-preview-removebg-
Trimble logo

Live Project and Placement Support

  • Live project work with our team

  • Publication of Reputed Conferences and Journals

  • Industrial Internship & Research

  • Field Based Studies

  • Projects, Labs for Practice, Assignments and Assessments

  • 100% Placement support guaranteed

  • We'll refer you to top MNCs who are hiring GIS professionals, like Cognizant, Accenture, DeduceTech, Wipro, and many more. 

  • We'll prepare you for the interview

Click Here To Enroll The Training Program

bottom of page