IT Fundamentals

AT = advanced topic

• Office basics
  • word processors: MS Word, LibreOffice Writer
    • basics: typing, punctuation marks; sentences, paragraphs, headings
    • direct formatting vs semantic structure (styles)
    • header, footer, notes, templates
    • tracking changes
  • spreadsheets: MS Excel, LibreOffice Calc
    • basics: columns, rows, sorting, formulas
  • web browsers: Firefox, Chrome, Edge
    • servers, IP addresses, links, https
    • user tracking, cookies, Javascript, GDPR
    • content filtering; other extensions
    • DNS, VPN, SOCKS5 proxy, TOR (AT)
  • email, IM, RTC
  • data security essentials
    • password managers
    • backups
    • data encryption (AT)
• Computer hardware
  • CPU, RAM
  • data storage: HDD, SSD
  • peripherals: keyboard, mouse/touchpad, monitor
• Plain text
  • plain text vs rich text; text file vs binary file
  • text editors: VS Code, nano, vim
  • Markdown, CommonMark
  • data serialization; html, xml, yaml, json, csv
  • character encoding, unicode¹ (AT)
• CLI, shell (POSIX)
  • GUI vs CLI; terminal (tty) vs shell
  • bash; coreutils: file, text, shell utilities
  • streams; stdin, stdout, stderr; piping
  • find, grep, gzip, less, mc, nano, sed, tar, wget
  • processes; async execution (AT)
  • shell scripts (AT)
• Git
  • version control & git basics
  • remote; GitHub, Bitbucket, GitLab
  • branches, merging, rebasing
• Regex²
  • pattern matching basics; use cases
  • anchors, quantifiers, character classes
• Linux
  • core concepts, distros
  • OS overview: Windows vs Unix-like
  • free software, FSF, GNU, LF
  • SSH, public-key authentication
  • user management; root vs sudo (AT)
  • package managers, repositories (AT)
  • filesystem; directory hierarchy (AT)
  • systemd: units, timers, journald (AT)
• SQL
  • databases, tables, fields, records, queries
  • RDBMS: PostgreSQL, MariaDB/MySQL, SQLite, Oracle, MS SQL Server
  • cloud DWH: BigQuery, Snowflake, Redshift
  • DDL, DML (AT)
  • aggregations, subqueries, joins (AT)
• VM, VPS, Docker (AT)
  • hardware virtualization, virtual machines (AT)
  • OS-level virtualization, containerization (AT)
  • docker-compose (AT)
• CS basics (AT)
  • Boolean algebra (AT)
  • set theory, relational algebra (AT)
  • binary numbers (AT)
  • computer networks (AT)
  • programming essentials (AT)
    • data, variables (AT)
    • control structures, control flow (AT)
  • software development: specifying, designing, programming, documenting, testing software (AT)