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)](https://static.wixstatic.com/media/5d1736_5584dbf9a1894bc3b88693aaa8ed8c37~mv2.png/v1/fill/w_333,h_333,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/Add%20a%20heading%20(5).png)
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](https://static.wixstatic.com/media/5d1736_66ff355bb555421a952b57adb8c52890~mv2.png/v1/fill/w_200,h_111,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/wipro-company2-removebg-preview-removebg.png)
![download-removebg-preview-removebg-previ](https://static.wixstatic.com/media/5d1736_1471ed4766344c2e85dabc3670d5ff8f~mv2.png/v1/fill/w_126,h_66,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/download-removebg-preview-removebg-previ.png)
![1631300595166-removebg-preview-removebg-](https://static.wixstatic.com/media/5d1736_dd488220508a4ce2942d943517d0fe59~mv2.png/v1/fill/w_60,h_60,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/1631300595166-removebg-preview-removebg-.png)
![Trimble logo](https://static.wixstatic.com/media/5d1736_5ea4fd1b1fe84c01af5621cccffa5ccb~mv2.png/v1/fill/w_140,h_73,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/download-removebg-preview%20(1)_edited.png)
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