Planeamento
Aulas do tipo Teórico-Prático
Class 01 - Welcome, presentation and course organization
- Welcome, presentation and course organization
- what is data
- what is information
- data stores
- types of data bases
Class 02 - Principles of Data Quality
- Data Quality Frameworks
- Principles of Data Quality
- Data wrangling
- Tools for organizing and cleaning data
Class 03 - Relational Model
- Ontologies
- Entity-Relationship
- Relational model
- Entity - relationship diagrams
Class 04 - Hand-on class
Hand-on exercises 4, 5, 6, 7, 8
Class 05 - Normal forms
- Normal forms
- Types of relationships
Class 06 - Structured Query Language (SQL - DML)
- Structured Query Language (SQL)
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- SELECT statement
- DBeaver demo
Class 06 - SQL Data Definition Language (DDL)
- SQL DDL - CREATE, ALTER, TRUNCATE e DROP
- Exercises on SQL Data Definition Language statements
Class 08 - Hand-on class
Hands on exercise resolution 9, 10, 11
Class 09 - Evaluation test. SQL Aggregate functions
- Test for continuous evaluation
- SQL - Aggregation functions
Class 10 - SQL - Working with multiple tables
- implicit JOIN - INNER, LEFT, RIGHT JOIN
- table aliases
- JOIN
Class 11 - Working with multiple tables - hands-on
- Exercises on using multiple tables with JOIN
- Exercises on using the database from Python
Class 12 - SQL index
- SQL index
Class 13 - Brief introduction to NoSQL
- Consistency models (ACID, BASE)
- Distributed databases
- NoSQL examples
Class 14 - Evaluation Test
- Test for continuous evaluation