FSST 4

Course Overview

Agile Software Development

• Manifesto for Agile Software Development
• Principles behind the Agile Manifesto
• The Scrum Guide
• Scrum Quiz

Introduction to Linux

• Introduction to KDE Neon (Linux) and Bash

Introduction to Databases

1st week

Database Management Systems

Download and install the available sqlite databases and tools as described in this README. These databases are designed to match the examples in the SQL tutorial.

2nd week

Complete the SQL Tutorial up to and including aliases. Instead of relying on the website, execute the examples in your local database (use the "Execute SQL" tab of DB Brower for SQLite).

Accept the first database assignment on SQL SELECT.

SQL Exercises

• Introduction to SQL

Sample Code

For interacting with a database, there are many possible APIs. All large C++ libraries offer interaction with SQLite, but there are also many small, independend libraries focused on SQLite interaction. For example

• Sqlite with Qt - step by step
• wxSQLite3 minimal example
• SQLiteCpp

• read_db_table.c (compile via clang read_db_table.c -l sqlite3 or gcc read_db_table.c -l sqlite3; requires installation of libsqlite3-dev)
  Documentation: C-language Interface Specification for SQLite
• select.py
  Documentation: sqlite3 — DB-API 2.0 interface for SQLite databases
• JavaScript (nodejs)

Prior Exams

• FSST 4 final f2021 (group a)
• FSST 4 final f2021 (group b)
• FSST 4 final s2022 (group a)
• FSST 4 midterm f2023 (group a)
• FSST 4 final s2024 (group a)

Notes

• SQL Tools

Content of the Curriculum (4th Grade)

Module 7+8

• Operating Systems
  • Betriebssystemkomponenten
  • Select, install and configure operating systems for specific purposes
  • Benutzer, deren Rechte und die Peripherie verwalten sowie Client bzw. Server in einem Netz konfigurieren
  • Betriebssystemdienste
• Software Development
  • Software development process
  • Apply methodologies for developing software
  • Configuration management
  • Software verification and validation
  • Select and employ relevant programming languages to solve technical problems
• Embedded Programming
  • Create real-time systems
  • Programmierung für echtzeitnahe Steuerungen einsetzen
  • Hardwarenahe Programmteile hinsichtlich Code- und Laufzeiteffizienz testen und evaluieren
• Databases
  • Modelle des Datenbankentwurfs interpretieren sowie Datenbanken abfragen, planen und realisieren
  • Gängige Notationsformen, Strukturen, Entwurf, Implementierung, Abfragesprachen
• Web Development and Network Programming
  • Client-server architecture
  • Apply client- and server-side technologies