jlduim / databases_course

Material for the discipline "Database Modeling and Use"

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
  • TimeScale

• Cloud and DS Databases:

  • DoltHub
  • MLDB
  • DVC
  • Graviti

• 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
Class 1	Introduction, Syllabus, Evaluation, Integrated Development Environment	Users creation
Class 2	Basic Concepts, Representation. Abstraction. Structured and Unstructured Data
Class 3	Types and Architecture of Databases. Relational and non-Relational Databases
Class 4	Data Modeling: Diagrams, Relations, Schemas, Restrictions. Data Modeling Tools	Data Modeling Exercises
Class 5	Data Modeling: Table Normalization	Data Modeling Exercises
Class 6	Data Modeling: Conceptual, Logical, Physical	Data Modeling Exercises
Class 7	SQL language: Standards, implementations, Relational Algebra
Class 8	Introduction to RDBMS MySQL	Hands On MySQL CLI
Class 9	SQL language	SQL practice
Class 10	SQL language	SQL practice
Class 11	SQL language	SQL practice
Class 12	SQL language	Regular Expressions
Class 13	SQL language	SQL practice
Class 14	SQL language	SQL practice
---	Evaluation	---
Class 15	Programmatic access to Databases	Python programming
Class 16	Programmatic access to Databases	Python programming
Class 17	Programmatic access to Databases	Python programming
Class 18	Programmatic access to Databases	Python programming - SQLite
Class 19	Programmatic access to Databases	Python programming - SQLite
Class 20	Introduction to RDBMS Postgres	Hands On Postgres CLI
Class 21	Programmatic access to Databases	Python programming - Postgres
Class 22	Programmatic access to Databases	Python programming - Interface with Pandas
Class 23	Programmatic access to Databases	Python programming - Interface with Pandas
Class 24	Programmatic access to Databases	Python programming - Interface with Pandas
Class 25	Programmatic access to Databases	Python programming - Interface with Pandas
Class 26	Cloud Databases - DoltHub
Class 27	Cloud Databases - DoltHub
Class 28	NoSQL Databases
Class 29	NoSQL Databases	MongoDB practice
Class 30	NoSQL Databases	MongoDB practice
Class 31	NoSQL Databases	Elastic Search
---	Evaluation	---
---	---	---