Gained proficiency in relational database concepts and PostgreSQL architecture.
Designed and managed normalized database schemas with foreign key constraints.
Wrote complex SQL queries using joins, subqueries, and window functions.
Performed indexing, query optimization, and transaction management.
Worked with pgAdmin for database administration and backups.
Completed PostgreSQL learning through self-paced online courses and hands-on implementation in Odoo ERP modules. Developed strong understanding of relational database concepts, schema design, joins, subqueries, and optimization techniques. Worked on real scenarios involving data insertion, updates, constraints, and indexing. Used PostgreSQL as the backend for developing and managing custom Odoo applications, gaining experience with database views and ORM integration.