Reference
Explore networking, operating systems, data, cloud and operations; distinguish shared concepts from product implementations.
Manage changes with Git and GitHub
Before provisioning a server, learn to record and review file changes. No installation or account is needed. A small SQL edit in the PR lesson connects the stages between proposing a change and delivering it to users.
- Git basics: working tree, staging, commits and branches →
- GitHub basics: Git, repositories, pull requests and collaboration →
- GitHub pull request basics: review a SQL diff, checks and merge →
- GitHub Actions basics: workflows, jobs, runners and permissions →
- GitHub Actions OIDC for AWS: trust conditions, STS and permissions →
The PR lesson explains WHERE and AND where they are used. Continue to OIDC after understanding Actions and IAM role responsibilities. Diagrams and questions are teaching examples, with no live GitHub, AWS or database operations.
After the basics: design CI/CD
After Git, PRs and Actions, connect the conditions between a checked change and user-visible delivery: CI example → stage dependencies → execution identity → artifact verification → release gates → deployment strategies → recovery → postmortems. Choose the topic you need. Lessons distinguish general principles from GitHub/AWS examples.
- What is CI? Automated checks and what passing tests cannot prove →
- CI/CD pipeline design: dependencies, artifacts and deployment targets →
- CI/CD identity design: jobs, credentials and AWS role permissions →
- CI/CD supply-chain security: verify dependencies, digests and provenance →
- CI/CD release gates: match required checks, approvals and the deployed version →
- AWS deployment strategies: ECS rolling, blue/green and canary compared →
- AWS deployment rollback: application recovery and database compatibility →
- Incident postmortems: evidence, customer impact and verified corrective actions →
Examples use fictional inputs and records. No live workflows, destination changes or credential entry are involved.
Choose a subject
Available lessons and tools
Available lessons and tools are listed below. Other subjects are being prepared; the subject list also shows planned coverage.
Database basics: tables, keys, reads and writes
A database holds data; a database management system (DBMS) manages that data. SQL Server is one DBMS. Use five documents and three owners to distinguish tables, rows, columns, a document’s primary key and its foreign-key reference to a person.
SQL Server fundamentals and learning path
Microsoft SQL Server is a relational database management system. T-SQL expresses queries and operations; SSMS is a connection and management tool. Separate these roles, then connect structure → connections → permissions → query results → transactions.
T-SQL basics: SELECT, WHERE, NULL and JOIN results
SELECT chooses columns, WHERE retains matching rows, and JOIN combines rows using a condition. Predict results from the same five documents, changing one condition at a time. Keep a read-only principal separate from an independently authorized editor.
What is AWS? IAM, S3 and VPC explained for beginners
AWS (Amazon Web Services) is Amazon’s cloud platform. It provides services for servers, data storage, networking and more. This introductory lesson focuses on IAM for permissions, S3 for storage, and VPC for networking. Follow one internal reporting app to distinguish their roles.
What is AWS IAM? Authentication and permissions for beginners
AWS Identity and Access Management (IAM) controls access to AWS resources. Authentication establishes who is making a request; authorization decides whether that request is permitted. Follow an internal reporting app to understand why signing in does not automatically give permission to read a file.
What is Amazon S3? Buckets, keys and objects for beginners
Amazon Simple Storage Service (S3) stores data as objects. Start by separating a bucket, the container, a key, the object’s identifier, and the object, the stored data and its metadata. A monthly report example connects these terms to storage operations and access permissions.
What is Amazon VPC? Subnets, routes and traffic controls explained
Amazon Virtual Private Cloud (VPC) is a virtual network for AWS resources. Subnets divide its address space into ranges. Route tables direct traffic; security groups and network ACLs control traffic. Creating a VPC or assigning an IP address does not establish that an application can communicate.
How to read IAM policy JSON: Effect, Action and Resource
An IAM policy describes permissions in JSON. Start with a Statement, an individual rule, and compare its Effect, Action and Resource with one request. Valid JSON syntax does not establish that AWS will authorize the intended operation.
IPv4 CIDR calculator: address range, subnet mask and total count
Calculate an IPv4 range’s first and last addresses, subnet mask and total count locally from an address and prefix such as /24. CIDR fixes a prefix of the 32-bit address. The total is not a count of assignable hosts.