Tech 1 Semester Plan

About the course

About the course

Mandatories

Mandatory I - Tech Company

Mandatory I - Learning Goals

Course Preparation

Course Preperation

Semester Plan

The semester plan is subject to modifications during the semester.

Taught on: Tuesday

Title	Date	Description	Learning Goals	Resources and Activities (After class)
1	Jan. 27th	Introduction File Systems Terminal Commands Git vs. GitHub Setup SSH Key in GitHub Hands-on git	Can navigate the terminal: ls, cd, whoami, pwd. Can create, delete files / folders: mkdir, rm, cp, mv, touch, nano. Can use the following basic terminal commands: cat, wc, uniq, sort. Can create a new repository in your prefered Git provider. Can perform basic Git operations: clone, add, commit, push, pull.	Command Line Exercises Watch from #3 - #7: YouTube - Crash Course Computer Science Project-til-Github (Tara)
2	Feb. 3rd	Git Refresher Hardware Software Number Representations Encoding	Can list the main hardware components of a computer, their functions and the Von Neumann architecture. Can explain how computers work, starting from hardware all the way to software. Can talk about processes in operating systems. Can talk about different number representations such as: Binary Hexadecimal Decimal Can bring up real-world use cases for different number representations. Can explain different charsets like ASCII and Unicode and how they differ.	YouTube - Types of Databases https://www.markdowntutorial.com/ Number Conversion Programs Numeric Systems - Exercises
3	Feb. 10th	Database Paradigms SQL DDL DML	Knows about different types of databases and their use cases. Can setup a new MySQL database and connect to it. Can create DDL statements to create tables. Can create DML (SELECT, INSERT) statements. Can use WHERE clause to filter results.	Countries (DML)
4	Feb. 17th	Project	Project
5	Feb. 24th	Primary Keys SELECT ORDER GROUP LIMIT Aggregate Functions Foreign Keys SELECT JOIN UPDATE DELETE PRs and Forks	Can define Primary Keys. Understands how Foreign Keys work. In SELECT statements, can use (with moderate help): LIMIT, ORDER BY, GROUP BY aggregate functions like COUNT, SUM, AVG, MIN, and MAX pattern matching with LIKE and wildcards JOIN to combine data from multiple tables Can create inner, left and right joins after looking up the syntax. Can create DDL statements to create tables with constraints: PRIMARY KEY, AUTO_INCREMENT, FOREIGN KEY, UNIQUE, NOT NULL. Can create DML (UPDATE, DELETE) statements. Can create a pull request.	Work With Joins Mandatory I: Tech Company
6	March 3rd	Advanced git Git Branching YAML GitHub Actions	Understands different Git workflows such as GitHub Flow. Can solve a merge conflict. Can write YAML. Understands what GitHub Actions are and can breakdown workflows into runners, jobs, and steps. Can give use cases for GitHub Actions.	https://anderslatif.github.io/yaml_tutorial/ Resource: GitHub Actions 1 Pull Request Exercise 1 Optional: Visualizing GitHub Flow
7	March 10th	Setup Spring Project Optional: Setup Hot Swap with Spring in IntelliJ Cloud computing - Azure Web App	Understands different cloud service models: IaaS, PaaS, SaaS. Can deploy a web application to Azure App Service. Understands the flow from pushing, GitHub Actions running, building the project and deployment to Azure.	Pull Request Exercise 2 Hello GitHub Actions Demo v2
8	March 17th	Add database to Spring project MySQL database deployment Database deployment	Adding a database to a Spring Project. Setting up a database in Azure. Can set up a database in Azure and connect it to an Azure App Service project with a guide.
9	March 24th	Concurrency Problems in Databases Transactions (MySQL / JDBC) Transactions (MySQL / JDBC) Testing GitHub Actions	Is able to go through scenarios that can cause concurrency problems in databases. Can explain what ACID is and why it solves concurrency problems for databases. Is aware of the possibility to define transactions in SQL and JDBC. and atomic structures.
10	March 31st	Holiday	Holiday
11	April 7th	Project (Anders will introduce the project during class)	Project
12	April 14th	No Lecture	No Lecture	Mandatory II Given: Mandatory II - Learning Goals