Programming and Databases

last update: January 15, 2023

News:

[HTML: 20221124: Project Description is now available (submission deadline: 15/01/2022)
Labs for Test 1 (13/12/2022 10:00) are FC6 155 and FC6 157
Labs for Test 2 (13/01/2023 11:00) are FC6 155, FC6 157, and FC6 163
[PDF: Description of the Database to be used in Test 2]

Test 2:

[PDF: Description of the Database to be used in Test 2]
[Site: Mooshak System (to be used in Test 2)]

Slides:

[PDF: Python Introduction, types, variables, functions.]
[PDF: Python: Conditional execution; Loops.]
[PDF: Python: Loops (cont.), Strings]
[PDF: Python: Listas, Tuplos e Dicionários]
[PDF: Databases: Overview]
[PDF: Databases: Data Modelling]
[PDF: Databases: SQL]

[ZIP: BD Biblioteca (SQL)]
[SQL: BD Biblioteca (SQL) - version 2]

Exercises:

[PDF: Sheet #1]
[PDF: Sheet #2]
[PDF: Sheet #3]
[PDF: Sheet #4]
[PDF: Sheet #5]
[PDF: Sheet #6]
[HTML: Sheet #7 - SQL (Intro. with SQLZoo)]
[HTML: Sheet #8 - BD - Data Modelling] (Resolution Guide)
[HTML: Sheet #9 - BD - SQL] (Resolution Guide)

Codex (Python):

[Site: Self-assessment Exercises]

Project:

[HTML: Project Description (submission deadline: 17/01/2022)
[Site: Group formation for the PBD project (Moodle)]
[Site: Project submission (Moodle)]

MySQL - Connector/Python Coding Examples:

[Site: MySQL Connector/Python Developer Guide]
[Site: Connector/Python Coding Examples]

[Site: Connecting to MySQL Using Connector/Python]
[Site: Creating Tables Using Connector/Python]
[Site: Inserting Data Using Connector/Python]
[Site: Querying Data Using Connector/Python]

Other Resources

Python:

[Book PDF: How to Think Like a Computer Scientist: Learning with Python 3]
[Site: Python Tutor]
[Site: Online Python IDE]
[Site: Online Python Course]

Databases:

Software:

[MySQL Community Server]

pre-installed in the DCC lab computers
[HTML: Ubuntu instalation]

[DBeaver Community]
[Site: sqliteonline.com - online access to a MariaDB instance (compatible with MySQL)]