Database Management - PostgreSQL and MongoDB

This repository is dedicated to the Database Management course, where we will work with PostgreSQL and MongoDB. The repository structure is divided into three folders, one for each trimester of the course, to facilitate the management and access to the corresponding resources.

Repository Contents

Quarter 1: Store and Use Data, Simple SQL Queries

Introduction to PostgreSQL:
- Examples of database creation.
- Basic SQL queries.

Quarter 2: Database Administration with Management Tools, Advanced SQL Queries, Use of Functions and Procedures

Database Management with Administrative Tools:
- Usage of database management tools.
- User and permissions administration.
Advanced SQL Queries:
- Examples of complex queries.
- Usage of functions and stored procedures.
Practical Projects:
- Advanced SQL projects.
- Implementation of functions and procedures.

Quarter 3: Relational Database Design and MongoDB Usage

Relational Database Design:
- Normalization and efficient design.
- Theory on primary and foreign keys.
Introduction to MongoDB:
Queries and operations in MongoDB.

Common Technologies Used

SQL
PLpgSQL

Contact

For any questions or comments, feel free to get in touch:

WI hope you find these web application design projects both useful and educational!