Introduction to Databases
-
References:
-
Modeling Environments:
-
RDBMSs:
- MySQL (Local installation)
- MariaDB
- PostegreSQL
- SQLite
-
Managing Environments:
-
NoSQL Databases
-
Cloud and DS Databases:
-
Anaconda - Jupyter - Python(Python Environment)
Syllabus
Entity-Relationship Models and Diagrams. Entity Types and Attributes. Relationships. Relational Databases. Keys, Integrity. Relational Algebra. Formal Query Languages. SQL. Programmatic Databases Access. NoSQL Databases. RDF Triplestores. API Access
| Day | Topic | Activities |
|---|---|---|
| 04/08 | Introduction, Syllabus, Evaluation, Integrated Development Environment | Users creation |
| 06/08 | Basic Concepts, Representation. Abstraction. Structured and Unstructured Data | |
| 11/08 | Types and Architecture of Databases. Relational and non-Relational Databases | |
| 13/08 | Data Modeling: Diagrams, Relations, Schemas, Restrictions. Data Modeling Tools | Data Modeling Exercises |
| 18/08 | Data Modeling: Table Normalization | Data Modeling Exercises |
| 20/08 | Data Modeling: Conceptual, Logical, Physical | Data Modeling Exercises |
| 25/08 | SQL language: Standards, implementations, Relational Algebra | |
| 27/08 | Introduction to RDBMS MySQL | Hands On MySQL CLI |
| 01/09 | SQL language | SQL practice |
| 03/09 | SQL language | SQL practice |
| 08/09 | SQL language | SQL practice |
| 10/09 | SQL language | Regular Expressions |
| 15/09 | SQL language | SQL practice |
| 17/09 | SQL language | SQL practice |
| 19-26/09 | Evaluation (sending until 24/09) | |
| 29/09 | Programmatic access to Databases | Python programming |
| 01/10 | Programmatic access to Databases | Python programming |
| 06/10 | Programmatic access to Databases | Python programming |
| 08/10 | Programmatic access to Databases | Python programming - SQLite |
| 13/10 | Programmatic access to Databases | Python programming - SQLite |
| 20/10 | Introduction to RDBMS Postgres | Hands On Postgres CLI |
| 22/10 | Programmatic access to Databases | Python programming - Postgres |
| 27/10 | Programmatic access to Databases | Python programming - Interface with Pandas |
| 29/10 | Programmatic access to Databases | Python programming - Interface with Pandas |
| 03/11 | Programmatic access to Databases | Python programming - Interface with Pandas |
| 05/11 | Programmatic access to Databases | Python programming - Interface with Pandas |
| 10/11 | Cloud Databases - DoltHub | |
| 12/11 | Cloud Databases - DoltHub | |
| 17/11 | NoSQL Databases | |
| 19/11 | NoSQL Databases | MongoDB practice |
| 24/11 | NoSQL Databases | MongoDB practice |
| 26/11 | NoSQL Databases | Elastic Search |
| 27/11-03/12 | Evaluation (sending until 03/12) | |
| --- | --- | --- |