Registrasi Kegiatan Inhouse Training |
Tanggal posting 23-Nov-24 07:22 wib. dilihat sebanyak 44
kali
|
Registrasi Kegiatan Inhouse Training PostgreSQL/PostGIS Fundamental Training - Purnama Academy di H.R. Rasuna Said Jakarta Selatan - Purnama Academy |
Rp
-Hubungi Whatsapp-
( 4 Days )
|
|
Posting oleh : Purnama Academy , Whatsapp. 08380838**** |
|
|
|
Registrasi Kegiatan Inhouse Training , Jawa Barat
|
|
|
|
|
jadwalkegiatan.com
|
|
|
|
|
|
|
Detail dan Status Registrasi Kegiatan Sampai Dengan November 2024 |
Waktu Pelaksanaan |
4 Days |
Biaya |
Rp
-Hubungi Whatsapp- |
Keterangan |
Info Terbaru bulan November 2024 , Inhouse Training di H.R. Rasuna Said. purnamaacademy, Whatsapp 083808380001. 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. *** Other Topics : Microsoft Excel VBA Macro, Power Query, QGIS, IBM Cognos, PHP Web Development, Microsoft Project, Power BI, Python Programming, Oracle, Magento, Primavera P6, JSON, Angular, JQuery, Tableau visit www.purnamaAcademy.com atau whatsapp 0838-0838-0001 | Posting Date : Saturday, 23-November-2024, 02:22 |
|
|
|
Kontak Kegiatan |
Nama Kontak |
Purnama Academy |
Kontak HP / Whatsapp |
08380838****
|
Lokasi / Venue Kegiatan |
H.R. Rasuna Said |
|
Jawa Barat, Jakarta Selatan |
|
|
Peta Lokasi Kontak |
|
|
Perbesar Peta !
Detail peta sesuai alamat lokasi yang tertera di iklan 'Registrasi Kegiatan Inhouse Training PostgreSQL/PostGIS Fundamental Training - Purnama Academy di H.R. Rasuna Said Jakarta Selatan - Purnama Academy ' . Di-generate otomatis oleh google map Api update bulan November 2024 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
|
|
|
|
|
|
|
|
|
|
|
|