Python and SQL Programming and Artificial Intelligence

Im Zentrum stehen die Grundlagen der Programmierung mit Python und SQL, sowie die Modellierung von Datenbanken. Ein besonderer Fokus liegt auf objektorientierter und funktionaler Programmierung, dem Aufbau eines Data Marts in SQL und den Grundlagen der Künstlichen Intelligenz. Die Teilnehmenden lernen, Daten in relationalen Datenmodellen zu speichern und mit SQL darauf zuzugreifen. Zudem erhalten sie Einblicke in moderne DB-Systeme (NoSQL).

Die Weiterbildungsinhalte sind auf Englisch.
Introduction to Programming with Python

• Python as a programming language for data science
• Variables and built-in datatypes
• Statements and functions
• Error and exception handling
• Important Python data science modules

Project: Object Oriented and Functional Programming with Python

• This course introduces the students to the advanced programming concepts of object orientation and functional programming and how they are realized in the Python programming language.

Database Modeling and Database Systems

• Fundamentals of relational databases
• Simple database queries
• Entity/Relationship (E/R) Diagrams
• database development
• Complex database queries across multiple tables
• Changing data in databases
• NoSQL database systems

Build a Data Mart in SQL

• This course is about the implementation of a practical database use case employing previously-acquired knowledge on pertaining approaches and methods. The core aim is to apply the hitherto theoretical knowledge of database methods and approaches to solve a real-world application scenario. This entails reasoning about possible design and architectural choices in a rational way, as well as implementing them in a functioning database system.

Artificial Intelligence

• chart the historical developments in artificial intelligence
• understand the approach of contemporary AI systems
• comprehend the concepts behind reinforcement learning
• analyze natural language using basic NLP techniques
• scrutinize images and their contents

Project: Artificial Intelligence

• This course focuses on developing a simple AI system for a specific application and domain. A current list of topics is located in the Learning Management System.