Lecture notes

Martin Goik

Stuttgart Media University / MI

	Available formats:	Webhelp (this document) Zip archive for offline usage EPUB
	Hosted at:	HdM Stuttgart (primary site) medieninformatik.cloud (alternate site)
	Source code provided at `https://gitlab.mi.hdm-stuttgart.de/goik/GoikLectures`
	Published under the terms of the Creative Commons Attribution 4.0 International Public License.

Table of Contents

113105 Software development 1

Getting started

Lecture related resources

Using the exercises

Related resources

Coached exercises

Using plain Java™

Using Intellij IDEA

“Hello, World” and friends.
Simple calculations
A conditional
A loop

Language Fundamentals

Integer, ASCII and Unicode

Primitive types

Integer
char
Float
String

Arithmetic limitations

Conversions

Operators and expressions

Arithmetic and logical operators
Assignment operators
Unary operators
Operator precedence

The if conditional statement

if-then-else
Using else if

The switch statement

From blocks to methods

while
do ... while
for

Logic related external exercises

Using automated tests.

Multi-dimensional arrays

Objects and Classes

Static methods

Working with objects

Object methods

Encapsulation and access control
Getter and setter methods
Signatures
Method overloading
Constructors
Scopes

Class members and methods

A mathematical table.
Interest calculations
Programmer's favourite expression
Lotteries revisited
The greatest common divisor and the common multiple

Maven project dependencies

Maven command line usage
Intellij IDEA on top of Maven

Building a library of mathematical functions.

Maximum and absolute value
Factorial, the direct way
Factorial, the recursive way
Binomials, the recursive way
Implementing exponentials.
Adding sine
Strange things happen

Unit testing

Tests and implementation
Improving the algorithm
Parameterized testing
Helpful Junit methods
Technical details
Example: A class representing fractions

Value types and reference types

Arrays reconsidered

Varargs method parameter
Reconsidering System.out.format().
java.util.Arrays helpers
Extending arrays
Understanding static int main(String[] args)
Tic-tac-toe
Providing statistical data
Prime numbers revisited
The median of a given sample.
Plotting functions

Method calls, the details

Enumerations (enum)

Enumeration by integer representation
Enumeration by dedicated class
Defining a private constructor
enum replacing class

Core Classes

Using class Math
String exercises
Analyzing file pathnames

Inheritance

Overriding equals()

Overriding toString()

final methods

Abstract methods

Geometry classes reconsidered

protected access

final classes

The instanceof operator

The @Override annotation.

Runtime polymorphism

Error Handling

Checked vs unchecked exceptions
Exceptions and Junit
Variants
Class java.lang.Exception

Working with Numbers

Boxing and unboxing
Number Parsing
Number Formatting
Working with Money
Generating Random Numbers

Advanced topics

interface definitions and abstract Classes

Interfaces and sorting
A nonsense generator
An interface based plotter

Application deployment I

Preparations
Exercises
Part II, Exercises

Reading character streams

Preparations
Exercises

Collections

Preparations
Collections I, Exercises
Collections I, Exercises
Collections III, Exercises
Collections IV, Exercises
Maps 1, Preparations
Exercises
Towns and country names
Creating an overview of grades

Examination bonus point projects

Weather forecast
Reverse Polish notation (RPN) calculator
Currency converter, Summer 2017
An address database, Winter 2016
Poor man's UNIX grep, Summer 2016
Project Euler's sieve, Winter 2015

Exercising past examinations

Starting an exam
Implementing the project skeleton
Finish the exam

Examination hints

Past Software Development 1 examinations

2026 summer
2025 winter
2025 summer
2024 winter
2024 summer
2023 winter
2023 summer
2022 winter
2021 winter
2021 summer
2020/1 winter
2020/2 winter
2020 summer
2019 winter
2019 summer
2018 winter
2018 summer
2017 winter
2017 winter
2015 winter
2015 Sommer
2014 Winter

Past Software Development 1 exam preparing tests

Test 01
Test 02
Test 03
Test 04
Test 05

Working with git

Working with git locally.
Shared development with centralized remote.
Conflicts

Apache Maven

The project object model pom.xml
Plugins
Dependencies
Lifecycle, phases and goals

List of software development 1 lecture exercises

113492 Technical Documentation

Software independent considerations

General remarks

Common building blocks

Block level elements

Target formats
Selected elements
Schematron
Customizing
Assemblies
Styling the editor application

Modular documents

RelaxNG Schema

Transforming documents

Target format HTML
Target format print

TeX / LaTeX
Docbook

LaTeX hello,... world
Important elements
Macro
A complete document

Project proposals

Building a reveal.js editor
Authoring journey descriptions
Gitlab pages integration of Docbook
Codingbat reloaded
XML based exercise compilations
Past projects

List of software development 1 lecture exercises

113473 Database and application development

Database features

Selected database products overview

Installation
Features
Exercises

Installation
Features
High performance sharding cluster
Exercises

JDBC: Accessing Relational Data

Persistence in Object Oriented languages

Introduction to JDBC™

Write access, principles
Write access, coding!
JDBC™ and security
Read Access
Dynamically load a JDBC™ driver
Handling surrogate keys
Transactions

Configuring a Maven based Eclipse Java™ project with Hibernate

Creating a JPA configuration

A round trip working with objects

Persisting objects
Loading Objects by primary key
Loading objects by queries
Criteria based queries

Mapping single entities and database tables

Transient properties
Properties and NULL values
Defining keys
Composed keys
Indexes (non-unique)
Renaming tables and attributes
Changing the default type mapping
Object states and transitions
XML to JPA using JAXB

Inheritance

Single table per class hierarchy
Joined subclasses
Table per concrete class

Mapping related Components and entities

Primary keys revisited
Entity and value types
Mapping components

orphanRemoval vs. CascadeType.DELETE

Project ideas

Extending UNIX grep to databases
Database copy tool
Creating data samples
Database schema evolution tool

List of Database and application development lecture exercises

113475 Software defined Infrastructure

Manual server management

Preliminaries

Hetzner cloud administration GUI

Public / private key pair
Pass phrases and ssh agent
Agent forwarding
Port forwarding
X11 forwarding
Network data transfer using scp, rsync and ssh

Prerequisites

Ubuntu / Debian Package management

Prerequisites

Cloud provider

Working with Terraform
Cloud-init
Terraform modules
Volumes
Terraform loops
Terraform and DNS
Generating web SSL certificates
Private networks

Preliminaries
Exercises

Recommended Preparations
Exercises

Apache web server

Preliminaries
Exercises

Exercises

Network file systems served by Samba

Prerequisites
Samba server installation

Recommended Preparations
Exercises

Introduction
Exercises

Functional checks
SNMP based checks
ssh based checks

List of Software defined Infrastructure lecture exercises

Common topics

Project documentation

Bibliographic links

List of Figures

1. How much time to invest?
2. Your biggest enemies
3. German humour
4. AI tools and learning
5. 4 most imperative study objectives
6. Tuition attendance and exam results summer 2025
7. Examinations and result
8. Moodle and tuition groups
9. BW Lehrpool pool rooms
10. Recommended reading resources I
11. Recommended reading resources II
12. Online tutorials
13. Unix and the terminal
14. Online programming, automated feedback
15. Online programming I
16. Online programming II
17. Choosing the SD1 bwLehrpool VM
18. Intellij IDEA IDE
19. Live lecture additions
20. Embedded exercises
21. Using the exercises
22. HdM mail server
23. Configure MI VPN client access
24. MI Cloud server
25. MI Cloud server configuration
26. MI File server
27. MI Git versioning server
28. Coached exercises
29. Edit - compile - execute
30. Defining class Hello
31. Compiling Java™ file
32. Command line Java™ file compilation
33. Java byte code file Hello.class
34. Source code vs. bytecode
35. Executing byte code file Hello.class
36. Command line byte code file Hello.class execution
37. Wrap up: The edit - compile - execute cycle
38. Intellij IDEA requires a JDK™
39. Intellij IDEA installation
40. Idea »Ultimate« license types
41. Alternative: Using the HdM license server
42. Creating a new Java project
43. Getting first Java™ impressions
44. Manual calculation: Abacus
45. Mechanical calculation: Cash register
46. Electromechanical calculation: Zuse Z3
47. Vacuum Tube: Eniac
48. Transistor: Microprocessor ICs
49. Z80 8-bit data bus
50. Progress in hardware 1
51. Progress in hardware 2
52. Simple facts:
53. Unsigned 3 bit integer representation
54. Binary system addition
55. 3 bit two-complement representation
56. 3 bit two complement rationale: “Usual” addition
57. Signed 8 bit integer binary representation
58. 7-bit ASCII
59. 7-bit ASCII with even parity bit
60. Western European characters: ISO Latin 1 encoding
61. Unicode UTF-8 samples
62. Java types
63. Java signed integer primitive types
64. Four int literals representing decimal 29
65. Java unsigned integer, floating point and boolean primitive types
66. Variables: Handles to memory
67. Local variable declaration
68. Declare, assign and use
69. Combining declaration and initialization
70. Compound declarations
71. Identifier in Java™:
72. Identifier name examples:
73. Java™ keywords.
74. Note on contextual keywords
75. Variable naming conventions
76. Constant variables
77. Case sensitivity
78. Define before use
79. Type safety
80. Compile time analysis
81. Type inference (JDK™ 10)
82. Forcing conversions by cast
83. Watch out!
84. Casting long to int
85. Casting double to short
86. «C» programming language “liberal” assignment policy:
87. Consequences
88. From the report
89. Dynamic typing in PERL
90. Dynamic typing in PERL, part 2
91. Using final
92. Reference type examples
93. Literal examples
94. Definition of literal
95. Type and value
96. Four ways representing 35 by discriminator
97. Representations by base
98. Know your limits!
99. int vs. long
100. Binary literal representation
101. Just kidding ...
102. char
103. float and double
104. Precision difference
105. String literal
106. Multi line String literal (Java 15)
107. Strange things I
108. Strange things II
109. Limited floating point arithmetic precision
110. Nearest float to 0.1F
111. FloatConverter
112. Integer division: Take care!
113. Widening from byte to short
114. Narrowing from int literal to char variable
115. A widening «ladder»
116. A narrowing «ladder»
117. The binary plus operator
118. Binary operator output type
119. Detecting arithmetic overflow (Java 8+)
120. Dividing by zero
121. Generic binary operator
122. The modulus operator %
123. Binary operator type examples
124. No binary + operator yielding byte
125. int expression assignment
126. Constant expression assignment
127. The logical “and” operator &
128. The += operator
129. The &= operator
130. Arithmetic assignment operators
131. Logical assignment operators
132. Increment operator ++
133. Different range behaviour!
134. Cast required
135. Prefix and postfix notation
136. Operator examples
137. Precedence of “*” and “/” “+” over “+” and “-”
138. A binary operator's operands evaluation priority
139. “left to right” or “right to left”
140. Operator precedence references
141. “+” acting as string concatenation operator
142. Implicit string conversion and concatenation
143. Java™ comment flavors
144. Inline comments by /* ... */
145. Javadoc™ comments
146. Statements: General syntax
147. Statement examples: Declaring and assigning variables
148. Expression vs. statement
149. Multiple statements per line
150. Debugging multiple statements per line
151. Method local variable scope
152. Nested blocks and variable scopes
153. Block purposes
154. Principle of swapping two variables
155. Swapping two variables
156. Swapping two variables using a block
157. Conditional block execution
158. if syntax
159. if ... else
160. if ... else syntax
161. Best practices comparing for equality
162. Single statement branches
163. Nested if ... else
164. Enhanced readability: if ... else if ... else
165. if ... else if ... else syntax
166. User input recipe
167. Using a Scanner class collecting user input.
168. Converting numbers to day's names
169. Numbers to day's names: The hard way
170. Better: Using switch
171. switch Syntax
172. Switching on strings
173. switch expressions
174. Assigning switch expressions
175. Allowed types for switch statements
176. Labels must be constant expressions
177. Two blocks, same logic
178. Replacing two blocks by one method
179. Passing values to methods
180. Passing values to methods
181. Why loops?
182. Number of repetitions given by user input
183. A while loop
184. Combining increment and termination condition
185. while syntax
186. Empty while body
187. A do ... while loop
188. do ... while vs. while
189. do ... while syntax
190. Frequent usage of while
191. Replacing while(...) by for(...;...;...)
192. for syntax
193. for variable scope
194. for variable scope equivalence
195. for vs. while relationship
196. Nested loops 1
197. Nested loops 2
198. Better readability: row and column in favour of i and j
199. Calculating values
200. Response to coding errors
201. Unit test concept
202. alarmClock(...) with errors
203. Testing alarmClock(...)
204. Testing alarmClock(...) details
205. Motivating Arrays
206. Per member repeating tasks
207. Example: int array of primes
208. Java Visualizer
209. Loop prime values
210. Mind the limit!
211. Safer: Using length
212. Even better: “for-each” style loop
213. Mind the limit, part two
214. Primitive data one step initialization
215. Array
216. Two syntax variants
217. Passing an anonymous array to a method
218. Two-dimensional arrays
219. Behind the scenes
220. Memory allocation
221. Nested array initialization
222. Nested »ragged« array initialization
223. A method adding two values
224. Syntax of method definition
225. The static modifier matters!
226. Documentation: Javadoc™ is your friend!
227. Separating usage and definition
228. Representing two-dimensional points
229. General class structure
230. What's a class anyway?
231. Rectangle objects
232. A class describing rectangles
233. Rectangle class and instances
234. Generated diagrams
235. The new operator: Creating rectangle instances
236. Syntax creating instances
237. Assigning attribute values to class instances
238. Instance memory representation
239. References and null
240. Checking for object presence
241. Why packages ?
242. Rules and conventions
243. Fully qualified class name vs. import
244. Don't be too lazy!
245. Special: Classes in package java.lang
246. Class, package and file system
247. Source hierarchy view
248. Object methods
249. Get a rectangle's area
250. Currently: rectangle's area by class method
251. OO: rectangle's area by instance method
252. Transition to OO
253. Scaling a rectangle
254. Scaling method implementation
255. Scaling method signature
256. Using the scale(...) method
257. Method definition syntax
258. A rectangle's perimeter
259. getPerimeter() method implementation
260. Using Rectangle.getPerimeter()
261. Access control: Overall objectives
262. Example: Two ways implementing a day's time
263. private modifier access violation
264. Absent access modifier, access violation
265. Access rules
266. “Tips on Choosing an Access Level”
267. Direct access vs. setter method
268. Why adding setter methods?
269. Implementation change: Minutes only, no hours
270. Defining type signatures
271. Type signature examples
272. Defining method signatures
273. Method signature examples: Ignore return type!
274. Method overloading: Same name, different signature
275. Overloading, alternate names
276. No overloading in »C«
277. »C« requires unique function names
278. No distinction on return type
279. Method signatures rationale
280. Method signatures rationale
281. Example: IO.print(...)
282. Creating and initializing rectangles
283. Defining a constructor
284. Constructor syntax
285. Constructors
286. Multiple overloaded constructors
287. Constructor calls within constructor
288. Instances by overloaded constructors
289. No constructor vs. default constructor
290. Non - default constructor, but no default constructor
291. Employee example package hierarchy
292. Circle and variable scopes
293. Documenting classes and methods
294. Generated Javadoc
295. Refactoring «r» ⇒ «radius»
296. Scope assignment problem
297. this overriding method scope
298. Why should we require an instance?
299. Solution: Replace instance method by class method using static
300. Club membership objectives
301. Step 1: Implementing club member names.
302. Showing membership info.
303. Step 2: Adding membership numbers.
304. Showing membership numbers.
305. Member creation steps
306. Accessing the club's overall member count?
307. Accessing the club's member count
308. Syntax accessing class members
309. static / non-static wrap up
310. Finally understanding IO.print(ln)
311. Newton's letter to Robert Hooke
312. Application execution prerequisites
313. Why Maven project management?
314. Example: Creating PDF using iText7
315. Maven iText library pom.xml definition
316. Itext transitive dependencies
317. Class location in iText library
318. Class location in iText library
319. Maven repositories
320. Maven archetypes
321. Project «lottery» depending on «common»
322. Providing project «common»
323. Publish project «Common»'s library
324. Content of archive common-1.0.jar
325. Consuming project «lottery»
326. External libraries view
327. Using Helper.factorial(...) computing $(\begin{matrix} n \\ k \end{matrix}) = \frac{n!}{k! (n - k)!}$
328. Maven artifact dependency.
329. Using the MI Sd1 project template
330. CLI example
331. Supplementary MI Maven archetypes
332. CLI testing mi-maven-archetype-quickstart
333. CLI archetype details
334. Generated project layout
335. Maven compile
336. Compilation file view
337. Maven package
338. Executing Java™ archive second-0.9.jar
339. Maven javadoc:javadoc
340. Maven clean
341. Intellij IDEA Maven support
342. Adding MI Maven server
343. New MI archetype project
344. pom.xml content changes
345. Intellij IDEA generating Javadoc™
346. Pascal's triangle representing binomial coefficients.
347. An implementation sketch for the exponential
348. Comparing exponential and approximation
349. Comparing sin(x) and its approximation.
350. Recommended reading
351. Test categories
352. Example: Computing prime numbers
353. Unit test principle
354. Test driven development
355. Steps in Unit Testing
356. Step 1 + 2: Specify method, write skeleton
357. Execution yet being flawed
358. Sample test data
359. Step 3: Junit based specification test
360. Junit skeleton test result (Maven CLI)
361. Junit skeleton test result (IDE)
362. Providing explanatory failure messages:
363. Step 3: Providing more prime tests
364. Step 3: Prime mass testing
365. Step 4: Implement skeleton
366. Step 5: Testing our first implementation
367. Implementation observation
368. Changing the implementation
369. Regression test
370. Systematic error debugging
371. Error correction in detail
372. Parameterized tests
373. Required Junit dependency
374. CSV parameter testing
375. CSV parameter testing results
376. CSV parameter file based testing
377. Available comparison methods
378. Caution comparing float / double !!
379. Weird arithmetics?
380. Limited representation precision
381. Solving the issue
382. The @Test annotation
383. The Assertions class
384. Importing dependencies
385. Dependency archive content
386. Value vs. reference type variables
387. Different behaviour!
388. Value variable Details
389. Reference variable Details
390. Only «call-by-value» in Java™
391. «call-by-value» details
392. «call-by-reference» for objects?
393. «call-by-reference» details
394. No «call-by-reference» in Java™!
395. No «call-by-reference» details
396. C++ reference operator “&”
397. C++ offers «call-by-reference» by virtue of “&”
398. C++ «call-by-reference» details
399. Arrays of object references
400. Array instances are not objects
401. Array creation details
402. Array parameter passing
403. Parameter passing details
404. Array initializer: Value and reference types
405. Expecting one int argument
406. One, two or three int arguments by overloading
407. Observations
408. Arbitrary number of arguments by array
409. Observations
410. Vararg: Syntactic sugar by ellipsis »...«
411. Varargs: Generalizing arrays
412. Using varargs
413. Further reading on varargs
414. Arrays.toString(...) and Arrays.sort(...)
415. Arrays.binarySearch(...)
416. Arrays.fill(...)
417. Arrays.copyOfRange(...)
418. System.arraycopy(...)
419. Arrays.equals(...)
420. Lack of extendability
421. Extend array using a block
422. Replacing extending block by method
423. Extension result
424. Replacing copying loop by Arrays.copyOf()
425. static void main(String[] args)
426. Intellij IDEA run configuration
427. Intellij IDEA run configuration
428. Creating executable jar
429. Two Tic-tac-toe players fighting each other.
430. Two Tic-tac-toe players fighting each other.
431. Method calling
432. Three variable scopes
433. Scope lifetimes
434. Two runtime memory categories
435. IDE debugger
436. Motivation
437. Weekly offered lectures
438. Weekly offered lectures by simple numbers
439. Weekdays int representation
440. Weekly offered lectures using constants
441. Converting index values to day names
442. Providing lecture info
443. Sample lectures
444. Pitfall #1 of 2: Bogus day index value
445. Pitfall #2 of 2: Method argument order mismatch
446. Enumeration by class instances
447. Class instance per enumeration value
448. switch no longer works
449. Re-writing getPrice()
450. Pitfall: Creating an undesired instance
451. Define a private Day constructor
452. Preventing undesired Day instance creation
453. Adding a day name attribute
454. enum Day replacing public class Day
455. switch statements back working again
456. enum constructor being implicitly private
457. A minimal enum
458. An enum's parent class
459. Iterate over all enum values
460. Definition order matters!
461. Get an enum instance by its ordinal value
462. Get an enum instance by its constant's textual name
463. Openjdk source code repository
464. Superclass Object
465. String literals
466. OpenJDK String implementation
467. String copy constructor
468. Copy constructor and heap
469. Operator == and equals()
470. Remarks == vs. equals()
471. Operator == and equals() implications
472. equals() is being defined within respective class!
473. Math.sin(double x)
474. Guess who's inheriting the money
475. Biology and inheritance
476. Duplicate code
477. Idea: Centralize common code
478. Common and specific properties
479. Basic shape inheritance
480. Inheritance
481. Implementing Shape hierarchy
482. Creating instances
483. Shape constructor
484. Creating Rectangle instances
485. Rectangle constructor
486. Shape.equals()
487. Rectangle.equals()
488. Printing a Shape's info
489. Overwriting toString()
490. Shape extending Object
491. Overriding toString() in class Shape.
492. Logging Rectangle instances
493. Overriding toString() in Rectangle.
494. Rectangle extending Shape
495. Implementing Circle.toString()
496. Shape inheritance hierarchy and toString()
497. Moving Shape instances
498. Implementing Shape movements
499. Fools are everywhere!
500. Solution: final prevents overriding
501. Calculating a shape's area
502. Desired: Polymorphic getArea() call
503. Problems:
504. abstract method getArea()
505. abstract method getArea()
506. What's a “shape” anyway?
507. No instances of abstract classes.
508. Mandatory getArea() implementation.
509. Facts about abstract fields, methods and classes.
510. Moving shapes
511. protected access
512. final classes
513. final classes rationale
514. “Defeating” polymorphism
515. Defining equals(...): Expectations
516. Defining equals(...) of Shape instances
517. Comparing center coordinates
518. Implementing Rectangle.equals()
519. Implementing Circle.equals()
520. Testing equality of Shape objects
521. Overriding Object.toString()
522. @Override: Compile time error detection
523. Remarks on @Override
524. Polymorphism: Iteration over Object instances
525. Meta info of an instance
526. Instance meta info
527. Polymorphic dispatch / late binding
528. Example: Executing move()
529. Implementing getArea()
530. Implementing getArea() in class Shape ?
531. Solution: Abstract method getArea() in abstract class Shape
532. Polymorphic getArea() call
533. Runtime polymorphic dispatch
534. Polymorphic dispatch pseudo implementation
535. Compile- vs. runtime errors
536. NullPointerException (NPE for short)
537. NullPointerException is a class
538. Throwing an exception
539. Catching an exception by try {...} catch {...}
540. try {...} catch {...} syntax
541. Checked and unchecked exceptions
542. Further readings
543. Checked and unchecked exceptions
544. Expected exceptions in Junit
545. Just finally, no catch
546. try-with-resources (Java™ 7)
547. Scanner implementing AutoCloseable
548. No close() method in e.g. class String
549. Method printStackTrace()
550. Ascending inheritance ordering
551. Wrong ordering
552. Implementing convert
553. Problem: “Silent” errors
554. Step 1: Find exception base class
555. Step 2: Derive CardinalException
556. Step 3: Throwing CardinalException
557. Step 4: Unit test throwing CardinalException
558. Stack of integer values
559. Java™ collection features
560. Behind the scenes
561. Boxing and unboxing
562. Boxing syntax comparison
563. Parsing Integer user input
564. Parsing binary representation
565. Standard parse methods
566. Excerpt from java.util.Locale
567. Locale properties
568. Get a NumberFormat instance
569. Create a custom formatter
570. Polymorphic number parsing
571. Limited float precision
572. Limited double precision
573. Using BigDecimal
574. Chaining BigDecimal operations
575. BigDecimal features
576. Using static double random()
577. Seeding a pseudo random generator
578. Interface examples
579. Observations
580. Writing strings to file
581. Using Text2File
582. Possible Text2File errors:
583. Employ “try-with-resources”
584. interface syntax
585. The AutoCloseable promise
586. abstract class replacement
587. interface vs. abstract class
588. interface MyAutoCloseable
589. Extending MyAutoCloseable to flush
590. Using MyFlushable
591. Inheritance hierarchy
592. Upcoming topics
593. Interfaces implemented by class String
594. The Comparable interface
595. class String and Comparable
596. Comparison examples
597. Ascending and descending names
598. API requirements
599. Sorting strings alphabetically
600. Situation dependent sorting criteria
601. Implementing flexible sorting
602. Comparator in action
603. Case insensitive sort
604. Sort descending by lambda expression
605. Account hierarchy
606. Students and lecturers
607. An array of strings
608. An associative array describing month lengths
609. Grouping towns by country names
610. Collaborative efforts
611. Project rules
612. Internal code documentation
613. Internal code documentation hints
614. Javadoc™ mismatches
615. (Automated) tests
616. Deployment and execution
617. Marking criteria
618. Sample forecast session
619. Sample forecast invocation
620. Underlying data provider
621. cities.list.json.gz providing cities
622. ma/Copy URL result to file
623. Parse city data
624. Parse weather data
625. Requirements
626. Logging
627. Minimalist token scanner
628. Scanner output -1.34 0.34 + sqrt
629. Adding error detection
630. Error message
631. Running the currency converter terminal application.
632. Exam training by Guacamole
633. Environment hints:
634. Preparing an examination
635. Generating Javadoc™.
636. Programming hints
637. The implement - test - implement cycle
638. Finishing the exam
639. Personal examination cheat sheets
640. Unit tests in examinations
641. Example interface definition
642. Corresponding test
643. Don't cheat!
644. Unit tests strategy in examinations
645. Steps creating a new project
646. Creating a project at MI gitlab
647. Cloning a git project
648. Enter project folder, add Readme.md
649. Committing change set
650. Push to upstream repository
651. Inserting a Maven project
652. git status 1
653. Adding Maven files to repository
654. git status 2
655. Commit Maven project files
656. git status 3
657. Push to upstream again
658. Reverting changes
659. Pull changes from upstream
660. From https://www.urbandictionary.com
661. Useful links
662. Initialize git project
663. Configure author related data.
664. Adding resources to project index and staging area
665. Committing change set
666. Project versioning status
667. Adding a comment
668. git diff tracing changes
669. Reverting individual file.
670. Compiling, Math.class and Print.class.
671. Math.class, Print.class and versioning.
672. Show project's log
673. Switch to an older revision ...
674. ... and forth to current master's HEAD
675. Centralized remote repository
676. Step 1: Create remote repository
677. Step 2: Retrieve remote repository address
678. Step 2: Connect to remote repository
679. Step 3: Push local to remote
680. Step 3: Pull remote to local
681. Alternative: Create remote, then clone
682. Conflicting changes
683. Commit schedule
684. User B: git push fails
685. User B: git pull fails as well
686. Merge conflict details
687. Struggling for resolution
688. Merging Print.java manually
689. Commit and push merge
690. Maven: Recommended reading
691. What is Maven anyway?
692. Maven: Facts and benefits
693. Convention Over Configuration
694. Maven project layout
695. The project object model file
696. pom.xml characteristics
697. pom.xml vs. Makefile
698. «Hello, world» pom.xml
699. Executing «compile» phase
700. Examining the Java™ version culprit
701. Resolving encoding / Java™ version issues
702. POM inheritance
703. The Super POM
704. pom-4.0.0.xml content
705. Favour https in ~/.m2/settings.xml
706. Resolving to effective pom.xml
707. Plugin architecture
708. Sample plugins
709. Example: The maven-javadoc-plugin
710. Adding test capabilities
711. Dependency listing
712. Absence of hamcrest in pom.xml
713. ~/.m2/repository/junit/junit/4.12/junit-4.12.pom
714. Transitive dependencies
715. Oblivious to test implementation: TestNG
716. Phases
717. Maven lifecyles and phases
718. hooking into phase
719. Why XML based publishing?
720. XML features
721. Editors, compositors, designers ...
722. Promises in publishing
723. Publishing reality
724. Single source publishing
725. Separating Structure, content and format
726. Separating concerns
727. Content
728. Hierarchical structure
729. Hierarchical structure, XML source
730. Presentation
731. Example 1: HTML 5, pure structure
732. Example 2: TeX / LaTeX
733. Separating structure and presentation(s)
734. Sample technical document
735. Observations
736. Pros and cons of TeX / LaTeX
737. Tools of the trade
738. Inline formatting
739. Paragraphs
740. Lists
741. Tables
742. Images
743. Mathematical formulas
744. Cross references
745. Document sectioning
746. Modular document components
747. What is Docbook?
748. Authoring and publishing
749. Document representation
750. Software centric schema
751. Document targets
752. Docbook components
753. Target format overview
754. Tooling / Software
755. Different schema languages
756. Plain HTML
757. Web help
758. Eclipse help
759. Printed output
760. Paragraph
761. Itemized list
762. Ordered list
763. Glossary list
764. Nested lists
765. Reference
766. A table
767. A MathML equation
768. A TeX equation
769. Reference
770. Figure
771. Image map + calloutlist
772. Video
773. A warning
774. Reference
775. Recursive sections
776. Non-recursive sections
777. Two different link flavours
778. Choosing a top level element
779. Allowed 5.1 top level elements
780. Schematron on top of RelaxNG
781. Example: xml:id and permalink
782. Using Display #Anchors
783. Considerations author based permalink
784. Schematron permalink rule
785. HTML customization overview
786. Target specific configuration
787. Link stability
788. use.id.as.filename = 1
789. Parameter: use.id.as.filename
790. Customization parameter ulink.target
791. callout.unicode / callout.graphics
792. Links
793. Hooking into XSL
794. Categories
795. Example: videos
796. Links
797. Customize by CSS
798. Example CSS modifications
799. Styling the editor
800. Motivating modular documents
801. Monolithic document problems
802. Document decomposition
803. A monolithic document
804. Decomposing documents
805. XML grammar defining languages
806. Address list schema
807. Format conversion problem
808. XSL template rules
809. Example: Formatting <title> elements
810. Basic FO introduction
811. XMLMind Editor
812. Oxygenxml Author
813. Vendor links
814. Inverse editing
815. Document representation
816. Components
817. BibTeX
818. Makeindex example
819. Makeindex work flow
820. Extension example: MusiXTeX
821. Flavours
822. Components
823. Editors
824. reveal.js authoring tools: Principle
825. reveal.js features #1 of 3
826. reveal.js features #2 of 3
827. reveal.js features #3 of 3
828. reveal.js observations
829. Authoring tool project goals
830. Principle
831. Required / to be acquired skills
832. Principle
833. Codingbat: Desired features
834. Desired features
835. CRUD operation
836. Query
837. Schema
838. Procedures / triggers
839. Transactions / recovery
840. Data access control
841. API support
842. Installing Docker
843. Why LDAP?
844. LDAP introduction
845. Running a Docker container
846. Using docker-compose
847. Installing Apache Directory Studio
848. Administrator access to your DIT
849. Administrator access to your server's data tree
850. Administrator access to your server's configuration
851. Terminology
852. Adding an entry
853. Adding a new attribute
854. Replacing an attribute value
855. Deleting an attribute entirely
856. Multi valued attributes
857. Set semantics of multivalued attributes
858. Deleting selected attribute values
859. Query scope
860. Query filter
861. Schema support
862. Implementations
863. Implementations
864. Exercises
865. Why MongoDB?
866. Running a Docker container
867. Using docker-compose
868. Manual user creation
869. Log in as user explorer
870. Using IntelliJ
871. Idea show all databases
872. Terminology / Hierarchy
873. Adding a document
874. Updating attributes
875. Deleting a document
876. Deleting multiple documents
877. Multi valued attributes
878. Set semantics of multivalued attributes
879. Deleting selected attribute values
880. Deleting an attribute
881. Query filter
882. Schema validation support
883. Violating required field
884. Schema types
885. Enforcing unique keys
886. On the downside
887. Implementations
888. Implementations
889. Sharding rationale
890. Sharding rationale
891. Exercises
892. Prerequisite knowledge
893. Persistence [Bauer2015]
894. Java™ transient instances
895. RDBMS persistent records
896. Persisting transient User instances
897. Observations
898. Networking between clients and database server
899. JDBC™ features
900. JDBC™ in a three-tier application
901. JDBC™ connecting application server and database.
902. JDBC™ connection parameter
903. Components of a JDBC™ URL
904. IETF Uniform Resource Identifier
905. URL examples
906. Sub protocol examples
907. No standard port assignments ...
908. ... but Postgresql made it into Linux
909. JDBC™ architecture
910. DriverManager: Bootstrapping connections
911. Example: Mysql connection implementation
912. Driver libraries
913. Driver libraries by Maven
914. Driver unavailable
915. Connection interface
916. Statement interface
917. JDBC™ instances and relationships.
918. Important Connection methods
919. Important Statement methods
920. JDBC™ and threading.
921. JDBC™ connection pooling
922. pom.xml driver runtime scope
923. Person table
924. Objective: insert person record
925. JDBC™ backed data insert
926. Result
927. Two JDBC™ configurations
928. Figure 925, “JDBC™ backed data insert ” deficiencies
929. Why properties?
930. message.properties string externalization
931. Properties code sketch
932. Intellij IDEA settings, preconditions
933. Database related unit test phases
934. Implementing unit tests
935. Spring is your friend
936. Project layout
937. Closing connections
938. Employ AutoCloseable
939. Sniffing a JDBC™ connection by an intruder.
940. Setting up Wireshark
941. Capturing results
942. Mysql™ security
943. Mysql™ security
944. Assembling SQL
945. SQL injection principle
946. Preventing traffic tickets
947. Trouble at school
948. SQL injection impact
949. SQL injection relevance, [Clarke2009]
950. Handling injection attacks, part 1
951. Handling injection attacks, part 2
952. Input filtering
953. Validating user input prior to dynamically composing SQL statements.
954. Error message being presented to the user.
955. SQL statements in Java™ applications get parsed at the database server
956. Two questions
957. Addressing performance
958. Addressing performance mitigation
959. Restating the SQL injection problem
960. Solution: Use java.sql.PreparedStatement
961. PreparedStatement principle.
962. Three phases using parameterized queries
963. PreparedStatement example
964. Injection attempt example
965. Limitation: No dynamic table support!
966. JDBC™ read and write
967. Server / client object's life cycle
968. JDBC™ record container
969. Reading data from a database server.
970. Names and birth dates of friends
971. Accessing friend's database records
972. Important ResultSet states
973. JDBC™ to Java™ type conversions
974. Java™ to JDBC™ type conversions
975. Error prone type accessors!
976. Polymorphic accessor
977. Access by column name
978. Access by column index
979. Problem: null value ambiguity
980. Resolving null value ambiguity
981. Problem: Dynamic driver configuration
982. Shim driver (facade)
983. Users and groups
984. Isolation level
985. JDBC™ Isolation level
986. Setting the isolation level
987. Reasons for using Maven
988. Transitive dependencies
989. A basic persistence.xml JPA configuration file.
990. JPA persistence provider
991. Mapping hibintro.v1.model.User instances to a database.
992. A basic User class.
993. Mapping properties to attributes.
994. Annotating integrity constraints
995. Database schema mapping instances of hibintro.v1.model.User.
996. Loading a single object by a primary key value.
997. Retrieving hibintro.v1.model.User instances by HQL.
998. Business rules for projects
999. Persistence related object states
1000. Introducing inheritance mapping
1001. Modelling payment.
1002. A single relation mapping.
1003. Mapping the inheritance hierarchy.
1004. Inserting payment information
1005. Figure subclasses
1006. Joined subclass mapping.
1007. Implementing Object.equals(Object) by natural keys
1008. JPA caches.
1009. Common project steps #1/3
1010. Common project steps #2/3
1011. Common project steps #3/3
1012. Common technologies
1013. UNIX grep sample
1014. Similarities and differences
1015. Database grep requirements
1016. Connection profile handling
1017. Search level specification
1018. Property based searches
1019. Source and target database
1020. Copy process
1021. Considerations
1022. Sample data creation
1023. Schema evolution
1024. Techniques
1025. Subscribe to lecture
1026. Versioned code and documentation content
1027. Online documentation samples
1028. Create and publish a Hetzner account
1029. Your cloud project
1030. Server creation prerequisite: A Firewall
1031. Your first server
1032. Server access by ssh
1033. No ssh password based login
1034. Server access by web gui
1035. Current server security flaws
1036. Safety considerations
1037. ssh-keygen for elliptic key creation
1038. An elliptic ssh public / private key pair
1039. Result of ssh-keygen execution (client side)
1040. Transfer public key from client to server
1041. Cleaning up!
1042. Tedious: Passphrase required for each remote login
1043. Solving the passphrase issue
1044. Behind the scenes: How does it work?
1045. Intermediate host hopping
1046. Intermediate host hopping fails
1047. Intermediate host hopping options
1048. Enable ssh agent forwarding
1049. Forwarding port 80 to 2000 at localhost
1050. Frequent use e.g. connecting to remote database server
1051. X11 browser application forwarding
1052. Network file copy using scp
1053. Network file copy using rsync and ssh.
1054. Shell / Bash
1055. Choosing a text editor
1056. Secure Shell
1057. Working with files
1058. Network
1059. Processes handling
1060. Suggested readings:
1061. .deb packages
1062. The dpkg command
1063. The apt command
1064. Rationale using PPA's
1065. What's it all about?
1066. Terraform resources
1067. Creating databases
1068. Creating cloud resources
1069. Your course documentation: Code structure
1070. The env.template file
1071. Getting started: The Hetzner API token
1072. Minimal Terraform configuration
1073. Terraform init
1074. Terraform plan
1075. Terraform apply
1076. Local resources' state
1077. Credentials by E-Mail
1078. Problems: 😟
1079. ssh access, firewall
1080. ssh access, public key
1081. Apply ssh key access
1082. Output data details #1/2
1083. Output data details #2/2
1084. Storing secrets
1085. Problem 2: VCS and visible secrets 😱
1086. Addressing secrets by variable
1087. Addressing secrets by file
1088. Addressing secrets by Bash .env file
1089. Managing Terraform states
1090. Introduction and reference
1091. In a nutshell
1092. Configuration options
1093. Bash DIY
1094. Terraform interface to Cloud Init
1095. Using template files
1096. cloud-init file validation
1097. Yaml syntax quirk 1: Missing indentation
1098. Yaml missing indentation resolution
1099. Yaml syntax quirk 2: Wrong indentation
1100. Cloud-init configuration file validation
1101. Watch out for your enemies!
1102. Problem: Duplicate known_hosts entry on re-creating server
1103. Solution: Generating known_hosts ...
1104. ... cloud-init config using yamlencode / JSON
1105. ... and ssh wrapper
1106. Failsafe console login
1107. Avoiding Yaml parsing issues
1108. Terraform module Documentation
1109. Example: Creating a JSON host meta data file
1110. Parent module / sub module layout
1111. Parent module implementation
1112. Sub module implementation
1113. Sub module, JSON template file Tpl/hostdata.json and result
1114. Parent module vs. sub module context
1115. A volume: The easy way
1116. Unix mount
1117. Volume details
1118. Providing a mount point's name
1119. De-coupling server and volume creation
1120. Loop documentation
1121. Using count
1122. Subdomain per group
1123. Key file location
1124. Querying DNS by zone transfer
1125. Creating an »A« record with TTL=10
1126. Modify by delete/create
1127. Mind record caching
1128. Bind server ns1.hdm-stuttgart.cloud
1129. DNS provider
1130. DNS provider configuration
1131. Defining an “A” record
1132. Understanding web certificates
1133. Certificate trust level
1134. Certificates by Terraform
1135. dns_challenge provider
1136. rfc2136 provider configuration
1137. Bind server log file
1138. Private subnet overview
1139. Terraform network and subnetwork creation
1140. Gateway: External and internal interface
1141. intern host
1142. Lack of internet access
1143. Possible solutions
1144. http proxy apt-cacher-ng
1145. Cloud-init problem
1146. Service ready query script
1147. Terraform “service ready” dependency hook
1148. Pulumi facts
1149. Sample
1150. Architecture
1151. Asynchronous execution
1152. Executing plan
1153. Execution result
1154. Using cloud-init
1155. Login by public key
1156. A minimal system of hosts
1157. Firewall
1158. Importing Terraform DNS provider
1159. DNS provider
1160. DNS record
1161. Server
1162. Documentation links
1163. DNS query commands
1164. DNS forward lookup
1165. Display A-record result only
1166. Important record types
1167. Name Servers: Query type NS
1168. Recommended readings
1169. Openldap server documentation
1170. What is LDAP anyway?
1171. LDAP Server cli bind
1172. Document Information Tree (DIT)
1173. Relative and absolute DNs
1174. User example
1175. objectClass
1176. objectClass clarifications
1177. Augmenting inetOrgPerson by posixAccount
1178. Structural objectClass definitions
1179. Search scopes
1180. Predicate based queries
1181. LDAP bind types
1182. LDIF exchange format
1183. LDIF sample
1184. OpenLdap server architecture
1185. An example LDAP Tree
1186. External documentation
1187. URI to filesystem mapping
1188. Virtual hosting
1189. Implementing virtual hosting
1190. IP based virtual hosting
1191. IP based, pros / cons
1192. Name based virtual hosting
1193. Name based, pros / cons
1194. LDAP backed authentication
1195. PHP FPM server
1196. File services
1197. Customer demands
1198. Driving factors
1199. Selected cloud file services
1200. Selected self hosting products
1201. Nextcloud features
1202. Lightning integration
1203. Installation
1204. Docker hub
1205. Search images
1206. Pull image using CLI
1207. Pull Nextcloud image
1208. Nextcloud based on Alpine
1209. Inspect image
1210. Search an image's tags
1211. Nextcloud image by version
1212. List images by CLI
1213. Nextcloud latest image
1214. Duplicate Nextcloud images
1215. Maven ringing a bell?
1216. Un tag image by version
1217. Remove image by version
1218. Starting Nextcloud container
1219. List running containers
1220. Enter running container
1221. Remove container
1222. List volumes
1223. List orphaned volumes
1224. Remove volumes
1225. Technical features
1226. Documentation tool chain proposal

List of Tables

1. 4 Byte Two's complement representation of int values.
2. Exercises in 113105 Software development 1
3. Exercises in 113492 Technical Documentation
4. Exercises in 113473 Database and application development
5. Exercises in 113475 Software defined Infrastructure

List of Equations

1. Calculating binomials by cancelling common factors.
1. Power series definition of $f (x) = e^{x}$
2. Power series definition of $f (x) = \sin (x)$
3. Reordering of terms with respect to an implementation.

		Next
		Preface