Lab Reports

→

11

Introduction to Amazon EC2

Launching, monitoring, configuring security, resizing, and safely terminating an EC2 instance.

EC2 Security Groups EBS CloudWatch

→

225

Introduction to Amazon Linux AMI

Connecting via SSH with PuTTY and exploring the Linux man pages.

SSH PuTTY man

→

227

Linux Command Line

System info commands, timezone dates, Julian calendars, and bash history search.

Bash System Info History

→

229

Managing Users and Groups

Creating users, organizing groups by job role, and understanding sudoers permissions.

useradd groupadd usermod sudo

→

231

Editing Files

Using vimtutor, creating files with Vim, and editing with nano.

vim nano vimtutor

→

233

Working with the File System

Creating folder structures, copying, moving, and deleting files and directories.

mkdir cp mv rm

→

235

Working with Files

Creating tar backups, logging with echo and tee, and transferring files.

tar echo tee pipe

→

237

Managing File Permissions

Changing ownership and permission modes using absolute and symbolic methods.

chown chmod symbolic absolute

→

239

Managing Processes

Monitoring processes, checking real-time performance, and creating cron jobs.

ps top crontab grep

→

241

Managing Services & Monitoring

Controlling background daemons via systemctl and monitoring EC2 health visually.

systemctl httpd CloudWatch

→

243

Software Management

Upgrading packages, rolling back installations via yum history, and configuring the AWS CLI.

yum history AWS CLI curl

→

245

Managing Log Files

Auditing system authentication events and historical login data.

less lastlog /var/log/secure

→

247

Working with Commands

Manipulating data streams using tee, sort, cut, and the pipe operator.

tee sort cut Pipes (|)

→

249

The Bash Shell

Customizing the command-line interface with aliases and adjusting the PATH variable.

alias tar PATH

→

253

Bash Shell Scripting Exercise

Automating repetitive tasks in Linux by creating a loop script to generate files sequentially.

Bash Scripting Automation Loops

→

261

Internet Protocols: Public and Private IPs

Troubleshooting EC2 connectivity by understanding public vs. private IP addressing and the OSI model.

Public IP Private IP VPC OSI Model

→

262

Internet Protocols: Static and Dynamic Addresses

Resolving dynamic IP changes on EC2 instances by allocating and associating an Elastic IP.

Elastic IP Dynamic IP EC2

→

263

Create Subnets and Allocate IPs in a VPC

Planning CIDR blocks and creating a VPC with a public subnet using the VPC Wizard.

VPC Subnets CIDR RFC 1918

→

264

Create VPC Resources for Internet Connectivity

Building a full networking stack: Internet Gateway, route tables, NACLs, security groups, and EC2.

IGW Route Table NACL Security Group

→

265

Internet Protocol Troubleshooting Commands

Diagnosing network connectivity issues across OSI layers using ping, traceroute, netstat, telnet, and curl.

OSI Model ICMP TCP Traceroute

→

266

Troubleshooting a Network Issue

A cloud support scenario identifying blocked Apache servers through OS-level systemctl checks and Security Group analysis.

systemctl Security Groups VPC

→

267

Build Your VPC and Launch a Web Server

Building a robust VPC with public/private subnets across multiple AZs and bootstrapping an EC2 web app via user data.

Amazon VPC Multi-AZ User Data

→

276

Scanning AWS Lambda Functions with Amazon Inspector

Scanning serverless applications for vulnerabilities using automated security assessments.

Amazon Inspector AWS Lambda CVEs

→

277

Update EC2 instances with AWS Systems Manager Patch Manager

Automating OS patch baselines, maintenance windows, and compliance verification.

Patch Manager Systems Manager Compliance

→

279

Introduction to AWS IAM

Enforcing password policies, analyzing managed/inline JSON policies, and testing role-based permissions.

IAM Groups Policies Least Privilege

→

280

Malware Protection Using an AWS Network Firewall

Updating stateless network firewalls with stateful Suricata IPS rules to block malicious domains.

Network Firewall Stateful Rules Suricata IPS

→

281

Monitor an EC2 Instance with CloudWatch Alarms

Coupling CloudWatch metrics to Amazon SNS alerts for rapid detection of CPU spikes.

CloudWatch Amazon SNS Alerting

→

141

Challenge Lab: Python Scripting Exercise

Writing and testing a Python 3 script that calculates prime numbers and saves them into a results file.

Python 3 nano results.txt

→

268

Create and Drop Databases and Tables

Practicing CREATE, SHOW, ALTER, and DROP statements to build and remove a sample world schema.

MariaDB CREATE ALTER DROP

→

269

Insert, Update, and Delete Data in a Database

Using INSERT, UPDATE, DELETE, and SQL import to manipulate and restore rows in the world database.

INSERT UPDATE DELETE SQL Import

→

270

Selecting Data from a Database

Querying the world dataset with SELECT, COUNT(*), aliases, ORDER BY, WHERE, and AND conditions.

SELECT COUNT(*) WHERE ORDER BY

→

271

Query the World Database with Functions and Conditions

Using BETWEEN, LIKE, SUM, aliases, and LOWER to build clearer and more analytical SQL queries.

BETWEEN SUM LOWER

→

272

Working with Functions

Using aggregate and string functions such as SUM, SUBSTRING_INDEX, LENGTH, TRIM, and DISTINCT to transform query results.

SUM SUBSTRING_INDEX DISTINCT

→

273

Organizing Data

Using GROUP BY, SUM, OVER, and RANK to summarize regions and rank countries by population.

GROUP BY OVER() RANK

→

160

Build Your DB Server and Interact With Your DB Using an App

Launching a Multi-AZ RDS MySQL instance and connecting a web application to the managed database.

Amazon RDS Multi-AZ MySQL

→

162

Challenge Lab: Build Your DB Server and Interact With Your DB

Connecting to Amazon RDS from a Linux server, creating tables, inserting data, and validating an inner join.

Amazon RDS INNER JOIN MySQL Client