PostGIS Eğitimi Türkçe - Postgis in Turkish

Mastering PostGIS: Spatial Database Management for Desktop to Big Data

This course empowers you to harness the power of geospatial information systems (GIS) using PostGIS, the leading open-source spatial database extender for PostgreSQL. Learn to execute powerful GIS queries across a range of applications, from desktop analysis to large-scale data processing.

Why PostGIS?

Geographic processing is crucial in modern information systems. Over the past 15 years, the rise of location-based applications has made efficient spatial data storage, querying, and analysis essential. PostGIS on PostgreSQL provides the robust foundation you need to work with geospatial data effectively. This course focuses on mastering frequently used geospatial functions within this powerful environment.

Who Should Attend?

This training is designed for professionals in:

• Software Development: Expand your skillset with spatial data capabilities.
• Location-Based Application Development: Build and deploy location-aware applications.
• GIS Professionals: Deepen your expertise in spatial database management.
• Urban and Regional Planning: Utilize GIS for informed planning and decision-making.
• Map, Geology, and Mining Engineers: Leverage spatial data for analysis and visualization.

Course Content: A Hands-On Approach

This course emphasizes practical application through extensive SQL coding, with results visualized using QGIS. You'll gain proficiency in:

• PostgreSQL & PostGIS Setup: Installation of PostgreSQL, PostGIS, pgAdmin, and QGIS.
• Extension Management: Installing and managing PostGIS extensions.
• Database Objects: Understanding PostGIS tables, views, and functions.
• Data Import & Export: Importing and exporting data from various formats.
• Performance Optimization: Techniques for indexation, explain analyze, and backup/restore.
• Geometry Management: Comprehensive control over geometry functions for creation, access, editing, and output.
• Spatial Operators & Relationships: Utilizing geometic operators, geometric relationships, and measurement functions.
• Linear Referencing Systems: Working with linear referencing systems for accurate spatial data.

Tools Used:

Throughout the training, we'll utilize pgAdmin and QGIS for a comprehensive desktop GIS software experience.

Learning Outcomes:

Upon completion of this training, you will be able to:

• Efficiently transfer geospatial data between PostGIS and other formats.
• Execute geospatial relationship queries with optimal performance.
• Develop and implement the necessary SQL queries for building location-based applications and generating corporate maps.