Introduction to Databases

• References:

  • SQL Tutorial

• Modeling Environments:

  • Vertabelo
  • SQLDBM
  • Lucid Charts
  • Diagrams
  • DB Diagram
  • Quick DB Diagrams
  • Visual Paradigm
  • ERD Plus

• RDBMSs:

  • MySQL (Local installation)
  • MariaDB
  • PostegreSQL
    • PostGIS
  • SQLite
    • SpatialLite

• Managing Environments:

  • MySQL Workbench
  • PHPMyAdmin
  • PGAdmin
  • DBeaver

• NoSQL Databases

  • MongoDB
  • ElasticSearch

• Cloud and DS Databases:

  • DoltHub
  • MLDB

• Anaconda - Jupyter - Python(Python Environment)

• Fake Data Generation

---

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

Detailed Program:

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)
---	---	---