PostgreSQL/PostGIS Fundamental: 4-Day Intensive Training

 

PostgreSQL/PostGIS Fundamental: 4-Day Intensive Training

Overview

Dive into the world of advanced database management with our 4-day intensive PostgreSQL/PostGIS Fundamental training, hosted by Purnama Academy. This course is designed for database administrators, developers, and IT professionals who wish to learn how to use PostgreSQL, a powerful open-source relational database system, and PostGIS, an extension for spatial and geographic data handling.

Delivered by certified and experienced trainers, this hands-on course covers the fundamentals of PostgreSQL and PostGIS, including installation, configuration, spatial data management, and querying techniques. Participants will gain practical skills needed to effectively manage and analyze spatial data using PostgreSQL.

Training Details

• Duration: 4 Days
• Time: 09:00 AM - 04:00 PM (Each Day)
• Methods:
  • Public Offline Training
  • Inhouse Training
  • Online via Zoom
• Contact: For more information and registration, please contact our sales team via WhatsApp at 0838-0838-0001.

Course Syllabus

Day 1: Introduction to PostgreSQL and Basic Operations

• Morning Session:
  • Overview of PostgreSQL: Architecture and Features
  • Installing PostgreSQL: Setup and Configuration
  • Basic Database Operations: Creating Databases, Tables, and Indexes
• Afternoon Session:
  • Managing Users and Roles: Permissions and Security
  • Introduction to SQL in PostgreSQL: Queries, Joins, and Transactions
  • Hands-on Exercise: Setting Up a PostgreSQL Environment and Basic Operations

Day 2: Advanced PostgreSQL Features

• Morning Session:
  • Advanced SQL Techniques: Subqueries, Common Table Expressions (CTEs), and Window Functions
  • Data Types and Functions: Custom Types and Functions
  • Performance Tuning: Indexing, Query Optimization, and EXPLAIN
• Afternoon Session:
  • Backup and Recovery: Strategies and Tools
  • Managing Large Datasets: Partitioning and Sharding
  • Hands-on Exercise: Implementing Advanced Features and Performance Tuning

Day 3: Introduction to PostGIS and Spatial Data

• Morning Session:
  • Overview of PostGIS: Features and Capabilities
  • Installing and Configuring PostGIS: Setup and Integration with PostgreSQL
  • Working with Spatial Data: Creating and Managing Spatial Tables
• Afternoon Session:
  • Querying Spatial Data: Spatial Functions and Operators
  • Visualizing Spatial Data: Using Tools and Extensions for Map Visualization
  • Hands-on Exercise: Managing and Querying Spatial Data with PostGIS

Day 4: Advanced PostGIS Techniques and Final Project

• Morning Session:
  • Advanced Spatial Analysis: Buffering, Overlay, and Proximity Analysis
  • Integration with GIS Tools and Applications: Data Import/Export
  • Performance Optimization for Spatial Queries
• Afternoon Session:
  • Final Project: Designing and Implementing a Spatial Database Solution
  • Course Review and Q&A
  • Best Practices and Future Learning Resources

Registration and Contact

To register for the training or for more information, please contact our sales team via WhatsApp at 0838-0838-0001. We offer flexible training options, including public offline sessions, in-house training, and online via Zoom, to suit your learning preferences.

---

This syllabus provides a thorough foundation in PostgreSQL and PostGIS, ensuring participants acquire the skills necessary to effectively manage and analyze relational and spatial data. Adjustments can be made to tailor the content to specific needs or objectives

Categories: bandung, dba, jakarta, murah, postgis, postgresql, Silabus, training