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
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
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