Database design and optimization (SQLite/PostgreSQL).

As part of the portal development, I designed the database structure to ensure quick access to publications and their categories. I set up many-to-many relationships for tags and one-to-many relationships for authors. I worked on optimizing queries to reduce server load.

Stack: SQL, PostgreSQL, Django ORM.