Tech 1 Semester Plan

About the course

About the course

Semester Plan

The semester plan is subject to modifications during the semester.

Taught on: Tuesday

Title	Date	Description	Learning Goals	Resources and Activities
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.	Important!: Course Preparation Work 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	Git Refresher / Markdown 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.
4	Feb. 10th	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.	Mandatory I: Tech Company
6	March 3rd	MVN and javac 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.
7	March 10th	Setup Spring Project 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.
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 Threads Java Threads: Basics Java Threads: Priority Java Threads: Locks Java Threads: Counting Java Threads: Deadlock
10	March 31st	Holiday	Holiday