Learning the FOSS4g Stack:Enterprise GIS w/ Postgres/PostGIS

Training

Online

up to £ 100

Description

  • Type

    Training

  • Methodology

    Online

  • Class hours

    4h

  • Duration

    Flexible

  • Start date

    Different dates available

"For years I've been hearing everyone talking about Enterprise GIS, but I haven't seen anyone do it.‑ After this course, I can now say that ""I've created a multi-user enterprise GIS on my own!"" - John from California.Do you want to learn how to build an Enterprise GIS from scratch using Free and Open Source Software for GIS (FOSS4g)?In response to the high cost and complexities of implementing an Enterprise GIS, I created this easy-to-follow, hands-on training course allowing students to actually build a multi-user enterprise GIS from scratch using Postgres, PostGIS (free) and QGIS (free).‑ ‑As an added bonus, this training will show how you can add other GIS products (i.e. commercial GIS software) into the enterprise stack as GIS clients.In this course you will create an Enterprise GIS for a mid-sized municipality.‑ You will learn how to add users, each with different permissions for accessing and editing data, and also how to use PostGRES to control all aspects of database access, presentation, and editing.‑ You'll even perform simultaneous multi-user editing on the same GIS layer, and learn how a true Enterprise GIS can manage many users at once.‑ As a bonus, you will see how you can access all the GIS tools from outside of the software by using python to create a table-top GIS application that you might find at a kiosk.‑ And finally, I will show you an example of how the same data in the enterprise can be simultaneously displayed on the Internet using FOSS4g software."

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"Install Postgres and PostGISDesign a Postgres database with multiple users and rolesLoad spatial and attribute data into Postgres and PostGISManage data by including constraints, views, and indexesConnect GIS software and clients to the Enterprise Postgres databasePerform simultaneous multi-user editing of GIS dataIssue spatial and non-spatial SQL to perform geographic analysisDevelop and external application (kiosk) in PythonPublish Enterprise data on the Internet (this will be a demonstration only)Implement your Enterprise solution using a cloud-based hosting service... and you'll learn how to do it with Postgres 11 and PostGIS 3!!!"

"This course is meant for those looking for hands-on experience building a multi-user enterprise GIS from scratch, using open source tools.Students should have a familiarity with open source tools like QGIS, however, having that experience is not required, as the course is designed to teach student with little or no experienceThis course is perfect training for someone who is interviewing for a GIS position - not many applicants can articulate how they put together an enterprise GIS."

"Students should know what GIS is, and have some experience using GISStudents should be excited to learn about how to implement an Enterprise GIsAlthough this class provides a lot of hand-holding through advanced technical concepts, students should have a natural curiosity about GIS and technology, and not be afraid to tinker around - remember, in this training the stakes are low - if you break it, you can always start again."

"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2020

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 3 years

Subjects

  • Design
  • QGIS
  • Internet
  • Access
  • GIS
  • GIS Data
  • GIS Training
  • GIS Technology
  • PostGIS
  • Postgres
  • QGIS Training
  • QGIS tutorial
  • Programmers
  • Programming skills
  • WebGIS
  • Web Programming
  • GIS Analyst
  • Geographic Information Systems
  • QGIS Orientation
  • QGIS Project

Teachers and trainers (1)

AulaGEO Academy

AulaGEO Academy

Specialized center in Geospatial, Engineering and Operations

We choose the best courses and make them available to new audiences in the spectrum CAD - GIS - BIM - Digital Twins Our training offer covers the entire spectrum of data intelligence: Capture - Modeling - Design - Construction - Operation. The creators of courses with which we have decided to work or promote have been carefully selected, to offer a complementary set of knowledge. We firmly believe that today people do not seek courses to fill their walls with diplomas; but to make their abilities more productive.

Course programme

"Getting Started
Understanding the entire Open Source GIS Curriculum
Enterprise GIS overview
Install Postgres
Install QGIS
Import our data
Ways to load data into Postgres/PostGIS
System Design and Implementation
Logical Design: Groups, Users, and Layers
Physical Design - Roles, Users, and Layers - Part 1
Physical Design - Roles, Users, and Layers - Part 2
Physical Design - Views
Physical Design - Constraints
Physical Design - Triggers
Clean up code - make sure to run this
Enterprise GIS Use in Practice
Accessing Enterprise GIS data from desktop clients
Simultaneous Multi-user Editing of Enterprise GIS data
Server-Side Analysis of Enterprise GIS Data
Accessing Enterprise GIS Data with Python
A Demonstration of Internet Mapping with Postgres/PostGIS
Bonus Lecture: Hosting your enterprise GIS in the cloud
Bonus Lecture: How to keep learning"

Learning the FOSS4g Stack:Enterprise GIS w/ Postgres/PostGIS

up to £ 100