Basic QGIS course
Basic QGIS course
Learn to use QGIS, the data visualization, editing and analysis program that makes up a geographic information system. It is free, open source, cross-platform software that has become a benchmark among GIS (Geographic Information Systems) and the alternative to paid proprietary tools.
Specific goals | Temary
OBJECTIVES
- Learn to install and configure PostgreSQL in different environments.
- Manage advanced data structures and use PostgreSQL-specific data types.
- Create and optimize advanced SQL queries, including subqueries and complex joins.
- Implement and manage functions, stored procedures, and triggers.
- Administer security, user permissions, and perform maintenance and monitoring tasks.
- Use advanced extensions like PostGIS to extend PostgreSQL functionalities.
SYLLABUS
- Introduction to PostgreSQL
- History and features of PostgreSQL
- Installation and initial configuration
- Administration tools (pgAdmin, psql)
- PostgreSQL Structure and Architecture
- Database architecture
- Data types in PostgreSQL
- Creating and managing databases and tables
- Basic SQL Commands in PostgreSQL
- Basic SQL commands (SELECT, FROM, WHERE, GROUP BY, ORDER BY, INSERT, UPDATE, DELETE, CREATE)
- PostgreSQL functions
- Subqueries, unions, and joins
- Error handling
- Functions and Procedures
- User-defined functions
- Stored procedures
- Triggers and rules
- Indexing and Optimization
- Types of indexes and their creation
- Query optimization, ANALYZE
- Database Administration
- Backup and restore (pg_dump and pg_restore)
- Monitoring and maintenance
- User management ROLE
- Permission management GRANT
- Advanced Functions
- Table partitioning
- Replicas and high availability
- Extensions and additional modules (PostGIS, etc.)
RELATED PREVIOUS TRAININGS:
Online course - Geographic Information Systems with QGis
Editions
Tue 10/09/24 (15:30-19:30h)
Thu 12/09/24 (15:30-19:30h)
Mon 16/09/24 (15:30-19:30h)
Wed 18/09/24 (15:30-19:30h)
Thu 19/09/24 (15:30-19:30h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Tue 01/10/24 (15:30-19:30h)
Thu 03/10/24 (15:30-19:30h)
Mon 07/10/24 (15:30-19:30h)
Wed 09/10/24 (15:30-19:30h)
Fri 11/10/24 (15:30-19:30h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
General information
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Course ratings
Lesson taught by
LÓPEZ QUINTANILLA
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.