PostgreSQL intensive
PostgreSQL intensive
This course is designed for people with prior knowledge of SQL but who have never used PostgreSQL. You will learn how to install, configure, administer and optimize PostgreSQL databases, as well as how to use its basic and advanced features.
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.
CURRICULUM
- 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.)
Editions
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.
Trainer's person
LÓPEZ QUINTANILLA
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
