INFRASTRUCTURE LEARNINGINFRASTRUCTURE LEARNING
インフラ大全インフラ大全IT INFRASTRUCTURE / LEARNING
Infrastructure learning guide
Find a lesson or lab/

Esc to close · Search terms stay on your device

LEARNING日本語
REFERENCE

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.

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.

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.

Lesson

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.

Lesson

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.

Lesson

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.

Lesson

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.

Lesson

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.

Lesson

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.

Lesson

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.

Lesson

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.

TOOL / IPv4

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.