Welcome to the MBDA (Models and Databases) course repository at Escuela Colombiana de Ingeniería Julio Garavito.
This repository is your vibrant, all-in-one resource for theoretical materials, lab exercises, and our final project—all designed to help you master database modeling, SQL querying, and XML data management.
In this course, you'll dive into the essential world of databases and learn how to:
- Understand Basic Concepts & Data Models:
Explore the building blocks for modeling data and creating robust data solutions. - Master the Relational Model:
Learn about structure, integrity (both declarative and procedural), relational algebra, and SQL. - Explore Advanced Database Topics:
Delve into extended data models, normalization, transactions, security, and the use of XML for advanced querying.
All materials here are crafted to build a strong theoretical foundation and provide plenty of hands-on practice!
-
Theoretical Materials:
Find slides, PDFs, and notes covering database theory, data models, relational algebra, integrity constraints, and more. -
Labs & Exercises:
Practice your skills with exercises using Oracle SQL Developer for SQL queries and XML for data extraction. -
Final Project – "Delizia: The Importance of Not Wasting Food":
Note: This final project is a work-in-progress prototype applying all the concepts from MBDA.
For a complete look at the project details and source code, check out:
- Project Details: Project Repository
- SQL (Oracle SQL Developer):
Execute and practice complex SQL queries on relational databases. - XML:
Structure data and perform advanced querying using XPath and DTD. - Additional Resources:
Access guidebooks, auto-study material, and curated notes to enhance your learning experience.
- Management consultations
- Python automatization of some tables to generate multiple data registers
If you have any questions about the course content, project requirements, or need further assistance, please reach out via:
Email: [email protected]
"A good database design is the foundation of scalable and efficient systems."
Embrace the concepts, practice diligently, and keep innovating!
Happy coding and effective data modeling!