# Database Programming & Connectivity

## Agenda

1. Tiered Architectures and aspects of database connectivity
2. Database Connectivity: ODBC (Open Database Connectivity)
3. Database Programming: Python
4. Database Programming: Perl
5. Database Programming: JDBC (Java Database Connectivity)
6. Optional: Software Automation Tooling: Version und Build Management mit GIT und Maven

## References
**Shownotes**:

1. [MySQL Connectors](https://www.mysql.com/de/products/connector/)
2. [Application Programming Interfaces - MariaDB Knowledge Base](https://mariadb.com/kb/en/connectors/)
3. [Entity Framework documentation | Microsoft Docs](https://docs.microsoft.com/en-us/ef/)
4. [CRUD-Frameworks: Zugriffsschicht für Datenbanken](https://www.ionos.de/digitalguide/websites/web-entwicklung/crud-die-wichtigsten-datenbankoperationen/)
5. [PHP CRUD Tutorial (part 1)](https://startutorial.com/view/php-crud-tutorial-part-1)

ODBC
1. [Connector/ODBC and Third-Party ODBC Tools](https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools.html)
2. [Using Connector/ODBC with Microsoft Word or Excel](https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html)

Java / JDBC
1. [Java™ 8 JDBC API](https://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/)
2. [Java™ 8 JDBC Documentation](https://docs.oracle.com/javase/8/docs/api/java/sql/package-summary.html)
3. [Visual Studio](https://code.visualstudio.com/docs/?dv=win)
4. [OpenJDK](https://openjdk.org/)
5. [MySQL Connector/J Examples](https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-examples.html)
6. [Download MariaDB Connectors for data access & streaming | MariaDB](https://mariadb.com/downloads/connectors/connectors-data-access/java8-connector/)
7. [DHBW Stuttgart WI-DB Code Repository (Examples)](https://github.com/dhbw-stuttgart-wi-db)

Python
1. [The Python Tutorial](https://docs.python.org/3.11/tutorial/index.html)
2. [Installing Python 3.7 on Debian](https://linuxize.com/post/how-to-install-python-3-7-on-debian-9/)
3. [Install MySQL Connector Python](https://pynative.com/install-mysql-connector-python/)
4. [Python MySQL Tutorial](https://www.mysqltutorial.org/python-mysql/)
5. [MySQL Connector/Python Developer Guide](https://dev.mysql.com/doc/connector-python/en/)
6. [Deep dive: Taking advantage of MariaDB Connector for Python](https://go.mariadb.com/21Q4-WBN-GLBL-OSSG-Python-Connector-2021-08-26_Registration-LP.html?utm_source=marketo&utm_medium=email)
7. [How to Build a Complete Web App with Python and CockroachDB](https://www.cockroachlabs.com/blog/sample-app-python-and-cockroachdb/?utm_campaign=nl-email&utm_source=mkto&utm_medium=email&utm_term=may-monthly&utm_content=newsletter-2022-5&mkt_tok=MzUwLVFJTi04MjcAAAGEKsTsb0ht1Yn-Wf2ATenzZKw8448GaaIpj2ZN7drvRxArdmNoo3olY4kBDP-EtUhsFYB71j_OXXQ829qUUXd1FxFHdK3q4nhkZSJbXMI08zYzawhEbw)

Perl
1. [Perl Download](https://www.perl.org/get.html)
2. If you are completely new to perl consider visiting http://learn.perl.org/
3. [Simple Database access using Perl DBI and SQL](https://perlmaven.com/simple-database-access-using-perl-dbi-and-sql)

## Flashcards

[Database Programming & Connectivity](https://ankiweb.net/shared/info/614546468)